SAP ABAP View MDLA (Material View of Order Item/Schedule Line)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning
Basic Data
View Type | D | Database View |
Database View | MDLA | |
Short Description | Material View of Order Item/Schedule Line | |
Root table | EKPO | Purchasing Document Item |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | EKPO | EKPO | ||
2 | EKES |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | EKPO | MANDT | JL | EQ | 0 | 0 | ||||
2 | EKES | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | EKPO | EBELN | JL | EQ | 0 | 0 | ||||
4 | EKES | EBELN | JR | EQ | AND | 0 | 0 | |||
5 | EKPO | EBELP | JL | EQ | 0 | 0 | ||||
6 | EKES | EBELP | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | EKPO | MANDT | MANDT | Client | |||
2 | EBELN | EKPO | EBELN | EBELN | Purchasing Document Number | |||
3 | EBELP | EKPO | EBELP | EBELP | Item Number of Purchasing Document | |||
4 | ETENS | EKES | ETENS | ETENS | Sequential Number of Vendor Confirmation | |||
5 | MATNR | EKPO | MATNR | MATNR | Material Number | |||
6 | WERKS | EKPO | WERKS | EWERK | Plant | |||
7 | LGORT | EKPO | LGORT | LGORT_D | Storage location | |||
8 | BSTYP | EKPO | BSTYP | BSTYP | Purchasing document category | |||
9 | LOEKZ | EKPO | LOEKZ | ELOEK | Deletion indicator in purchasing document | |||
10 | ELIKZ | EKPO | ELIKZ | ELIKZ | "Delivery Completed" Indicator | |||
11 | MEINS | EKPO | MEINS | BSTME | Order unit | |||
12 | UMREZ | EKPO | UMREZ | UMBSZ | Numerator for Conversion of Order Unit to Base Unit | |||
13 | UMREN | EKPO | UMREN | UMBSN | Denominator for Conversion of Order Unit to Base Unit | |||
14 | WEBAZ | EKPO | WEBAZ | WEBAZ | Goods receipt processing time in days | |||
15 | PSTYP | EKPO | PSTYP | PSTYP | Item category in purchasing document | |||
16 | KNTTP | EKPO | KNTTP | KNTTP | Account assignment category | |||
17 | SOBKZ | EKPO | SOBKZ | SOBKZ | Special Stock Indicator | |||
18 | KZVBR | EKPO | KZVBR | KZVBR | Consumption posting | |||
19 | EINDT | EKES | EINDT | BBEIN | Delivery Date of Vendor Confirmation | |||
20 | UZEIT | EKES | UZEIT | BBUZE | Delivery Date Time-Spot in Vendor Confirmation | |||
21 | MENGE | EKES | MENGE | BBMNG | Quantity as Per Vendor Confirmation | |||
22 | DABMG | EKES | DABMG | DABMG | Quantity Reduced (MRP) | |||
23 | ESTKZ | EKES | ESTKZ | BBEST | Creation Indicator: Vendor Confirmation | |||
24 | KZDIS | EKES | KZDIS | KZDIS | Indicator: Confirmation is Relevant to Materials Planning | |||
25 | BBLOE | EKES | LOEKZ | BBLOE | Vendor confirmation deletion indicator | |||
26 | BWTAR | EKPO | BWTAR | BWTAR_D | Valuation type | |||
27 | KZBWS | EKPO | KZBWS | KZBWS | Valuation of Special Stock | |||
28 | REVLV | EKPO | REVLV | REVLV | Revision level | |||
29 | EMLIF | EKPO | EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
30 | LBLKZ | EKPO | LBLKZ | LBLKZ | Subcontracting vendor | |||
31 | STATU | EKPO | STATU | ASTAT | RFQ status | |||
32 | BERID | EKPO | BERID | BERID | MRP Area | |||
33 | ARSNR | EKPO | ARSNR | ARSNR | Settlement reservation number | |||
34 | ARSPS | EKPO | ARSPS | ARSPS | Item number of the settlement reservation | |||
35 | INSMK | EKPO | INSMK | INSMK | Stock Type | |||
36 | RESLO | EKPO | RESLO | RESLO | Issuing Storage Location for Stock Transport Order | |||
37 | CHARG | EKES | CHARG | CHARG_D | Batch Number | |||
38 | UPTYP | EKPO | UPTYP | UPTYP | Subitem Category, Purchasing Document | |||
39 | FLS_RSTO | EKPO | FLS_RSTO | FLS_RSTO | Store Return with Inbound and Outbound Delivery | |||
40 | ITCONS | EKPO | ITCONS | ME_IR_CO_ORDER | Real-Time Consumption Posting of Subcontracting Components | |||
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 |