SAP ABAP Table REXCJP_DETAIL_LINE (Detailed payment data for the output on the detailed ALV)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_JP (Package) Localization Flexible Real Estate Japan

Basic Data

Table Category	INTTAB	Structure
Structure	REXCJP_DETAIL_LINE	Table Relationship Diagram
Short Description	Detailed payment data for the output on the detailed ALV

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	Payment Info: Single line data of payments on the PDF
2	PYMNTCAT	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
3	PYMNTADDR	☐	REXCJP_PRADRC_PROP		STRU	0	0
4	.INCLUDE	☐				0	0	Addresses (Business Address Services)
5	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
7	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
8	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
9	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
10	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
11	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
12	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
13	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
14	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
15	NAME_TEXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
16	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
17	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
18	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
19	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
20	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
21	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
22	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
23	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
24	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
25	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
26	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
27	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
28	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
29	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
30	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
31	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
32	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	*
33	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
34	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
35	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
36	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
37	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
38	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
39	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
40	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
41	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
42	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
43	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	*
44	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
45	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
46	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
47	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
48	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
49	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
50	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
51	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
52	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
53	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
54	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
55	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
56	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
57	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)	*
58	FLAGGROUPS	☐	AD_FLGGP	XFELD	CHAR	1	0	Flag: There are more address group assignments
59	PERS_ADDR	☐	AD_PRSADDR	XFELD	CHAR	1	0	Flag: This is a personal address
60	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
61	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
62	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
63	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
64	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
65	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
66	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
67	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
68	FLAGCOMM2	☐	AD_FLGCM02	XFELD	CHAR	1	0	Flag: Telephone number(s) maintained
69	FLAGCOMM3	☐	AD_FLGCM03	XFELD	CHAR	1	0	Flag: Fax number(s) maintained
70	FLAGCOMM4	☐	AD_FLGCM04	XFELD	CHAR	1	0	Flag: Teletex number(s) maintained
71	FLAGCOMM5	☐	AD_FLGCM05	XFELD	CHAR	1	0	Flag: Telex number(s) maintained
72	FLAGCOMM6	☐	AD_FLGCM06	XFELD	CHAR	1	0	Indicator: E-Mail Address(es) Maintained
73	FLAGCOMM7	☐	AD_FLGCM07	XFELD	CHAR	1	0	Flag: RML (remote mail) addresse(s) maintained
74	FLAGCOMM8	☐	AD_FLGCM08	XFELD	CHAR	1	0	Flag: X.400 addresse(s) maintained
75	FLAGCOMM9	☐	AD_FLGCM09	XFELD	CHAR	1	0	Flag: RFC destination(s) maintained
76	FLAGCOMM10	☐	AD_FLGCM10	XFELD	CHAR	1	0	Flag: Printer maintained
77	FLAGCOMM11	☐	AD_FLGCM11	XFELD	CHAR	1	0	Flag: SSF maintained
78	FLAGCOMM12	☐	AD_FLGCM12	XFELD	CHAR	1	0	Flag: URI/FTP address maintained
79	FLAGCOMM13	☐	AD_FLGCM13	XFELD	CHAR	1	0	Flag: Pager address maintained
80	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	*
81	MC_NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
82	MC_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
83	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
84	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
85	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
86	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
87	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
88	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
89	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	*
90	ADRC_UUID	☐	AD_UUID	SYSUUID	RAW	16	0	UUID Used in the Address
91	UUID_BELATED	☐	AD_UUID_BELATED	AD_UUID_BELATED	CHAR	1	0	Indicator: UUID was generated later
92	ID_CATEGORY	☐	AD_ID_CATEGORY	AD_ID_CATEGORY	CHAR	1	0	Category of an Address ID
93	ADRC_ERR_STATUS	☐	AD_ERR_STATUS	AD_ERR_STATUS	CHAR	1	0	Error Status of Address
94	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
95	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
96	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
97	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
98	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
99	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*
100	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
101	MC_COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
102	MC_TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
103	XPCPT	☐	AD_XPCPT	AD_XPCPT	CHAR	1	0	Business Purpose Completed Flag
104	PYMNTDET	☐	REXCJP_PR_DETAIL	CHAR15	CHAR	15	0	Payment Details
105	PYMNTBAS	☐	REXCJP_PR_BASIS	CHAR15	CHAR	15	0	Basis for Calculation
106	PYMNTAM	☐	REXCJP_PYMNTAM	WERT7	CURR	13	2	Payment Amount
107	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
108	.INCLUDE	☐				0	0	Payment specific data
109	.INCLUDE	☐				0	0	Accounting: Secondary Index for Vendors (Cleared Items)
110	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
111	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	LFB1
112	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
113	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
114	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
115	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
116	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
117	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
118	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
119	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
120	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
121	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
122	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
123	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
124	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
125	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
126	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
127	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
128	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
129	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	*
130	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
131	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
132	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
133	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
134	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
135	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
136	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
137	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
138	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
139	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
140	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
141	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
142	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
143	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
144	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
145	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
146	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
147	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
148	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
149	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
150	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
151	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
152	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
153	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
154	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
155	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
156	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
157	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
158	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
159	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
160	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
161	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
162	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
163	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
164	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
165	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
166	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
167	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
168	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
169	ZOLLT	☐	DZOLLT	ZOLLT	CHAR	8	0	Customs Tariff Number
170	ZOLLD	☐	DZOLLD	DATUM	DATS	8	0	Customs Date
171	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
172	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
173	DIEKZ	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
174	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
175	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
176	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
177	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
178	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
179	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
180	XANET	☐	XANET	XFELD	CHAR	1	0	Indicator: Down Payment in Net Procedure?
181	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
182	XESRD	☐	XESRD	XFELD	CHAR	1	0	Indicator: Is any ISR data set in the document ?
183	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
184	MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
185	DMBT1	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
186	WRBT1	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
187	MWSK2	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
188	DMBT2	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
189	WRBT2	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
190	MWSK3	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
191	DMBT3	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
192	WRBT3	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
193	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
194	QSSHB	☐	QSSHB	WERT7	CURR	13	2	Withholding Tax Base Amount
195	QBSHB	☐	QBSHB	WERT7	CURR	13	2	Withholding Tax Amount (in Document Currency)
196	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
197	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
198	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
199	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	*
200	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
201	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
202	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
203	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	*
204	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	*
205	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
206	QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
207	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
208	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
209	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
210	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
211	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
212	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
213	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
214	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
215	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
216	DMB21	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
217	DMB22	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
218	DMB23	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
219	DMB31	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
220	DMB32	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
221	DMB33	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
222	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
223	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
224	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
225	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
226	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
227	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
228	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
229	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
230	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
231	LNRAN	☐	LNRAN	LNRAN	NUMC	5	0	Sequence Number of Asset Line Items in Fiscal Year	ANEK
232	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
233	KZBTR	☐	KZBTR_FI	WERT7	CURR	13	2	Original Reduction Amount in Local Currency
234	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
235	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
236	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
237	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
238	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
239	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
240	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
241	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
242	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
243	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
244	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
245	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
246	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
247	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
248	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
249	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
250	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
251	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
252	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
253	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
254	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
255	PYAMT	☐	PYAMT	WERT7	CURR	13	2	Amount in Payment Currency
256	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
257	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
258	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
259	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
260	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
261	PENLC1	☐	PENALTY1	WERT13	CURR	13	2	Penalty Charge Amount in First Local Currency
262	PENLC2	☐	PENALTY2	WERT13	CURR	13	2	Penalty Charge Amount in Second Local Currency
263	PENLC3	☐	PENALTY3	WERT13	CURR	13	2	Penalty Charge Amount in Third Local Currency
264	PENFC	☐	PENALTY	WERT13	CURR	13	2	Penalty Charge Amount in Document Currency
265	PENDAYS	☐	PDAYS	INT4	INT4	10	0	Number of Days for Penalty Charge Calculation
266	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
267	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
268	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
269	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
270	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
271	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
272	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
273	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
274	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable
275	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
276	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
277	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
278	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
279	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
280	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
281	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
282	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
283	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
284	.INCLU--AP	☐				0	0	IS-PS: Data appendix of cleared items vendor
285	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
286	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
287	UEBGDAT	☐	UEBGDAT	DATUM	DATS	8	0	Transfer date of an item to legal dunning proceeding
288	.INCLU--AP	☐				0	0	Joint Venture Fields
289	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
290	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
291	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
292	.INCLU--AP	☐				0	0	Append zur Mandatsverwaltung BSAK
293	.INCLUDE	☐				0	0	Append Struktur für die Mandatsnummer
294	PROPMANO	☐	REHORECNNRM	RECNNR	CHAR	13	0	Mandate, Mandate-Opening Contract
295	WRBTRV	☐	REXCJP_AMOUNT	WERTV7	CURR	13	2	Signed Amount in Document Currency
296	PAYMENTCAT	☐	REXCJPPCRCAT	REXCJPPCRCAT	CHAR	3	0	Payment Category
297	PAYMENTCATT	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
298	LOCATION	☐	REXCJP_LOC_ADDR	TEXT120	CHAR	120	0	Payment's location
299	OBJECTNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
300	CONTRACTINTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCJP_DETAIL_LINE	BTYPE	T8JA	BILIND	REF	C	CN
2	REXCJP_DETAIL_LINE	BUKRS	LFB1	BUKRS	KEY	1	CN
3	REXCJP_DETAIL_LINE	EGRUP	T8JF	EGRUP	REF	C	CN
4	REXCJP_DETAIL_LINE	LIFNR	LFA1	LIFNR	KEY	1	CN
5	REXCJP_DETAIL_LINE	LNRAN	ANEK	LNRAN	REF	C	CN
6	REXCJP_DETAIL_LINE	PSWSL	TCURC	WAERS	REF	C	CN
7	REXCJP_DETAIL_LINE	UZAWE	T042F	UZAWE	REF	C	CN
8	REXCJP_DETAIL_LINE	VNAME	T8JV	VNAME	REF	C	CN

History

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