I_PRODNMODOPCOMPONENTBASIC

CDS View

Op Comp Keys and basic data

I_PRODNMODOPCOMPONENTBASIC is a CDS View in S/4HANA. Op Comp Keys and basic data. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdnModOperationComponent view_entity from COMPOSITE Production Model Operation Component

Fields (20)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsVersion BillOfOperationsVersion 1
KEY BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
KEY BOOOperationInternalID BOOOperationInternalID 1
KEY ProductionModelUUID ProductionModelUUID 1
BillOfMaterialItemQuantity ProdnModBOMCompAssgdQuantity 1
BillOfMaterialItemUnit ProdnModBOMCompAssgdQtyUnit 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
BillOfOperationsVariant BillOfOperationsVariant 1
BOOOpInternalVersionCounter BOOOpInternalVersionCounter 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Material Material 1
Operation Operation 1
OperationText OperationText 1
Plant Plant 1
TargetBOMItemNodeNumber BillOfMaterialItemNodeNumber 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.

-- Op Comp Keys and basic data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNMODOPCOMPONENTBASIC (
    BILLOFOPERATIONSVERSION,
    BOOOPBOMITEMINTERNALID,
    BOOOPERATIONINTERNALID,
    PRODUCTIONMODELUUID,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BOOOPINTERNALVERSIONCOUNTER,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MATERIAL,
    OPERATION,
    OPERATIONTEXT,
    PLANT,
    TARGETBOMITEMNODENUMBER,
    PRIMARY KEY (BILLOFOPERATIONSVERSION, BOOOPBOMITEMINTERNALID, BOOOPERATIONINTERNALID, PRODUCTIONMODELUUID)
);