Average Daily Balance (ADB) and Error Correction System (ECS) (New) Locate this document in the navigation structure

Technical Data

Product Version

SAP NetWeaver 7.0 BI Content Add-On 5 SP01

Area

SAP ERP Financial Accounting (FI)

Country Relevance

Valid for all countries

 

DataSources

  • Error Correction System: Item List (0AC_INT_ECS_1)

  • Average Daily Balance (0FI_GL_60)

  • Ledger Environment (Attributes) (0LEDENV_ATTR)

  • Ledger Environment (Text) (0LEDENV_TEXT)

  • Status of ECS Item (0ECSSTATUS_TEXT)

  • ECS Environment (Text) (0IFTYPE_TEXT)

  • Compound Error Category (0COMPERROR_TEXT)

  • Severity of Error in ECS Item (0SEVERITY_TEXT)

DataStore Objects

  • Error Correction System: Item List (Replicated) (0ECS_DS01)

  • Average Daily Balances (Replicated) (0FIGL_D60)

InfoCubes

  • Error Correction System: Item List (Direct) (0ECS_VP01)

  • Average Daily Balances (Direct) (0FIGL_V60)

MultiProvider

  • Error Correction System: Item List (0ECS_MP01)

  • Average Daily Balances (0FIGL_M60)

Queries

  • Error Correction System: Item List (0ECS_MP01_Q0001)

  • Average Daily Balances (0FIGL_M60_Q0001)

Characteristics

  • Document Type of the Posted Document (0DOCTYPP)

  • Document Type of the Correction Document (0DOCTYPM)

  • Document Number of the Posted Document (0DOCNOP)

  • Document Number of the Correction Document (0NEWDOCNO)

  • Posting Date of Posted FI Document (0POSTDATEP)

  • Posting Date of Correction Document (0POSTDATEM)

  • Company Code in Posted Document (0COMPCODEP)

  • Company Code of Correction Document (0NEWCMPCODE)

  • Posting Key of Posted Document (0POSTKEYP)

  • Posting Key of Correction Document (0POSTKEYM)

  • Date on which the record was created (0CREATEDON)

  • Reference in ECS for ECS Items in the Same FI Document (0INTDOCRFID)

  • ECS Environment (0IFTYPE)

  • Year in which ECS item was entered (relevant for the internal document number) (0INTDOCYEAR)

  • External Run ID (Versioned) (0RUNIDEXT)

  • ID of Error Correction Item (0ITEMID)

  • Fiscal Year of Posted Document (0FISCYEARP)

  • Fiscal Year of Correction Document (0NEWYEAR)

  • Fiscal Year Variant (From Correction Document) (0NEWFVAR)

  • Compound Error Category (0COMPERROR)

  • General Ledger Account of the Posted Document (0GLACCTP)

  • General Ledger Account in Correction Document (0GLACCTM)

  • General Ledger (0LEDGERGL)

  • Chart of Accounts (From Posted Document) (0CHRTACCTSP)

  • Chart of Accounts (From Correction Document) (0CHRTACCTSM)

  • Account Type (0ACCT_TYPE)

  • Corrected Fiscal Year Variant (0FISCVARNTM)

  • Corrected Company Code (0COMPCODEM)

  • Corrected Fiscal Year (0FISCYEARM)

  • Controlling Area in Posted Document (0COAREAP)

  • Controlling Area in Correction Document (0COAREAM)

  • Cost Center in Posted Document (0CSTCENTERP)

  • Cost Center in Correction Document (0CSTCENTERM)

  • Ledger Environment (0LEDENV)

  • Last Changed By (0CHANGEUSER)

  • Monthly Average Ledger (0LEDGERMAV)

  • Name of Person who Created the Object (0CREATEDBY)

  • Number of Line Item in Accounting Document (0ITEM_NUM)

  • Original Partner Company Number (0PCOMPANYO)

  • Original Document Type (0DOCTYPO)

  • Original Posting Date of FI Document (0POSTDATEO)

  • Original Posting Key (0POSTKEYO)

  • Original General Ledger Account of the Imported Document (0GLACCTO)

  • Original Cost Center (0COAREAO)

  • Original Cost Center of the Imported Document (0CSTCENTERO)

  • Original Profit Center of the Imported Document (0PROFITCTRO)

  • Partner Company Number in Posted Document (0PCOMPANYP)

  • Partner Company Number in Correction Document (0PCOMPANYM)

  • Profit Center of Posted Document (0PROFITCTRP)

  • Profit Center of Correction Document (0PROFITCTRM)

  • Severity of Error in ECS Item (0SEVERITY)

  • Status of ECS Item (0ECSSTATUS)

  • Key Date (0CLCDAT)

  • Daily Ledger (0LEDGERDA)

  • Transaction Currency (0ECSTRNSCUR)

  • Last Changed On (0CHANGEDATE)

Key Figures

  • Amount in Transaction Currency of Posted Document (0AMTTCP)

  • Amount in Transaction Currency of Original Document (0AMTTCO)

  • Current Month Average Balance (0CURMAVG)

  • Year-to-Date Average Balance (0YTODTAVG)

  • Quarter-to-Date Average Balance (0QTODTAVG)

  • Average Activity (0AVGACT)

  • Average Activity from Ledger Version 1 (0AVGACTDB1)

  • Average Activity from Ledger Version 99 (0AVGACTDB99)

  • Current Month Activity (0CURMBAL)

  • Quarter-to-Date Activity (0QTODTACT)

  • Year-to-Date Balance (0YTODTBAL)

  • Current Day Activity (0CURDACT)

  • Prior Month Balance (0PRMBAL)

  • Prior Day Balance (0PRDBAL)