JLRP SAP (IS-M/SD: Item Data for Settlement) Table details

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




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




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

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

The JLRP table consists of various fields, each holding specific information or linking keys about IS-M/SD: Item Data for Settlement data available in SAP. These include JVBELN (IS-M: Settlement number), JPOSNR (IS-M: Settlement item number), ABIMG (IS-M: Actual Settlement Quantity), MEINS (Base Unit of Measure).. 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 JLRP 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
JVBELNIS-M: Settlement number JVBELNCHAR10JLRKALPHAJVBELNJLV
JPOSNRIS-M: Settlement item number JPOSNRNUMC6JPOSNR
ABIMGIS-M: Actual Settlement Quantity JABIMGDEC9(3) JSTMENGE
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
SMENGScale quantity in base unit of measure SMENGQUAN13(3) MENG13
KTGRMIS-M: Account assignment group for publication KTGRDECHAR2Assigned to domainKTGRM
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
BRTWRIS-M: Gross Value in Document Currency ISPBRTWRCURR15(2) WERTV8
NETWRIS-M: Net Value of Settlement Item in Document Currency NETWR_LPCURR15(2) WERTV8
VBELVOriginating document VBELVCHAR10Assigned to domainALPHAVBELN
POSNVOriginating item POSNVNUMC6Assigned to domainPOSNR
VGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
VGTYPSD document category VBTYPCHAR1VBTYP
DIENLIS-M: Service DIENLCHAR18MATN1DIENL
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
POSARItem type POSARCHAR1POSAR
JABRPOSARTIS-M: Settlement item type JABRPOSARTCHAR2JABRPOSART
TAXM1Tax classification material TAXM1CHAR1Assigned to domainTAXKM
TAXM2Tax classification 2 for material TAXM2CHAR1Assigned to domainTAXKM
TAXM3Tax classification 3 for material TAXM3CHAR1Assigned to domainTAXKM
TAXM4Tax Classification 4 Material TAXM4CHAR1Assigned to domainTAXKM
TAXM5Tax classification 5 for material TAXM5CHAR1Assigned to domainTAXKM
TAXM6Tax classification 6 for material TAXM6CHAR1Assigned to domainTAXKM
TAXM7Tax classification 7 for material TAXM7CHAR1Assigned to domainTAXKM
TAXM8Tax Classification 8 Material TAXM8CHAR1Assigned to domainTAXKM
TAXM9Tax Classification 9 Material TAXM9CHAR1Assigned to domainTAXKM
KOWRRStatistical values KOWRRCHAR1KOWRR
PRSFDCarry out pricing PRSFDCHAR1PRSFD
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
STCURExchange rate for statistics (Exch.rate at time of creation) STCUR_APDEC9(5) KURRF
UVPRSIncomplete with respect to pricing UVPRSCHAR1XFELD
UVALLGenerally incomplete UVALLCHAR1XFELD
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
RK_AUFNROrder Number of RK Order for Account Assignment J_RK_AUFNRCHAR8ALPHAJ_RK_AUFNR
RK_POSNRItem Number of RK Order for Account Assignment J_RK_POSNRNUMC2ALPHAJ_RK_POSNR
CO_AUFNROrder number of internal CO order for account assignment J_CO_AUFNRCHAR12Assigned to domainALPHAAUFNRANR
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
XBEZPOSIS-M/SD: Item Type in Service Settlement for Home Delivery XBEZPOSCHAR1JXBEZPOS
BEZTATActual Carrier Route BEZIRKTATCHAR10Assigned to domainALPHABEZIRK
BEZRUNDTATActual Delivery Round BEZRUNDTATCHAR10Assigned to domainALPHABEZRUNDEJBR
GP_ERS_ARTIS-M: Business Partner Substitution Type GP_ERS_ARTCHAR2Assigned to domainGP_ERS_ART
VERSANDDATIS-M: Shipping Date VRSNDDATUMDATS8DATUMRFD
TRAGEZDistribution time category (for home delivery settlement) TRAGEZEITKCHAR2Assigned to domainTRAGEZEITK
JAUARTIS-M/SD: Sales Document Types AUART_ISPCHAR4Assigned to domainAUART_ISPJAD
AUAGRPIS-M/SD: Sales document type grouping JAUARTGRPCHAR1JAUARTGRPJKAUARTGRP
BEZTYPMix Type BEZUGSTYP_JE_PVACHAR2JDTBEZTYPBEZUGSTYP_JE_PVAJD3MJD7
DRUTATActual Publication Delivered DRERZTATCHAR8Assigned to domainALPHADRERZJDCMJD1
DRUARTPublication Type DRUERZARTCHAR1Assigned to domainDRUERZART
PVATATActual edition delivered PVATATCHAR8Assigned to domainALPHAPVAJDDMJD2
BRGEWIS-M: Gross weight (issue weight incl.weight of inserts) JBRGEWQUAN13(3) ISPMNG13
NTGEWIS-M: Net Weight (Weight of Issue Minus Inserts) JNTGEWQUAN13(3) ISPMNG13
MEINHGWIS-M: Unit of weight for total issue weight JMEINHGWUNIT3Assigned to domainCUNITMEINS
BEILAGENIS-M: Number of inserts per issue JBEILAGENDEC9STMENGE
MEINHBLIS-M: Unit of weight for inserts JMEINHBLUNIT3Assigned to domainCUNITMEINS
NORMZGActual Qty Standard Units in a Home Del. Company's Delivery NORMMNGIZGDEC9STMENGE
NORMZUActual Quantity of Standard Units in a Carrier's Delivery NORMMNGIZUDEC9STMENGE
WRBMZGActual Quantity of Prom. Copies in a Del. Company's Delivery WRBMNGIZGDEC9STMENGE
WRBMZUActual Quantity of Prom. Copies in a Carrier's Delivery WRBMNGIZUDEC9STMENGE
NORMDZIS-M: Average quantity per period in carrier route (EE) JDMNGZUDEC9(3) JSTMENGE
NORMDGIS-M: Average quantity per period in carrier route (SC) JDMNGZGDEC9(3) JSTMENGE
LFATATActual delivery type (usually DT for dist.viability set) LFARTTATCHAR2Assigned to domainLIEFERART
XSCHLGELDIS-M: Key compensation XSCHLGELDCHAR1XFELD
XWEGGLDNTIS-M/SD: Path compensation daily JXWGGLD_TCHAR1XFELD
XWEGGLDFGIS-M/SD: Path compensation daily JXWGGLD_TCHAR1XFELD
XWEGGLDFNIS-M/SD: Path compensation daily JXWGGLD_TCHAR1XFELD
XWGGELDPAIS-M/SD: Flat rate path compensation (monthly) JXWGGLD_MCHAR1XFELD
XFARGLDNTIS-M/SD: Run compensation daily JXFAGLD_TCHAR1XFELD
XFARGLDFGIS-M/SD: Run compensation daily JXFAGLD_TCHAR1XFELD
XFARGLDFNIS-M/SD: Run compensation daily JXFAGLD_TCHAR1XFELD
XFAHRGELDIS-M/SD: Run compensation XFAHRGELDCHAR1XFELD
XBEILZUNTInsert bonus XBEILZUCHAR1XFELD
XBEILZUFGInsert bonus XBEILZUCHAR1XFELD
XBEILZUFNInsert bonus XBEILZUCHAR1XFELD
XGEWIZUNTIS-M/SD: Weight surcharge XGEWIZUCHAR1XFELD
XGEWIZUFGIS-M/SD: Weight surcharge XGEWIZUCHAR1XFELD
XGEWIZUFNIS-M/SD: Weight surcharge XGEWIZUCHAR1XFELD
KTFEIERFGIS-M/SD: Public holiday bonus category KATFEIERCHAR2Assigned to domainKATFEIER
KTFEIERFNIS-M/SD: Public holiday bonus category KATFEIERCHAR2Assigned to domainKATFEIER
KTNACHTNTIS-M/SD: Night bonus category KATNACHTCHAR2Assigned to domainKATNACHT
KTNACHTFGIS-M/SD: Night bonus category KATNACHTCHAR2Assigned to domainKATNACHT
KTNACHTFNIS-M/SD: Night bonus category KATNACHTCHAR2Assigned to domainKATNACHT
KTSONN_NTIS-M/SD: Sunday bonus category KATSONNCHAR2Assigned to domainKATSONN
KTSONN_FGIS-M/SD: Sunday bonus category KATSONNCHAR2Assigned to domainKATSONN
KTSONN_FNIS-M/SD: Sunday bonus category KATSONNCHAR2Assigned to domainKATSONN
KTSLGDIS-M: Key compensation category SCHLGLDKATCHAR2Assigned to domainSCHLGLDKAT
KTWEGDIS-M: Path length category WEGLANGKATCHAR2Assigned to domainWEGLANGKAT
KTFAGDDistance Traveled: Category (for Home Delivery Settlement) FAHRKMKATCHAR2Assigned to domainFAHRKMKAT
KTTOPOTopography category (for home delivery settlement) TOPOLOGIEKCHAR2Assigned to domainTOPOLOGIEK
KTTRAGDistribution time category (for home delivery settlement) TRAGEZEITKCHAR2Assigned to domainTRAGEZEITK
BEZKT1Carrier Route Flat Rate Category BEZKATE1CHAR2Assigned to domainBEZKATE1
BEZKT2IS-M: Carrier Route Category 2 BEZKATE2CHAR2Assigned to domainBEZKATE2
BEZKT3IS-M: Carrier Route Category 3 BEZKATE3CHAR2Assigned to domainBEZKATE3
BEZKT4IS-M: Carrier Route Category 4 BEZKATE4CHAR2Assigned to domainBEZKATE4
BEZKT5IS-M: Carrier Route Category 5 BEZKATE5CHAR2Assigned to domainBEZKATE5
GEWTVACalculated Issue Weight VAGEWICHTQUAN9(3) ISPMNG9
GEWBEIWeight of Inserts GEWICHTBEIQUAN9(3) ISPMNG9
GESGEWWeight of carrying issue (including inserts) TVAGEWICHTQUAN9(3) ISPMNG9
ANZBEINumber of inserts STCKBEILAGNUMC3ANZBEILAGE
MEINHGUnit of weight for issue (calculated weight) MEINHVAGEWUNIT3Assigned to domainCUNITMEINS
XFEIERTAGPublic holiday flag FEIERTAGKZCHAR1CHAR1
WOTAG_NFatory calendar flag CINDCHAR1CHAR1
WOTAG_AIS-M: Abbreviation for weekday JWOTAGCHAR2TEXT2
XVERGPVASTIS-M/SD: Remuneration according to editions per day XVERGPVASTCHAR1XFELD
XVERGPVAPEIS-M/SD: Remuneration according to edition period average XVERGPVAPECHAR1XFELD
XVERGPVATDIS-M/SD: Remuneration according to daily edition average XVERGPVATDCHAR1XFELD
XVERGPVADUIS-M/SD: Remuneration according to edition average XVERGPVADUCHAR1XFELD
XVERGBEZPAIS-M/SD: Remuneration by carrier route flat rate XVERGBEZPACHAR1XFELD
DRERZPublication DRERZCHAR8JDTDRERALPHADRERZJD1MJD1
PVAEdition PVACHAR8JDTPVAALPHAPVAJD2
BZPERFIS-M: Service Type for Billing BEZPERFAKTCHAR5TJD09BEZPER
WRBARTSales Source WERBEARTCHAR4TJWARALPHAWERBEARTJWA
WRBAKTSales Promotion WERBEAKTCHAR8TJWAKALPHAWERBEAKTJWTMJW1
MINBEZMinimum Length of Subscription MINDBEZUGQUAN2ISPMNG2
MINEINTime Unit for Minimum Length of Subscription MINDBEZEINUNIT3T006CUNITMEINS
XWKZIndicator: Promotion rebate XWKZCHAR1XFELD
POARTInternal Item Type for Sales Order POART_ISPCHAR2TJAPPOART_ISPJAP
XEINMLIndicator: One-time commission XEINMALPRVCHAR1XFELD
XRENDIRenewal commission XRENDITECHAR1XFELD
XPATEIS-M: Sponsored subscription XPATECHAR1XFELD
XFBLGABRIS-M: Follow-on settlement documents XFBLGABRCHAR1XFELD
ZLSCHIS-M: Order payment method JKAPZLSCHCHAR1Assigned to domainZLSCH
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision for order header SPART_AKCHAR2Assigned to domainSPARTSPA
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10JKAKALPHAAVNRJK1MJK1
GPAGBusiness Partner: Sold-to Party GPAGCHAR10Assigned to domainALPHAGPNR
GPNR_LEIS-M: Business Partner Service Provider GPNR_LECHAR10Assigned to domainALPHAGPNR
BSTDKCustomer purchase order date BSTDKDATS8DATUM
POSNRSales Order Item APNRNUMC6JKCOMMAPNR
POSEXExternal Item Number (Purchase Order Item) POSEX_ISPNUMC6POSEX_ISPJK2
ETENRDelivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
GUELTIGVONIS-M: Start of delivery of sales order item LIEFBEGDATS8DATUMJK3
RECHBEGINNBilling From RECHBEGINNDATS8DATUM
PROVFDATCommission due date PROVFDATDATS8DATUM
XIMMATIndicator: Proof of matriculation provided XIMMATRIKCHAR1XFELD
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
FKDATIS-M: Billing/Settlement Date JFKDATDATS8DATUM
KONDAPrice group (customer) KONDACHAR2Assigned to domainKONDAVKA
ANZMONABREIS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm. ANZMONABREQUAN2ISPMNG2
XPROVRUECKIndicator: Commission recalculation for order item XPROVRUECKCHAR1XFELD
ANZETIS-M: Number of Publication Dates ISPANZETDEC5ANZET
PROVRARTCommission clawback type PROVRARTCHAR1PROVRART
WERBKZSCHLIS-M: WBZ, Promotion Rebate Key JWBZWKZSCHCHAR1TJKW9JWBZWKZSCH
FKPERBilling Frequency FKPERCHAR2TJK01FKPERJFKPER
XNEGOPIS-M: Item with Automatic Transformation to Chargeable XNEGOPTIONCHAR1XFELD
ZUSTTYPIS-M: Carrier Type JZUSTTYPCHAR1Assigned to domainJZUSTTYP
WRBMDZIS-M: Average promotion qty per period in carr.route (EE) JWRBMDZDEC9(3) JSTMENGE
WRBMDGIS-M: Average promotion qty per period in carr.route (SC) JWRBMDGDEC9(3) JSTMENGE
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
FAHRKMDistance (for Home Delivery Settlement) FAHRKMQUAN9(3) ISPMNG9
EFAHRKUnit (km/m) EINHFAHRKMUNIT3T006CUNITMEINS
BBEWRTIS-M: Valuation of carrier route for home del.settlement JZBEWERTNUMC5NUMC5
VERKMITARTIS-M: Vehicle type VERKMIT_HRCHAR2TJL55VERKMIT_HR
TAET_KLASSIS-M: Activity classification TAET_KLASSCHAR2TJV49TAET_KLASS
VORGAENGERIS-M: Number of predecessor VORGAENGERNUMC12LAUFNUMMER
NACHFOLGERNumber of successor NACHFOLGERNUMC12LAUFNUMMER
DRERZTRAEGCarrying Publication DRERZTRAEGCHAR8JDTDRERALPHADRERZJD1
PVATRAEGCarrying Edition PVATRAEGCHAR8JDTPVAALPHAPVAJD2
VERTYPIS-M: Sales Agent Type VERTYPCHAR2TJG11ALPHAVERTYP
PROMNRSales order introduction JPROMNRNUMC3JKCOMMJPROMNR
PROVPERCNTIS-M/SD: Percentage rate of commission PROVPERCNTNUMC3PROZENT100
EVENTIS-M/SD: Event in order processing JK_EVENTCHAR4Assigned to domainALPHAJK_EVENT
XAQUISITIONIS-M/SD: Indicator - first introduction record XAQUISITIONCHAR1XFELD
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
.INCLU--AP 0
MONNRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
MONFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
TUENRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
TUEFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
WEDNRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
WEDFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
THUNRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
THUFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
FRINRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
FRIFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
SATNRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
SATFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06
SUNNRCOMPLNumber of Complaints /NAM/NBRCOMPLNUMC4NUMC04
SUNFACTORWeight Factor /NAM/WGTFCTRNUMC6NUMC06

Key field Non-key field



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

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

SELECT SINGLE *
FROM JLRP
INTO CORRESPONDING FIELDS OF WA_JLRP
WHERE...

How to access SAP table JLRP

Within an ECC or HANA version of SAP you can also view further information about JLRP 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!