SAP ABAP Table FAGLPOSBW (Fields for LI Extractor: New General Ledger Accounting)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ GBIW_ERP_LI (Package) Line Item Extractors for General Ledger ERP

Basic Data

Table Category	INTTAB	Structure
Structure	FAGLPOSBW	Table Relationship Diagram
Short Description	Fields for LI Extractor: New General Ledger Accounting

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

Foreign Keys

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

History

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