SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

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

JLRP is a SAP table coming under IS module and IS-M component.View details, Fields & related tables of JLRP.

SAP JLRP Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
JVBELNIS-M: Settlement numberJVBELNJVBELN
JPOSNRIS-M: Settlement item numberJPOSNRJPOSNR
ABIMGIS-M: Actual Settlement QuantityJABIMGJSTMENGE
MEINSBase Unit of MeasureMEINSMEINS
SMENGScale quantity in base unit of measureSMENGMENG13
KTGRMIS-M: Account assignment group for publicationKTGRDEKTGRM
GSBERBusiness AreaGSBERGSBER
PRSDTDate for pricing and exchange ratePRSDTDATUM
FBUDADate When Services RenderedFBUDADATUM
KURSKExchange Rate for Pricing and StatisticsKURSKKURRF
BRTWRIS-M: Gross Value in Document CurrencyISPBRTWRWERTV8
NETWRIS-M: Net Value of Settlement Item in Document CurrencyNETWR_LPWERTV8
VBELVOriginating documentVBELVVBELN
POSNVOriginating itemPOSNVPOSNR
VGBELDocument number of the reference documentVGBELVBELN
VGPOSItem number of the reference itemVGPOSPOSNR
VGTYPSD document categoryVBTYPVBTYP
DIENLIS-M: ServiceDIENLDIENL
ARKTXShort text for sales order itemARKTXTEXT40
POSARItem typePOSARPOSAR
JABRPOSARTIS-M: Settlement item typeJABRPOSARTJABRPOSART
TAXM1Tax classification materialTAXM1TAXKM
TAXM2Tax classification materialTAXM2TAXKM
TAXM3Tax classification materialTAXM3TAXKM
TAXM4Tax Classification 4 MaterialTAXM4TAXKM
TAXM5Tax classification 5 for materialTAXM5TAXKM
TAXM6Tax classification 6 for materialTAXM6TAXKM
TAXM7Tax classification 7 for materialTAXM7TAXKM
TAXM8Tax Classification 8 MaterialTAXM8TAXKM
TAXM9Tax Classification 9 MaterialTAXM9TAXKM
KOWRRStatistical valuesKOWRRKOWRR
PRSFDCarry out pricingPRSFDPRSFD
KOSTLCost CenterKOSTLKOSTL
ERNAMName of Person who Created the ObjectERNAMUSNAM
ERDATDate on which the record was createdERDATDATUM
ERZETEntry timeERZETUZEIT
STAFOUpdate group for statistics updateSTAFOSTAFO
WAVWRCost in document currencyWAVWRWERTV7
KZWI1Subtotal 1 from pricing procedure for conditionKZWI1WERTV7
KZWI2Subtotal 2 from pricing procedure for conditionKZWI2WERTV7
KZWI3Subtotal 3 from pricing procedure for conditionKZWI3WERTV7
KZWI4Subtotal 4 from pricing procedure for conditionKZWI4WERTV7
KZWI5Subtotal 5 from pricing procedure for conditionKZWI5WERTV7
KZWI6Subtotal 6 from pricing procedure for conditionKZWI6WERTV7
STCURExchange rate for statistics (Exch.rate at time of creation)STCUR_APKURRF
UVPRSIncomplete with respect to pricingUVPRSXFELD
UVALLGenerally incompleteUVALLXFELD
PRCTRProfit CenterPRCTRPRCTR
KOKRSControlling AreaKOKRSCACCD
PAOBJNRProfitability Segment Number (CO-PA)RKEOBJNRRKEOBJNR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPS_POSNR
RK_AUFNROrder Number of RK Order for Account AssignmentJ_RK_AUFNRJ_RK_AUFNR
RK_POSNRItem Number of RK Order for Account AssignmentJ_RK_POSNRJ_RK_POSNR
CO_AUFNROrder number of internal CO order for account assignmentJ_CO_AUFNRAUFNR
TXJCDTax JurisdictionTXJCDTXJCD
XBEZPOSIS-M/SD: Item Type in Service Settlement for Home DeliveryXBEZPOSJXBEZPOS
BEZTATActual Carrier RouteBEZIRKTATBEZIRK
BEZRUNDTATActual Delivery RoundBEZRUNDTATBEZRUNDE
GP_ERS_ARTIS-M: Business Partner Substitution TypeGP_ERS_ARTGP_ERS_ART
VERSANDDATIS-M: Shipping DateVRSNDDATUMDATUM
TRAGEZDistribution time category (for home delivery settlement)TRAGEZEITKTRAGEZEITK
JAUARTIS-M/SD: Sales Document TypesAUART_ISPAUART_ISP
AUAGRPIS-M/SD: Sales document type groupingJAUARTGRPJAUARTGRP
BEZTYPMix TypeBEZUGSTYP_JE_PVABEZUGSTYP_JE_PVA
DRUTATActual Publication DeliveredDRERZTATDRERZ
DRUARTPublication TypeDRUERZARTDRUERZART
PVATATActual edition deliveredPVATATPVA
BRGEWIS-M: Gross weight (issue weight incl.weight of inserts)JBRGEWISPMNG13
NTGEWIS-M: Net Weight (Weight of Issue Minus Inserts)JNTGEWISPMNG13
MEINHGWIS-M: Unit of weight for total issue weightJMEINHGWMEINS
BEILAGENIS-M: Number of inserts per issueJBEILAGENSTMENGE
MEINHBLIS-M: Unit of weight for insertsJMEINHBLMEINS
NORMZGActual Qty Standard Units in a Home Del. Company's DeliveryNORMMNGIZGSTMENGE
NORMZUActual Quantity of Standard Units in a Carrier's DeliveryNORMMNGIZUSTMENGE
WRBMZGActual Quantity of Prom. Copies in a Del. Company's DeliveryWRBMNGIZGSTMENGE
WRBMZUActual Quantity of Prom. Copies in a Carrier's DeliveryWRBMNGIZUSTMENGE
NORMDZIS-M: Average quantity per period in carrier route (EE)JDMNGZUJSTMENGE
NORMDGIS-M: Average quantity per period in carrier route (SC)JDMNGZGJSTMENGE
LFATATActual delivery type (usually DT for dist.viability set)LFARTTATLIEFERART
XSCHLGELDIS-M: Key compensationXSCHLGELDXFELD
XWEGGLDNTIS-M/SD: Path compensation dailyJXWGGLD_TXFELD
XWEGGLDFGIS-M/SD: Path compensation dailyJXWGGLD_TXFELD
XWEGGLDFNIS-M/SD: Path compensation dailyJXWGGLD_TXFELD
XWGGELDPAIS-M/SD: Flat rate path compensation (monthly)JXWGGLD_MXFELD
XFARGLDNTIS-M/SD: Run compensation dailyJXFAGLD_TXFELD
XFARGLDFGIS-M/SD: Run compensation dailyJXFAGLD_TXFELD
XFARGLDFNIS-M/SD: Run compensation dailyJXFAGLD_TXFELD
XFAHRGELDIS-M/SD: Run compensationXFAHRGELDXFELD
XBEILZUNTInsert bonusXBEILZUXFELD
XBEILZUFGInsert bonusXBEILZUXFELD
XBEILZUFNInsert bonusXBEILZUXFELD
XGEWIZUNTIS-M/SD: Weight surchargeXGEWIZUXFELD
XGEWIZUFGIS-M/SD: Weight surchargeXGEWIZUXFELD
XGEWIZUFNIS-M/SD: Weight surchargeXGEWIZUXFELD
KTFEIERFGIS-M/SD: Public holiday bonus categoryKATFEIERKATFEIER
KTFEIERFNIS-M/SD: Public holiday bonus categoryKATFEIERKATFEIER
KTNACHTNTIS-M/SD: Night bonus categoryKATNACHTKATNACHT
KTNACHTFGIS-M/SD: Night bonus categoryKATNACHTKATNACHT
KTNACHTFNIS-M/SD: Night bonus categoryKATNACHTKATNACHT
KTSONN_NTIS-M/SD: Sunday bonus categoryKATSONNKATSONN
KTSONN_FGIS-M/SD: Sunday bonus categoryKATSONNKATSONN
KTSONN_FNIS-M/SD: Sunday bonus categoryKATSONNKATSONN
KTSLGDIS-M: Key compensation categorySCHLGLDKATSCHLGLDKAT
KTWEGDIS-M: Path length categoryWEGLANGKATWEGLANGKAT
KTFAGDDistance Traveled: Category (for Home Delivery Settlement)FAHRKMKATFAHRKMKAT
KTTOPOTopography category (for home delivery settlement)TOPOLOGIEKTOPOLOGIEK
KTTRAGDistribution time category (for home delivery settlement)TRAGEZEITKTRAGEZEITK
BEZKT1Carrier Route Flat Rate CategoryBEZKATE1BEZKATE1
BEZKT2IS-M: Carrier Route Category 2BEZKATE2BEZKATE2
BEZKT3IS-M: Carrier Route Category 3BEZKATE3BEZKATE3
BEZKT4IS-M: Carrier Route Category 4BEZKATE4BEZKATE4
BEZKT5IS-M: Carrier Route Category 5BEZKATE5BEZKATE5
GEWTVACalculated Issue WeightVAGEWICHTISPMNG9
GEWBEIWeight of InsertsGEWICHTBEIISPMNG9
GESGEWWeight of carrying issue (including inserts)TVAGEWICHTISPMNG9
ANZBEINumber of insertsSTCKBEILAGANZBEILAGE
MEINHGUnit of weight for issue (calculated weight)MEINHVAGEWMEINS
XFEIERTAGPublic holiday flagFEIERTAGKZCHAR1
WOTAG_NFatory calendar flagCINDCHAR1
WOTAG_AIS-M: Abbreviation for weekdayJWOTAGTEXT2
XVERGPVASTIS-M/SD: Remuneration according to editions per dayXVERGPVASTXFELD
XVERGPVAPEIS-M/SD: Remuneration according to edition period averageXVERGPVAPEXFELD
XVERGPVATDIS-M/SD: Remuneration according to daily edition averageXVERGPVATDXFELD
XVERGPVADUIS-M/SD: Remuneration according to edition averageXVERGPVADUXFELD
XVERGBEZPAIS-M/SD: Remuneration by carrier route flat rateXVERGBEZPAXFELD
DRERZPublicationDRERZDRERZ
PVAEditionPVAPVA
BZPERFIS-M: Service Type for BillingBEZPERFAKTBEZPER
WRBARTSales SourceWERBEARTWERBEART
WRBAKTSales PromotionWERBEAKTWERBEAKT
MINBEZMinimum Length of SubscriptionMINDBEZUGISPMNG2
MINEINTime Unit for Minimum Length of SubscriptionMINDBEZEINMEINS
XWKZIndicator: Promotion rebateXWKZXFELD
POARTInternal Item Type for Sales OrderPOART_ISPPOART_ISP
XEINMLIndicator: One-time commissionXEINMALPRVXFELD
XRENDIRenewal commissionXRENDITEXFELD
XPATEIS-M: Sponsored subscriptionXPATEXFELD
XFBLGABRIS-M: Follow-on settlement documentsXFBLGABRXFELD
ZLSCHIS-M: Order payment methodJKAPZLSCHZLSCH
VTWEGDistribution ChannelVTWEGVTWEG
SPARTDivision for order headerSPART_AKSPART
VBELNIS-M/SD: Publishing Sales OrderAVNRAVNR
GPAGBusiness Partner: Sold-to PartyGPAGGPNR
GPNR_LEIS-M: Business Partner Service ProviderGPNR_LEGPNR
BSTDKCustomer purchase order dateBSTDKDATUM
POSNRSales Order ItemAPNRAPNR
POSEXExternal Item Number (Purchase Order Item)POSEX_ISPPOSEX_ISP
ETENRSchedule lineETENRETENR
GUELTIGVONIS-M: Start of delivery of sales order itemLIEFBEGDATUM
RECHBEGINNBilling FromRECHBEGINNDATUM
PROVFDATCommission due datePROVFDATDATUM
XIMMATIndicator: Proof of matriculation providedXIMMATRIKXFELD
SHKZGDebit/Credit IndicatorSHKZGSHKZG
FKDATIS-M: Billing/Settlement DateJFKDATDATUM
KONDAPrice Group (Customer)KONDAKONDA
ANZMONABREIS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm.ANZMONABREISPMNG2
XPROVRUECKIndicator: Commission recalculation for order itemXPROVRUECKXFELD
ANZETIS-M: Number of Publication DatesISPANZETANZET
PROVRARTCommission clawback typePROVRARTPROVRART
WERBKZSCHLIS-M: WBZ, Promotion Rebate KeyJWBZWKZSCHJWBZWKZSCH
FKPERBilling FrequencyFKPERFKPER
XNEGOPIS-M: Item with Automatic Transformation to ChargeableXNEGOPTIONXFELD
ZUSTTYPIS-M: Carrier TypeJZUSTTYPJZUSTTYP
WRBMDZIS-M: Average promotion qty per period in carr.route (EE)JWRBMDZJSTMENGE
WRBMDGIS-M: Average promotion qty per period in carr.route (SC)JWRBMDGJSTMENGE
VKORGSales OrganizationVKORGVKORG
FAHRKMDistance (for Home Delivery Settlement)FAHRKMISPMNG9
EFAHRKUnit (km/m)EINHFAHRKMMEINS
BBEWRTIS-M: Valuation of carrier route for home del.settlementJZBEWERTNUMC5
VERKMITARTIS-M: Vehicle typeVERKMIT_HRVERKMIT_HR
TAET_KLASSIS-M: Activity classificationTAET_KLASSTAET_KLASS
VORGAENGERIS-M: Number of predecessorVORGAENGERLAUFNUMMER
NACHFOLGERNumber of successorNACHFOLGERLAUFNUMMER
DRERZTRAEGCarrying PublicationDRERZTRAEGDRERZ
PVATRAEGCarrying EditionPVATRAEGPVA
VERTYPIS-M: Sales Agent TypeVERTYPVERTYP
PROMNRSales order introductionJPROMNRJPROMNR
PROVPERCNTIS-M/SD: Percentage rate of commissionPROVPERCNTPROZENT100
EVENTIS-M/SD: Event in order processingJK_EVENTJK_EVENT
XAQUISITIONIS-M/SD: Indicator - first introduction recordXAQUISITIONXFELD
MATNRMaterial NumberMATNRMATNR

JLRP related tables

TableNote
A158PTT Circulation/Publication (CH)
A159Package Type/PType Var./Country Grouping
A385Sales Org./DChann./Division/Material/Status/Proc.Status
A386Sales Org./Dist.Chl./Division/Sold-To Pty
A446IS-M/SD: Network for Postal Shipping
A447IS-M/SD: Settlement Number for Periodical Post
A448IS-M/SD: Promotion Rebate for WBZ Company
A449IS-M/SD: Lump Sum Promotion Rebate
A450IS-PSD: Versandkosten pauschal Ländergruppierung
A451Purchase Price
A452IS-M/SD: Lump Sum Shipping Costs f.Current Delivery Country
A453IS-M/SD: Advance Payment Discount
A454IS-M/SD: Sales Promotion Discount
A455Customer Discount/Title
A456Conditions Per Publication and Price Group
A457Subscription Prices for Edition Condition Grouping
A458IS-M/SD: Employee Renewal Commission
A459IS-M/SD: Employee Up-Front Commission
A460Daily Subscription Prices for Edition Condition Grouping
A461IS-M/SD: Employee Bonus for Sales Promotion
Do you know this 11 Advantages of SAP Software?
Read Now
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2021 sapstack.com