FAGL_BW_LOG_TOTL

FI-GL: Log for BW Extraction: Totals Records | #transactional | Component: Information System
Column Name Description
MANDT Client
DATASOURCE InfoSource
REQUNR Request number for the data transfer
LOGTIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
RECNR Record number of the line item record
Column Name Description
💲 Currency Key (CURRUNIT):
BALANCE Accumulated Balance
DEBIT Total Debit Postings
CREDIT Total Credit Postings
TURNOVER Sales of the Period
💲 Currency key of the original transaction currency (RWCUR):
WSL Value in Original Transaction Currency (Document Currency)
💲 Local Currency (RHCUR):
HSL Value in Local Currency
💲 Controlling area currency (RKCUR):
KSL Value in Group Currency
💲 Currency Key of Third Currency (ROCUR):
OSL Value in Another Currency
Column Name Description
📏 Unit of Measure (QUANUNIT):
QUANTITY Consumption Quantity
Column Name Description
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
AUGDT Clearing Date
BUDAT Posting Date in the Document
BLDAT Document Date in Document
Column Name Description
RRCTY Record Type Show values
CURTYPE Currency type Show values
UPMOD BW Delta Process: Record Mode Show values
VALUTYP Valuation View Show values
DRCRK Debit/Credit Indicator Show values
Column Name Description Domain name
RYEAR Fiscal year GJAHR
RVERS Version RVERS
VALUETYPE Value type for Reporting RSVTYPE
FISCPER Fiscal year / period RSFISCPER
FISCVAR Fiscal year variant RSFISCVAR
CHARTACCTS Chart of Accounts KTOPL
RCOMP Company RCOMP
RPRCTR Receiver profit center PRCTR
SPRCTR Sender Profit Center PRCTR
GJAHR Fiscal Year GJAHR
BELNR Document Number of an Accounting Document BELNR
BUZEI Number of Line Item Within Accounting Document BUZEI
DOCLN Six-Character Posting Item for Ledger DOCLN6
AUGBL Document Number of the Clearing Document BELNR
AUGGJ Fiscal Year of Clearing Document GJAHR
BTTYPE Business Transaction Category FINS_BTTYPE
KUNNR Customer Number KUNNR
LIFNR Account Number of Supplier LIFNR
MATNR Material Number MATNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
POPER Posting period POPER
PERIV Fiscal Year Variant PERIV
FISCYEARPER Period/Year JAHRPER
BLART Document Type BLART
USNAM User Name XUBNAME
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
FI-SL Business Transaction FAGL_BW_LOG_TOTL.ACTIV == T022.ACTIVITY
Reference procedure FAGL_BW_LOG_TOTL.AWTYP == TTYP.AWTYP
Cost Element
  • Controlling Area
  • Cost Element
  • ?
  • Client
  • FAGL_BW_LOG_TOTL.KOKRS == CSKB.KOKRS
  • FAGL_BW_LOG_TOTL.COST_ELEM == CSKB.KSTAR
  • FAGL_BW_LOG_TOTL.[column in domain "DATBI"] == CSKB.DATBI
  • FAGL_BW_LOG_TOTL.MANDT == CSKB.MANDT
Controlling Area
  • FAGL_BW_LOG_TOTL.MANDT == TKA01.MANDT
  • FAGL_BW_LOG_TOTL.KOKRS == TKA01.KOKRS
Logical system FAGL_BW_LOG_TOTL.LOGSYS == TBDLS.LOGSYS
Partner Profit Center
  • ?
  • ?
  • Partner Profit Center
  • FAGL_BW_LOG_TOTL.MANDT == CEPC.MANDT
  • FAGL_BW_LOG_TOTL.[column in domain "DATBI"] == CEPC.DATBI
  • FAGL_BW_LOG_TOTL.[column in domain "KOKRS"] == CEPC.KOKRS
  • FAGL_BW_LOG_TOTL.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • FAGL_BW_LOG_TOTL.MANDT == CEPC.MANDT
  • FAGL_BW_LOG_TOTL.[column in domain "DATBI"] == CEPC.DATBI
  • FAGL_BW_LOG_TOTL.KOKRS == CEPC.KOKRS
  • FAGL_BW_LOG_TOTL.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
Account Number
  • Company Code
  • Client
  • Account Number
  • FAGL_BW_LOG_TOTL.RBUKRS == SKB1.BUKRS
  • FAGL_BW_LOG_TOTL.MANDT == SKB1.MANDT
  • FAGL_BW_LOG_TOTL.RACCT == SKB1.SAKNR
Company ID of Trading Partner
  • FAGL_BW_LOG_TOTL.MANDT == T880.MANDT
  • FAGL_BW_LOG_TOTL.RASSC == T880.RCOMP
Company Code
  • FAGL_BW_LOG_TOTL.MANDT == T001.MANDT
  • FAGL_BW_LOG_TOTL.RBUKRS == T001.BUKRS
Business Area
  • FAGL_BW_LOG_TOTL.MANDT == TGSB.MANDT
  • FAGL_BW_LOG_TOTL.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • FAGL_BW_LOG_TOTL.MANDT == CSKS.MANDT
  • FAGL_BW_LOG_TOTL.[column in domain "DATBI"] == CSKS.DATBI
  • FAGL_BW_LOG_TOTL.RCNTR == CSKS.KOSTL
  • FAGL_BW_LOG_TOTL.KOKRS == CSKS.KOKRS
Functional Area
  • FAGL_BW_LOG_TOTL.MANDT == TFKB.MANDT
  • FAGL_BW_LOG_TOTL.RFAREA == TFKB.FKBER
Transaction type
  • FAGL_BW_LOG_TOTL.MANDT == T856.MANDT
  • FAGL_BW_LOG_TOTL.RMVCT == T856.TRTYP
Trading partner's business area
  • FAGL_BW_LOG_TOTL.MANDT == TGSB.MANDT
  • FAGL_BW_LOG_TOTL.SBUSA == TGSB.GSBER
Sender cost center
  • ?
  • Sender cost center
  • ?
  • FAGL_BW_LOG_TOTL.MANDT == CSKS.MANDT
  • FAGL_BW_LOG_TOTL.[column in domain "DATBI"] == CSKS.DATBI
  • FAGL_BW_LOG_TOTL.SCNTR == CSKS.KOSTL
  • FAGL_BW_LOG_TOTL.[column in domain "KOKRS"] == CSKS.KOKRS
Segment for Segmental Reporting
Partner Functional Area
  • FAGL_BW_LOG_TOTL.MANDT == TFKB.MANDT
  • FAGL_BW_LOG_TOTL.SFAREA == TFKB.FKBER