SAP ABAP View J_7LIZFV_V (REA View: Info Systems: Assignm. Material Type <=> Packaging)
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
⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
⤷ J7LR (Package) REA Core Functionality
Basic Data
View Type | D | Database View |
Database View | J_7LIZFV_V | |
Short Description | REA View: Info Systems: Assignm. Material Type <=> Packaging | |
Root table | J_7LS01 | REA Fractions: Internal Fractions |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | J_7LS01 | J_7LS01 | ||
2 | J_7LS01T | |||
3 | J_7LV02 | |||
4 | J_7LV01 | |||
5 | MARA | |||
6 | MAKT |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | J_7LS01 | MANDT | JL | EQ | 0 | 0 | ||||
2 | J_7LS01T | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | J_7LS01 | STOFI | JL | EQ | 0 | 0 | ||||
4 | J_7LS01T | STOFF | JR | EQ | AND | 0 | 0 | |||
5 | J_7LS01 | MANDT | JL | EQ | 0 | 0 | ||||
6 | J_7LV02 | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | J_7LS01 | STOFI | JL | EQ | 0 | 0 | ||||
8 | J_7LV02 | STOFF | JR | EQ | AND | 0 | 0 | |||
9 | J_7LS01T | SPRAS | JL | EQ | 0 | 0 | ||||
10 | MAKT | SPRAS | JR | EQ | AND | 0 | 0 | |||
11 | J_7LV01 | MANDT | JL | EQ | 0 | 0 | ||||
12 | J_7LV02 | MANDT | JR | EQ | AND | 0 | 0 | |||
13 | J_7LV01 | VRPNR | JL | EQ | 0 | 0 | ||||
14 | J_7LV02 | VRPNR | JR | EQ | AND | 0 | 0 | |||
15 | J_7LV01 | VARIANTE | JL | EQ | 0 | 0 | ||||
16 | J_7LV02 | VARIANTE | JR | EQ | AND | 0 | 0 | |||
17 | MARA | MANDT | JL | EQ | 0 | 0 | ||||
18 | J_7LV01 | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | MARA | MATNR | JL | EQ | 0 | 0 | ||||
20 | J_7LV01 | VRPNR | JR | EQ | AND | 0 | 0 | |||
21 | MARA | MANDT | JL | EQ | 0 | 0 | ||||
22 | MAKT | MANDT | JR | EQ | AND | 0 | 0 | |||
23 | MARA | MATNR | JL | EQ | 0 | 0 | ||||
24 | MAKT | MATNR | JR | EQ | AND | 0 | 0 | |||
25 | J_7LS01 | LVORMADM | EQ | ' ' | AND | 0 | 0 | |||
26 | J_7LV02 | LVORMADM | EQ | ' ' | AND | 0 | 0 | |||
27 | J_7LV01 | LVORMADM | EQ | ' ' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | J_7LS01 | MANDT | MANDT | Client | |||
2 | STOFI | J_7LS01 | STOFI | J_7LRSTOFI | Internal Fraction | |||
3 | SPRASV | MAKT | SPRAS | SPRAS | Language Key | |||
4 | DATBI | J_7LV02 | DATBI | DATBI | Valid To Date | |||
5 | VRPNR | J_7LV02 | VRPNR | J_7LVRP | Packaging | |||
6 | VVARIANTE | J_7LV01 | VARIANTE | J_7LVVARIANTE | Variant of Packaging | |||
7 | STOKL | J_7LS01 | STOKL | MGEF_STOKL | Class of substances | |||
8 | GSTFN | J_7LS01 | GSTFN | STOFF | Hazardous material number | |||
9 | STOKTX | J_7LS01T | STOKTX | J_7LRSTKTX | Internal Fraction: Short Text | |||
10 | STOKTG | J_7LS01T | STOKTG | J_7LRSTKTG | Internal Fraction: Short Text in Uppercase | |||
11 | DATAB | J_7LV02 | DATAB | DATAB | Valid-From Date | |||
12 | VRSIO | J_7LV02 | VRSIO | J_7LVRS | Version | |||
13 | STGEW | J_7LV02 | STGEW | J_7LRGEW | Fraction Weight | |||
14 | GEWEI | J_7LV02 | GEWEI | GEWEI | Weight Unit | |||
15 | VPTYP | J_7LV01 | VPTYP | J_7LVPTYP | Packaging Class | |||
16 | VPARTG | J_7LV01 | VPARTG | J_7LVPARTG | Packaging Type Weight-Dependent Fee | |||
17 | VPARTS | J_7LV01 | VPARTS | J_7LVPARTS | Packaging Type Item-Dependent Fee | |||
18 | TRENNKZ | J_7LV01 | TRENNKZ | J_7LVTRNKZ | Indicator for Packaging Separability | |||
19 | VPFORMTYP | J_7LV01 | VPFORMTYP | J_7LVFORMT | Packaging Form Type | |||
20 | VERSCHNITT | J_7LV01 | VERSCHNITT | J_7LVRSCHN | Remnants | |||
21 | VPKTX | MAKT | MAKTX | MAKTX | Material description | |||
22 | VPKTG | MAKT | MAKTG | MAKTG | Material description in upper case for matchcodes | |||
23 | VPEBENE | J_7LV01 | VPEBENE | J_7LVEBENE | Packaging Level | |||
24 | MUSTERVRPNR | J_7LV01 | MUSTERVRPNR | J_7LMSTVRP | REA Packaging Master: Assigned Model Packaging | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |