MMPUR_EXT_EKET

Transparent Table Application Table
63 Fields 1 CDS Views

Scheduling Agreement Schedule Lines

MMPUR_EXT_EKET is an SAP database table in S/4HANA. Scheduling Agreement Schedule Lines. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurOrderScheduleLine view from BASIC Central Purchase Order Schedule Line

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY etenr ETENR Schedule Line
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
eindt EINDT Delivery Date
slfdt SLFDT Stat. Del. Date
lpein LPEIN Delivery Date
menge ETMEN Scheduled Qty
ameng VOMNG Previous Qty
wemng WEEMG Delivered
wamng WAMNG Issued
uzeit LZEIT Time
banfn BANFN Purchase Req.
bnfpo BNFPO Requisn. item
estkz ESTKZ Creation ind.
qunum QUNUM Quota arr.
qupos QUPOS Quota arr. item
mahnz MAHNZE No. Rem./Exp.
bedat ETBDT PurchOrderDate
rsnum RSNUM Reservation
sernr SERNR BOM expl.number
fixkz ETFIX Fixing Ind.
glmng GLMNG Qty Delivered
dabmg DABMG Qty Reduced
charg CHARG_D Batch
licha LICHN Supplier Batch
chkom CHKOM Components Chg.
verid VERID Prod. Version
abart MEABART Release type
mng02 MNG06 Committed Qty
dat01 DAT05 Committed date
altdt ALTDT Prev.deliv.date
aulwe AULWE Route Schedule
mbdat MBDAT Mat.Avail.Date
mbuhr MBUHR Matl Staging Tme
lddat LDDAT Loading Date
lduhr LDUHR Loading Time
tddat TDDAT_D TranspPlngDate
tduhr TDUHR Tr. Plan. Time
wadat WADAT Goods Issue
wauhr WAUHR GI Time
eldat ELDAT GR End Date
eluhr ELUHR GR End Time
anzsn ANZSN No.serial no.
nodisp NODISP Res./Purc. req.
geo_route /SPE/DE_ROUTE_ID Georoute
route_gts /SPE/DE_ROUTE_GTS_CODE GTSRouteCode
gts_ind /SPE/DE_LEG_GTS_CODE Gds Traffic Ty
tsp SPDNR Fwd Agent
cd_locno APOLOCNO APO location
cd_loctype APOLOCTYPE APO locatn type
handoverdate HANDOVER_DATE Handover Date
handovertime HANDOVER_TIME Handover Time
wesbb WESBB Val. GR BlStock OUn
startdate MMPUR_SERVPROC_PERIOD_START Start Date
enddate MMPUR_SERVPROC_PERIOD_END End Date
_dataaging DATA_TEMPERATURE Data Aging
tms_ref_uuid TMS_REF_UUID GUID of SAP TM
openpurchaseorderquantity OPENPURCHASEORDERQUANTITY Open Purchase Order Quantity
purchaseorderquantityunit BSTME Order Unit
schedulelineopenquantity SCHEDULELINEOPENQUANTITY SchLineOpenQuan
currency WAERS Currency

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.

-- Scheduling Agreement Schedule Lines
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EKET (
    MANDT,                      -- Client [MANDT]
    EBELN,                      -- Purchasing Doc. [EBELN]
    EBELP,                      -- Item [EBELP]
    ETENR,                      -- Schedule Line [ETENR]
    EXTSOURCESYSTEM,            -- Connected System ID [MMPUR_D_SOURCE_SYS]
    EINDT,                      -- Delivery Date [EINDT]
    SLFDT,                      -- Stat. Del. Date [SLFDT]
    LPEIN,                      -- Delivery Date [LPEIN]
    MENGE,                      -- Scheduled Qty [ETMEN]
    AMENG,                      -- Previous Qty [VOMNG]
    WEMNG,                      -- Delivered [WEEMG]
    WAMNG,                      -- Issued [WAMNG]
    UZEIT,                      -- Time [LZEIT]
    BANFN,                      -- Purchase Req. [BANFN]
    BNFPO,                      -- Requisn. item [BNFPO]
    ESTKZ,                      -- Creation ind. [ESTKZ]
    QUNUM,                      -- Quota arr. [QUNUM]
    QUPOS,                      -- Quota arr. item [QUPOS]
    MAHNZ,                      -- No. Rem./Exp. [MAHNZE]
    BEDAT,                      -- PurchOrderDate [ETBDT]
    RSNUM,                      -- Reservation [RSNUM]
    SERNR,                      -- BOM expl.number [SERNR]
    FIXKZ,                      -- Fixing Ind. [ETFIX]
    GLMNG,                      -- Qty Delivered [GLMNG]
    DABMG,                      -- Qty Reduced [DABMG]
    CHARG,                      -- Batch [CHARG_D]
    LICHA,                      -- Supplier Batch [LICHN]
    CHKOM,                      -- Components Chg. [CHKOM]
    VERID,                      -- Prod. Version [VERID]
    ABART,                      -- Release type [MEABART]
    MNG02,                      -- Committed Qty [MNG06]
    DAT01,                      -- Committed date [DAT05]
    ALTDT,                      -- Prev.deliv.date [ALTDT]
    AULWE,                      -- Route Schedule [AULWE]
    MBDAT,                      -- Mat.Avail.Date [MBDAT]
    MBUHR,                      -- Matl Staging Tme [MBUHR]
    LDDAT,                      -- Loading Date [LDDAT]
    LDUHR,                      -- Loading Time [LDUHR]
    TDDAT,                      -- TranspPlngDate [TDDAT_D]
    TDUHR,                      -- Tr. Plan. Time [TDUHR]
    WADAT,                      -- Goods Issue [WADAT]
    WAUHR,                      -- GI Time [WAUHR]
    ELDAT,                      -- GR End Date [ELDAT]
    ELUHR,                      -- GR End Time [ELUHR]
    ANZSN,                      -- No.serial no. [ANZSN]
    NODISP,                     -- Res./Purc. req. [NODISP]
    GEO_ROUTE,                  -- Georoute [/SPE/DE_ROUTE_ID]
    ROUTE_GTS,                  -- GTSRouteCode [/SPE/DE_ROUTE_GTS_CODE]
    GTS_IND,                    -- Gds Traffic Ty [/SPE/DE_LEG_GTS_CODE]
    TSP,                        -- Fwd Agent [SPDNR]
    CD_LOCNO,                   -- APO location [APOLOCNO]
    CD_LOCTYPE,                 -- APO locatn type [APOLOCTYPE]
    HANDOVERDATE,               -- Handover Date [HANDOVER_DATE]
    HANDOVERTIME,               -- Handover Time [HANDOVER_TIME]
    WESBB,                      -- Val. GR BlStock OUn [WESBB]
    STARTDATE,                  -- Start Date [MMPUR_SERVPROC_PERIOD_START]
    ENDDATE,                    -- End Date [MMPUR_SERVPROC_PERIOD_END]
    _DATAAGING,                 -- Data Aging [DATA_TEMPERATURE]
    TMS_REF_UUID,               -- GUID of SAP TM [TMS_REF_UUID]
    OPENPURCHASEORDERQUANTITY,  -- Open Purchase Order Quantity [OPENPURCHASEORDERQUANTITY]
    PURCHASEORDERQUANTITYUNIT,  -- Order Unit [BSTME]
    SCHEDULELINEOPENQUANTITY,   -- SchLineOpenQuan [SCHEDULELINEOPENQUANTITY]
    CURRENCY,                   -- Currency [WAERS]
    PRIMARY KEY (MANDT, EBELN, EBELP, ETENR, EXTSOURCESYSTEM)
);

Learn More