I_MFGORDERCONFMATLDOCITEM

CDS View
24 Fields 7 CDS Views

Material Document Items of Mfg Order Confirmation

I_MFGORDERCONFMATLDOCITEM is a CDS View in S/4HANA. Material Document Items of Mfg Order Confirmation. It contains 24 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_ProcOrdConfMatlDocItem view_entity from COMPOSITE Material Movements for Confirmation
A_ProdnOrdConfMatlDocItem view_entity from COMPOSITE Material Movements for Confirmation
I_MfgOrderConfGRBatchCharc view_entity from COMPOSITE Batch Characteristics of Manufacturing Order Confirmation
P_ProcOrderConfBatchCharc view_entity from COMPOSITE Private View Batch Characteristics for Matl Mvmnts of Conf
P_ProdnOrderConfBatchCharc view_entity from COMPOSITE Private View Batch Characteristics for Matl Mvmnts of Conf
R_ProcOrdConfMatlDocItemTP view_entity from TRANSACTIONAL Process Order Conf Material Document
R_ProdnOrdConfMatlDocItemTP view_entity from TRANSACTIONAL Production Order Conf Material Document

Fields (24)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument 3
KEY MaterialDocumentItem MaterialDocumentItem 3
KEY MaterialDocumentYear MaterialDocumentYear 3
KEY MfgOrderConfirmation ConfirmationCount 3
KEY MfgOrderConfirmationGroup ConfirmationGroup 3
_ConfirmationCount _ConfirmationCount 1
_ConfirmationGroup _ConfirmationGroup 1
_ConfirmationPlant _ConfirmationPlant 1
_DocumentDate _DocumentDate 1
_MaterialDocumentHeader _MaterialDocumentHeader 1
_MaterialDocumentYear _MaterialDocumentYear 1
_MfgOrder _MfgOrder 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderItem _MfgOrderItem 1
_MfgOrderType _MfgOrderType 1
_PostingDate _PostingDate 1
ConfirmationPlant ConfirmationPlant 1
ConfirmationText ConfirmationText 1
CreatedByUser CreatedByUser 1
DocumentDate DocumentDate 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderItem ManufacturingOrderItem 1
PostingDate PostingDate 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.

-- Material Document Items of Mfg Order Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDERCONFMATLDOCITEM (
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMATIONGROUP,
    _CONFIRMATIONCOUNT,
    _CONFIRMATIONGROUP,
    _CONFIRMATIONPLANT,
    _DOCUMENTDATE,
    _MATERIALDOCUMENTHEADER,
    _MATERIALDOCUMENTYEAR,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERITEM,
    _MFGORDERTYPE,
    _POSTINGDATE,
    CONFIRMATIONPLANT,
    CONFIRMATIONTEXT,
    CREATEDBYUSER,
    DOCUMENTDATE,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERITEM,
    POSTINGDATE,
    PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, MFGORDERCONFIRMATION, MFGORDERCONFIRMATIONGROUP)
);

Learn More