EKEK
Header Data for Scheduling Agreement Releases
EKEK is an SAP database table in S/4HANA. Header Data for Scheduling Agreement Releases. It contains 39 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_Purgscheagrmtreldoc | view | from | BASIC | Scheduling Agreement Release Document |
Fields (39)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ebeln | EBELN | Purchasing Doc. | |||
| KEY | ebelp | EBELP | Item | |||
| KEY | abart | MEABART | Release type | |||
| KEY | abruf | MEABRUF | Release No. | |||
| abefz | MEAWEFZ | Cum. Recd Qty | ||||
| abrdt | MEABRDT | Release Date | ||||
| lfdkd | MELFDKD | Date/Last Del. | ||||
| lfnkd | MELFNKD1 | Last Deliv. | ||||
| lwedt | MELWEDT | Date of Last GR | ||||
| lwemg | MELWEMG | Last GR Qty | ||||
| ablli | MEABLLI | Ex. release no. | ||||
| erdat | MEERDAT | Created on | ||||
| absfz | ABFTZ | Agr. Cum. Qty | ||||
| abfde | MEABFDE | PGA End | ||||
| abmde | MEABMDE | End of Mat. GAP | ||||
| eruhr | MEERUHR | Time | ||||
| abrzt | MEABRZT | Time of release | ||||
| abhzt | ABHZT | Release Horizon | ||||
| ruskz | RUSKZ | Backlog and/or IR | ||||
| staab | STAAB | Status of release | ||||
| webrl | WEBRL | Internet rel. | ||||
| loadingpoint | /SCMTMS/LOADING_POINT_ID | Load./Unload. Pt | ||||
| vencf | VENCF | Supplier Ack. | ||||
| cpudt | MEERDAT | Created on | ||||
| cputm | MEERUHR | Time | ||||
| stpin | STPIN | Stop Indicator | ||||
| brsvz | BRSVZ | Backlog/Imm. Req. Br. Forward | ||||
| ersgr | ERSGR | Reason | ||||
| lgbzo | UNLPT | (Auto) UnloadPt | ||||
| inidt | INIDT | 1st Creation Date | ||||
| initm | INITM | 1st. Creation Time | ||||
| wefzmit | WEFZMIT | 2nd CRQ | ||||
| dispo | DISPO | MRP Controller | ||||
| loadcarr | PL_LOADCARR | Load carrier | ||||
| t_trgqty | PL_T_TRGQTY | Target quantity | ||||
| baseunit | MEINS | Base Unit | ||||
| lctxt | PL_CONTENT_LC | Short text | ||||
| akstopgr | AKSTOPGR | Stop Reasons |
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.
-- Header Data for Scheduling Agreement Releases
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKEK (
MANDT, -- Client [MANDT]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
ABART, -- Release type [MEABART]
ABRUF, -- Release No. [MEABRUF]
ABEFZ, -- Cum. Recd Qty [MEAWEFZ]
ABRDT, -- Release Date [MEABRDT]
LFDKD, -- Date/Last Del. [MELFDKD]
LFNKD, -- Last Deliv. [MELFNKD1]
LWEDT, -- Date of Last GR [MELWEDT]
LWEMG, -- Last GR Qty [MELWEMG]
ABLLI, -- Ex. release no. [MEABLLI]
ERDAT, -- Created on [MEERDAT]
ABSFZ, -- Agr. Cum. Qty [ABFTZ]
ABFDE, -- PGA End [MEABFDE]
ABMDE, -- End of Mat. GAP [MEABMDE]
ERUHR, -- Time [MEERUHR]
ABRZT, -- Time of release [MEABRZT]
ABHZT, -- Release Horizon [ABHZT]
RUSKZ, -- Backlog and/or IR [RUSKZ]
STAAB, -- Status of release [STAAB]
WEBRL, -- Internet rel. [WEBRL]
LOADINGPOINT, -- Load./Unload. Pt [/SCMTMS/LOADING_POINT_ID]
VENCF, -- Supplier Ack. [VENCF]
CPUDT, -- Created on [MEERDAT]
CPUTM, -- Time [MEERUHR]
STPIN, -- Stop Indicator [STPIN]
BRSVZ, -- Backlog/Imm. Req. Br. Forward [BRSVZ]
ERSGR, -- Reason [ERSGR]
LGBZO, -- (Auto) UnloadPt [UNLPT]
INIDT, -- 1st Creation Date [INIDT]
INITM, -- 1st. Creation Time [INITM]
WEFZMIT, -- 2nd CRQ [WEFZMIT]
DISPO, -- MRP Controller [DISPO]
LOADCARR, -- Load carrier [PL_LOADCARR]
T_TRGQTY, -- Target quantity [PL_T_TRGQTY]
BASEUNIT, -- Base Unit [MEINS]
LCTXT, -- Short text [PL_CONTENT_LC]
AKSTOPGR, -- Stop Reasons [AKSTOPGR]
PRIMARY KEY (MANDT, EBELN, EBELP, ABART, ABRUF)
);
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