MMPUR_HUB_CMNTS

Transparent Table Application Table

User comments for Central Purchase Requisitions in PPRC

MMPUR_HUB_CMNTS is an SAP database table in S/4HANA. User comments for Central Purchase Requisitions in PPRC. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrmtHbRpldPurReqnItmComment view_entity from BASIC Central PR item comments

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY comment_id guid GUID
KEY purchaserequisition banfn Purchase Req.
KEY purchaserequisitionitem bnfpo Requisn. item
KEY extsourcesystem mmpur_d_source_sys Connected System ID
created_on timestamp Time Stamp
changed_on timestamp Time Stamp
commented_by xubname User
system_comment comment_content Comment
user_comment comment_content Comment
target_user xubname User
isdeleted boole_d TRUE
action sstring Search String

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.

-- User comments for Central Purchase Requisitions in PPRC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_HUB_CMNTS (
    MANDT,                    -- Client [mandt]
    COMMENT_ID,               -- GUID [guid]
    PURCHASEREQUISITION,      -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,  -- Requisn. item [bnfpo]
    EXTSOURCESYSTEM,          -- Connected System ID [mmpur_d_source_sys]
    CREATED_ON,               -- Time Stamp [timestamp]
    CHANGED_ON,               -- Time Stamp [timestamp]
    COMMENTED_BY,             -- User [xubname]
    SYSTEM_COMMENT,           -- Comment [comment_content]
    USER_COMMENT,             -- Comment [comment_content]
    TARGET_USER,              -- User [xubname]
    ISDELETED,                -- TRUE [boole_d]
    ACTION,                   -- Search String [sstring]
    PRIMARY KEY (MANDT, COMMENT_ID, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, EXTSOURCESYSTEM)
);