SAP ABAP View /SAPPSPRO/M_MEKH (Generated View for Matchcode ID MEKK -H)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   MM (Application Component) Materials Management
     /SAPPSPRO/PUR_BASIS (Package) tables, structures, general infrastructure
Basic Data
View Type D Database View 
Database View /SAPPSPRO/M_MEKH  
Short Description Generated View for Matchcode ID MEKK -H    
Root table EKPO   Purchasing Document Item 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 EKPO EKPO
2 EKKO  
3 /SAPPSPRO/EADD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 EKKO MANDT JL EQ 0 1 BSTYP
2 EKPO MANDT JR EQ AND 0 1 BSTYP
3 EKKO EBELN JL EQ 0 1 BSTYP
4 EKPO EBELN JR EQ AND 0 1 BSTYP
5 EKKO MANDT JL EQ 0 1 BSTYP
6 /SAPPSPRO/EADD MANDT JR EQ AND 0 1 BSTYP
7 EKKO EBELN JL EQ 0 1 BSTYP
8 /SAPPSPRO/EADD EBELN JR EQ AND 0 1 BSTYP
9 EKPO PACKNO GT '0000000000' AND 0 10 PACKNO
10 EKKO BSTYP EQ 'F' AND 0 1 BSTYP
11 EKPO PSTYP EQ '9' 0 1 BSTYP
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT EKPO MANDT   MANDT Client
2 WERKS EKPO WERKS   EWERK Plant
3 MATKL EKPO MATKL   MATKL Material Group
4 EKORG EKKO EKORG   EKORG Purchasing organization
5 LONGNUM_UC /SAPPSPRO/EADD LONGNUM_UC   /SAPPSPRO/LONGNUM_UC Smart Document Number
6 LONGNUM /SAPPSPRO/EADD LONGNUM   /SAPPSPRO/LONGNUM Smart Number
7 EBELN EKKO EBELN   EBELN Purchasing Document Number
8 TXZ01 EKPO TXZ01   TXZ01 Short Text
                 
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 10A