MMPUR_EXT_EKES
Supplier Confirmations
MMPUR_EXT_EKES is an SAP database table in S/4HANA. Supplier Confirmations. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PrmtHbRpldPOSuplrConf | view | from | BASIC | Supplier Confirmation for Rpld PO |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ebeln | EBELN | Purchasing Doc. | |||
| KEY | ebelp | EBELP | Item | |||
| KEY | extsourcesystem | MMPUR_D_SOURCE_SYS | Connected System ID | |||
| KEY | etens | ETENS | Sequential No. | |||
| ebtyp | EBTYP | Confirm. Cat. | ||||
| eindt | BBEIN | Delivery Date | ||||
| lpein | BBLPE | Delivery Date | ||||
| uzeit | BBUZE | Time | ||||
| erdat | BBERD | Created on | ||||
| ezeit | BBEZE | Creation Time | ||||
| menge | BBMNG | Quantity | ||||
| dabmg | DABMG | Qty Reduced | ||||
| estkz | BBEST | Creation Ind. | ||||
| loekz | BBLOE | Deletion Ind. | ||||
| kzdis | KZDIS | MRP-Relevant | ||||
| xblnr | XBLNR_LONG | Reference | ||||
| vbeln | VBELN_VL | Delivery | ||||
| vbelp | POSNR_VL | Item | ||||
| mprof | MPROF | Mfr Part Profile | ||||
| ematn | EMATN | MPN: Material | ||||
| mahnz | MAHNZ | No. Rem./Exp. | ||||
| charg | CHARG_D | Batch | ||||
| uecha | UECHA | HghLevItmBatch |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Supplier Confirmations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EKES (
MANDT, -- Client [MANDT]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
EXTSOURCESYSTEM, -- Connected System ID [MMPUR_D_SOURCE_SYS]
ETENS, -- Sequential No. [ETENS]
EBTYP, -- Confirm. Cat. [EBTYP]
EINDT, -- Delivery Date [BBEIN]
LPEIN, -- Delivery Date [BBLPE]
UZEIT, -- Time [BBUZE]
ERDAT, -- Created on [BBERD]
EZEIT, -- Creation Time [BBEZE]
MENGE, -- Quantity [BBMNG]
DABMG, -- Qty Reduced [DABMG]
ESTKZ, -- Creation Ind. [BBEST]
LOEKZ, -- Deletion Ind. [BBLOE]
KZDIS, -- MRP-Relevant [KZDIS]
XBLNR, -- Reference [XBLNR_LONG]
VBELN, -- Delivery [VBELN_VL]
VBELP, -- Item [POSNR_VL]
MPROF, -- Mfr Part Profile [MPROF]
EMATN, -- MPN: Material [EMATN]
MAHNZ, -- No. Rem./Exp. [MAHNZ]
CHARG, -- Batch [CHARG_D]
UECHA, -- HghLevItmBatch [UECHA]
PRIMARY KEY (MANDT, EBELN, EBELP, EXTSOURCESYSTEM, ETENS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA