I_MASTERRECIPEHEADER

CDS View
25 Fields 3 CDS Views

Master Recipe Header Details

I_MASTERRECIPEHEADER is a CDS View in S/4HANA. Master Recipe Header Details. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_LinkedProdnVersBOO view_entity from CONSUMPTION BOO to Material Assignment for ProdnVers
C_LinkedProdnVersBOO view_entity union CONSUMPTION BOO to Material Assignment for ProdnVers
I_MasterRecipeHeaderTP view_entity from TRANSACTIONAL Master Recipe - Header

Fields (25)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup MasterRecipeGroup 1
KEY BillOfOperationsVariant MasterRecipe 1
KEY BOOInternalVersionCounter MasterRecipeInternalVersion,ProductionRoutingInternalVers 2
BillOfOperationsDesc BillOfOperationsDesc 2
BillOfOperationsProfile BillOfOperationsProfile 1
BillOfOperationsStatus BillOfOperationsStatus 2
BillOfOperationsUnit BillOfOperationsUnit 2
BillOfOperationsUsage BillOfOperationsUsage 2
ChangeNumber ChangeNumber 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LongTextLanguageCode LongTextLanguageCode 1
MaximumLotSizeQuantity MaximumLotSizeQuantity 2
MinimumLotSizeQuantity MinimumLotSizeQuantity 2
OperationReferenceQuantity OperationReferenceQuantity 1
OperationUnit OperationUnit 1
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr 1
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr 1
PlainLongText PlainLongText 1
Plant Plant 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 1
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2

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 Recipe Header Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MASTERRECIPEHEADER (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSVARIANT,
    BOOINTERNALVERSIONCOUNTER,
    BILLOFOPERATIONSDESC,
    BILLOFOPERATIONSPROFILE,
    BILLOFOPERATIONSSTATUS,
    BILLOFOPERATIONSUNIT,
    BILLOFOPERATIONSUSAGE,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LONGTEXTLANGUAGECODE,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONUNIT,
    OPQTYTOBASEQTYDNMNTR,
    OPQTYTOBASEQTYNMRTR,
    PLAINLONGTEXT,
    PLANT,
    RESPONSIBLEPLANNERGROUP,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSVARIANT, BOOINTERNALVERSIONCOUNTER)
);

Learn More