I_OPACTYINSTANCEREFERENCECOMP

CDS View

Reference component of an OA instance

I_OPACTYINSTANCEREFERENCECOMP is a CDS View in S/4HANA. Reference component of an OA instance. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyInstceRefCompInstce view_entity from COMPOSITE Component instance of an OA instance

Fields (11)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY BillOfMaterialVersion BillOfMaterialVersion 1
KEY InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
_MfgOrder _MfgOrder 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OpActyNtwkInstanceBasic _OpActyNtwkInstanceBasic 1
ManufacturingOrder ManufacturingOrder 1 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Reference component of an OA instance'
define view entity I_OpActyInstanceReferenceComp
  as select distinct from  P_OpActyReferenceComp        as OpActyReferenceComp
    inner join             I_OpActyInstceNtwkElmntBasic as OpActyInstceNtwkElmntBasic on  OpActyInstceNtwkElmntBasic.OperationActivity           = OpActyReferenceComp.OperationActivity
                                                                                      and OpActyInstceNtwkElmntBasic.OperationActyVersionCounter = OpActyReferenceComp.OperationActyVersionCounter
    left outer to one join I_OpActyInstanceComponent    as OpActyInstanceComponent    on  OpActyInstanceComponent.OpActyNtwkInstance       = OpActyInstceNtwkElmntBasic.OpActyNtwkInstance
                                                                                      and OpActyInstanceComponent.OpActyNtwkElement        = OpActyInstceNtwkElmntBasic.OpActyNtwkElement
                                                                                      and OpActyInstanceComponent.BillOfMaterialCategory   = OpActyReferenceComp.BillOfMaterialCategory
                                                                                      and OpActyInstanceComponent.BillOfMaterialInternalID = OpActyReferenceComp.BillOfMaterial
                                                                                      and OpActyInstanceComponent.BillOfMaterialVariant    = OpActyReferenceComp.BillOfMaterialVariant
                                                                                      and OpActyInstanceComponent.InheritedBOMItemNode     = OpActyReferenceComp.InheritedNodeNumberForBOMItem
                                                                                      and OpActyInstanceComponent.BillOfMaterialVersion    = OpActyReferenceComp.BillOfMaterialVersion
{
  key OpActyInstceNtwkElmntBasic.OpActyNtwkInstance,
  key OpActyInstceNtwkElmntBasic.OpActyNtwkElement,
  key OpActyReferenceComp.BillOfMaterialCategory,
  key cast(OpActyReferenceComp.BillOfMaterial as mpe_exec_stnum preserving type ) as BillOfMaterial,
  key OpActyReferenceComp.BillOfMaterialVariant,
  key OpActyReferenceComp.InheritedNodeNumberForBOMItem,
  key OpActyReferenceComp.BillOfMaterialVersion,
      OpActyReferenceComp.OperationActivity,
      OpActyReferenceComp.OperationActyVersionCounter,
      OpActyInstceNtwkElmntBasic.ManufacturingOrder,
      OpActyInstceNtwkElmntBasic.OrderInternalID,
      OpActyInstceNtwkElmntBasic.OrderOperationInternalID,
      /* Associations */
      OpActyInstceNtwkElmntBasic._OpActyNtwkInstance,
      OpActyInstceNtwkElmntBasic._OpActyNtwkInstanceBasic,
      OpActyInstceNtwkElmntBasic._MfgOrder,
      OpActyInstceNtwkElmntBasic._OrderInternalID,
      OpActyReferenceComp._OperationActivity,
      OpActyReferenceComp._OperationActivityInternalId
}
where
  OpActyInstanceComponent.Reservation is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYINSTANCECOMPONENT",
"I_OPACTYINSTCENTWKELMNTBASIC",
"P_OPACTYREFERENCECOMP"
],
"ASSOCIATED":
[
"I_MFGORDER",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKINSTANCEBASIC",
"I_OPERATIONACTIVITY",
"I_OPERATIONACTIVITYINTERNALID",
"I_ORDINTERNALBILLOFOPERATIONS"
],
"BASE":
[
"I_OPACTYINSTCENTWKELMNTBASIC",
"P_OPACTYREFERENCECOMP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More