SAP ABAP Table J_7LV1P (REA Document: Item Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_7LV1P	Table Relationship Diagram
Short Description	REA Document: Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	J_7LVNR_A	VBELN	CHAR	10	0	REA Declaration: Document Number	J_7LV1K
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	VRSIO	☑	J_7LVRS	CHAR6	CHAR	6	0	Version
5	POSNR	☑	J_7LRPOS_A	NUMC6	NUMC	6	0	REA Declaration: Line Item
6	UEPOS	☐	J_7LUEPOS	NUMC6	NUMC	6	0	REA Declaration: Higher-Level Line Item
7	NETWR	☐	J_7LNETWR	J_7LWERTVX	CURR	17	2	Net Value in Document Currency
8	NETWE	☐	J_7LNETWE	J_7LWERTVX	CURR	17	2	Net Value in Recycling Partner Currency
9	BERWR	☐	J_7LBERWR	J_7LWERTVX	CURR	17	2	Calculated Value in Document Currency (Output Value Formula)
10	BERWE	☐	J_7LBERWE	J_7LWERTVX	CURR	17	2	Net Value in Recycling Partner Currency (Fee Formula)
11	PBERWR	☐	J_7LPBERWR	J_7LWERTVX	CURR	17	2	Calculated Value in Document Currency (Initial Value PF)
12	PBERWE	☐	J_7LPBERWE	J_7LWERTVX	CURR	17	2	Calculated Value in Recycling Partner Crcy (Price Formula)
13	PLVRS	☐	J_7LRPLVRS	J_7LRPLVRS	CHAR	6	0	Price List Version	J_7LP01
14	SOKOA	☐	J_7LSOKOA	J_7LSOKOA	NUMC	4	0	Special Condition Type	J_7LC21
15	KOART	☐	J_7LKOART	CHAR4	CHAR	4	0	Condition Type	J_7LC36
16	PLTYP	☐	J_7LRPLT	J_7LRPLT	CHAR	1	0	Price List Item Category
17	POSAR	☐	J_7LPOSAR	J_7LPOSAR	CHAR	1	0	Declaration Item Type
18	VFLKL	☐	J_7LVFLKL	J_7LRVFLKL	CHAR	6	0	Volume/Area Class	*
19	VFLST	☐	J_7LVFLST	J_7LMENGV17_6	QUAN	17	6	Number of Pieces for Volume and Area Classes
20	VRPST	☐	J_7LVRPST	J_7LMENGV17_6	QUAN	17	6	Number of Pieces, Packaging
21	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
22	STOFE	☐	J_7LRSTOFE	J_7LSTOFFE	CHAR	6	0	Partner Fraction	*
23	STOFP	☐	J_7LRSTOFP	J_7LSTOFFE	CHAR	6	0	Fraction Price: Recycling Partner	*
24	STGEW	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
25	STGEWFF	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
26	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
27	PLPOS	☐	J_7LRPLPOS	J_7LRPLPOS	NUMC	6	0	Price List Item
28	FORMEL	☐	J_7LFORMEL	J_7LFORMEL	CHAR	4	0	Formula for Fee Calculation	J_7LE15
29	PFORMEL	☐	J_7LPFORMEL	J_7LPFORMEL	CHAR	4	0	Price Formula	J_7LE17
30	PKOART	☐	J_7LPKOART	CHAR4	CHAR	4	0	Condition Type of Price Formula Use	J_7LC36
31	PFORMVW	☐	J_7LPFORMVW	J_7LPFORMVW	CHAR	1	0	Use of Price Formula
32	PKPROZ	☐	J_7LPKPROZ	DECV3_2	DEC	5	2	Percentage for Valuation Share (from Price Formula Use)
33	PKPROZS	☐	J_7LPKPROZS	DECV3_2	DEC	5	2	Percentage for Valuation Share of Item-Dep.Fee (from PF)
34	PGAAWR	☐	J_7LPGAAWR	J_7LWERTVX	CURR	17	2	Total Value Absolute Article in Doc.Crcy from Price Formula
35	PGAAWE	☐	J_7LPGAAWE	J_7LWERTVX	CURR	17	2	Total Value Absolute Article in Part.Crcy from Price Formula
36	PKPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
37	PREISR	☐	J_7LSTPR	J_7LWERTVX	CURR	17	2	Price in Reference Company Code Currency
38	PREISE	☐	J_7LSTPE	J_7LWERTVX	CURR	17	2	Price in Recycling Partner Currency
39	PREISA	☐	J_7LRSTPA	J_7LWERTVX	CURR	17	2	Price in Alternative Currency of Reference Company Code
40	PREISB	☐	J_7LRSTPB	J_7LWERTVX	CURR	17	2	Price in Document Currency
41	KPEIN	☐	J_7LKPEIN	J_7LKPEIN	DEC	9	0	Condition Pricing Unit
42	KPROZ	☐	J_7LKPROZ	DECV3_3	DEC	6	3	Percentage for Valuation Share (Price List Item/Trade Level)
43	KOKEY	☐	J_7LKOKEY	NUMC6	NUMC	6	0	Condition Type Assignment Key
44	SPLIT	☐	J_7LRSPLIT	J_7LPRZNT	DEC	7	4	Splitting Quota in Percent
45	RVBLN	☐	J_7LRVBLN	VBELN	CHAR	10	0	Assigned Sales Document	VBUK
46	RPOSN	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
47	RMATN	☐	J_7LRMATN	MATNR	CHAR	18	0	Material Number in Assigned Sales Document Item	MARA
48	VPEBENE	☐	J_7LVEBENE	J_7LVEBENE	NUMC	2	0	Packaging Level	J_7LC20
49	VPARTG	☐	J_7LVPARTG	J_7LRVPART	NUMC	2	0	Packaging Type Weight-Dependent Fee	J_7LC17
50	VPARTS	☐	J_7LVPARTS	J_7LRVPART	NUMC	2	0	Packaging Type Item-Dependent Fee	J_7LC17
51	VRPKT	☐	J_7LVRPKT	J_7LVRPKT	CHAR	5	0	Packaging Category Fraction	*
52	INFOK	☐	J_7LINFOK	J_7LINFOK	CHAR	5	0	Additional Info Key	*
53	FUELLG	☐	J_7LFUELLG	J_7LFUELLG	CHAR	5	0	Content ID Key	*
54	HDLST	☐	J_7LHDLST	J_7LHDLST	NUMC	5	0	Trade Level	*
55	KPROZH	☐	J_7LKPROZH	DECV3_2	DEC	5	2	Trade Level Valuation Percentage
56	KPROZHF	☐	J_7LKPROZHF	DECV3_2	DEC	5	2	Valuation Percentage for Trade Level Fraction
57	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
58	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
59	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
60	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
61	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
62	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
63	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
64	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
65	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
66	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
67	HKUNNR	☐	HKUNNR_KH	KUNNR	CHAR	10	0	Customer number of the higher-level customer hierarchy	KNA1
68	HVKORG	☐	HVKORG	VKORG	CHAR	4	0	Higher-level sales organization	TVKO
69	HVTWEG	☐	HVTWEG	VTWEG	CHAR	2	0	Higher-level distribution channel	TVTW
70	HSPART	☐	HSPART	SPART	CHAR	2	0	Higher-level division	TSPA
71	HPARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
72	GRUPPE	☐	J_7LGRUPPE	J_7LGRUPPE	CHAR	4	0	Grouping of Characteristics in MM	J_7LC46
73	STGEWM	☐	J_7LRGEW	J_7LMENGV17_6	QUAN	17	6	Fraction Weight
74	GEWEIM	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
75	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
76	FKIMP	☐	J_7LMNGP	J_7LDEC	DEC	17	6	Proportional Quantity (Sales / Entry Unit
77	KUMSTKZ	☐	J_7LKUMSTKZ	J_7LKUMSTKZ	CHAR	1	0	Cumulation Mode for Number of Pieces in Declaration Item
78	MHRKFT	☐	J_7LMHRKFT	J_7LMHRKFT	CHAR	1	0	Origin of Declaration Item
79	MATNS	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
80	VARIANTE	☐	J_7LVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant
81	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
82	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
83	VRPNR	☐	J_7LVRP	MATNR	CHAR	18	0	Packaging	*
84	VVARIANTE	☐	J_7LVVARIANTE	J_7LVARIANTE	CHAR	18	0	Variant of Packaging
85	KPEINV	☐	J_7LRKPEIN	KPEIN	DEC	5	0	Number of Sales Units in Packaging Bill of Material
86	MEINSV	☐	KMPME	MEINS	UNIT	3	0	Component Unit of Measure	*
87	FMENGV	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
88	.INCLU-ADM	☐				0	0	REA Administration Data
89	DATABADM	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
90	DATBIADM	☐	DATBI	DATUM	DATS	8	0	Valid To Date
91	ERSDAADM	☐	ERSDA	DATUM	DATS	8	0	Created On
92	ERZETADM	☐	J_7LERZET	UZEIT	TIMS	6	0	Time Created
93	ERNAMADM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
94	LAEDAADM	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
95	AEZETADM	☐	J_7LAEZET	UZEIT	TIMS	6	0	Time Last Change Was Made
96	AENAMADM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
97	LVORMADM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LV1P	FORMEL	J_7LE15	FORMEL
2	J_7LV1P	GEWEI	T006	MSEHI
3	J_7LV1P	GRUPPE	J_7LC46	GRUPPE
4	J_7LV1P	GSBER	TGSB	GSBER
5	J_7LV1P	HKUNNR	KNA1	KUNNR
6	J_7LV1P	HPARVW	TPAR	PARVW
7	J_7LV1P	HSPART	TSPA	SPART
8	J_7LV1P	HVKORG	TVKO	VKORG
9	J_7LV1P	HVTWEG	TVTW	VTWEG
10	J_7LV1P	KMEIN	T006	MSEHI
11	J_7LV1P	KOART	J_7LC36	KOART
12	J_7LV1P	LLAND	T005	LAND1
13	J_7LV1P	MANDT	T000	MANDT
14	J_7LV1P	MATKL	T023	MATKL
15	J_7LV1P	MATNR	MARA	MATNR
16	J_7LV1P	MATNS	MARA	MATNR
17	J_7LV1P	MBRSH	T137	MBRSH
18	J_7LV1P	MTART	T134	MTART
19	J_7LV1P	PFORMEL	J_7LE17	PFORMEL
20	J_7LV1P	PKOART	J_7LC36	KOART
21	J_7LV1P	PLVRS	J_7LP01	PLVRS
22	J_7LV1P	PRDHA	T179	PRODH
23	J_7LV1P	RMATN	MARA	MATNR
24	J_7LV1P	RPOSN	VBUP	POSNR
25	J_7LV1P	RVBLN	VBUK	VBELN
26	J_7LV1P	SOKOA	J_7LC21	SOKOA
27	J_7LV1P	SPART	TSPA	SPART
28	J_7LV1P	VBELN	J_7LV1K	VBELN
29	J_7LV1P	VKORG	TVKO	VKORG
30	J_7LV1P	VPARTG	J_7LC17	VPART
31	J_7LV1P	VPARTS	J_7LC17	VPART
32	J_7LV1P	VPEBENE	J_7LC20	VPEBENE
33	J_7LV1P	VRKME	T006	MSEHI
34	J_7LV1P	VTWEG	TVTW	VTWEG
35	J_7LV1P	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in