Table of Contents SAP Tables FI Enterprise Structure Tables Table Description Table SAP Company Code T001 Countries in SAP T005 Global Company Data T880 SAP Currency Codes TCURC SAP Exchange Rates TCURR GL Account Groups T077S Directory of Chart of Accounts T004 Fiscal Year variant in SAP T009 Credit Control Area in SAP T014 […]
Table of Contents Enterprise Structure Localize Global company code 0001 setting Tcode : O035 SAP supplied sample company code is 0001. This is country independent. So if the implementation is for USA this is localize for country US installation. This is than copied to the new organization units. This will copy below settings for country
Table of Contents Foreign Exchange Forward Deals- End User Training FX Spot / Forward trade Functionality With spot transactions, internationally traded currencies are bought and sold on the value date at spot prices. With forward transactions, the currencies are traded at a future date at the forward price agreed at the time of the
IMG- FSCM – Treasury & Risk Management- Transaction manager – General Settings-Accounting- Link to Other Accounting Components
Here we link the GL accounts to Account assignment reference. This activity covers many tasks which are explained as below.
Define Account Symbols
Account Symbols represent GL Accounts. SAP has defined several standard account symbols. Can add new ones if required.
Business Definition
Account Symbols
SAP Definition
Short Term Investment
1
Position
Cash
3
Bank Clearing
Interest Receivable
5.1.2
Acc. Receivable Interest
Interest Income
4.1.1
Interest Gain
Unrealized FX Gain
4.9.4.2
Increase FX
Unrealized FX Loss
4.9.3.2
Decrease FX
Realized FX Gain
4.9.2.1
Realized Gain FX
Realized FX Loss
4.9.1.1
Realized Loss FX
Define Posting Specs
It links Account symbols defined in earlier step with Posting type (Balance Sheet, Profit/Loss) and Debit or Credit accounting entry. For our configuration below posting specs are required.
Posting Spec
Description
Debit Symbol
Credit Symbol
11100
Investment Increase
1
3
13900
Interest Accrual
5.1.2
4.1.1
15700
Balance Sheet Revaluation (loss)
4.9.3.2
1
15300
Balance Sheet Revaluation (gain)
1
4.9.4.2
15400
Reset FX Gain
4.9.4.2
1
15800
Reset FX Loss
1
4.9.3.2
11200
Investment Decrease
3
1
11210
Interest Receipt
3
5.1.2
12300
Realized FX Gain
1
4.9.2.1
12400
Realized FX Loss
4.9.1.1
1
15430
Move FX gain from unrealized to realized
4.9.4.2
4.9.2.1
15730
Move FX loss from unrealized to realized
4.9.1.1
4.9.3.2
Assign Update Types to Posting Specs
Assign Update Type to Posting specs defined in last step.
Assignment of GL Accounts to Account Symbols
Silver Level Membership Required
You must be a Silver Level member to access this content.
Table of Contents General Settings Maintain Calendar IMG: SAP Netweaver – General Settings – Maintain Calendar The Factory Calendar is relevant for the Treasury. Ensure Factory calendar is maintained for current year. Click change and ensure Factory Calendar is valid for current year Assign Holiday calendar to factory calendar. Verify assigned holiday calendar has the
Table of Contents SAP BCM Implementation What is SAP BCM BCM stands for Bank Communication Management. It is a component under FSCM (Financial Supply Chain Management) that is responsible for communication with a bank in terms of payments sent, acknowledgments received, and approval workflows before payments are sent to the bank. BCM is responsible for
Table of Contents SAP Query Purpose SAP Query enables data from multiple tables to be extracted in one report, provided at least one field from one table can be linked to another table There are two methods of creating query in SAP SAP Quick Viewer: Query created by this method is user specific –i.e. the
Table of Contents SAP Bank Account Management In SAP S4/HANA Finance House banks are merged into Bank Account Management (BAM) in SAP Cash Management powered by SAP S4/HANA Bank Account Management is provided in 2 versions. Bank Account Management lite (BAM) Bank Account Management Full version ` SAP Bank Account Management Lite Bank Account Management lite
Table of Contents Foreign Currency Valuation Foreign Currency Valuation in SAP FASB 52: is issued by US accounting standard board. It provides guidance on financial reporting of companies operating in foreign countries Functional Currency: Currency of the economic environment in which the entity operates. In case of SAP functional currency is generally company code /
Table of Contents Substitution in SAP What is the substitution The substitution function can be used to substitute a value to some fields which is included in line item table BSEG or header table BKPF. And the substitutions are valid for both the manual entry of documents and the automatic created entry of documents (for example, payment program). You can define