SAP ABAP Table IDCN_S_AR_AGING_ITEM (AR Aging Output Item)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-CN (Package) Localization (China)

Basic Data

Table Category	INTTAB	Structure
Structure	IDCN_S_AR_AGING_ITEM	Table Relationship Diagram
Short Description	AR Aging Output Item

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	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
2	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
3	OVDAYS	☐	IDCN_OVDAYS	INT4	INT4	10	0	Overdue Days
4	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
5	VBELV	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
9	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
10	SEGMENT	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
11	PERCENT	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
12	SEGMENT0	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
13	PERCENT0	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
14	SEGMENT1	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
15	PERCENT1	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
16	SEGMENT2	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
17	PERCENT2	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
18	SEGMENT3	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
19	PERCENT3	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
20	SEGMENT4	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
21	PERCENT4	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
22	SEGMENT5	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
23	PERCENT5	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
24	SEGMENT6	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
25	PERCENT6	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
26	SEGMENT7	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
27	PERCENT7	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
28	SEGMENT8	☐	RASTB	WERTV8	CURR	15	2	Amount Assigned to a Sorted List Interval
29	PERCENT8	☐	IDCN_PERCENTAGE		DEC	30	3	Percentage
30	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	KNB1
32	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
33	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
34	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
35	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
36	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
37	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
38	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
39	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
40	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
41	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
43	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
44	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
45	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
46	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
47	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
48	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
49	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	*
50	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
51	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
52	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
53	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
54	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
55	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
56	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
57	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
58	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
59	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
60	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
61	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
62	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
63	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
64	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
65	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
66	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
67	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
68	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
69	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
70	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
71	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
72	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
73	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
74	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
75	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
76	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
77	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
78	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
79	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
80	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
81	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
82	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
83	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
84	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
85	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
86	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
87	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
88	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
89	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	*
90	ANFAE	☐	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
91	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
92	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
93	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
94	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
95	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
96	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
97	XANET	☐	XANET	XFELD	CHAR	1	0	Indicator: Down Payment in Net Procedure?
98	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
99	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
100	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
101	MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
102	DMBT1	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
103	WRBT1	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
104	MWSK2	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
105	DMBT2	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
106	WRBT2	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
107	MWSK3	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
108	DMBT3	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
109	WRBT3	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
110	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
111	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
112	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
113	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
114	INFAE	☐	INFAE	CHAR08	CHAR	8	0	Inverted Date for Net Due Date
115	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
116	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	*
117	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	*
118	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
119	XNOZA	☐	XNOZA	XFELD	CHAR	1	0	Indicator: Account is not counted
120	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
121	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
122	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
123	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
124	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
125	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
126	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
127	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
128	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
129	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
130	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
131	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
132	DMB21	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
133	DMB22	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
134	DMB23	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
135	DMB31	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
136	DMB32	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
137	DMB33	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
138	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
139	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
140	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
141	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
142	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
143	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
144	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
145	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
146	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
147	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
148	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
149	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
150	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
151	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
152	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
153	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
154	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
155	VPOS2	☐	NUM06	NUM06	NUMC	6	0	Numeric field: Length 6
156	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
157	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
158	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
159	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
160	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
161	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
162	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
163	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
164	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	*
165	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
166	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
167	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
168	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
169	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
170	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
171	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
172	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
173	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
174	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
175	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
176	ABSBT	☐	ABSBT	WERT7	CURR	13	2	Credit Management: Hedged Amount
177	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
178	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
179	PYAMT	☐	PYAMT	WERT7	CURR	13	2	Amount in Payment Currency
180	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
181	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
182	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	*
183	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
184	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
185	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
186	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
187	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
188	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
189	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
190	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable
191	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
192	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
193	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
194	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
195	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
196	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
197	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
198	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
199	FB_SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
200	FB_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
201	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
202	SALE_DOC	☐	VBELV	VBELN	CHAR	10	0	Originating document	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IDCN_S_AR_AGING_ITEM	AUFNR	AUFK	AUFNR	REF	C	CN
2	IDCN_S_AR_AGING_ITEM	BLART	T003	BLART	REF	1	CN
3	IDCN_S_AR_AGING_ITEM	BSCHL	TBSL	BSCHL	REF	C	CN
4	IDCN_S_AR_AGING_ITEM	BUKRS	KNB1	BUKRS	KEY	1	CN
5	IDCN_S_AR_AGING_ITEM	GSBER	TGSB	GSBER	REF	C	CN
6	IDCN_S_AR_AGING_ITEM	KUNNR	KNA1	KUNNR	KEY	1	CN
7	IDCN_S_AR_AGING_ITEM	MWSKZ	T007A	MWSKZ	REF	C	CN
8	IDCN_S_AR_AGING_ITEM	UMSKZ	T074U	UMSKZ	REF	C	CN
9	IDCN_S_AR_AGING_ITEM	WAERS	TCURC	WAERS	REF	1	CN

History

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