M_MECCP_K

20 Fields 1 CDS Views

Generated Table for View

M_MECCP_K is an SAP database table in S/4HANA. Generated Table for View. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_M_MECCP_K view from

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY banfn BANFN Purchase Req.
KEY bnfpo BNFPO Requisn. item
KEY zebkn DZEBKN Ser.no.acc.ass.
KEY kostl KOSTL Cost Center
KEY anln1 ANLN1 Asset
KEY anln2 ANLN2 Sub-number
KEY aufnr AUFNR Order
KEY ps_psp_pnr PS_PSP_PNR WBS Element
KEY nplnr NPLNR Network
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY etenr EETEN Schedule Line
iseopblocked EOPBLOCKED Busin. Purp. Cmpltd.
ekgrp BKGRP Purch. Group
bsart ESART Document Type
statu ESTAK Status
werks EWERK Plant
ekorg EKORG Purchasing Org.
bstyp EBSTYP Doc. Category

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE M_MECCP_K (
    MANDT,         -- Client [MANDT]
    BANFN,         -- Purchase Req. [BANFN]
    BNFPO,         -- Requisn. item [BNFPO]
    ZEBKN,         -- Ser.no.acc.ass. [DZEBKN]
    KOSTL,         -- Cost Center [KOSTL]
    ANLN1,         -- Asset [ANLN1]
    ANLN2,         -- Sub-number [ANLN2]
    AUFNR,         -- Order [AUFNR]
    PS_PSP_PNR,    -- WBS Element [PS_PSP_PNR]
    NPLNR,         -- Network [NPLNR]
    EBELN,         -- Purchasing Doc. [EBELN]
    EBELP,         -- Item [EBELP]
    ETENR,         -- Schedule Line [EETEN]
    ISEOPBLOCKED,  -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    EKGRP,         -- Purch. Group [BKGRP]
    BSART,         -- Document Type [ESART]
    STATU,         -- Status [ESTAK]
    WERKS,         -- Plant [EWERK]
    EKORG,         -- Purchasing Org. [EKORG]
    BSTYP,         -- Doc. Category [EBSTYP]
    PRIMARY KEY (MANDT, BANFN, BNFPO, ZEBKN, KOSTL, ANLN1, ANLN2, AUFNR, PS_PSP_PNR, NPLNR, EBELN, EBELP, ETENR)
);

Learn More