I_MRPMASTERDATAISSUEBASIC

CDS View
18 Fields 4 CDS Views

Master Data Related Issues of an MRP Run

I_MRPMASTERDATAISSUEBASIC is a CDS View in S/4HANA. Master Data Related Issues of an MRP Run. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MRPIssueAcceptedByVH view_entity inner CONSUMPTION User who accepted some MRP Issues
I_MRPMasterDataIssue view_entity from COMPOSITE Master data related issue that occurred during an MRP run
P_MRPMasterDataIssueCntMsgType view_entity from COMPOSITE Calculated Values for Master Data Issues
P_MRPMasterDataIssueCount view_entity from COMPOSITE Calculated Values for DD MRP

Fields (18)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MRPArea MRPArea 1
KEY MRPMasterDataIssueItemCount MRPMasterDataIssueItemCount 1
KEY MRPMasterDataIssueSource MRPMasterDataIssueSource 1
KEY Plant Plant 2
_MRPMasterDataIssueSource _MRPMasterDataIssueSource 1
CreationDateTime CreationDateTime 1
MRPIssueAcceptanceDateTime IsAcceptedDateTime 1
MRPIssueAcceptedByUser IsAcceptedByUser 1
MRPIssueIsAccepted IsAccepted 1
MRPMessageLogUUID MRPLogUUID 1
SystemMessageIdentification SystemMessageIdentification 1
SystemMessageNumber SystemMessageNumber 1
SystemMessageType SystemMessageType 1
SystemMessageVariable1 SystemMessageVariable1 1
SystemMessageVariable2 SystemMessageVariable2 1
SystemMessageVariable3 SystemMessageVariable3 1
SystemMessageVariable4 SystemMessageVariable4 1

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.

-- Master Data Related Issues of an MRP Run
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPMASTERDATAISSUEBASIC (
    MATERIAL,
    MRPAREA,
    MRPMASTERDATAISSUEITEMCOUNT,
    MRPMASTERDATAISSUESOURCE,
    PLANT,
    _MRPMASTERDATAISSUESOURCE,
    CREATIONDATETIME,
    MRPISSUEACCEPTANCEDATETIME,
    MRPISSUEACCEPTEDBYUSER,
    MRPISSUEISACCEPTED,
    MRPMESSAGELOGUUID,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    PRIMARY KEY (MATERIAL, MRPAREA, MRPMASTERDATAISSUEITEMCOUNT, MRPMASTERDATAISSUESOURCE, PLANT)
);

Learn More