I_OPACTYINSTCENTWKELMNTBASIC

CDS View
24 Fields 24 CDS Views

OA instance with OA network instance and OA network element

I_OPACTYINSTCENTWKELMNTBASIC is a CDS View in S/4HANA. OA instance with OA network instance and OA network element. It contains 24 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
C_MfgQualifnOpActyAssgmt view from CONSUMPTION Qualification Assignment to OA
C_MfgQualifnOpActyAssgmt view union CONSUMPTION Qualification Assignment to OA
C_OpActyInstceExtdQltyChkGrp view_entity inner CONSUMPTION EQC Group of an OA Instance
C_OpActyInstceInspCharcSqnc view_entity from CONSUMPTION IC sequence based on Op Activity
C_OpActyInstcPlndWrkInstrnVers view_entity inner CONSUMPTION WI for Plan Data application
C_OperationActivityComponent view inner CONSUMPTION Operation Activity Component
C_OperationActivityPlndMatlRet view inner CONSUMPTION Operation Activity Component
C_SFIAssembledComponent view inner CONSUMPTION Component Assembled into a SFI (Manual and Backflushed)
C_SFIAtOpActyPlndMatlRet view inner CONSUMPTION Shop Floor Item At OA Planned Material Return
C_SFOOpActyNonTrcblUsedPRT view_entity inner CONSUMPTION Shop floor order used non traceable PRT
C_ShopFloorItemAtOpActyComp view inner CONSUMPTION Shop Floor Item At OA Component
I_OpActyInstceInspCharcInfo view_entity from COMPOSITE NonSFI ICs with operation activity
I_OpActyInstceNmbrOfInspCharcs view_entity from COMPOSITE OA Instance Number of ICs
I_SFIAssembledMaterial view inner COMPOSITE Material Assembled into a SFI (Manual and Backflushed)
I_SFIAtOpActyInspCharcInfo view_entity from COMPOSITE IC info of SFI at OAI
P_MfgInspCharcHistory view inner COMPOSITE
P_OpActyComponentAssignment view inner CONSUMPTION
P_OpActyInstanceAssembledComp2 view inner COMPOSITE
P_OpActyInstceEquipActvRegn view_entity inner CONSUMPTION
P_OpActyInstceReferenceComp view_entity inner COMPOSITE Reference component of an OA instance
P_ProdnHoldAffcdSFIAtOpActy view inner CONSUMPTION
P_SFIOpActyInstceEquipActvRegn view_entity inner CONSUMPTION
P_SFIOpActyTrcblUsedPRT view_entity inner CONSUMPTION
P_SFOOpActyTrcblUsedPRT view_entity inner CONSUMPTION

Fields (24)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 12
KEY OpActyNtwkInstance OpActyNtwkInstance 12
_ManufacturingOrder _ManufacturingOrder 2
_MfgOrder _MfgOrder 5
_MfgOrderOperation _MfgOrderOperation 2
_OpActyNtwkInstance _OpActyNtwkInstance 5
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 3
_OperationActivityInstance _OperationActivityInstance 4
_OperationActivityText _OperationActivityText 6
_OrderInternalID _OrderInternalID 1
BillOfOperationsGroup BillOfOperationsGroup 10
BillOfOperationsType BillOfOperationsType 8
BillOfOperationsVariant BillOfOperationsVariant 3
BillOfOperationsVersion BillOfOperationsVersion 3
ManufacturingOrder ManufacturingOrder 11
OpActyNtwkElementElement OpActyNtwkElementElement,OperationActivity 8
OpActyNtwkElementElmntVersCntr OpActyNtwkElementElmntVersCntr,OperationActyVersionCounter 11
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 2
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 1
OperationActivity OperationActivity 8
OperationActyVersionCounter OperationActyVersionCounter 8
OrderInternalID OrderInternalID 6
OrderOperationInternalID InspPlanOperationInternalID,OrderOperationInternalID 6
StatusAndActionSchema StatusAndActionSchema 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.

-- OA instance with OA network instance and OA network element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPACTYINSTCENTWKELMNTBASIC (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _MANUFACTURINGORDER,
    _MFGORDER,
    _MFGORDEROPERATION,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPERATIONACTIVITYINSTANCE,
    _OPERATIONACTIVITYTEXT,
    _ORDERINTERNALID,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    MANUFACTURINGORDER,
    OPACTYNTWKELEMENTELEMENT,
    OPACTYNTWKELEMENTELMNTVERSCNTR,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITY,
    OPERATIONACTYVERSIONCOUNTER,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    STATUSANDACTIONSCHEMA,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);

Learn More