JLRK SAP (IS-M/SD: Settlement Header Data) Table details
Dictionary Type: Table
Description: IS-M/SD: Settlement Header Data
Description: IS-M/SD: Settlement Header Data
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | IS-M: Settlement number | JVBELN | CHAR | 10 | ALPHA | JVBELN | JLV | ||
JVBTYP | IS-M: Sales document category | JVBTYP | CHAR | 1 | JVBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | Assigned to domain | KALSM | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
ABDAT | IS-M: Settlement Date | JABDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUPER | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
RFBSK | IS-M: Status for transfer to financial accounting JLRK | RFBSK_ISPA | CHAR | 1 | RFBSK_ISPA | ||||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BRTWR | IS-M: Gross Value in Document Currency | ISPBRTWR | CURR | 15(2) | WERTV8 | ||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
JSABRN | IS-M: Number of Reversed Settlement | JSABRN | CHAR | 10 | Assigned to domain | ALPHA | JVBELN | ||
JSTORN | IS-M: Reversal Number | JSTORN | CHAR | 10 | Assigned to domain | ALPHA | JVBELN | ||
JSNABR | IS-M: Number of Reversal in Subsequent Document | JSNABR | CHAR | 10 | Assigned to domain | ALPHA | JVBELN | ||
STOGRD | IS-M: Service Settlement Reversal Reason | JSTOGRD | CHAR | 3 | Assigned to domain | JSTOGRD | |||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
OBJART | IS-M: Object type for document flow | LABART | CHAR | 4 | JOBJART | ||||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
MANKZ | IS-M: Manual settlement post-editing | MANBKZ | CHAR | 1 | XFELD | ||||
VERSGE | IS-M: Service Company | VERSERVGES | CHAR | 10 | Assigned to domain | ALPHA | GPNR | JGF | MJG0G |
GPNR | IS-M: Business Partner Key | GPNR | CHAR | 10 | Assigned to domain | ALPHA | GPNR | JGP | MJG0 |
GPNR_ZE | IS-M/SD: Business Partner Payee | GPNR_ZEMPF | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
FAKVON | IS-M: Settlement period from | JABRVON | DATS | 8 | DATUM | ||||
FAKBIS | IS-M: Settlement Period To | JABRBIS | DATS | 8 | DATUM | ||||
MONBEW | IS-M/SD: Type of valuation ( - / quantity / qty*price ) | MONBEW | CHAR | 1 | MONBEW | ||||
UEBERLART | IS-M: Transfer type | UEBERLART | CHAR | 1 | UEBERLART | ||||
PERNR | IS-M: Personnel Number | JPERNR2 | CHAR | 20 | JPERNR | ||||
JSTGVB | IS-M: Statistics group for sales documents | JSTGVB | CHAR | 2 | TJKMC1 | ALPHA | JSTGVB | ||
KTGRD_MA | IS-M: Expense Account Assignment Group for SC Employees | JKTGRD_MA | CHAR | 2 | TJL21 | JKTGRD_MA | |||
KTGRDVSG | IS-M: Expense Account Assignment Group for SC | JKTGRD_VSG | CHAR | 2 | TJL19 | JKTGRD_VSG | |||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
JPROVKDAT | IS-M: Due date of deposit retained | JPROVKDAT | DATS | 8 | JPROVKDAT | ||||
UEBNR | IS-M: Number of Transfer Run to FI | ISPUEBNR | CHAR | 10 | Assigned to domain | ALPHA | ISPUEBNR | ||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | FKKVK | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
BELNR_FKK | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects