FAGL_BW_LOG_TOTL - FI-GL: Log for BW Extraction: Totals Records

FI-GL: Log for BW Extraction: Totals Records information is stored in SAP table FAGL_BW_LOG_TOTL.
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_TOTL

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
RYEAR	Fiscal year		RYEAR	NUMC	8
ACTIV	FI-SL Business Transaction		ACTI1	CHAR	8	T022
RMVCT	Transaction type		RMVCT	CHAR	6	T856
RTCUR	Currency Key		RTCUR	CUKY	10
RUNIT	Base Unit of Measure		MEINS	UNIT	6
AWTYP	Reference procedure		AWTYP	CHAR	10	TTYP
RLDNR	Ledger in General Ledger Accounting		FAGL_RLDNR	CHAR	4	V_FAGL_T881_DBAL
RRCTY	Record Type		RRCTY	CHAR	2
RVERS	Version		RVERS	CHAR	6
LOGSYS	Logical system		LOGSYS	CHAR	20	TBDLS
RACCT	Account Number		RACCT	CHAR	20	SKB1
COST_ELEM	Cost Element		KSTAR	CHAR	20	CSKB
RBUKRS	Company Code		BUKRS	CHAR	8	T001
RCNTR	Cost Center		KOSTL	CHAR	20	CSKS
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
RFAREA	Functional Area		FKBER	CHAR	32	TFKB
RBUSA	Business Area		GSBER	CHAR	8	TGSB
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	FAGL_SEGM
SCNTR	Sender cost center		SKOST	CHAR	20	CSKS
PPRCTR	Partner Profit Center		PPRCTR	CHAR	20	CEPC
SFAREA	Partner Functional Area		SFKBER	CHAR	32	TFKB
SBUSA	Trading partner's business area		PARGB	CHAR	8	TGSB
RASSC	Company ID of Trading Partner		RASSC	CHAR	12	T880
PSEGMENT	Partner Segment for Segmental Reporting		FB_PSEGMENT	CHAR	20	FAGL_SEGM
QUANUNIT	Unit of Measure		ROUNIT	UNIT	6
VALUETYPE	Value type for Reporting		RSVTYPE	NUMC	6
CURTYPE	Currency type		RSCURTYPE	CHAR	4
FISCPER	Fiscal year / period		RSFISCPER	NUMC	14
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
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
CPUTM	Time of Entry		CPUTM	TIMS	12
RCOMP	Company		RCOMP_D	CHAR	12
RPRCTR	Receiver profit center		RPRCTR	CHAR	20
SPRCTR	Sender Profit Center		SPRCTR	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
DOCLN	Six-Character Posting Item for Ledger		DOCLN6	CHAR	12
AUGBL	Document Number of the Clearing Document		AUGBL	CHAR	20
AUGDT	Clearing Date		AUGDT	DATS	16
AUGGJ	Fiscal Year of Clearing Document		AUGGJ	NUMC	8
BTTYPE	Business Transaction Category		FINS_BTTYPE	CHAR	8
KUNNR	Customer Number		KUNNR	CHAR	20
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
MATNR	Material Number		MATNR	CHAR	80
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
DRCRK	Debit/Credit Indicator		SHKZG	CHAR	2
POPER	Posting period		POPER	NUMC	6
PERIV	Fiscal Year Variant		PERIV	CHAR	4
FISCYEARPER	Period/Year		JAHRPER	NUMC	14
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BLDAT	Document Date in Document		BLDAT	DATS	16
BLART	Document Type		BLART	CHAR	4
USNAM	User Name		USNAM	CHAR	24
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
RWCUR	Currency key of the original transaction currency		RWCUR	CUKY	10
RHCUR	Local Currency		HWAER	CUKY	10
RKCUR	Controlling area currency		KWAER	CUKY	10
ROCUR	Currency Key of Third Currency		FAGL_CURR3	CUKY	10
WSL	Value in Original Transaction Currency (Document Currency)		VWCUR12	CURR	12
HSL	Value in Local Currency		VLCUR12	CURR	12
KSL	Value in Group Currency		VGCUR12	CURR	12
OSL	Value in Another Currency		VOCUR12	CURR	12