P_SRVCENTRSHTITMTOTCONFDQTY

DDL: P_SRVCENTRSHTITMTOTCONFDQTY SQL: PSESITMTOTCONFDQ Type: view COMPOSITE

P_SRVCENTRSHTITMTOTCONFDQTY is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItemBasic) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItemBasic Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSESITMTOTCONFDQ view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_ServiceEntrySheetItemBasic PurchaseOrder
KEY PurchaseOrderItem I_ServiceEntrySheetItemBasic PurchaseOrderItem
TotalConfirmedQuantity
PurchaseOrderItemQuantityUnit _PurchaseOrderItem PurchaseOrderQuantityUnit 
@AbapCatalog.sqlViewName: 'PSESITMTOTCONFDQ'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED

//@EndUserText.label: 'SES Item: Total Confirmed Quantity'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_SRVCENTRSHTITMTOTCONFDQTY
  as select from I_ServiceEntrySheetItemBasic as Document

  association [1..1] to R_PurchaseOrderItem as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                  and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

{
  key Document.PurchaseOrder,
  key Document.PurchaseOrderItem,
      //    Document.IsDeleted,             //refers not to result values

      //    Document.ParentObjectIsDeleted, //refers not to result values


      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderItemQuantityUnit'
      cast( sum(Document.ConfirmedQuantity) as mmpur_ses_confirmedquantity preserving type ) as TotalConfirmedQuantity,

      @Semantics.unitOfMeasure: true
      _PurchaseOrderItem.PurchaseOrderQuantityUnit                                           as PurchaseOrderItemQuantityUnit

}
where
      Document.IsDeleted             is initial
  and Document.ParentObjectIsDeleted is initial
group by
  Document.PurchaseOrder,
  Document.PurchaseOrderItem,
  //         Document.IsDeleted,

  //         Document.ParentObjectIsDeleted,

  _PurchaseOrderItem.PurchaseOrderQuantityUnit

Learn More