MMPUR_PR_D_POHD

Transparent Table Application Table
25 Fields 1 CDS Views

Header Draft Database Table for Purchase Order

MMPUR_PR_D_POHD is an SAP database table in S/4HANA. Header Draft Database Table for Purchase Order. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurOrderDraftForMngPurReqn view from BASIC Purchase Order Draft For Purchase Requisition

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
ebeln EBELN Purchasing Doc.
lifnr LLIEF Goods Supplier
bsart ESART Document Type
bukrs BUKRS Company Code
ekorg EKORG Purchasing Org.
ekgrp BKGRP Purch. Group
elifn ELIFN Supplier
waers WAERS Currency
zterm DZTERM Pyt Terms
wkurs WKURS Exchange Rate
inco1 INCO1 Incoterms
inco2 INCO2 Incoterms 2
net_price BAPICUREXT Currency amount
purchasingorgname EKOTX Description
purchasinggrpname EKNAM Description
supplyingvendorname NAME1_GP Name
ernam ERNAM Created By
aedat ERDAT Created On
draft_id /BOBF/CONF_KEY NodeID
dummy_ekko_incl_eew_ps EKKO_INCL_EEW Ext. Include
startdate MMPUR_SERVPROC_PERIOD_START Start Date
enddate MMPUR_SERVPROC_PERIOD_END End Date

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 Draft Database Table for Purchase Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_PR_D_POHD (
    MANDT,                   -- Client [MANDT]
    DB_KEY,                  -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,              -- NodeID [/BOBF/CONF_KEY]
    EBELN,                   -- Purchasing Doc. [EBELN]
    LIFNR,                   -- Goods Supplier [LLIEF]
    BSART,                   -- Document Type [ESART]
    BUKRS,                   -- Company Code [BUKRS]
    EKORG,                   -- Purchasing Org. [EKORG]
    EKGRP,                   -- Purch. Group [BKGRP]
    ELIFN,                   -- Supplier [ELIFN]
    WAERS,                   -- Currency [WAERS]
    ZTERM,                   -- Pyt Terms [DZTERM]
    WKURS,                   -- Exchange Rate [WKURS]
    INCO1,                   -- Incoterms [INCO1]
    INCO2,                   -- Incoterms 2 [INCO2]
    NET_PRICE,               -- Currency amount [BAPICUREXT]
    PURCHASINGORGNAME,       -- Description [EKOTX]
    PURCHASINGGRPNAME,       -- Description [EKNAM]
    SUPPLYINGVENDORNAME,     -- Name [NAME1_GP]
    ERNAM,                   -- Created By [ERNAM]
    AEDAT,                   -- Created On [ERDAT]
    DRAFT_ID,                -- NodeID [/BOBF/CONF_KEY]
    DUMMY_EKKO_INCL_EEW_PS,  -- Ext. Include [EKKO_INCL_EEW]
    STARTDATE,               -- Start Date [MMPUR_SERVPROC_PERIOD_START]
    ENDDATE,                 -- End Date [MMPUR_SERVPROC_PERIOD_END]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More