How to understand FICO tables so as to prepare Functional spec that ABAPer can work with? Please explain the data pulling logic? and how to map the tables after configuration
Answers were Sorted based on User's Feedback
Answer / chandrika sharma
There are few basic tables for SAP FICO where master/transactional data has been stored.
GL- BSEG
AR - BSID/BSAD
AP - BSIK/BSAK etc.
Logic is always based on the requirement raised. However, the basic funda to get the logic is always search for a common field between two tables and fetch the required information. Sometimes, a table might give you huge amount of data, in that case, you can write the logic of filtering the data on the basis of different fields. In the functional specifications, mention clearly the field name with table and if you want to give any filteration over there.
Eg. For a customer ageing report, the open items exists in table BSID (Table for transactional open item data for customers)if you want to show only transactions of down payments, filter can be put like only select the line items with where special GL indicator (UMSKZ)is A and so on.
We need not to do any mapping after configuration in SAP. System does it automatically.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkatarao.darsi
There are few basic tables for SAP FICO where master/transactional data has been stored.
GL- BEGS
AR - BSID/BSAD
AP - BSIK/BSAK etc.
Logic is always based on the requirement raised. However, the basic funda to get the logic is always search for a common field between two tables and fetch the required information. Sometimes, a table might give you huge amount of data, in that case, you can write the logic of filtering the data on the basis of different fields. In the functional specifications, mention clearly the field name with table and if you want to give any filteration over there.
Eg. For a customer ageing report, the open items exists in table BSID (Table for transactional open item data for customers)if you want to show only transactions of down payments, filter can be put like only select the line items with where special GL indicator (UMSKZ)is A and so on.
We need not to do any mapping after configuration in SAP. System does it automatically.
Is This Answer Correct ? | 0 Yes | 0 No |
How are controlling areas and company codes related?
what are the most important control functions of posting keys?
i can't find Particular G/L account releated to Cost center.
Explain managerial closing. : fi- general ledger accounting
WHAT IS SCREEN LAYOUT AND WHY WE NEED SCREEN LAYOUT IN ASSETS CONFIGURATION ?
Hi, Let me know what is the config. required for customer's interest calculation kindly explain briefly.
Can we change the depreciation value after Depreciation Run. How to activate deactivated or closed asset. And how to change Depreciation key after posting transactions.
where do you control the header data?
Define meta data, master data and transaction data?
What do you mean by operation scrap?
What is financial accounting sap ?
What is a contract? : fi- accounts payable