I_OPACTYCOMPINSTCEASSIGNMENT

CDS View
17 Fields 6 CDS Views

Assignment of component instance to operation activity

I_OPACTYCOMPINSTCEASSIGNMENT is a CDS View in S/4HANA. Assignment of component instance to operation activity. It contains 17 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_OperationActivityCompInstce view from CONSUMPTION Operation Activity Component Instance
P_AssldReltdComponentInstance view inner COMPOSITE
P_MfgOrdCompNoInstceAssyByDgtl view inner COMPOSITE
P_MfgOrderCompInstceAssyQty view inner COMPOSITE
P_OAInstceCompNrOfInstances view_entity from COMPOSITE Number of OA Component Instances
P_SFICompNoInstceAssyByDgtlMck view inner COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 4
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 2
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
_DigitalMockUpCharcs _DigitalMockUpCharcs 3
_OpActyComponentAssignment _OpActyComponentAssignment 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 1
_OperationActivityInstance _OperationActivityInstance 1
_ReservationHeader _ReservationHeader 1
MfgRefStrucBOMLeafAssgmtUUID MfgRefStrucBOMLeafAssgmtUUID 1
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 1
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 1
ReltdOriglDgtlMockUpCharcsUUID ReltdOriglDgtlMockUpCharcsUUID 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.

-- Assignment of component instance to operation activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYCOMPINSTCEASSIGNMENT (
    DGTLMOCKUPCHARCSUUID,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORIGLDGTLMOCKUPCHARCSUUID,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _DIGITALMOCKUPCHARCS,
    _OPACTYCOMPONENTASSIGNMENT,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPERATIONACTIVITYINSTANCE,
    _RESERVATIONHEADER,
    MFGREFSTRUCBOMLEAFASSGMTUUID,
    MFGREFSTRUCITMDETISCONTEXTUAL,
    MFGREFSTRUCTUREITEMDETAILUUID,
    RELTDORIGLDGTLMOCKUPCHARCSUUID,
    PRIMARY KEY (DGTLMOCKUPCHARCSUUID, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORIGLDGTLMOCKUPCHARCSUUID, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);

Learn More