SAP ABAP View U_16402 (Competitor Material)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   CA (Application Component) Cross-Application Components
     UUDM (Package) EDM: Data Modeler (General)
Basic Data
View Type D Database View 
Database View U_16402  
Short Description Competitor Material    
Root table MARA   General Material Data 
Entity TypeDM02L 
Short text Co-applicant material
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 MARA MARA
2 MAKT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 MARA MANDT JL EQ 0 0
2 MAKT MANDT JR EQ AND 0 0
3 MARA MATNR JL EQ 0 0
4 MAKT MATNR JR EQ AND 0 0
5 MARA MTART EQ 'WETT' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT MARA MANDT   MANDT Client
2 MATNR MARA MATNR   MATNR Material Number
3 SPRAS MAKT SPRAS   SPRAS Language Key
4 ERSDA MARA ERSDA   ERSDA Created On
5 ERNAM MARA ERNAM   ERNAM Name of Person who Created the Object
6 LAEDA MARA LAEDA   LAEDA Date of Last Change
7 AENAM MARA AENAM   AENAM Name of Person Who Changed Object
8 VPSTA MARA VPSTA   VPSTA Maintenance status of complete material
9 PSTAT MARA PSTAT   PSTAT_D Maintenance status
10 LVORM MARA LVORM   LVOMA Flag Material for Deletion at Client Level
11 MTART MARA MTART   MTART Material type
12 MBRSH MARA MBRSH   MBRSH Industry sector
13 MATKL MARA MATKL   MATKL Material Group
14 BISMT MARA BISMT   BISMT Old material number
15 MEINS MARA MEINS   MEINS Base Unit of Measure
16 LABOR MARA LABOR   LABOR Laboratory/design office
17 BRGEW MARA BRGEW   BRGEW Gross weight
18 NTGEW MARA NTGEW   NTGEW Net weight
19 GEWEI MARA GEWEI   GEWEI Weight Unit
20 VOLUM MARA VOLUM   VOLUM Volume
21 VOLEH MARA VOLEH   VOLEH Volume unit
22 SPART MARA SPART   SPART Division
23 KUNNR MARA KUNNR   WETTB Competitor
24 EAN11 MARA EAN11   EAN11 International Article Number (EAN/UPC)
25 NUMTP MARA NUMTP   NUMTP Category of International Article Number (EAN)
26 PRDHA MARA PRDHA   PRODH_D Product Hierarchy
27 KZKFG MARA KZKFG   KZKFG Configurable Material
28 BEGRU MARA BEGRU   BEGRU Authorization Group
29 KOSCH MARA KOSCH   KOSCH Product allocation determination procedure
30 MAKTX MAKT MAKTX   MAKTX Material description
31 MAKTG MAKT MAKTG   MAKTG Material description in upper case for matchcodes
                 
Maintenance Status
Access
  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