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

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ GBIW_ERP (Package) Extractors for General Ledger in ERP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FAGL_BW_LOG_TOTL	Table Relationship Diagram
Short Description	FI-GL: Log for BW Extraction: Totals Records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DATASOURCE	☑	RSISOURCE	RSISOURCE	CHAR	30	0	InfoSource
3	REQUNR	☑	RSREQUNR	RSREQUNR	CHAR	30	0	Request number for the data transfer
4	LOGTIMESTAMP	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	RECNR	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
6	RYEAR	☐	RYEAR	GJAHR	NUMC	4	0	Fiscal year
7	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
8	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
9	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
10	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
11	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
12	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
13	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
14	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
15	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
16	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
17	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
18	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
20	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
21	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
22	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
23	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
24	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
25	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
26	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
27	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
28	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
29	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
30	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
31	QUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
32	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
33	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
34	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
35	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
36	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
37	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
38	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
39	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
40	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
41	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
42	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
43	TURNOVER	☐	RR_SALES	WERTV9	CURR	17	2	Sales of the period
44	QUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity
45	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
46	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
47	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
48	RPRCTR	☐	RPRCTR	PRCTR	CHAR	10	0	Receiver profit center	*
49	SPRCTR	☐	SPRCTR	PRCTR	CHAR	10	0	Sender Profit Center	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGL_BW_LOG_TOTL	ACTIV	T022	ACTIVITY
2	FAGL_BW_LOG_TOTL	AWTYP	TTYP	AWTYP
3	FAGL_BW_LOG_TOTL	COST_ELEM	CSKB	KSTAR
4	FAGL_BW_LOG_TOTL	KOKRS	TKA01	KOKRS
5	FAGL_BW_LOG_TOTL	LOGSYS	TBDLS	LOGSYS
6	FAGL_BW_LOG_TOTL	PPRCTR	CEPC	PRCTR
7	FAGL_BW_LOG_TOTL	PRCTR	CEPC	PRCTR
8	FAGL_BW_LOG_TOTL	PSEGMENT	FAGL_SEGM	SEGMENT
9	FAGL_BW_LOG_TOTL	RACCT	SKB1	SAKNR
10	FAGL_BW_LOG_TOTL	RASSC	T880	RCOMP	KEY	1	CN
11	FAGL_BW_LOG_TOTL	RBUKRS	T001	BUKRS
12	FAGL_BW_LOG_TOTL	RBUSA	TGSB	GSBER
13	FAGL_BW_LOG_TOTL	RCNTR	CSKS	KOSTL
14	FAGL_BW_LOG_TOTL	RFAREA	TFKB	FKBER
15	FAGL_BW_LOG_TOTL	RLDNR	V_FAGL_T881_DBAL	RLDNR
16	FAGL_BW_LOG_TOTL	RMVCT	T856	TRTYP
17	FAGL_BW_LOG_TOTL	SBUSA	TGSB	GSBER	KEY	1	CN
18	FAGL_BW_LOG_TOTL	SCNTR	CSKS	KOSTL
19	FAGL_BW_LOG_TOTL	SEGMENT	FAGL_SEGM	SEGMENT
20	FAGL_BW_LOG_TOTL	SFAREA	TFKB	FKBER	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	606