MMPUR_AUTO_STAT

Transparent Table Application Table

Purchasing Document Automation Status

MMPUR_AUTO_STAT is an SAP database table in S/4HANA. Purchasing Document Automation Status. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurgDocAutomationStatus view from BASIC Purchasing Document Automation Status

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY purchasingdocumentuniqueid PURGDOCNODEUNIQUEID Purch. Doc. ID
KEY sapobjecttype SBO_BO_TYPE SAP Object Type
KEY sapobjectnodetype SBO_NODE_TYPE SAP Obj Node Type
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
KEY procmtautomnruleid MMPUR_RULE_ID Rule ID
KEY procmtautomnactivityid MMPUR_ACTIVITY_ID Activity ID
KEY procmtautomnactionuniqueid MMPUR_ACTION_UNIQUE_ID Action Unique ID
purgdocautomationstatus MMPUR_AUTOMATION_STATUS Automation Status
creationdatetime MMPUR_TIMESTAMP Timestamp
purgdocstatusdetaillogid MMPUR_AUTO_LOGID Purch Doc Log ID

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.

-- Purchasing Document Automation Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_AUTO_STAT (
    CLIENT,                      -- Client [MANDT]
    PURCHASINGDOCUMENTUNIQUEID,  -- Purch. Doc. ID [PURGDOCNODEUNIQUEID]
    SAPOBJECTTYPE,               -- SAP Object Type [SBO_BO_TYPE]
    SAPOBJECTNODETYPE,           -- SAP Obj Node Type [SBO_NODE_TYPE]
    EXTSOURCESYSTEM,             -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PROCMTAUTOMNRULEID,          -- Rule ID [MMPUR_RULE_ID]
    PROCMTAUTOMNACTIVITYID,      -- Activity ID [MMPUR_ACTIVITY_ID]
    PROCMTAUTOMNACTIONUNIQUEID,  -- Action Unique ID [MMPUR_ACTION_UNIQUE_ID]
    PURGDOCAUTOMATIONSTATUS,     -- Automation Status [MMPUR_AUTOMATION_STATUS]
    CREATIONDATETIME,            -- Timestamp [MMPUR_TIMESTAMP]
    PURGDOCSTATUSDETAILLOGID,    -- Purch Doc Log ID [MMPUR_AUTO_LOGID]
    PRIMARY KEY (CLIENT, PURCHASINGDOCUMENTUNIQUEID, SAPOBJECTTYPE, SAPOBJECTNODETYPE, EXTSOURCESYSTEM, PROCMTAUTOMNRULEID, PROCMTAUTOMNACTIVITYID, PROCMTAUTOMNACTIONUNIQUEID)
);