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