1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to FAGL_BW_LOG_TOTL 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_TOTL is a SAP standard transp table used for storing FI-GL: Log for BW Extraction: Totals Records related data in SAP. It comes under the package GBIW_ERP.

SAP FAGL_BW_LOG_TOTL table

Table FAGL_BW_LOG_TOTL technical data

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

SAP FAGL_BW_LOG_TOTL 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_TOTL 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
  • RYEAR : Fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ACTIV : FI-SL Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • RLDNR : Ledger in General Ledger Accounting
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • COST_ELEM : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RCNTR : 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
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • SCNTR : Sender cost center
    Its data type is CHAR (Character String) with field length 10
  • PPRCTR : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • SFAREA : Partner Functional Area
    Its data type is CHAR (Character String) with field length 16
  • SBUSA : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • RASSC : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • PSEGMENT : Partner Segment for Segmental Reporting
    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
  • FISCPER : Fiscal year / period
    Its data type is NUMC (Character String with Digits Only) with field length 7
  • 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
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RCOMP : Company
    Its data type is CHAR (Character String) with field length 6
  • RPRCTR : Receiver profit center
    Its data type is CHAR (Character String) with field length 10
  • SPRCTR : Sender Profit Center
    Its data type is CHAR (Character String) with field length 10

    • FAGL_BW_LOG_TOTL related tables

    • 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_QUEUE_LOG : Log of Delta Queue for Error Analysis

    FAGL_BW_LOG_TOTL 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_ITEM SAP table for – FI-GL: Log for BW Extraction: Line Items

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

    FAGL_BW_LOG_HEAD SAP table for – FI-GL: Log for BW Extraction: Control Data

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

    DFKKSUMOLD SAP table for – Totals Records Without Account Assignment Changes

    DFKKSUMOLD table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    FAGL_QUEUE_LOG SAP table for – Log of Delta Queue for Error Analysis

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

    SE16_ECMCT SAP tcode for – Data Browser Totals Records

    SE16_ECMCT tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Data Browser Totals...

    S_P6B_12000112 SAP tcode for – Database List of Totals Records

    S_P6B_12000112 tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Database List of...

    FAGLFLEXT SAP table for – General Ledger: Totals

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

    «
    »