MMPUR_PR_FOR_CNF

Transparent Table Application Table
22 Fields 1 CDS Views

Purchase Requisition Open for confirmation

MMPUR_PR_FOR_CNF is an SAP database table in S/4HANA. Purchase Requisition Open for confirmation. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcmtHubPurReqnOpenForConf view from BASIC External SSP requisitions open for conf

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY procmthubpurchaserequisition BANFN Purchase Req.
KEY procmthubpurrequisitionitem BNFPO Requisn. item
KEY procmthubreferencepurorder EBELN Purchasing Doc.
KEY procmthubreferencepurorderitm EBELP Item
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
extplantforpurg MM_PUR_HUB_WERKS Plant
procmthubrefpurorditemmaterial MATNR Material
procmthubrefpurorderopenqty BSTMG PO Quantity
procmthubrefpurorditemuom LAGME Base Unit
procmthubrefpurorditmisdeleted ELOEK Del. Indicator
prmthbrefpurorditmisnotgrrlvt WEPOS Goods Receipt
prmthbrefpurorditmisdelivcmplt ELIKZ Deliv. Compl.
prmthbrefpurchaseorderstatus EPSTATU Item status
procmthubcreatedbyuser ERNAM Created By
procmthubcreationdate ERDAT Created On
procmthubpurchasinggroup EKGRP Purch. Group
purreqnrequestor MMPUR_REQ_D_REQUESTOR Requestor
sspauthorexternalbpidnnumber MMPUR_REQ_D_AUTHOR Author
procmthubrefpurordsupplier LIFNR Supplier
extcompanycodeforpurg MM_PUR_HUB_BUKRS Company Code
lastchangedatetime TIMESTAMPL Time Stamp

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.

-- Purchase Requisition Open for confirmation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_PR_FOR_CNF (
    MANDT,                           -- Client [MANDT]
    PROCMTHUBPURCHASEREQUISITION,    -- Purchase Req. [BANFN]
    PROCMTHUBPURREQUISITIONITEM,     -- Requisn. item [BNFPO]
    PROCMTHUBREFERENCEPURORDER,      -- Purchasing Doc. [EBELN]
    PROCMTHUBREFERENCEPURORDERITM,   -- Item [EBELP]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    EXTPLANTFORPURG,                 -- Plant [MM_PUR_HUB_WERKS]
    PROCMTHUBREFPURORDITEMMATERIAL,  -- Material [MATNR]
    PROCMTHUBREFPURORDEROPENQTY,     -- PO Quantity [BSTMG]
    PROCMTHUBREFPURORDITEMUOM,       -- Base Unit [LAGME]
    PROCMTHUBREFPURORDITMISDELETED,  -- Del. Indicator [ELOEK]
    PRMTHBREFPURORDITMISNOTGRRLVT,   -- Goods Receipt [WEPOS]
    PRMTHBREFPURORDITMISDELIVCMPLT,  -- Deliv. Compl. [ELIKZ]
    PRMTHBREFPURCHASEORDERSTATUS,    -- Item status [EPSTATU]
    PROCMTHUBCREATEDBYUSER,          -- Created By [ERNAM]
    PROCMTHUBCREATIONDATE,           -- Created On [ERDAT]
    PROCMTHUBPURCHASINGGROUP,        -- Purch. Group [EKGRP]
    PURREQNREQUESTOR,                -- Requestor [MMPUR_REQ_D_REQUESTOR]
    SSPAUTHOREXTERNALBPIDNNUMBER,    -- Author [MMPUR_REQ_D_AUTHOR]
    PROCMTHUBREFPURORDSUPPLIER,      -- Supplier [LIFNR]
    EXTCOMPANYCODEFORPURG,           -- Company Code [MM_PUR_HUB_BUKRS]
    LASTCHANGEDATETIME,              -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, PROCMTHUBPURCHASEREQUISITION, PROCMTHUBPURREQUISITIONITEM, PROCMTHUBREFERENCEPURORDER, PROCMTHUBREFERENCEPURORDERITM)
);

Learn More