I_OPACTYCOMPONENTASSIGNMENT

CDS View
36 Fields 32 CDS Views

Operation Activity Instance Comp Assign

I_OPACTYCOMPONENTASSIGNMENT is a CDS View in S/4HANA. Operation Activity Instance Comp Assign. It contains 36 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
C_MfgQualifnOpActyAssgmt view inner CONSUMPTION Qualification Assignment to OA
I_OAInstceCompNrOfInstances view_entity from COMPOSITE OA Instance Component Nr Of Instances
I_OpActyInstanceComponent view_entity from BASIC Component of an Operation Activity Instance
I_OpActySFIGroupCompDetail view inner COMPOSITE Detail of a component of a group of SFI at OA
I_OperationActivityPlndMatlRet view from BASIC Operation Activity Planned Material Return
P_AssldReltdComponentInstance view from COMPOSITE
P_AssldReltdCompSFINoInstce view from COMPOSITE
P_AssldReltdSerialNumberBatch view from COMPOSITE
P_MfgOrdCompMfgRefStruc view inner CONSUMPTION
P_MfgOrderCompInstceAssyQty view inner COMPOSITE
P_MfgOrderOriglComponentAssy view inner COMPOSITE
P_NmbrOfCompOpActivities view_entity from CONSUMPTION
P_OpActyBackflushByOrigComp view inner COMPOSITE
P_OpActyComponentAssignment view from CONSUMPTION
P_OpActyComponentAssignmentAgg view from COMPOSITE
P_OpActyComponentAssignmentDMU view from COMPOSITE
P_OpActyInstanceAssembledComp view inner COMPOSITE
P_OpActyInstcePlndComponent view_entity from CONSUMPTION Planned Components at OA Instance
P_OpActyInstceWithMissingComp view from COMPOSITE
P_OpActyNrOfMandComponents view from CONSUMPTION
P_OpActyPlndComponentPerSFI view from COMPOSITE
P_OperationActivityCompUnion view from CONSUMPTION
P_SFIAssembledComponent view inner CONSUMPTION
P_SFIAssembledMaterial view inner COMPOSITE
P_SFIAtOpActyBckflshByOrigComp view from COMPOSITE
P_SFIDisassemblyByCompInstce view_entity inner CONSUMPTION
P_SFIDisassemblyByComponent view_entity inner CONSUMPTION
P_SFODisassemblyByCompInstce view_entity inner CONSUMPTION
P_SFODisassemblyByComponent view_entity inner CONSUMPTION
P_SFONonTraceableComponent view_entity from CONSUMPTION
P_ShopFloorItemAtOpActyComp view from CONSUMPTION
P_ShopFloorItemComponent view inner CONSUMPTION

Fields (36)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement CurrentOpActyNtwkElement,OpActyNtwkElement 17
KEY OpActyNtwkInstance CurrentOpActyNtwkInstance,OpActyNtwkInstance 18
KEY RecordType CurrentRecordType,RecordType 16
KEY Reservation Reservation 14
KEY ReservationItem CurrentReservationItem,ReservationItem 16
_BOMItmMfgRefStrucItmAssgmt _BOMItmMfgRefStrucItmAssgmt 2
_MfgRefHierItemWithDetails _MfgRefHierItemWithDetails 3
_MfgRefStrucItemWithDetails _MfgRefStrucItemWithDetails 3
_OpActyNtwkInstance _OpActyNtwkInstance 8
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 5
_OperationActivityInstance _OperationActivityInstance 8
_PlannedInventoryUsblyCode _PlannedInventoryUsblyCode 1
_ReltdOpActyCompAssignment _ReltdOpActyCompAssignment 1
_ReservationHeader _ReservationHeader 7
AssemblySequenceNumber AssemblySequenceNumber 7
BOOOpBOMItemInternalID BOOOpBOMItemInternalID 13
ComponentAssemblyType ComponentAssemblyType 6
LeadingOpActyNtwkElement LeadingOpActyNtwkElement 8
LeadingOpActyNtwkInstance LeadingOpActyNtwkInstance 8
LeadingReservation LeadingReservation 8
LeadingReservationItem LeadingReservationItem 8
LeadingReservationRecordType LeadingReservationRecordType 8
LogicalComponent LogicalComponent 7
MatlCompAssemblyIsNotRequired MatlCompAssemblyIsNotRequired 4
MatlCompInstceAssyIsRequired MatlCompInstceAssyIsRequired 9
MfgOrderComponentUsageNetQty MfgOrderComponentUsageNetQty 6
MfgOrderComponentUsageQuantity MaterialComponentQuantity,MfgOrderComponentUsageNetQty,MfgOrderComponentUsageQuantity 9
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 9
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 10
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 10
PlannedInventoryUsabilityCode PlannedInventoryUsabilityCode 2
RelatedOpActyNtwkElement RelatedOpActyNtwkElement 9
RelatedOpActyNtwkInstance RelatedOpActyNtwkInstance 9
RelatedRecordType RelatedRecordType 9
RelatedReservation RelatedReservation 5
RelatedReservationItem RelatedReservationItem 9

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.

-- Operation Activity Instance Comp Assign
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYCOMPONENTASSIGNMENT (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _BOMITMMFGREFSTRUCITMASSGMT,
    _MFGREFHIERITEMWITHDETAILS,
    _MFGREFSTRUCITEMWITHDETAILS,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPERATIONACTIVITYINSTANCE,
    _PLANNEDINVENTORYUSBLYCODE,
    _RELTDOPACTYCOMPASSIGNMENT,
    _RESERVATIONHEADER,
    ASSEMBLYSEQUENCENUMBER,
    BOOOPBOMITEMINTERNALID,
    COMPONENTASSEMBLYTYPE,
    LEADINGOPACTYNTWKELEMENT,
    LEADINGOPACTYNTWKINSTANCE,
    LEADINGRESERVATION,
    LEADINGRESERVATIONITEM,
    LEADINGRESERVATIONRECORDTYPE,
    LOGICALCOMPONENT,
    MATLCOMPASSEMBLYISNOTREQUIRED,
    MATLCOMPINSTCEASSYISREQUIRED,
    MFGORDERCOMPONENTUSAGENETQTY,
    MFGORDERCOMPONENTUSAGEQUANTITY,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    PLANNEDINVENTORYUSABILITYCODE,
    RELATEDOPACTYNTWKELEMENT,
    RELATEDOPACTYNTWKINSTANCE,
    RELATEDRECORDTYPE,
    RELATEDRESERVATION,
    RELATEDRESERVATIONITEM,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More