SAP ABAP Table JLRKVB (Mix Structure for XJLRK/YJLRP)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JLRKVB	Table Relationship Diagram
Short Description	Mix Structure for XJLRK/YJLRP

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	IS-M/SD: Settlement Header Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	JVBELN	JVBELN	CHAR	10	0	IS-M: Settlement number	*
4	JVBTYP	☐	JVBTYP	JVBTYP	CHAR	1	0	IS-M: Sales document category
5	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
6	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
7	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	*
8	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
9	ABDAT	☐	JABDAT	DATUM	DATS	8	0	IS-M: Settlement Date
10	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
11	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	BUPER	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
13	RFBSK	☐	RFBSK_ISPA	RFBSK_ISPA	CHAR	1	0	IS-M: Status for transfer to financial accounting JLRK
14	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
15	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
16	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
17	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
18	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
19	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	BRTWR	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
23	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
24	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
25	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
26	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
27	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
28	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
29	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
30	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
31	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
32	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
33	JSABRN	☐	JSABRN	JVBELN	CHAR	10	0	IS-M: Number of Reversed Settlement	*
34	JSTORN	☐	JSTORN	JVBELN	CHAR	10	0	IS-M: Reversal Number	*
35	JSNABR	☐	JSNABR	JVBELN	CHAR	10	0	IS-M: Number of Reversal in Subsequent Document	*
36	STOGRD	☐	JSTOGRD	JSTOGRD	CHAR	3	0	IS-M: Service Settlement Reversal Reason	*
37	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
38	OBJART	☐	LABART	JOBJART	CHAR	4	0	IS-M: Object type for document flow
39	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
40	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
41	MANKZ	☐	MANBKZ	XFELD	CHAR	1	0	IS-M: Manual settlement post-editing
42	VERSGE	☐	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	*
43	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
44	GPNR_ZE	☐	GPNR_ZEMPF	GPNR	CHAR	10	0	IS-M/SD: Business Partner Payee	*
45	FAKVON	☐	JABRVON	DATUM	DATS	8	0	IS-M: Settlement period from
46	FAKBIS	☐	JABRBIS	DATUM	DATS	8	0	IS-M: Settlement Period To
47	MONBEW	☐	MONBEW	MONBEW	CHAR	1	0	IS-M/SD: Type of valuation ( - / quantity / qty*price )
48	UEBERLART	☐	UEBERLART	UEBERLART	CHAR	1	0	IS-M: Transfer type
49	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
50	JSTGVB	☐	JSTGVB	JSTGVB	CHAR	2	0	IS-M: Statistics group for sales documents	TJKMC1
51	KTGRD_MA	☐	JKTGRD_MA	JKTGRD_MA	CHAR	2	0	IS-M: Expense Account Assignment Group for SC Employees	TJL21
52	KTGRDVSG	☐	JKTGRD_VSG	JKTGRD_VSG	CHAR	2	0	IS-M: Expense Account Assignment Group for SC	TJL19
53	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
54	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
55	JPROVKDAT	☐	JPROVKDAT	JPROVKDAT	DATS	8	0	IS-M: Due date of deposit retained
56	UEBNR	☐	ISPUEBNR	ISPUEBNR	CHAR	10	0	IS-M: Number of Transfer Run to FI	*
57	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
58	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
59	BELNR_FKK	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
60	.INCLUDE	☐				0	0	IS-PSD: Settlement Header - Dynamic Part
61	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
62	HIPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
63	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
64	NAMRG	☐	NAME1	TEXT30	CHAR	30	0	Name
65	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
66	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
67	UVALS	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
68	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
69	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
70	JZUOVBELN	☐	JVBELN	JVBELN	CHAR	10	0	IS-M: Settlement number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JLRKVB	BUKRS	T001	BUKRS
2	JLRKVB	EKORG	T024E	EKORG
3	JLRKVB	JSTGVB	TJKMC1	STGVB
4	JLRKVB	KTGRDVSG	TJL19	JKTGRD_VSG
5	JLRKVB	KTGRD_MA	TJL21	JKTGRD_MA
6	JLRKVB	KURST	TCURV	KURST
7	JLRKVB	LAND1	T005	LAND1
8	JLRKVB	MANDT	T000	MANDT
9	JLRKVB	STAFO	TMCB	STAFO
10	JLRKVB	STWAE	TCURC	WAERS
11	JLRKVB	UMSKZ	T074U	UMSKZ
12	JLRKVB	VKONT	FKKVK	VKONT
13	JLRKVB	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in