P_ORDEROPCOMPSTATUSBASICAGGRGN

CDS View

Aggregated System Status of Order Component

P_ORDEROPCOMPSTATUSBASICAGGRGN is a CDS View in S/4HANA. Aggregated System Status of Order Component. It contains 10 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 10 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderComponentWithStatus view_entity inner COMPOSITE Manufacturing Order Component with Status

Fields (10)

KeyField CDS FieldsUsed in Views
_CompIsCreatedByOrderSplitCode _CompIsCreatedByOrderSplitCode 1
_ComponentIsCreatedCode _ComponentIsCreatedCode 1
_ComponentIsDeletedCode _ComponentIsDeletedCode 1
_ComponentIsPrintedCode _ComponentIsPrintedCode 1
_ComponentIsReleasedCode _ComponentIsReleasedCode 1
MaterialComponentIsCreated MaterialComponentIsCreated 1
MaterialComponentIsDeleted MaterialComponentIsDeleted 1
MaterialComponentIsPrinted MaterialComponentIsPrinted 1
MaterialComponentIsReleased MaterialComponentIsReleased 1
MatlCompIsCreatedByOrderSplit MatlCompIsCreatedByOrderSplit 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated order component status per ObjectInternalID

// to be used in OrderOperationComponent views (join) only!


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity P_OrderOpCompStatusBasicAggrgn
  as select from P_OrderOpCompStatusBasic
{
      // Key

  key ObjectInternalID,

      // Status

      cast(max(MaterialComponentIsCreated)    as componentiscreated  preserving type) as MaterialComponentIsCreated,
      cast(max(MaterialComponentIsReleased)   as componentisreleased preserving type) as MaterialComponentIsReleased,
      cast(max(MaterialComponentIsPrinted)    as componentisprinted  preserving type) as MaterialComponentIsPrinted,
      cast(max(MaterialComponentIsDeleted)    as componentisdeleted  preserving type) as MaterialComponentIsDeleted,
      cast(max(MatlCompIsCreatedByOrderSplit) as iscrtedbyordersplit preserving type) as MatlCompIsCreatedByOrderSplit,

      // Associations

      _StatusObject,
      _ComponentIsCreatedCode,
      _ComponentIsReleasedCode,
      _ComponentIsPrintedCode,
      _ComponentIsDeletedCode,
      _CompIsCreatedByOrderSplitCode
}
group by
  ObjectInternalID

Learn More