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

SAP table FAGL_BW_LOG_TOTL has 5 primary key fields being MANDT,DATASOURCE,REQUNR,LOGTIMESTAMP,RECNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
DATASOURCE InfoSource CHAR 30 0 RSISOURCE
REQUNR Request number for the data transfer CHAR 30 0 RSREQUNR
LOGTIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
RECNR Record number of the line item record CHAR 18 0 GU_RECID
RYEAR Fiscal year NUMC 4 0 RYEAR
ACTIV FI-SL Business Transaction CHAR 4 0 T022 ACTI1
RMVCT Transaction type CHAR 3 0 T856 RMVCT
RTCUR Currency Key CUKY 5 0 RTCUR
RUNIT Base Unit of Measure UNIT 3 0 MEINS
AWTYP Reference procedure CHAR 5 0 TTYP AWTYP
RLDNR Ledger in General Ledger Accounting CHAR 2 0 V_FAGL_T881_DBAL FAGL_RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 RVERS
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
RACCT Account Number CHAR 10 0 SKB1 RACCT
COST_ELEM Cost Element CHAR 10 0 CSKB KSTAR
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RCNTR Cost Center CHAR 10 0 CSKS KOSTL
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
RFAREA Functional Area CHAR 16 0 TFKB FKBER
RBUSA Business Area CHAR 4 0 TGSB GSBER
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
SCNTR Sender cost center CHAR 10 0 CSKS SKOST
PPRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
SFAREA Partner Functional Area CHAR 16 0 TFKB SFKBER
SBUSA Trading partner's business area CHAR 4 0 TGSB PARGB
RASSC Company ID of Trading Partner CHAR 6 0 T880 RASSC
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_PSEGMENT
QUANUNIT Unit of Measure UNIT 3 0 ROUNIT
VALUETYPE Value type for Reporting NUMC 3 0 RSVTYPE
CURTYPE Currency type CHAR 2 0 RSCURTYPE
00 Document currency
10 Company code currency
20 Controlling area currency
30 Group currency
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
80 Ledger currency
90 Profit center invoice currency
FISCPER Fiscal year / period NUMC 7 0 RSFISCPER
FISCVAR Fiscal year variant CHAR 2 0 RSFISCVAR
CHARTACCTS Chart of Accounts CHAR 4 0 KTOPL
UPMOD BW Delta Process: Record Mode CHAR 1 0 RODMUPDMOD
After-Image
A Add
D Delete (Key Only)
N New Image
R Reverse-Image
X Before-Image
Y Update Image (Value from Update)
VALUTYP Valuation View NUMC 1 0 VALUTYP
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
CURRUNIT Currency Key CUKY 5 0 RSCURRENCY
BALANCE Accumulated Balance CURR 23 2 RR_KUMSL
DEBIT Total Debit Postings CURR 23 2 RR_UMSOL
CREDIT Total Credit Postings CURR 23 2 RR_UMHAB
TURNOVER Sales of the Period CURR 23 2 RR_SALES
QUANTITY Consumption Quantity QUAN 17 3 SMEGR9
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
RCOMP Company CHAR 6 0 RCOMP_D
RPRCTR Receiver profit center CHAR 10 0 RPRCTR
SPRCTR Sender Profit Center CHAR 10 0 SPRCTR
GJAHR Fiscal Year NUMC 4 0 GJAHR
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
DOCLN Six-Character Posting Item for Ledger CHAR 6 0 DOCLN6
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
BTTYPE Business Transaction Category CHAR 4 0 FINS_BTTYPE
KUNNR Customer Number CHAR 10 0 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
MATNR Material Number CHAR 40 0 MATNR
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
DRCRK Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
POPER Posting period NUMC 3 0 POPER
PERIV Fiscal Year Variant CHAR 2 0 PERIV
FISCYEARPER Period/Year NUMC 7 0 JAHRPER
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
BLART Document Type CHAR 2 0 BLART
USNAM User Name CHAR 12 0 USNAM
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
RWCUR Currency key of the original transaction currency CUKY 5 0 RWCUR
RHCUR Local Currency CUKY 5 0 HWAER
RKCUR Controlling area currency CUKY 5 0 KWAER
ROCUR Currency Key of Third Currency CUKY 5 0 FAGL_CURR3
WSL Value in Original Transaction Currency (Document Currency) CURR 23 2 VWCUR12
HSL Value in Local Currency CURR 23 2 VLCUR12
KSL Value in Group Currency CURR 23 2 VGCUR12
OSL Value in Another Currency CURR 23 2 VOCUR12

