SAP ABAP Table JLRK (IS-M/SD: Settlement Header Data)

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	TRANSP	Transparent table
Transparent table	JLRK	Table Relationship Diagram
Short Description	IS-M/SD: Settlement Header Data

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in