P_OPERATIONACTIVITYCOMPUNION

CDS View
55 Fields 1 CDS Views

P_OPERATIONACTIVITYCOMPUNION is a CDS View in S/4HANA. It contains 55 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_OperationActivityComponent view from CONSUMPTION

Fields (55)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
AlternativeItemGroup AlternativeItemGroup 1
AlternativeItemPriority AlternativeItemPriority 1
AlternativeItemStrategy AlternativeItemStrategy 1
BaseUnit BaseUnit 1
Batch Batch 1
BatchSplitType BatchSplitType 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMItem BOMItem 1
BOMItemCategory BOMItemCategory 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 1
EntryUnit EntryUnit 1
FormulaKey FormulaKey 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 1
InheritedBOMItemNode InheritedBOMItemNode 1
IsBulkMaterialComponent IsBulkMaterialComponent 1
LeadingOpActyNtwkElement LeadingOpActyNtwkElement 1
LeadingOpActyNtwkInstance LeadingOpActyNtwkInstance 1
LeadingReservation LeadingReservation 1
LeadingReservationItem LeadingReservationItem 1
LeadingReservationRecordType LeadingReservationRecordType 1
LogicalComponent LogicalComponent 1
MaterialComponentIsMissing MaterialComponentIsMissing 1
MatlCompAssemblyIsNotRequired MatlCompAssemblyIsNotRequired 1
MatlCompDiscontinuationType MatlCompDiscontinuationType 1
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
OriginalReservation OriginalReservation 1
OriginalReservationItem OriginalReservationItem 1
ProductionPlant ProductionPlant 1
QuantityInEntryUnit QuantityInEntryUnit 1
RelatedOpActyNtwkElement RelatedOpActyNtwkElement 1
RelatedOpActyNtwkInstance RelatedOpActyNtwkInstance 1
RelatedRecordType RelatedRecordType 1
RelatedReservationItem RelatedReservationItem 1
ReservationIsFinallyIssued ReservationIsFinallyIssued 1
UsageProbabilityPercent UsageProbabilityPercent 1
VariableSizeComponentQuantity VariableSizeComponentQuantity 1
VariableSizeComponentUnit VariableSizeComponentUnit 1
VariableSizeDimension1 VariableSizeDimension1 1
VariableSizeDimension2 VariableSizeDimension2 1
VariableSizeDimension3 VariableSizeDimension3 1
VariableSizeDimensionUnit VariableSizeDimensionUnit 1
VariableSizeItemUnit VariableSizeItemUnit 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPERATIONACTIVITYCOMPUNION (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    BASEUNIT,
    BATCH,
    BATCHSPLITTYPE,
    BILLOFMATERIAL,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMINTERNALCHANGECOUNT,
    BOOOPBOMITEMINTERNALID,
    ENTRYUNIT,
    FORMULAKEY,
    GOODSMOVEMENTISALLOWED,
    INHERITEDBOMITEMNODE,
    ISBULKMATERIALCOMPONENT,
    LEADINGOPACTYNTWKELEMENT,
    LEADINGOPACTYNTWKINSTANCE,
    LEADINGRESERVATION,
    LEADINGRESERVATIONITEM,
    LEADINGRESERVATIONRECORDTYPE,
    LOGICALCOMPONENT,
    MATERIALCOMPONENTISMISSING,
    MATLCOMPASSEMBLYISNOTREQUIRED,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPINSTCEASSYISREQUIRED,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    ORIGINALRESERVATION,
    ORIGINALRESERVATIONITEM,
    PRODUCTIONPLANT,
    QUANTITYINENTRYUNIT,
    RELATEDOPACTYNTWKELEMENT,
    RELATEDOPACTYNTWKINSTANCE,
    RELATEDRECORDTYPE,
    RELATEDRESERVATIONITEM,
    RESERVATIONISFINALLYISSUED,
    USAGEPROBABILITYPERCENT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    VARIABLESIZEITEMUNIT,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More