Tuesday, August 30, 2016

BW Asset Extraction

List of Datasources
  • 0FI_AA_11 - FI-AA: Transactions

0FI_AA_11

Base Tables : ANLC
                       ANEK : Document Header Asset Posting


Datasource Notes from SAP : LINK


Important DELTA Notes

All the above datasources work as a set , the deltas are dependent.

For delta of 0ASSET_AFAB_ATTR to work fine, 0ASSET_ATTR_TEXT should have successful data extraction.
For 0FI_AA_11 and 0FI_AA_12, both 0ASSET_ATTR_TEXT and 0ASSET_AFAB_ATTR should have successful data extractions.

There should be 'D' entries in the table for the preceding datasource, for the next datasource to have successful data extraction.
If FI_GL_4 is active in the system, system checks for the delta from that datasource too.
The delta timestamps can be seen in table BWOM2_TIMEST



Other Information

User FM 'RKE_TIMESTAMP_CONVERT_OUTPUT' to convert the timestamps in the table to general format.

SAP Note 926047 gives some information on delta functionality.

Delta FM
BWFIT_RESET_TIMESTAMPS

Tables
  • ANLB - 
  • ANLC - Asset Value Fields

T-Codes
  • AS01 - Asset Master Data
  • AW01
    • In the parameters tab 
      • Exp. Useful Life in Years = ( Order Dep. Start Date year ) - ( Previous Year)
      • Exp Useful Life in Years = ( Order Dep. Start Date Period) - ( Start of that Fiscal Period)


Other Details
  • BAPI_FIXEDASSET_GETDETAIL

Related SAP Notes

926047 - Depreciation values extracted without master data to BW


Reference Notes 

No comments:

Post a Comment