MMPUR_HUB_CMNTS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PrmtHbRpldPurReqnItmComment | view_entity | from | BASIC | Central PR item comments |
Fields (13)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA