SAP ABAP View V_HTN_MSUBST (View to Group Tables MARA and MSUBST for Search Help Z)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷
IS-AD-MPN (Application Component) Manufacturer Part Number
⤷
AD_MPN_SUCHEHILFE_IC (Package) Search Help for MPN - only Interchangeability objects
ECC-DIMP (Software Component) DIMP⤷
IS-AD-MPN (Application Component) Manufacturer Part Number⤷
AD_MPN_SUCHEHILFE_IC (Package) Search Help for MPN - only Interchangeability objects
Basic Data
| View Type | D | Database View |
| Database View | V_HTN_MSUBST | |
| Short Description | View to Group Tables MARA and MSUBST for Search Help Z | |
| Root table | MARA | General Material Data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | MARA |
MARA | ||
| 2 | MSUBST |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | MARA |
MATNR | JL | EQ | 0 | 0 | ||||
| 2 | MSUBST |
MATNR | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MSUBST |
MANDT | MANDT | Client | |||
| 2 | MATNR |
MSUBST |
MATNR | ORIG_MATNR | Original material number / FFF class | |||
| 3 | MFRPN |
MARA |
MFRPN | MFRPN | Manufacturer Part Number | |||
| 4 | SUBSTMAT |
MSUBST |
SUBSTMAT | SUBSTMAT | Part that replaces another part | |||
| 5 | EXCHTYP |
MSUBST |
EXCHTYP | PIC_PICCODE | Cause of part exchange | |||
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 |
