SAP ERP

SAP Tables

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 […]

SAP Tables Read More »

SAP Finance Part-1

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

SAP Finance Part-1 Read More »

SAP Treasury and Risk Management Part 2

Define Account Determination

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 DefinitionAccount SymbolsSAP Definition
Short Term Investment1Position
Cash3Bank Clearing
Interest Receivable5.1.2Acc. Receivable Interest
Interest Income4.1.1Interest Gain
Unrealized FX Gain4.9.4.2Increase FX
Unrealized FX Loss4.9.3.2Decrease FX
Realized FX Gain4.9.2.1Realized Gain FX
Realized FX Loss4.9.1.1Realized 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 SpecDescriptionDebit SymbolCredit Symbol
11100Investment Increase13
13900Interest Accrual5.1.24.1.1
15700Balance Sheet Revaluation (loss)4.9.3.21
15300Balance Sheet Revaluation (gain)14.9.4.2
15400Reset FX Gain4.9.4.21
15800Reset FX Loss14.9.3.2
11200Investment Decrease31
11210Interest Receipt35.1.2
12300Realized FX Gain14.9.2.1
12400Realized FX Loss4.9.1.11
15430Move FX gain from unrealized to realized4.9.4.24.9.2.1
15730Move FX loss from unrealized to realized4.9.1.14.9.3.2

A screenshot of a computer Description automatically generated

A screenshot of a computer Description automatically generated

Assign Update Types to Posting Specs

Assign Update Type to Posting specs defined in last step.

A screenshot of a computer Description automatically generated

Assignment of GL Accounts to Account Symbols

A screenshot of a computer Description automatically generated

Silver Level Membership Required

You must be a Silver Level member to access this content.

Join Now

Already a member? Log in here

SAP Treasury and Risk Management Part 2 Read More »

SAP Treasury & Risk Management Part 1

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

SAP Treasury & Risk Management Part 1 Read More »

SAP Foreign Currency

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 /

SAP Foreign Currency Read More »

SAP Substitutions

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

SAP Substitutions Read More »

error: Content is protected !!