FAGL_BW_LOG_ITEM - FI-GL: Log for BW Extraction: Line Items
FI-GL: Log for BW Extraction: Line Items information is stored in SAP table FAGL_BW_LOG_ITEM.
It is part of development package GBIW_ERP in software component FI-GL-IS. This development package consists of objects that can be grouped under "Extractors for General Ledger in ERP".
It is part of development package GBIW_ERP in software component FI-GL-IS. This development package consists of objects that can be grouped under "Extractors for General Ledger in ERP".
Fields for table FAGL_BW_LOG_ITEM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DATASOURCE | InfoSource | X | RSISOURCE | CHAR | 60 | |
| REQUNR | Request number for the data transfer | X | RSREQUNR | CHAR | 60 | |
| LOGTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | X | TIMESTAMP | DEC | 8 | |
| RECNR | Record number of the line item record | X | GU_RECID | CHAR | 36 | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
| BELNR | Accounting Document Number | BELNR_BIW | CHAR | 20 | ||
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
| RLDNR | Ledger | RLDNR | CHAR | 4 | ||
| LDGRP | Ledger Group | FAGL_LDGRP | CHAR | 8 | ||
| DOCNR | Doc. Number | DOCNR | CHAR | 20 | ||
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6_POS | CHAR | 12 | ||
| MONAT | Fiscal period | MONAT | NUMC | 4 | ||
| FISCPER | Fiscal year / period | RSFISCPER | NUMC | 14 | ||
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 20 | ||
| AUGDT | Clearing Date | AUGDT | DATS | 16 | ||
| BLART | Document Type | BLART | CHAR | 4 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| BSCHL | Posting Key | BSCHL | CHAR | 4 | ||
| BSTAT | Document Status | BSTAT_D | CHAR | 2 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| HKONT | General Ledger Account | HKONT | CHAR | 20 | ||
| KOSTL | Cost Center | KOSTL | CHAR | 20 | ||
| PRCTR | Profit Center | PRCTR | CHAR | 20 | ||
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 20 | ||
| GSBER | Business Area | GSBER | CHAR | 8 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| WAERS | Currency Key | WAERS | CUKY | 10 | ||
| WRBTR | Amount in document currency | WRBTR | CURR | 12 | ||
| CURT2 | Currency Type of Second Local Currency | CURT2 | CHAR | 4 | ||
| CURT3 | Currency Type of Third Local Currency | CURT3 | CHAR | 4 | ||
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB | CURR | 12 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | ||
| DMBTR | Amount in local currency | DMBTR | CURR | 12 | ||
| DMBE2 | Amount in Second Local Currency or Global Currency | DMBE2 | CURR | 12 | ||
| HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 10 | ||
| DMBE3 | Amount in Third Local Currency or First Freely-Def. Currency | DMBE3 | CURR | 12 | ||
| HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 10 | ||
| DMHAB | Credit Amount in Local Currency | DMHAB | CURR | 12 | ||
| DMHA2 | Credit Amount in Second Local Currency | DMHA2 | CURR | 12 | ||
| DMHA3 | Credit Amount in Third Local Currency | DMHA3 | CURR | 12 | ||
| DMSOL | Debit Amount in Local Currency | DMSOL | CURR | 12 | ||
| DMSO2 | Debit Amount in Second Local Currency | DMSO2 | CURR | 12 | ||
| DMSO3 | Debit Amount in Third Local Currency | DMSO3 | CURR | 12 | ||
| DMSH2 | Amount in Second Local Currency with +/- Sign | DMSH2 | CURR | 12 | ||
| DMSH3 | Amount in Third Local Currency with +/- Sign | DMSH3 | CURR | 12 | ||
| WRHAB | Credit Amount in Document Currency | WRHAB | CURR | 12 | ||
| WRSOL | Debit Amount in Document Currency | WRSOL | CURR | 12 | ||
| RBUKRS | Company Code | BUKRS | CHAR | 8 | ||
| RACCT | Account Number | RACCT | CHAR | 20 | ||
| RCNTR | Cost Center | KOSTL | CHAR | 20 | ||
| RPRCTR | Receiver profit center | RPRCTR | CHAR | 20 | ||
| QUANUNIT | Unit of Measure | ROUNIT | UNIT | 6 | ||
| VALUETYPE | Value type for Reporting | RSVTYPE | NUMC | 6 | ||
| CURTYPE | Currency type | RSCURTYPE | CHAR | 4 | ||
| FISCVAR | Fiscal year variant | RSFISCVAR | CHAR | 4 | ||
| CHARTACCTS | Chart of Accounts | KTOPL | CHAR | 8 | ||
| UPMOD | BW Delta Process: Record Mode | RODMUPDMOD | CHAR | 2 | ||
| VALUTYP | Valuation View | VALUTYP | NUMC | 2 | ||
| CURRUNIT | Currency Key | RSCURRENCY | CUKY | 10 | ||
| BALANCE | Accumulated Balance | RR_KUMSL | CURR | 12 | ||
| DEBIT | Total Debit Postings | RR_UMSOL | CURR | 12 | ||
| CREDIT | Total Credit Postings | RR_UMHAB | CURR | 12 | ||
| TURNOVER | Sales of the Period | RR_SALES | CURR | 12 | ||
| QUANTITY | Consumption Quantity | SMEGR9 | QUAN | 9 | ||
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
| KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
| MLDWAER | Currency Key | WAERS | CUKY | 10 | ||
| HWBAS | Tax Base Amount in Local Currency | HWBAS_BSES | CURR | 12 | ||
| FWBAS | Tax Base Amount in Document Currency | FWBAS_BSES | CURR | 12 | ||
| HWSTE | Tax Amount in Local Currency | HWSTE | CURR | 12 | ||
| FWSTE | Tax Amount in Document Currency | FWSTE | CURR | 12 |