SAP ABAP View V_MATGRP_DATE (Database View for Hierarchy Key Date)
Hierarchy
☛
EA-RETAIL (Software Component) SAP Enterprise Extension Retail
⤷ LO-MD (Application Component) Logistics Basic Data
⤷ WRF_CM_MD (Package) Category Management - Master Data
⤷ LO-MD (Application Component) Logistics Basic Data
⤷ WRF_CM_MD (Package) Category Management - Master Data
Basic Data
View Type | D | Database View |
Database View | V_MATGRP_DATE | |
Short Description | Database View for Hierarchy Key Date | |
Root table | WRF_MATGRP_STRUC | Category Structure |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | WRF_MATGRP_STRUC | WRF_MATGRP_STRUC | ||
2 | WRF_MATGRP_STRCT | |||
3 | WRF_MATGRP_TREE | |||
4 | WRF_MATGRP_TREET |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | WRF_MATGRP_STRUC | MANDT | JL | EQ | 0 | 0 | ||||
2 | WRF_MATGRP_STRCT | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | WRF_MATGRP_STRUC | HIER_ID | JL | EQ | 0 | 0 | ||||
4 | WRF_MATGRP_STRCT | HIER_ID | JR | EQ | AND | 0 | 0 | |||
5 | WRF_MATGRP_STRUC | NODE | JL | EQ | 0 | 0 | ||||
6 | WRF_MATGRP_STRCT | NODE | JR | EQ | AND | 0 | 0 | |||
7 | WRF_MATGRP_STRUC | MANDT | JL | EQ | 0 | 0 | ||||
8 | WRF_MATGRP_TREE | MANDT | JR | EQ | AND | 0 | 0 | |||
9 | WRF_MATGRP_STRUC | TREE_LEVEL | JL | EQ | 0 | 0 | ||||
10 | WRF_MATGRP_TREE | TREE_LEVEL | JR | EQ | AND | 0 | 0 | |||
11 | WRF_MATGRP_TREE | MANDT | JL | EQ | 0 | 0 | ||||
12 | WRF_MATGRP_TREET | MANDT | JR | EQ | AND | 0 | 0 | |||
13 | WRF_MATGRP_TREE | TREE_LEVEL | JL | EQ | 0 | 0 | ||||
14 | WRF_MATGRP_TREET | TREE_LEVEL | JR | EQ | AND | 0 | 0 | |||
15 | WRF_MATGRP_STRCT | SPRAS | JL | EQ | 0 | 0 | ||||
16 | WRF_MATGRP_TREET | SPRAS | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | WRF_MATGRP_STRUC | MANDT | MANDT | Client | |||
2 | HIER_ID | WRF_MATGRP_STRUC | HIER_ID | WRF_HIER_CNT | Hierarchy | |||
3 | NODE | WRF_MATGRP_STRUC | NODE | WRF_STRUC_NODE2 | Hierarchy Node | |||
4 | TREE_LEVEL | WRF_MATGRP_STRUC | TREE_LEVEL | WRF_CDT_LEVEL | Hierarchy Level | |||
5 | LTEXT | WRF_MATGRP_STRCT | LTEXT | WRF_MATGRP_TEXT2 | Description | |||
6 | SPRAS | WRF_MATGRP_STRCT | SPRAS | SPRAS | Language Key | |||
7 | LEVEL_TEXT | WRF_MATGRP_TREET | LEVEL_TEXT | WRF_LEVEL_TEXT | Name: Hierarchy Level | |||
8 | REFERENCE | WRF_MATGRP_STRUC | REFERENCE | WRF_CDT_REF | Reference Node | |||
9 | DATE_FROM | WRF_MATGRP_STRUC | DATE_FROM | WRF_DATE_FROM | Validity Start Date of Assignment in Article Hierarchy | |||
10 | DATE_TO | WRF_MATGRP_STRUC | DATE_TO | WRF_DATE_TO | Validity End Date of Assignment in Article Hierarchy | |||
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 | 20130529 |
SAP Release Created in | 111 |