P_OPERATIONACTIVITYINSTANCEBSC

CDS View
34 Fields 1 CDS Views

OA Instance with OA network instance

P_OPERATIONACTIVITYINSTANCEBSC is a CDS View in S/4HANA. OA Instance with OA network instance. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyInstceNtwkElmntBasic view from BASIC OA instance with OA network instance and OA network element

Fields (34)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
_ManufacturingOrder _ManufacturingOrder 1
_MfgOrder _MfgOrder 1
_MfgOrderOperation _MfgOrderOperation 1
_OpActyInstanceStatusBasic _OpActyInstanceStatusBasic 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 1
_OpActyNtwkInternalId _OpActyNtwkInternalId 1
_OperationActivityNetwork _OperationActivityNetwork 1
_OrderInternalID _OrderInternalID 1
_OrderOperation _OrderOperation 1
_OrderOperationBasic _OrderOperationBasic 1
_SASSchema _SASSchema 1
_UnitOfMeasure _UnitOfMeasure 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
BillOfOperationsVariant BillOfOperationsVariant 1
BillOfOperationsVersion BillOfOperationsVersion 1
BOOOperationInternalID BOOOperationInternalID 1
ManufacturingOrder ManufacturingOrder 1
OpActyConfirmationIsAllowed OpActyConfirmationIsAllowed 1
OpActyConfIsSFIBased OpActyConfIsSFIBased 1
OpActyConfNotAllowedReason OpActyConfNotAllowedReason 1
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds 1
OpActyExpdExecLaborDurnInSecs OpActyExpdExecLaborDurnInSecs 1
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 1
OperationActivityNetwork OperationActivityNetwork 1
OpPlannedScrapQuantity OpPlannedScrapQuantity 1
OpPlannedYieldQuantity OpPlannedYieldQuantity 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
ProductionUnit ProductionUnit 1
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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPERATIONACTIVITYINSTANCEBSC (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    _MANUFACTURINGORDER,
    _MFGORDER,
    _MFGORDEROPERATION,
    _OPACTYINSTANCESTATUSBASIC,
    _OPACTYNTWKINSTANCE,
    _OPACTYNTWKINSTANCEBASIC,
    _OPACTYNTWKINTERNALID,
    _OPERATIONACTIVITYNETWORK,
    _ORDERINTERNALID,
    _ORDEROPERATION,
    _ORDEROPERATIONBASIC,
    _SASSCHEMA,
    _UNITOFMEASURE,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOOOPERATIONINTERNALID,
    MANUFACTURINGORDER,
    OPACTYCONFIRMATIONISALLOWED,
    OPACTYCONFISSFIBASED,
    OPACTYCONFNOTALLOWEDREASON,
    OPACTYEXPDEXECDURNINSECONDS,
    OPACTYEXPDEXECLABORDURNINSECS,
    OPACTYNTWKVERSIONCOUNTER,
    OPERATIONACTIVITYNETWORK,
    OPPLANNEDSCRAPQUANTITY,
    OPPLANNEDYIELDQUANTITY,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODUCTIONUNIT,
    STATUSANDACTIONSCHEMA,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE)
);

Learn More