FAGL_BW_LOG_TOTL foreign key relationships

Table Field Check Table Check Field
0 FAGL_BW_LOG_TOTL AWTYP TTYP Object Types for Accounting AWTYP
1 FAGL_BW_LOG_TOTL COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
1 FAGL_BW_LOG_TOTL COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
1 FAGL_BW_LOG_TOTL COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
1 FAGL_BW_LOG_TOTL COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
0 FAGL_BW_LOG_TOTL KOKRS TKA01 Controlling Areas MANDT
1 FAGL_BW_LOG_TOTL LOGSYS TBDLS Logical system LOGSYS
0 FAGL_BW_LOG_TOTL PPRCTR CEPC Profit Center Master Data Table PRCTR
0 FAGL_BW_LOG_TOTL PPRCTR CEPC Profit Center Master Data Table DATBI
0 FAGL_BW_LOG_TOTL PPRCTR CEPC Profit Center Master Data Table KOKRS
1 FAGL_BW_LOG_TOTL PRCTR CEPC Profit Center Master Data Table PRCTR
1 FAGL_BW_LOG_TOTL PRCTR CEPC Profit Center Master Data Table DATBI
1 FAGL_BW_LOG_TOTL PRCTR CEPC Profit Center Master Data Table KOKRS
0 FAGL_BW_LOG_TOTL PSEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FAGL_BW_LOG_TOTL RACCT SKB1 G/L account master (company code) MANDT
1 FAGL_BW_LOG_TOTL RACCT SKB1 G/L account master (company code) BUKRS
0 FAGL_BW_LOG_TOTL RASSC T880 Global Company Data (for KONS Ledger) MANDT
0 FAGL_BW_LOG_TOTL RASSC T880 Global Company Data (for KONS Ledger) RCOMP
1 FAGL_BW_LOG_TOTL RBUKRS T001 Company Codes BUKRS
0 FAGL_BW_LOG_TOTL RBUSA TGSB Business Areas MANDT
0 FAGL_BW_LOG_TOTL RBUSA TGSB Business Areas GSBER
1 FAGL_BW_LOG_TOTL RCNTR CSKS Cost Center Master Record MANDT
1 FAGL_BW_LOG_TOTL RCNTR CSKS Cost Center Master Record KOKRS
1 FAGL_BW_LOG_TOTL RCNTR CSKS Cost Center Master Record KOSTL
1 FAGL_BW_LOG_TOTL RCNTR CSKS Cost Center Master Record DATBI
0 FAGL_BW_LOG_TOTL RFAREA TFKB Functional areas FKBER
1 FAGL_BW_LOG_TOTL RMVCT T856 Transaction Types MANDT
1 FAGL_BW_LOG_TOTL RMVCT T856 Transaction Types TRTYP
0 FAGL_BW_LOG_TOTL SBUSA TGSB Business Areas MANDT
0 FAGL_BW_LOG_TOTL SBUSA TGSB Business Areas GSBER
1 FAGL_BW_LOG_TOTL SCNTR CSKS Cost Center Master Record MANDT
1 FAGL_BW_LOG_TOTL SCNTR CSKS Cost Center Master Record KOKRS
1 FAGL_BW_LOG_TOTL SCNTR CSKS Cost Center Master Record KOSTL
1 FAGL_BW_LOG_TOTL SCNTR CSKS Cost Center Master Record DATBI
0 FAGL_BW_LOG_TOTL SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 FAGL_BW_LOG_TOTL SFAREA TFKB Functional areas FKBER