C_OperationActivityCompInstce

DDL: C_OPERATIONACTIVITYCOMPINSTCE SQL: CMPEOACOMPINSTCE Type: view CONSUMPTION Package: MPE_EXEC_CONF

Operation Activity Component Instance

C_OperationActivityCompInstce is a Consumption CDS View that provides data about "Operation Activity Component Instance" in SAP S/4HANA. It reads from 1 data source (I_OpActyCompInstceAssignment) and exposes 17 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_CONF.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_OpActyCompInstceAssignment OpActyCompInstceAssignment from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOACOMPINSTCE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Operation Activity Component Instance view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_OpActyCompInstceAssignment Reservation
KEY ReservationItem I_OpActyCompInstceAssignment ReservationItem
KEY RecordType I_OpActyCompInstceAssignment RecordType
KEY OpActyNtwkInstance I_OpActyCompInstceAssignment OpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyCompInstceAssignment OpActyNtwkElement
KEY OriglDgtlMockUpCharcsUUID I_OpActyCompInstceAssignment OriglDgtlMockUpCharcsUUID
DgtlMockUpCharcsUUID I_OpActyCompInstceAssignment DgtlMockUpCharcsUUID
ReltdOriglDgtlMockUpCharcsUUID I_OpActyCompInstceAssignment ReltdOriglDgtlMockUpCharcsUUID
MfgRefStrucBOMLeafAssgmtUUID I_OpActyCompInstceAssignment MfgRefStrucBOMLeafAssgmtUUID
MfgRefStructureItemDetailUUID I_OpActyCompInstceAssignment MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual I_OpActyCompInstceAssignment MfgRefStrucItmDetIsContextual
ReferenceDesignatorValue
_OpActyComponentAssignment I_OpActyCompInstceAssignment _OpActyComponentAssignment
_OpActyNtwkInstance I_OpActyCompInstceAssignment _OpActyNtwkInstance
_OpActyNtwkInstanceBasic I_OpActyCompInstceAssignment _OpActyNtwkInstanceBasic
_OperationActivityInstance I_OpActyCompInstceAssignment _OperationActivityInstance
_ReservationHeader I_OpActyCompInstceAssignment _ReservationHeader 
@AbapCatalog.sqlViewName: 'CMPEOACOMPINSTCE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@EndUserText.label: 'Operation Activity Component Instance'
define view C_OperationActivityCompInstce
  as select from I_OpActyCompInstceAssignment as OpActyCompInstceAssignment
{
  key OpActyCompInstceAssignment.Reservation,
  key OpActyCompInstceAssignment.ReservationItem,
  key OpActyCompInstceAssignment.RecordType,
      @UI.hidden: true
  key OpActyCompInstceAssignment.OpActyNtwkInstance,
      @UI.hidden: true
  key OpActyCompInstceAssignment.OpActyNtwkElement,
      @UI.hidden: true
  key OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID,
      @UI.hidden: true
      OpActyCompInstceAssignment.DgtlMockUpCharcsUUID,
      @UI.hidden: true
      OpActyCompInstceAssignment.ReltdOriglDgtlMockUpCharcsUUID,
      @UI.hidden: true
      OpActyCompInstceAssignment.MfgRefStrucBOMLeafAssgmtUUID,
      @UI.hidden: true
      OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID,
      @UI.hidden: true
      OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual,
      cast(case
        when OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual = 'X'
        and OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName is not null
        and OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName <> ''
          then OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName
        when OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual = ''
        and OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName is not null
        and OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName <> ''
          then OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName
        when OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue is not null
        or   OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue <> ''
          then OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue
      -- If no RefDes exists, use GUID as Fallback (instead of having empty RefDes)
        else bintohex( OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID )
      end as vmp_ref_des) as ReferenceDesignatorName,
      OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue,
      @ObjectModel.text.element: 'MfgRefStrucItmRefDsgntrDesc'
      cast( case OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual
        when 'X' then OpActyCompInstceAssignment._MfgRefHierItemWithDetails.MfgRefStrucItmRefDesignator
        else OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDesignator
        end as mpe_mrs_designator preserving type )           as MfgRefStrucItmRefDesignator,
      @UI.hidden: true
      cast( case OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual
        when 'X' then OpActyCompInstceAssignment._MfgRefHierItemWithDetails._MfgReferenceHierarchyItmTxt[1: Language=$session.system_language].HierMfgRefDesignatorDesc
        else OpActyCompInstceAssignment._MfgRefStrucItemWithDetails._MfgReferenceStructureItmTxt[1: Language=$session.system_language].MfgRefStrucItmRefDsgntrDesc
      end as mpe_mrs_designator_description preserving type ) as MfgRefStrucItmRefDsgntrDesc,
      cast( case OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual
        when 'X' then OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName
        else OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName
      end as mpe_mrs_designator_name preserving type )        as MfgRefStrucItmRefDsgntrName,
      OpActyCompInstceAssignment._OpActyComponentAssignment,
      OpActyCompInstceAssignment._OpActyNtwkInstance,
      OpActyCompInstceAssignment._OpActyNtwkInstanceBasic,
      OpActyCompInstceAssignment._OperationActivityInstance,
      OpActyCompInstceAssignment._ReservationHeader
}

Learn More