1. SAP Tutorial
  2. FI Module

FAGL_BW_LOG_ITEM SAP table for – FI-GL: Log for BW Extraction: Line Items

Here we would like to draw your attention to FAGL_BW_LOG_ITEM table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGL_BW_LOG_ITEM is a SAP standard transp table used for storing FI-GL: Log for BW Extraction: Line Items related data in SAP. It comes under the package GBIW_ERP.

SAP FAGL_BW_LOG_ITEM table

Table FAGL_BW_LOG_ITEM technical data

TableFAGL_BW_LOG_ITEM
Data storingFI-GL: Log for BW Extraction: Line Items
ModuleFI
Sub ModuleFI-GL
SAP PackageGBIW_ERP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FAGL_BW_LOG_ITEM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FAGL_BW_LOG_ITEM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DATASOURCE : InfoSource
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • REQUNR : Request number for the data transfer
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • LOGTIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • RECNR : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • LDGRP : Ledger Group
    Its data type is CHAR (Character String) with field length 4
  • DOCNR : Doc. Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Six-Character Posting Item for Ledger
    Its data type is CHAR (Character String) with field length 6
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FISCPER : Fiscal year / period
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • CURT2 : Currency Type of Second Local Currency
    Its data type is CHAR (Character String) with field length 2
  • CURT3 : Currency Type of Third Local Currency
    Its data type is CHAR (Character String) with field length 2
  • DMSHB : Amount in Local Currency with +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • HWAE2 : Currency Key of Second Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • HWAE3 : Currency Key of Third Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMHAB : Credit Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMHA2 : Credit Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMHA3 : Credit Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMSOL : Debit Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMSO2 : Debit Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMSO3 : Debit Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • DMSH2 : Amount in Second Local Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • DMSH3 : Amount in Third Local Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • WRHAB : Credit Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • WRSOL : Debit Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • RCNTR : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • RPRCTR : Receiver profit center
    Its data type is CHAR (Character String) with field length 10
  • QUANUNIT : Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VALUETYPE : Value type for Reporting
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CURTYPE : Currency type
    Its data type is CHAR (Character String) with field length 2
  • FISCVAR : Fiscal year variant
    Its data type is CHAR (Character String) with field length 2
  • CHARTACCTS : Chart of Accounts
    Its data type is CHAR (Character String) with field length 4
  • UPMOD : BW Delta Process: Record Mode
    Its data type is CHAR (Character String) with field length 1
  • VALUTYP : Valuation View
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CURRUNIT : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BALANCE : Accumulated balance
    Its data type is CURR (Currency Field) with field length 17
  • DEBIT : Total debit postings
    Its data type is CURR (Currency Field) with field length 17
  • CREDIT : Total credit postings
    Its data type is CURR (Currency Field) with field length 17
  • TURNOVER : Sales of the period
    Its data type is CURR (Currency Field) with field length 17
  • QUANTITY : Consumption Quantity
    Its data type is QUAN (Quantity field) with field length 17

    • FAGL_BW_LOG_ITEM related tables

    • FAGL_QUEUE_LOG : Log of Delta Queue for Error Analysis
    • FAGL_BW_LOG_TOTL : FI-GL: Log for BW Extraction: Totals Records
    • FAGL_BW_LOG_HEAD : FI-GL: Log for BW Extraction: Control Data
    • FAGL_BW_LOG_ITEM : FI-GL: Log for BW Extraction: Line Items

    FAGL_BW_LOG_ITEM related transaction codes under SAP package GBIW_ERP

    • FAGLBW03 : Assign Gen. Ledger DataSource/Ledger
    • FAGLBW01 : Generate Gen. Ledger Extract Struct.

    Related References

    Related Tutorials

    FAGL_BW_LOG_TOTL SAP table for – FI-GL: Log for BW Extraction: Totals Records

    FAGL_BW_LOG_TOTL table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of FI-GL:...

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    FAGLFLEXP SAP table for – General Ledger: Plan Line Items

    FAGLFLEXP table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of General...

    FMIP SAP table for – Plan Line Items Table for Funds Management

    FMIP table in SAP FI (Funds Management in FI) module. This table is used for storing data of Plan Line...

    GLFLEXP SAP table for – Flexible G/L: Plan line items

    GLFLEXP table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Flexible...

    J_3RKKRS SAP table for – Account correspondence line items

    J_3RKKRS table in SAP FI (Localization in FI) module. This table is used for storing data of Account correspondence line...

    PCRRETAILP SAP table for – Plan line items table

    PCRRETAILP table in SAP FI (Retail Ledger in FI) module. This table is used for storing data of Plan line...

    «
    »