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 |