SAP ABAP Table FAGL_EXTSTRUCT_LEAD (Extraction Structure for the Leading Ledger)

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	INTTAB	Structure
Structure	FAGL_EXTSTRUCT_LEAD	Table Relationship Diagram
Short Description	Extraction Structure for the Leading Ledger

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RYEAR	☐	RYEAR	GJAHR	NUMC	4	0	Fiscal year
2	.INCLUDE	☐				0	0	General ledger: Transaction attributes
3	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
4	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
5	.INCLUDE	☐				0	0	RTCUR + RUNIT
6	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
7	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
8	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
9	.INCLUDE	☐				0	0	General ledger: Technical fields
10	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Key of Line Items
11	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
12	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
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	.INCLUDE	☐				0	0	General ledger: Main account assignment
17	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
18	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
19	.INCLUDE	☐				0	0	General ledger: SAP additional account assignment
20	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
21	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
23	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
24	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
25	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
26	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
27	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
28	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
29	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
30	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
31	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
32	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
33	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
34	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
35	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
36	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
37	.INCLUDE	☐				0	0	FI-SL: Additional Fields for the TT Extraction Structure
38	QUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
39	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
40	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
41	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
42	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
43	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
44	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
45	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
46	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
47	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
48	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
49	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
50	TURNOVER	☐	RR_SALES	WERTV9	CURR	17	2	Sales of the period
51	QUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity
52	ADQUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
53	ADQUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity
54	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
55	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	2004_1_500