J_7LV1P SAP (REA Document: Item Data) Table details
Dictionary Type: Table
Description: REA Document: Item Data
Description: REA Document: Item Data
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | REA Declaration: Document Number | J_7LVNR_A | CHAR | 10 | J_7LV1K | ALPHA | VBELN | VF | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
VRSIO | Version | J_7LVRS | CHAR | 6 | CHAR6 | ||||
POSNR | REA Declaration: Line Item | J_7LRPOS_A | NUMC | 6 | NUMC6 | ||||
UEPOS | REA Declaration: Higher-Level Line Item | J_7LUEPOS | NUMC | 6 | NUMC6 | ||||
NETWR | Net Value in Document Currency | J_7LNETWR | CURR | 17(2) | J_7LWERTVX | ||||
NETWE | Net Value in Recycling Partner Currency | J_7LNETWE | CURR | 17(2) | J_7LWERTVX | ||||
BERWR | Calculated Value in Document Currency (Output Value Formula) | J_7LBERWR | CURR | 17(2) | J_7LWERTVX | ||||
BERWE | Net Value in Recycling Partner Currency (Fee Formula) | J_7LBERWE | CURR | 17(2) | J_7LWERTVX | ||||
PBERWR | Calculated Value in Document Currency (Initial Value PF) | J_7LPBERWR | CURR | 17(2) | J_7LWERTVX | ||||
PBERWE | Calculated Value in Recycling Partner Crcy (Price Formula) | J_7LPBERWE | CURR | 17(2) | J_7LWERTVX | ||||
PLVRS | Price List Version | J_7LRPLVRS | CHAR | 6 | J_7LP01 | J_7LRPLVRS | J6N | ||
SOKOA | Special Condition Type | J_7LSOKOA | NUMC | 4 | J_7LC21 | J_7LSOKOA | |||
KOART | Condition Type | J_7LKOART | CHAR | 4 | J_7LC36 | CHAR4 | |||
PLTYP | Price List Item Category | J_7LRPLT | CHAR | 1 | J_7LRPLT | ||||
POSAR | Declaration Item Type | J_7LPOSAR | CHAR | 1 | J_7LPOSAR | ||||
VFLKL | Volume/Area Class | J_7LVFLKL | CHAR | 6 | Assigned to domain | J_7LRVFLKL | |||
VFLST | Number of Pieces for Volume and Area Classes | J_7LVFLST | QUAN | 17(6) | J_7LMENGV17_6 | ||||
VRPST | Number of Pieces, Packaging | J_7LVRPST | QUAN | 17(6) | J_7LMENGV17_6 | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
STOFE | Partner Fraction | J_7LRSTOFE | CHAR | 6 | Assigned to domain | J_7LSTOFFE | |||
STOFP | Fraction Price: Recycling Partner | J_7LRSTOFP | CHAR | 6 | Assigned to domain | J_7LSTOFFE | |||
STGEW | Fraction Weight | J_7LRGEW | QUAN | 17(6) | J_7LMENGV17_6 | ||||
STGEWFF | Fraction Weight | J_7LRGEW | QUAN | 17(6) | J_7LMENGV17_6 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
PLPOS | Price List Item | J_7LRPLPOS | NUMC | 6 | J_7LRPLPOS | ||||
FORMEL | Formula for Fee Calculation | J_7LFORMEL | CHAR | 4 | J_7LE15 | J_7LFORMEL | |||
PFORMEL | Price Formula | J_7LPFORMEL | CHAR | 4 | J_7LE17 | J_7LPFORMEL | |||
PKOART | Condition Type of Price Formula Use | J_7LPKOART | CHAR | 4 | J_7LC36 | CHAR4 | |||
PFORMVW | Use of Price Formula | J_7LPFORMVW | CHAR | 1 | J_7LPFORMVW | ||||
PKPROZ | Percentage for Valuation Share (from Price Formula Use) | J_7LPKPROZ | DEC | 5(2) | DECV3_2 | ||||
PKPROZS | Percentage for Valuation Share of Item-Dep.Fee (from PF) | J_7LPKPROZS | DEC | 5(2) | DECV3_2 | ||||
PGAAWR | Total Value Absolute Article in Doc.Crcy from Price Formula | J_7LPGAAWR | CURR | 17(2) | J_7LWERTVX | ||||
PGAAWE | Total Value Absolute Article in Part.Crcy from Price Formula | J_7LPGAAWE | CURR | 17(2) | J_7LWERTVX | ||||
PKPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
PREISR | Price in Reference Company Code Currency | J_7LSTPR | CURR | 17(2) | J_7LWERTVX | ||||
PREISE | Price in Recycling Partner Currency | J_7LSTPE | CURR | 17(2) | J_7LWERTVX | ||||
PREISA | Price in Alternative Currency of Reference Company Code | J_7LRSTPA | CURR | 17(2) | J_7LWERTVX | ||||
PREISB | Price in Document Currency | J_7LRSTPB | CURR | 17(2) | J_7LWERTVX | ||||
KPEIN | Condition Pricing Unit | J_7LKPEIN | DEC | 9 | J_7LKPEIN | ||||
KPROZ | Percentage for Valuation Share (Price List Item/Trade Level) | J_7LKPROZ | DEC | 6(3) | DECV3_3 | ||||
KOKEY | Condition Type Assignment Key | J_7LKOKEY | NUMC | 6 | NUMC6 | ||||
SPLIT | Splitting Quota in Percent | J_7LRSPLIT | DEC | 7(4) | J_7LPRZNT | ||||
RVBLN | Assigned Sales Document | J_7LRVBLN | CHAR | 10 | VBUK | ALPHA | VBELN | ||
RPOSN | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
RMATN | Material Number in Assigned Sales Document Item | J_7LRMATN | CHAR | 18 | MARA | MATN1 | MATNR | ||
VPEBENE | Packaging Level | J_7LVEBENE | NUMC | 2 | J_7LC20 | J_7LVEBENE | |||
VPARTG | Packaging Type Weight-Dependent Fee | J_7LVPARTG | NUMC | 2 | J_7LC17 | J_7LRVPART | |||
VPARTS | Packaging Type Item-Dependent Fee | J_7LVPARTS | NUMC | 2 | J_7LC17 | J_7LRVPART | |||
VRPKT | Packaging Category Fraction | J_7LVRPKT | CHAR | 5 | Assigned to domain | J_7LVRPKT | |||
INFOK | Additional Info Key | J_7LINFOK | CHAR | 5 | Assigned to domain | J_7LINFOK | |||
FUELLG | Content ID Key | J_7LFUELLG | CHAR | 5 | Assigned to domain | J_7LFUELLG | |||
HDLST | Trade Level | J_7LHDLST | NUMC | 5 | Assigned to domain | J_7LHDLST | |||
KPROZH | Trade Level Valuation Percentage | J_7LKPROZH | DEC | 5(2) | DECV3_2 | ||||
KPROZHF | Valuation Percentage for Trade Level Fraction | J_7LKPROZHF | DEC | 5(2) | DECV3_2 | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LLAND | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
MBRSH | Industry sector | MBRSH | CHAR | 1 | T137 | MBRSH | MTP | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
HKUNNR | Customer number of the higher-level customer hierarchy | HKUNNR_KH | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
HVKORG | Higher-level sales organization | HVKORG | CHAR | 4 | TVKO | VKORG | VKO | ||
HVTWEG | Higher-level distribution channel | HVTWEG | CHAR | 2 | TVTW | VTWEG | VTW | ||
HSPART | Higher-level division | HSPART | CHAR | 2 | TSPA | SPART | SPA | ||
HPARVW | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
GRUPPE | Grouping of Characteristics in MM | J_7LGRUPPE | CHAR | 4 | J_7LC46 | J_7LGRUPPE | |||
STGEWM | Fraction Weight | J_7LRGEW | QUAN | 17(6) | J_7LMENGV17_6 | ||||
GEWEIM | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
FKIMP | Proportional Quantity (Sales / Entry Unit | J_7LMNGP | DEC | 17(6) | J_7LDEC | ||||
KUMSTKZ | Cumulation Mode for Number of Pieces in Declaration Item | J_7LKUMSTKZ | CHAR | 1 | J_7LKUMSTKZ | ||||
MHRKFT | Origin of Declaration Item | J_7LMHRKFT | CHAR | 1 | J_7LMHRKFT | ||||
MATNS | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
VARIANTE | Variant | J_7LVARIANTE | CHAR | 18 | J_7LVARIANTE | J6Q | |||
DATAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
DATBI | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
VRPNR | Packaging | J_7LVRP | CHAR | 18 | Assigned to domain | MATN1 | MATNR | J6L | |
VVARIANTE | Variant of Packaging | J_7LVVARIANTE | CHAR | 18 | J_7LVARIANTE | ||||
KPEINV | Number of Sales Units in Packaging Bill of Material | J_7LRKPEIN | DEC | 5 | KPEIN | ||||
MEINSV | Component unit of measure | KMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FMENGV | Component quantity | KMPMG | QUAN | 13(3) | MENGV13 | ||||
.INCLU-ADM | 0 | ||||||||
DATABADM | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
DATBIADM | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
ERSDAADM | Created On | ERSDA | DATS | 8 | DATUM | ||||
ERZETADM | Time Created | J_7LERZET | TIMS | 6 | UZEIT | ||||
ERNAMADM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
LAEDAADM | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
AEZETADM | Time Last Change Was Made | J_7LAEZET | TIMS | 6 | UZEIT | ||||
AENAMADM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
LVORMADM | Deletion Indicator | LVORM | CHAR | 1 | XFELD |
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 tableDATA: 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 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