SAP ABAP Table FAGLPOSE_CORE (Core Fields for Reading Data of Line Items in New GL)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ FAGL_REPORTING (Package) Reporting: New General Ledger

Basic Data

Table Category	INTTAB	Structure
Structure	FAGLPOSE_CORE	Table Relationship Diagram
Short Description	Core Fields for Reading Data of Line Items in New GL

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	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
2	ANLN2	☐	ANLN2_4	ANLN2_4	CHAR	4	0	New asset subnumber, 4 characters
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
4	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
5	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
6	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
7	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
8	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
10	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
14	BWWRT	☐	BWWRT_X8	WRTV8	CURR	15	2	Valuated Amount in Local Currency
15	BWWR2	☐	BWWR2_X8	WRTV8	CURR	15	2	Amount Valuated in Local Currency 2
16	BWWR3	☐	BWWR3_X8	WRTV8	CURR	15	2	Amount Valuated in Local Currency 3
17	DMSHB	☐	DMSHB_X8	WRTV8	CURR	15	2	Amount in Local Currency with +/- Signs
18	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
19	DMBE2	☐	DMBE2_X8	WRTV8	CURR	15	2	Amount in Second Local Currency
20	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
21	DMBE3	☐	DMBE3_X8	WRTV8	CURR	15	2	Amount in Third Local Currency
22	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
23	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
24	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
25	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
26	FAEDT	☐	FAEDT_FPOS	DATUM	DATS	8	0	Net Due Date
27	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
28	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
30	JAMON	☐	JAMON_XPO	JAMON_XPO	CHAR	7	0	Fiscal Year/Posting Period from Posting Date
31	KOART	☐	KOART	KOART	CHAR	1	0	Account type
32	KONTO	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
33	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
34	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
35	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
36	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
37	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
38	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
39	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
40	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
41	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
42	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
43	QBSHB	☐	QBSHB_X8	WRTV8	CURR	15	2	Withholding Tax Amount in Document Currency
44	QSFBT	☐	QSFBT_X8	WRTV8	CURR	15	2	Withholding Tax Exempt Amount in Document Currency
45	QSSHB	☐	QSSHB_X8	WRTV8	CURR	15	2	Withholding Tax Base Amount in Document Currency
46	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
47	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
48	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
49	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
50	SKFBT	☐	SKFBT_X8	WRTV8	CURR	15	2	Amount Eligible for Cash Discount in Document Currency
51	WSKTO	☐	WSKTO_X8	WRTV8	CURR	15	2	Cash Discount Amount in Document Currency
52	SKNTO	☐	SKNTO_X8	WRTV8	CURR	15	2	Cash Discount Amount in Local Currency
53	STAKZ	☐	XSTKZ	XFELD	CHAR	1	0	Indicator: Statistical document ?
54	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
55	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
56	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
57	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
58	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
59	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
60	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
61	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
62	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
63	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
64	VERZ1	☐	VERZ1	WRTV3	DEC	5	0	Days in Arrears for Cash Discount Terms 1
65	VERZN	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
66	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
67	WRSHB	☐	WRSHB_X8	WRTV8	CURR	15	2	Amount in Document Currency (Foreign Currency)
68	WAERS	☐	WAER_DOC	WAERS	CUKY	5	0	Document Currency (Key)	TCURC
69	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
70	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
71	XSTRP	☐	XSTRP	XFELD	CHAR	1	0	Indicator: Disputed item?
72	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
73	ZALDT	☐	DZALDT	DATUM	DATS	8	0	Probable Payment Date (Cash Discount 1 Due)
74	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
75	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
76	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
77	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
78	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
79	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
80	ZINSZ	☐	DZINSZ	WRTV8	CURR	15	2	Interest Calculation Numerator (Days in Arrears * Amount)
81	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
82	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
83	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
84	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
85	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
86	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
87	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
88	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	T053R
89	ASKTO	☐	ASKTO_X8	WRTV8	CURR	15	2	Current Cash Discount Amount in Document Currency
90	KURSE	☐	KURSE	KURSF	DEC	9	5	Effective Exchange Rate in the Line Item
91	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
92	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
93	PSWBT	☐	PSWBT_X8	WERT8	CURR	15	2	Amount for General Ledger Update (Absolute)
94	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
95	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
96	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
97	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
98	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
99	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
100	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
101	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
102	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
103	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
104	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
105	ABSBT	☐	ABSBT_X8	WERT8	CURR	15	2	Credit Management: Hedged Amount (Absolute)
106	KKBWR	☐	KKBWR	WAERS	CUKY	5	0	Currency of Credit Control Area	*
107	PROJK	☐	PROJK_EXT	CHAR24	CHAR	24	0	Individual Structural Element (WBS Element) in Ext. Format
108	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
109	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
110	XAUGP	☐	XAUGP	XFELD	CHAR	1	0	Indicator: Item has been cleared?
111	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
112	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
113	GKART	☐	GKART	GKART	CHAR	1	0	Offsetting Account Type
114	GKONT	☐	GKONT	GKONT	CHAR	10	0	Offsetting Account Number
115	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
116	PYAMT	☐	PYAMT_X8	WERT8	CURR	15	2	Amount in Automatic Payment Currency (Absolute)
117	PYORD	☐	PYORD	PYORD	CHAR	10	0	Payment Order
118	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
119	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION
120	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
121	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
122	AGZEI	☐	AGZEI	AGZEI	DEC	5	0	Clearing Item
123	LONGNUM	☐	/SAPPSPRO/LONGNUM	/SAPPSPRO/LONGNUM	CHAR	40	0	Smart Number
124	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
125	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
126	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
127	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
128	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
129	BEWAR	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
130	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
131	DMBTR	☐	DMBTR_X8	WRTV8	CURR	15	2	Amount in Local Currency
132	DOCNR	☐	BELNR_D_POS	BELNR	CHAR	10	0	Document Number of a General Ledger Document
133	DOCLN	☐	DOCLN6_POS	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
134	FKBER	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
135	FKBER_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
136	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
137	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
138	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
139	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	CSKB
140	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
141	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
142	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
143	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
144	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
145	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
146	PFKBER	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	TFKB
147	PKOSTL	☐	PKOSTL	KOSTL	CHAR	10	0	Partner cost center	CSKS
148	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
149	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
150	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
151	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
152	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	V_FAGL_T881_DBAL
153	RYEAR	☐	GJAHR_POS	GJAHR	NUMC	4	0	General Ledger Fiscal Year
154	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKB1
155	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
156	WRBTR	☐	WRBTR_X8	WRTV8	CURR	15	2	Amount in Document Currency
157	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
158	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	*
159	XLGCLR	☐	XLGCLR	XFELD	CHAR	1	0	Clearing Specific to Ledger Groups
160	XREORG	☐	FAGL_R_XDOC_REORG	FLAG	CHAR	1	0	Doc. Contains Open Item that Was Transferred During Reorg.
161	.INCLUDE	☐				0	0
162	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
163	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
164	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
165	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGLPOSE_CORE	AWSYS	TBDLS	LOGSYS
2	FAGLPOSE_CORE	AWTYP	TTYP	AWTYP
3	FAGLPOSE_CORE	BEWAR	T856	TRTYP
4	FAGLPOSE_CORE	BLART	T003	BLART
5	FAGLPOSE_CORE	BSCHL	TBSL	BSCHL
6	FAGLPOSE_CORE	BUKRS	T001	BUKRS	KEY	1	CN
7	FAGLPOSE_CORE	CESSION_KZ	TCESSION	CESSION_KZ
8	FAGLPOSE_CORE	FKBER_LONG	TFKB	FKBER
9	FAGLPOSE_CORE	GSBER	TGSB	GSBER
10	FAGLPOSE_CORE	HWAER	TCURC	WAERS
11	FAGLPOSE_CORE	KKBER	T014	KKBER	REF	1	CN
12	FAGLPOSE_CORE	KOKRS	TKA01	KOKRS
13	FAGLPOSE_CORE	KOSTL	CSKS	KOSTL
14	FAGLPOSE_CORE	KSTAR	CSKB	KSTAR
15	FAGLPOSE_CORE	KUNNR	KNA1	KUNNR
16	FAGLPOSE_CORE	LIFNR	LFA1	LIFNR
17	FAGLPOSE_CORE	MABER	T047M	MABER
18	FAGLPOSE_CORE	MANSP	T040S	MANSP
19	FAGLPOSE_CORE	MEINS	T006	MSEHI
20	FAGLPOSE_CORE	MSCHL	T040	MSCHL
21	FAGLPOSE_CORE	PARGB	TGSB	GSBER
22	FAGLPOSE_CORE	PFKBER	TFKB	FKBER
23	FAGLPOSE_CORE	PKOSTL	CSKS	KOSTL
24	FAGLPOSE_CORE	PPRCT	CEPC	PRCTR
25	FAGLPOSE_CORE	PRCTR	CEPC	PRCTR
26	FAGLPOSE_CORE	PSEGMENT	FAGL_SEGM	SEGMENT
27	FAGLPOSE_CORE	PSWSL	TCURC	WAERS
28	FAGLPOSE_CORE	RLDNR	V_FAGL_T881_DBAL	RLDNR
29	FAGLPOSE_CORE	RSTGR	T053R	RSTGR
30	FAGLPOSE_CORE	SAKNR	SKB1	SAKNR
31	FAGLPOSE_CORE	SEGMENT	FAGL_SEGM	SEGMENT
32	FAGLPOSE_CORE	UMSKZ	T074U	UMSKZ	REF	C	CN
33	FAGLPOSE_CORE	VBUND	T880	RCOMP
34	FAGLPOSE_CORE	WAERS	TCURC	WAERS
35	FAGLPOSE_CORE	WERKS	T001W	WERKS
36	FAGLPOSE_CORE	ZLSCH	T042Z	ZLSCH
37	FAGLPOSE_CORE	ZLSPR	T008	ZAHLS

History

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