SAP ABAP Table FAGLPOS_ARRE (Receivables According to General Ledger Account Assignments)

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	FAGLPOS_ARRE	Table Relationship Diagram
Short Description	Receivables According to General Ledger Account Assignments

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

Foreign Keys

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

History

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