SAP ABAP View MDBS (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
⤷ MD (Package) Application development R/3 requirements planning
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MD (Package) Application development R/3 requirements planning
Basic Data
View Type | D | Database View |
Database View | MDBS | |
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 | EKET |
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 | EKET | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | EKPO | EBELN | JL | EQ | 0 | 0 | ||||
4 | EKET | EBELN | JR | EQ | AND | 0 | 0 | |||
5 | EKPO | EBELP | JL | EQ | 0 | 0 | ||||
6 | EKET | 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 | ETENR | EKET | ETENR | EETEN | Delivery Schedule Line Counter | |||
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 | ETFZ1 | EKPO | ETFZ1 | ETFZ1 | Firm Zone (Go-Ahead for Production) | |||
20 | ETFZ2 | EKPO | ETFZ2 | ETFZ2 | Trade-Off Zone (Go-Ahead for Materials Procurement) | |||
21 | BSTAE | EKPO | BSTAE | BSTAE | Confirmation Control Key | |||
22 | ARSNR | EKPO | ARSNR | ARSNR | Settlement reservation number | |||
23 | ARSPS | EKPO | ARSPS | ARSPS | Item number of the settlement reservation | |||
24 | ETDRK | EKPO | ETDRK | ETDRK | Indicator: Print-relevant schedule lines exist | |||
25 | EINDT | EKET | EINDT | EINDT | Item delivery date | |||
26 | MENGE | EKET | MENGE | ETMEN | Scheduled Quantity | |||
27 | WEMNG | EKET | WEMNG | WEEMG | Quantity of goods received | |||
28 | DABMG | EKET | DABMG | DABMG | Quantity Reduced (MRP) | |||
29 | WAMNG | EKET | WAMNG | WAMNG | Issued quantity | |||
30 | GLMNG | EKET | GLMNG | GLMNG | Quantity Delivered (Stock Transfer) | |||
31 | QUNUM | EKET | QUNUM | QUNUM | Number of quota arrangement | |||
32 | QUPOS | EKET | QUPOS | QUPOS | Quota arrangement item | |||
33 | RSNUM | EKET | RSNUM | RSNUM | Number of reservation/dependent requirements | |||
34 | ESTKZ | EKET | ESTKZ | ESTKZ | Creation indicator (purchase requisition/schedule lines) | |||
35 | BEDAT | EKET | BEDAT | ETBDT | Order date of schedule line | |||
36 | FIXKZ | EKET | FIXKZ | ETFIX | Schedule Line is "Fixed" | |||
37 | SERNR | EKET | SERNR | SERNR | BOM explosion number | |||
38 | AMENG | EKET | AMENG | VOMNG | Previous Quantity (Delivery Schedule Lines) | |||
39 | REVLV | EKPO | REVLV | REVLV | Revision level | |||
40 | BWTAR | EKPO | BWTAR | BWTAR_D | Valuation type | |||
41 | WEPOS | EKPO | WEPOS | WEPOS | Goods Receipt Indicator | |||
42 | CHARG | EKET | CHARG | CHARG_D | Batch Number | |||
43 | AKTNR | EKPO | AKTNR | WAKTION | Promotion | |||
44 | RETPO | EKPO | RETPO | RETPO | Returns Item | |||
45 | STATU | EKPO | STATU | ASTAT | RFQ status | |||
46 | EMLIF | EKPO | EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
47 | LBLKZ | EKPO | LBLKZ | LBLKZ | Subcontracting vendor | |||
48 | EREKZ | EKPO | EREKZ | EREKZ | Final Invoice Indicator | |||
49 | KZBWS | EKPO | KZBWS | KZBWS | Valuation of Special Stock | |||
50 | EGLKZ | EKPO | EGLKZ | EGLKZ | "Outward Delivery Completed" Indicator | |||
51 | KZFIX | EKPO | KZSTU | MRPRE | Firm/Trade-Off Zones Binding with Regard to Mat. Planning | |||
52 | INSMK | EKPO | INSMK | INSMK | Stock Type | |||
53 | STAPO | EKPO | STAPO | STAPO | Item is statistical | |||
54 | BERID | EKPO | BERID | BERID | MRP Area | |||
55 | VERID | EKET | VERID | VERID | Production Version | |||
56 | RESLO | EKPO | RESLO | RESLO | Issuing Storage Location for Stock Transport Order | |||
57 | UPTYP | EKPO | UPTYP | UPTYP | Subitem Category, Purchasing Document | |||
58 | PRIO_URG | EKPO | PRIO_URG | PRIO_URG | Requirement Urgency | |||
59 | PRIO_REQ | EKPO | PRIO_REQ | PRIO_REQ | Requirement Priority | |||
60 | FLS_RSTO | EKPO | FLS_RSTO | FLS_RSTO | Store Return with Inbound and Outbound Delivery | |||
61 | NODISP | EKET | NODISP | NODISP | Ind: Reserv. not applicable to MRP;Purc. req. not created | |||
62 | BANFN | EKET | BANFN | BANFN | Purchase requisition number | |||
63 | BNFPO | EKET | BNFPO | BNFPO | Item number of purchase requisition | |||
64 | ITCONS | EKPO | ITCONS | ME_IR_CO_ORDER | Real-Time Consumption Posting of Subcontracting Components | |||
65 | FIXMG | EKPO | FIXMG | ME_FIXMG | Delivery Date and Quantity Fixed | |||
66 | MNG02 | EKET | MNG02 | MNG06 | Committed quantity | |||
67 | UZEIT | EKET | UZEIT | LZEIT | Delivery Date Time-Spot | |||
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 |