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

Dictionary Type: Table
Description: IS-M/SD: Settlement Header Data




ABAP Code to SELECT data from JLRK
Related tables to JLRK
Access table JLRK




Table field list including key, data, relationships and ABAP select examples

JLRK is a standard SAP Table which is used to store IS-M/SD: Settlement Header Data data and is available within R/3 SAP systems depending on the version and release level.

The JLRK table consists of various fields, each holding specific information or linking keys about IS-M/SD: Settlement Header Data data available in SAP. These include VBELN (IS-M: Settlement number), JVBTYP (IS-M: Sales document category), WAERK (SD Document Currency), EKORG (Purchasing Organization).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JLRK table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNIS-M: Settlement number JVBELNCHAR10ALPHAJVBELNJLV
JVBTYPIS-M: Sales document category JVBTYPCHAR1JVBTYP
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
KALSMSales and Distribution: Pricing Procedure in Pricing KALSMASDCHAR6Assigned to domainKALSM
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
ABDATIS-M: Settlement Date JABDATDATS8DATUM
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUPERFiscal Period MONATNUMC2MONAT
RFBSKIS-M: Status for transfer to financial accounting JLRK RFBSK_ISPACHAR1RFBSK_ISPA
POPERPosting period POPERNUMC3POPERPOPR
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
CPKURID:Exchange rate setting (no new rate determ.in bill.doc.) CPKURCHAR1CPKUR
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
LAND1Country Key LAND1CHAR3T005LAND1LND
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
BRTWRIS-M: Gross Value in Document Currency ISPBRTWRCURR15(2) WERTV8
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
ZUKRICombination criteria in the billing document DZUKRICHAR40CHAR40
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
ERDATDate on Which Record Was Created ERDATDATS8DATUM
STAFOUpdate group for statistics update STAFOCHAR6TMCBALPHASTAFOMCF
STWAEStatistics currency STWAECUKY5TCURCWAERS
STCEGVAT Registration Number STCEGCHAR20STCEG
AEDATChanged On AEDATDATS8DATUM
JSABRNIS-M: Number of Reversed Settlement JSABRNCHAR10Assigned to domainALPHAJVBELN
JSTORNIS-M: Reversal Number JSTORNCHAR10Assigned to domainALPHAJVBELN
JSNABRIS-M: Number of Reversal in Subsequent Document JSNABRCHAR10Assigned to domainALPHAJVBELN
STOGRDIS-M: Service Settlement Reversal Reason JSTOGRDCHAR3Assigned to domainJSTOGRD
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
OBJARTIS-M: Object type for document flow LABARTCHAR4JOBJART
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
STCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
MANKZIS-M: Manual settlement post-editing MANBKZCHAR1XFELD
VERSGEIS-M: Service Company VERSERVGESCHAR10Assigned to domainALPHAGPNRJGFMJG0G
GPNRIS-M: Business Partner Key GPNRCHAR10Assigned to domainALPHAGPNRJGPMJG0
GPNR_ZEIS-M/SD: Business Partner Payee GPNR_ZEMPFCHAR10Assigned to domainALPHAGPNR
FAKVONIS-M: Settlement period from JABRVONDATS8DATUM
FAKBISIS-M: Settlement Period To JABRBISDATS8DATUM
MONBEWIS-M/SD: Type of valuation ( - / quantity / qty*price ) MONBEWCHAR1MONBEW
UEBERLARTIS-M: Transfer type UEBERLARTCHAR1UEBERLART
PERNRIS-M: Personnel Number JPERNR2CHAR20JPERNR
JSTGVBIS-M: Statistics group for sales documents JSTGVBCHAR2TJKMC1ALPHAJSTGVB
KTGRD_MAIS-M: Expense Account Assignment Group for SC Employees JKTGRD_MACHAR2TJL21JKTGRD_MA
KTGRDVSGIS-M: Expense Account Assignment Group for SC JKTGRD_VSGCHAR2TJL19JKTGRD_VSG
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
UMSKZSpecial G/L Indicator UMSKZCHAR1T074UUMSKZ
JPROVKDATIS-M: Due date of deposit retained JPROVKDATDATS8JPROVKDAT
UEBNRIS-M: Number of Transfer Run to FI ISPUEBNRCHAR10Assigned to domainALPHAISPUEBNR
XNOMESSIS-M: Indicator - Do Not Perform Output Determination XNOMESSCHAR1XFELD
VKONTContract Account Number VKONT_KKCHAR12FKKVKALPHAVKONT_KKKTOFKKVKP_F4
BELNR_FKKNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12Assigned to domainALPHAOPBEL_KK80B

Key field Non-key field



How do I retrieve data from SAP table JLRK using ABAP code

The following ABAP code Example will allow you to do a basic selection on JLRK to SELECT all data from the table
DATA: WA_JLRK TYPE JLRK.

SELECT SINGLE *
FROM JLRK
INTO CORRESPONDING FIELDS OF WA_JLRK
WHERE...

How to access SAP table JLRK

Within an ECC or HANA version of SAP you can also view further information about JLRK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!