P_OPACTYINSTCEPLNDCOMPDSASSY

CDS View

Plnd Comps for Disassembly at OA Instnce

P_OPACTYINSTCEPLNDCOMPDSASSY is a CDS View in S/4HANA. Plnd Comps for Disassembly at OA Instnce. It contains 58 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_OpActyInstcePlndCompDsassy view_entity from CONSUMPTION Plnd Dassy Components at OA Instance

Fields (58)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY Plant Plant 1
_MfgRefHierItemWithDetails _MfgRefHierItemWithDetails 1
_MfgRefStrucItemWithDetails _MfgRefStrucItemWithDetails 1
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 1
Assembly Assembly 1
AssemblySequenceNumber AssemblySequenceNumber 1
BaseUnit BaseUnit 1
BillOfMaterialInternalID BillOfMaterialInternalID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
EffectivityParameterVariant EffectivityParameterVariant 1
FormulaKey FormulaKey 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 1
InheritedBOMItemNode InheritedBOMItemNode 1
IsBatchManagementRequired IsBatchManagementRequired 1
IsBulkMaterialComponent IsBulkMaterialComponent 1
LeadingOpActyNtwkElement LeadingOpActyNtwkElement 1
LeadingOpActyNtwkInstance LeadingOpActyNtwkInstance 1
LeadingReservation LeadingReservation 1
LeadingReservationItem LeadingReservationItem 1
LeadingReservationRecordType LeadingReservationRecordType 1
LogicalComponent LogicalComponent 1
ManufacturingOrder ManufacturingOrder 1
MatlCompAssembleControl MatlCompAssembleControl 1
MatlCompAssemblyIsNotRequired MatlCompAssemblyIsNotRequired 1
MatlCompDiscontinuationType MatlCompDiscontinuationType 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MfgBOMItemIsPhantomChild MfgBOMItemIsPhantomChild 1
MfgOrderComponentUsageQuantity MfgOrderComponentUsageQuantity 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStrucItmRefDesignator MfgRefStrucItmRefDesignator 1
MfgRefStrucItmRefDsgntrName MfgRefStrucItmRefDsgntrName 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
PlannedInventoryUsabilityCode PlannedInventoryUsabilityCode 1
ProductionPlant ProductionPlant 1
RelatedOpActyNtwkElement RelatedOpActyNtwkElement 1
RelatedOpActyNtwkInstance RelatedOpActyNtwkInstance 1
RelatedRecordType RelatedRecordType 1
RelatedReservationItem RelatedReservationItem 1
RequiredQuantity RequiredQuantity 1
SerialNumberIsRqdForAssembly SerialNumberIsRqdForAssembly 1
SerialNumberProfile SerialNumberProfile 1
StockCheckMessageType StockCheckMessageType 1
StorageLocation StorageLocation 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 1
VariableSizeComponentUnit VariableSizeComponentUnit 1
VariableSizeDimension1 VariableSizeDimension1 1
VariableSizeDimension2 VariableSizeDimension2 1
VariableSizeDimension3 VariableSizeDimension3 1
VariableSizeDimensionUnit VariableSizeDimensionUnit 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.

-- Plnd Comps for Disassembly at OA Instnce
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYINSTCEPLNDCOMPDSASSY (
    OPACTYNTWKINSTANCE,
    PLANT,
    _MFGREFHIERITEMWITHDETAILS,
    _MFGREFSTRUCITEMWITHDETAILS,
    _OPACTYNTWKINSTANCEBASIC,
    ASSEMBLY,
    ASSEMBLYSEQUENCENUMBER,
    BASEUNIT,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    BOOOPBOMITEMINTERNALID,
    EFFECTIVITYPARAMETERVARIANT,
    FORMULAKEY,
    GOODSMOVEMENTISALLOWED,
    INHERITEDBOMITEMNODE,
    ISBATCHMANAGEMENTREQUIRED,
    ISBULKMATERIALCOMPONENT,
    LEADINGOPACTYNTWKELEMENT,
    LEADINGOPACTYNTWKINSTANCE,
    LEADINGRESERVATION,
    LEADINGRESERVATIONITEM,
    LEADINGRESERVATIONRECORDTYPE,
    LOGICALCOMPONENT,
    MANUFACTURINGORDER,
    MATLCOMPASSEMBLECONTROL,
    MATLCOMPASSEMBLYISNOTREQUIRED,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPINSTCEASSYISREQUIRED,
    MFGBOMITEMISPHANTOMCHILD,
    MFGORDERCOMPONENTUSAGEQUANTITY,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCITMREFDESIGNATOR,
    MFGREFSTRUCITMREFDSGNTRNAME,
    MFGREFSTRUCTUREITEMDETAILUUID,
    PLANNEDINVENTORYUSABILITYCODE,
    PRODUCTIONPLANT,
    RELATEDOPACTYNTWKELEMENT,
    RELATEDOPACTYNTWKINSTANCE,
    RELATEDRECORDTYPE,
    RELATEDRESERVATIONITEM,
    REQUIREDQUANTITY,
    SERIALNUMBERISRQDFORASSEMBLY,
    SERIALNUMBERPROFILE,
    STOCKCHECKMESSAGETYPE,
    STORAGELOCATION,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    PRIMARY KEY (OPACTYNTWKINSTANCE, PLANT)
);