J_7LV1P SAP (REA Document: Item Data) Table details

Dictionary Type: Table
Description: REA Document: Item Data




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




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

J_7LV1P is a standard SAP Table which is used to store REA Document: Item Data data and is available within R/3 SAP systems depending on the version and release level.

The J_7LV1P table consists of various fields, each holding specific information or linking keys about REA Document: Item Data data available in SAP. These include VBELN (REA Declaration: Document Number), MATNR (Material Number), VRSIO (Version), POSNR (REA Declaration: Line Item).. 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: Cannot Be Enhanced


SAP J_7LV1P 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
VBELNREA Declaration: Document Number J_7LVNR_ACHAR10J_7LV1KALPHAVBELNVF
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VRSIOVersion J_7LVRSCHAR6CHAR6
POSNRREA Declaration: Line Item J_7LRPOS_ANUMC6NUMC6
UEPOSREA Declaration: Higher-Level Line Item J_7LUEPOSNUMC6NUMC6
NETWRNet Value in Document Currency J_7LNETWRCURR17(2) J_7LWERTVX
NETWENet Value in Recycling Partner Currency J_7LNETWECURR17(2) J_7LWERTVX
BERWRCalculated Value in Document Currency (Output Value Formula) J_7LBERWRCURR17(2) J_7LWERTVX
BERWENet Value in Recycling Partner Currency (Fee Formula) J_7LBERWECURR17(2) J_7LWERTVX
PBERWRCalculated Value in Document Currency (Initial Value PF) J_7LPBERWRCURR17(2) J_7LWERTVX
PBERWECalculated Value in Recycling Partner Crcy (Price Formula) J_7LPBERWECURR17(2) J_7LWERTVX
PLVRSPrice List Version J_7LRPLVRSCHAR6J_7LP01J_7LRPLVRSJ6N
SOKOASpecial Condition Type J_7LSOKOANUMC4J_7LC21J_7LSOKOA
KOARTCondition Type J_7LKOARTCHAR4J_7LC36CHAR4
PLTYPPrice List Item Category J_7LRPLTCHAR1J_7LRPLT
POSARDeclaration Item Type J_7LPOSARCHAR1J_7LPOSAR
VFLKLVolume/Area Class J_7LVFLKLCHAR6Assigned to domainJ_7LRVFLKL
VFLSTNumber of Pieces for Volume and Area Classes J_7LVFLSTQUAN17(6) J_7LMENGV17_6
VRPSTNumber of Pieces, Packaging J_7LVRPSTQUAN17(6) J_7LMENGV17_6
KMEINCondition unit KMEINUNIT3T006CUNITMEINS
STOFEPartner Fraction J_7LRSTOFECHAR6Assigned to domainJ_7LSTOFFE
STOFPFraction Price: Recycling Partner J_7LRSTOFPCHAR6Assigned to domainJ_7LSTOFFE
STGEWFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
STGEWFFFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
PLPOSPrice List Item J_7LRPLPOSNUMC6J_7LRPLPOS
FORMELFormula for Fee Calculation J_7LFORMELCHAR4J_7LE15J_7LFORMEL
PFORMELPrice Formula J_7LPFORMELCHAR4J_7LE17J_7LPFORMEL
PKOARTCondition Type of Price Formula Use J_7LPKOARTCHAR4J_7LC36CHAR4
PFORMVWUse of Price Formula J_7LPFORMVWCHAR1J_7LPFORMVW
PKPROZPercentage for Valuation Share (from Price Formula Use) J_7LPKPROZDEC5(2) DECV3_2
PKPROZSPercentage for Valuation Share of Item-Dep.Fee (from PF) J_7LPKPROZSDEC5(2) DECV3_2
PGAAWRTotal Value Absolute Article in Doc.Crcy from Price Formula J_7LPGAAWRCURR17(2) J_7LWERTVX
PGAAWETotal Value Absolute Article in Part.Crcy from Price Formula J_7LPGAAWECURR17(2) J_7LWERTVX
PKPEINCondition pricing unit KPEINDEC5KPEIN
PREISRPrice in Reference Company Code Currency J_7LSTPRCURR17(2) J_7LWERTVX
PREISEPrice in Recycling Partner Currency J_7LSTPECURR17(2) J_7LWERTVX
PREISAPrice in Alternative Currency of Reference Company Code J_7LRSTPACURR17(2) J_7LWERTVX
PREISBPrice in Document Currency J_7LRSTPBCURR17(2) J_7LWERTVX
KPEINCondition Pricing Unit J_7LKPEINDEC9J_7LKPEIN
KPROZPercentage for Valuation Share (Price List Item/Trade Level) J_7LKPROZDEC6(3) DECV3_3
KOKEYCondition Type Assignment Key J_7LKOKEYNUMC6NUMC6
SPLITSplitting Quota in Percent J_7LRSPLITDEC7(4) J_7LPRZNT
RVBLNAssigned Sales Document J_7LRVBLNCHAR10VBUKALPHAVBELN
RPOSNSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
RMATNMaterial Number in Assigned Sales Document Item J_7LRMATNCHAR18MARAMATN1MATNR
VPEBENEPackaging Level J_7LVEBENENUMC2J_7LC20J_7LVEBENE
VPARTGPackaging Type Weight-Dependent Fee J_7LVPARTGNUMC2J_7LC17J_7LRVPART
VPARTSPackaging Type Item-Dependent Fee J_7LVPARTSNUMC2J_7LC17J_7LRVPART
VRPKTPackaging Category Fraction J_7LVRPKTCHAR5Assigned to domainJ_7LVRPKT
INFOKAdditional Info Key J_7LINFOKCHAR5Assigned to domainJ_7LINFOK
FUELLGContent ID Key J_7LFUELLGCHAR5Assigned to domainJ_7LFUELLG
HDLSTTrade Level J_7LHDLSTNUMC5Assigned to domainJ_7LHDLST
KPROZHTrade Level Valuation Percentage J_7LKPROZHDEC5(2) DECV3_2
KPROZHFValuation Percentage for Trade Level Fraction J_7LKPROZHFDEC5(2) DECV3_2
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LLANDCountry of Destination LLANDCHAR3T005LAND1VLL
MTARTMaterial Type MTARTCHAR4T134MTARTMTA
MBRSHIndustry sector MBRSHCHAR1T137MBRSHMTP
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
PRDHAProduct hierarchy PRODH_DCHAR18T179PRODHVPR
HKUNNRCustomer number of the higher-level customer hierarchy HKUNNR_KHCHAR10KNA1ALPHAKUNNR
HVKORGHigher-level sales organization HVKORGCHAR4TVKOVKORGVKO
HVTWEGHigher-level distribution channel HVTWEGCHAR2TVTWVTWEGVTW
HSPARTHigher-level division HSPARTCHAR2TSPASPARTSPA
HPARVWPartner Function PARVWCHAR2TPARPARVWPARVWPAR
GRUPPEGrouping of Characteristics in MM J_7LGRUPPECHAR4J_7LC46J_7LGRUPPE
STGEWMFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
GEWEIMWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
FKIMPProportional Quantity (Sales / Entry Unit J_7LMNGPDEC17(6) J_7LDEC
KUMSTKZCumulation Mode for Number of Pieces in Declaration Item J_7LKUMSTKZCHAR1J_7LKUMSTKZ
MHRKFTOrigin of Declaration Item J_7LMHRKFTCHAR1J_7LMHRKFT
MATNSMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VARIANTEVariant J_7LVARIANTECHAR18J_7LVARIANTEJ6Q
DATABValid-From Date DATABDATS8DATUM
DATBIValid To Date DATBIDATS8DATUM
VRPNRPackaging J_7LVRPCHAR18Assigned to domainMATN1MATNRJ6L
VVARIANTEVariant of Packaging J_7LVVARIANTECHAR18J_7LVARIANTE
KPEINVNumber of Sales Units in Packaging Bill of Material J_7LRKPEINDEC5KPEIN
MEINSVComponent unit of measure KMPMEUNIT3Assigned to domainCUNITMEINS
FMENGVComponent quantity KMPMGQUAN13(3) MENGV13
.INCLU-ADM 0
DATABADMValid-From Date DATABDATS8DATUM
DATBIADMValid To Date DATBIDATS8DATUM
ERSDAADMCreated On ERSDADATS8DATUM
ERZETADMTime Created J_7LERZETTIMS6UZEIT
ERNAMADMName of Person who Created the Object ERNAMCHAR12USNAM
LAEDAADMDate of Last Change LAEDADATS8DATUM
AEZETADMTime Last Change Was Made J_7LAEZETTIMS6UZEIT
AENAMADMName of Person Who Changed Object AENAMCHAR12USNAM
LVORMADMDeletion Indicator LVORMCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_7LV1P
INTO CORRESPONDING FIELDS OF WA_J_7LV1P
WHERE...

How to access SAP table J_7LV1P

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