SAP ABAP View ENT5045 (Purchase contract item - consignment)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CA (Application Component) Cross-Application Components
⤷ UUDM (Package) EDM: Data Modeler (General)
⤷ CA (Application Component) Cross-Application Components
⤷ UUDM (Package) EDM: Data Modeler (General)
Basic Data
View Type | D | Database View |
Database View | ENT5045 | |
Short Description | Purchase contract item - consignment | |
Root table | EKPO | Purchasing Document Item |
Entity Type | DM02L |
Short text | Purchase contract item - consignment |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | EKPO | EKPO | ||
2 | EKKO |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | EKKO | MANDT | JL | EQ | 0 | 0 | ||||
2 | EKPO | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | EKKO | EBELN | JL | EQ | 0 | 0 | ||||
4 | EKPO | EBELN | JR | EQ | AND | 0 | 0 | |||
5 | EKKO | BSTYP | EQ | 'K' | 1 | AND | 0 | 0 | ||
6 | EKPO | PSTYP | EQ | '2' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | EKPO | MANDT | 1 | MANDT | Client | ||
2 | EBELN | EKPO | EBELN | 1 | EBELN | Purchasing Document Number | ||
3 | EBELP | EKPO | EBELP | 1 | EBELP | Item Number of Purchasing Document | ||
4 | BEDAT | EKKO | BEDAT | 1 | EBDAT | Purchasing Document Date | ||
5 | MATNR | EKPO | MATNR | 1 | MATNR | Material Number | ||
6 | EKORG | EKKO | EKORG | 1 | EKORG | Purchasing organization | ||
7 | EMATN | EKPO | EMATN | 1 | EMATNR | Material number | ||
8 | WERKS | EKPO | WERKS | 1 | EWERK | Plant | ||
9 | BUKRS | EKPO | BUKRS | 1 | BUKRS | Company Code | ||
10 | LGORT | EKPO | LGORT | 1 | LGORT_D | Storage location | ||
11 | BEDNR | EKPO | BEDNR | 1 | BEDNR | Requirement Tracking Number | ||
12 | MATKL | EKPO | MATKL | 1 | MATKL | Material Group | ||
13 | IDNLF | EKPO | IDNLF | 1 | IDNLF | Material Number Used by Vendor | ||
14 | MEINS | EKPO | MEINS | 1 | BSTME | Order unit | ||
15 | WEBAZ | EKPO | WEBAZ | 1 | WEBAZ | Goods receipt processing time in days | ||
16 | MAHN1 | EKPO | MAHN1 | 1 | MAHN1 | Number of Days for First Reminder/Expediter | ||
17 | MAHN2 | EKPO | MAHN2 | 1 | MAHN2 | Number of Days for Second Reminder/Expediter | ||
18 | MAHN3 | EKPO | MAHN3 | 1 | MAHN3 | Number of Days for Third Reminder/Expediter | ||
19 | KTMNG | EKPO | KTMNG | 1 | KTMNG | Target Quantity | ||
20 | ABMNG | EKPO | ABMNG | 1 | NORAM | Standard release order quantity | ||
21 | UEBTO | EKPO | UEBTO | 1 | UEBTO | Overdelivery Tolerance Limit | ||
22 | UEBTK | EKPO | UEBTK | 1 | UEBTK | Indicator: Unlimited Overdelivery Allowed | ||
23 | UNTTO | EKPO | UNTTO | 1 | UNTTO | Underdelivery Tolerance Limit | ||
24 | LABNR | EKPO | LABNR | 1 | LABNR | Order Acknowledgment Number | ||
25 | LMEIN | EKPO | LMEIN | 1 | LAGME | Base Unit of Measure | ||
26 | KZABS | EKPO | KZABS | 1 | KZABS | Order Acknowledgment Requirement | ||
27 | EVERS | EKPO | EVERS | 1 | EVERS | Shipping Instructions | ||
28 | INSMK | EKPO | INSMK | 1 | INSMK | Stock Type | ||
29 | LOEKZ | EKPO | LOEKZ | 1 | ELOEK | Deletion indicator in purchasing document | ||
30 | UMREZ | EKPO | UMREZ | 1 | UMBSZ | Numerator for Conversion of Order Unit to Base Unit | ||
31 | UMREN | EKPO | UMREN | 1 | UMBSN | Denominator for Conversion of Order Unit to Base Unit | ||
32 | MAHNZ | EKPO | MAHNZ | 1 | MAHNZ | Number of Reminders/Expediters | ||
33 | NOTKZ | EKPO | NOTKZ | 1 | NOTKZ | Exclusion in Outline Agreement Item with Material Class | ||
34 | AEDAT | EKPO | AEDAT | 1 | PAEDT | Purchasing Document Item Change Date | ||
35 | TXZ01 | EKPO | TXZ01 | 1 | TXZ01 | Short Text | ||
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 |