SAP ABAP Table GLE_STR_ADB_KF_DELTA_EXTR (Extraction Structure for ADB Key Figures (Delta Extraction))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL-ADB (Application Component) Average Daily Balance
     ⤷ GADB_AL_APPL (Package) ADB Application Layer

Basic Data

Table Category	INTTAB	Structure
Structure	GLE_STR_ADB_KF_DELTA_EXTR	Table Relationship Diagram
Short Description	Extraction Structure for ADB Key Figures (Delta Extraction)

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	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
3	.INCLUDE	☐				0	0	General ledger: Transaction attributes
4	ACTIV	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
5	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
6	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
7	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
8	.INCLUDE	☐				0	0	General ledger: Technical fields
9	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Key of Line Items
10	RLDNR	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	V_FAGL_T881_DBAL
11	.INCLUDE	☐				0	0	General Ledger: Technical Fields in Data Part of Line Items
12	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
13	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	*
14	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
15	.INCLUDE	☐				0	0	General ledger: Main account assignment
16	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKB1
17	COST_ELEM	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
18	.INCLUDE	☐				0	0	General ledger: SAP additional account assignment
19	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
20	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
21	.INCLUDE	☐				0	0	General Ledger: Additional Acct Assignmt in Data Part of LIs
22	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
23	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
24	RFAREA	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
25	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
27	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
28	.INCLUDE	☐				0	0
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0	General ledger: Sender SAP additional account assignment
31	SCNTR	☐	SKOST	KOSTL	CHAR	10	0	Sender cost center	CSKS
32	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
33	SFAREA	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
34	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
35	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
36	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
37	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
39	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
40	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
41	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
42	XBILK	☐	XBILK	XFELD	CHAR	1	0	Indicator: Account is a balance sheet account?
43	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
44	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
45	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
46	CLCDAT	☐	GLE_DTE_ADB_TILL_DATE	DATUM	DATS	8	0	Key Date for Key Figure Calculation in BI Extraction
47	CURPERIODACT_D	☐	GLE_DTE_ADB_CURDAYACT_D	WERTV12	CURR	23	2	Current Day Activity Debit
48	CURPERIODACT_C	☐	GLE_DTE_ADB_CURDAYACT_C	WERTV12	CURR	23	2	Current Day Activity Credit
49	CURPERIODACT	☐	GLE_DTE_ADB_CURDAYACT	WERTV12	CURR	23	2	Current Day Activity
50	CURMONTHAVG	☐	GLE_DTE_ADB_CURMONTHAVG	WERTV12	CURR	23	2	Month-to-Date Average Balance
51	QTODATEAVG	☐	GLE_DTE_ADB_QTODATEAVG	WERTV12	CURR	23	2	Quarter-to-Date Average Balance
52	YTODATEAVG	☐	GLE_DTE_ADB_YTODATEAVG	WERTV12	CURR	23	2	Year-to-Date Average Balance
53	CURMONTHBAL	☐	GLE_DTE_ADB_CURMONTHBAL	WERTV12	CURR	23	2	Current Month Activity
54	QTODATEACT	☐	GLE_DTE_ADB_QTODATEACT	WERTV12	CURR	23	2	Quarter-to-Date Activity
55	YTODATEBAL	☐	GLE_DTE_ADB_YTODATEBAL	WERTV12	CURR	23	2	Year-to-Date Balance

Foreign Keys

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

History

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