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)
);