General Ledger: Line Items (replicated) 
DataStore object: 0FIGL_D40
Contains replicated G/L line item data.
Structure
Delta Update
Delta update is not supported for this DataStore object.
Data Modeling
Object Type | Name | Technical Name |
|---|---|---|
Characteristic | Line Item (General Ledger View) | 0AC_DOC_LN |
Characteristic | Document Number (General Ledger View) | 0AC_DOC_NR |
Characteristic | Ledger | 0AC_LEDGER |
Characteristic | Company code | 0COMP_CODE |
Time characteristic | Fiscal year variant | 0FISCVARNT |
Time characteristic | Fiscal year | 0FISCYEAR |
Object Type | Name | Technical Name |
|---|---|---|
Characteristic | Payment Reference | 0AB_KIDNO |
Characteristic | Account type | 0ACCT_TYPE |
Characteristic | Document Number of Invoice to which Transaction Relates | 0ACDOCNO_IR |
Characteristic | Document Status | 0AC_DOCSTAT |
Characteristic | Document Text | 0AC_DOCTEXT |
Characteristic | Accounting document number | 0AC_DOC_NO |
Characteristic | Document type | 0AC_DOC_TYP |
Characteristic | Assignment Number | 0ALLOC_NMBR |
Characteristic | Asset Sub-number | 0ASSET |
Characteristic | Main Asset Number | 0ASSET_MAIN |
Characteristic | Type of Bill of Exchange Usage | 0BILLEXCHUS |
Characteristic | Billing document | 0BILL_NUM |
Characteristic | Baseline Date For Due Date Calculation | 0BLINE_DATE |
Characteristic | Business area | 0BUS_AREA |
Characteristic | Accounts Receivable Pledging Indicator | 0CESSION |
Characteristic | Chart of accounts | 0CHRT_ACCTS |
Characteristic | Clearing date | 0CLEAR_DATE |
Characteristic | Clearing was reset | 0CLEAR_REV |
Characteristic | Fiscal Year of Clearing Document | 0CLR_DOC_FY |
Characteristic | Clearing Document Number | 0CLR_DOC_NO |
Characteristic | Order Number | 0COORDER |
Characteristic | Cost Center | 0COSTCENTER |
Characteristic | Cost Element | 0COSTELMNT |
Characteristic | Controlling area | 0CO_AREA |
Characteristic | Date on which the record was created | 0CREATEDON |
Characteristic | Account number of supplier/vendor | 0CREDITOR |
Key figure | Credit amount in foreign currency | 0CREDIT_DC |
Key figure | Credit amount in local currency | 0CREDIT_LC |
Key figure | Credit Amount in Second Local Currency | 0CREDIT_LC2 |
Key figure | Credit Amount in Third Local Currency | 0CREDIT_LC3 |
Characteristic | Credit Control Area | 0C_CTR_AREA |
Key figure | Withholding Tax Base Amount in Doc. Currency | 0DEBCREDCWB |
Key figure | Amount Exempt of Withholding Tax in Doc. Currency | 0DEBCREDCWF |
Key figure | Withholding tax amount in doc. currency | 0DEBCREDCWT |
Key figure | Valuated Amount in Second Local Currency (with plus/minus) | 0DEBCREL2VA |
Key figure | Valuated Amount in Third Local Currency (with plus/minus) | 0DEBCREL3VA |
Key figure | Valuated Amount in Local Currency (with plus/minus) | 0DEBCRELCVA |
Characteristic | Customer Number | 0DEBITOR |
Key figure | Debit amount in foreign currency | 0DEBIT_DC |
Key figure | Debit amount in local currency | 0DEBIT_LC |
Key figure | Debit Amount in 2nd Local Currency | 0DEBIT_LC2 |
Key figure | Debit Amount in Third Local Currency | 0DEBIT_LC3 |
Key figure | Foreign currency amount with signs (+/-) | 0DEB_CRE_DC |
Key figure | Amount in Second Local Currency with +/- Sign | 0DEB_CRE_L2 |
Key figure | Amount in Third Local Currency with +/- Sign | 0DEB_CRE_L3 |
Key figure | Amount in Local Currency with +/- Signs | 0DEB_CRE_LC |
Key figure | Amount eligible for cash discount in document currency | 0DISC_BASE |
Unit of measurement | Document currency | 0DOC_CURRCY |
Characteristic | Document Date | 0DOC_DATE |
Characteristic | Sales document | 0DOC_NUMBER |
Characteristic | Due date for cash discount 1 | 0DSCT_DATE1 |
Key figure | Days for Cash Discount 1 | 0DSCT_DAYS1 |
Key figure | Days for Second Cash Discount | 0DSCT_DAYS2 |
Key figure | Percentage for Cash Discount 1 | 0DSCT_PCT1 |
Key figure | Percentage for second cash discount | 0DSCT_PCT2 |
Key figure | Cash discount amount in document currency | 0DSC_AMT_DC |
Key figure | Cash discount amount in local currency | 0DSC_AMT_LC |
Characteristic | Dunning Area | 0DUNN_AREA |
Characteristic | Dunning block | 0DUNN_BLOCK |
Characteristic | Dunning key | 0DUNN_KEY |
Characteristic | Dunning level | 0DUNN_LEVEL |
Time characteristic | Fiscal year / period | 0FISCPER |
Time characteristic | Posting period | 0FISCPER3 |
Characteristic | Period (Entry View) | 0FISCPER3_E |
Characteristic | Fiscal Year Variant (Entry View) | 0FISCVRNT_E |
Characteristic | Year (Entry View) | 0FISCYEAR_E |
Characteristic | Reference Procedure | 0FI_AWTYP |
Characteristic | Business Transaction | 0FI_RACTIV |
Characteristic | Account Number of the Branch | 0FI_SUBSID |
Characteristic | Contract Number (Loans) | 0FS_CTR_NO |
Characteristic | Contract Type | 0FS_CTR_TP |
Characteristic | Flow Type | 0FS_FLW_TP |
Characteristic | Functional area | 0FUNC_AREA |
Characteristic | G/L Account | 0GL_ACCOUNT |
Characteristic | Clearing Status of Line Item | 0GL_CLRSTAT |
Characteristic | Document Status (for Selection) | 0GL_DOCSTAT |
Characteristic | Ledger Group | 0GL_LDGRP |
Characteristic | Ledger Group-Specific Clearing | 0GL_LGCLR |
Characteristic | Business Place | 0ID_BUPLA |
Characteristic | Tax Code | 0IS_TXCOD |
Characteristic | Number of line item within accounting document | 0ITEM_NUM |
Characteristic | Date of last dunning notice | 0LAST_DUNN |
Unit of measurement | Second Local Currency | 0LOC_CURRC2 |
Unit of measurement | Third Local Currency | 0LOC_CURRC3 |
Unit of measurement | Local currency | 0LOC_CURRCY |
Characteristic | Currency Type of Second Local Currency | 0LOC_CURTP2 |
Characteristic | Currency Type of Third Local Currency | 0LOC_CURTP3 |
Characteristic | Movement Type | 0MOVE_TYPE |
Characteristic | Negative Posting | 0NEGPSTNG |
Characteristic | Due date for net payment | 0NETDUEDATE |
Key figure | Deadline for Net Conditions | 0NETTERMS |
Characteristic | Purchasing document number | 0OI_EBELN |
Characteristic | Item number of purchasing document | 0OI_EBELP |
Characteristic | Partner profit center | 0PART_PRCTR |
Characteristic | Trading partner business area of the business partner | 0PBUS_AREA |
Characteristic | Partner Company Number | 0PCOMPANY |
Characteristic | Partner Functional Area | 0PFUNC_AREA |
Characteristic | Plant | 0PLANT |
Characteristic | Terms of Payment Key | 0PMNTTRMS |
Characteristic | Payment block key | 0PMNT_BLOCK |
Characteristic | Payment method supplement | 0PMTMTHSUPL |
Characteristic | Item Text | 0POSTXT |
Characteristic | Posting key | 0POST_KEY |
Characteristic | Profit Center | 0PROFIT_CTR |
Characteristic | Partner Segment for Segmental Reporting | 0PSEGMENT |
Characteristic | Reference Key | 0PSM_AWKEY |
Characteristic | Logical system of source document | 0PSM_AWSYS |
Characteristic | Posting date in the document | 0PSTNG_DATE |
Key figure | Quantity | 0QUANTITY |
Characteristic | Reconciliation Account | 0RC_ACCOUNT |
Characteristic | Difference Reason for Payments | 0REASON_CDE |
Data packet characteristic | BW Delta Process: Update Mode | 0RECORDMODE |
Characteristic | Reference document number | 0REF_DOC_NO |
Characteristic | Reference Key 1 | 0REF_KEY1 |
Characteristic | Reference Key 2 | 0REF_KEY2 |
Characteristic | Reference Key 3 | 0REF_KEY3 |
Characteristic | Fiscal Year of Reversal Document | 0REV_DOC_FY |
Characteristic | Reversal Document Number | 0REV_DOC_NO |
Characteristic | Segment for Segmental Reporting | 0SEGMENT |
Characteristic | Sending Cost Center | 0SEND_CCTR |
Characteristic | Special General Ledger Indicator | 0SP_GL_IND |
Characteristic | Transaction Class Special General Ledger | 0SP_GL_TT |
Characteristic | Sales document item | 0S_ORD_ITEM |
Unit of measurement | Unit of Measure | 0UNIT |
Characteristic | User Name | 0USERNAME |
Characteristic | Value Date | 0VALUE_DATE |
Key figure | Amount in local currency | 0VALUE_LC |
Characteristic | Work Breakdown Structure Element (WBS Element) | 0WBS_ELEMT |
Characteristic | Work breakdown structure element (external) | 0WBS_ELM_EX |