P_SRVCENTRSHTITMTOTCONFDAMT

DDL: P_SRVCENTRSHTITMTOTCONFDAMT SQL: PSESITMTOTCONFAM Type: view COMPOSITE Package: APPL_MM_PUR_SES_TR

SES Item: Total Confirmed Amount

P_SRVCENTRSHTITMTOTCONFDAMT is a Composite CDS View that provides data about "SES Item: Total Confirmed Amount" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItem) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views. Part of development package APPL_MM_PUR_SES_TR.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItem Document from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSESITMTOTCONFAM 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 #D 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_ServiceEntrySheetItem PurchaseOrder
KEY PurchaseOrderItem I_ServiceEntrySheetItem PurchaseOrderItem
PurchaseOrderCurrency _PurchaseOrderItem DocumentCurrency
NetAmountInPurchaseOrderCrcy 
@AbapCatalog.sqlViewName: 'PSESITMTOTCONFAM'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

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

define view P_SRVCENTRSHTITMTOTCONFDAMT
  as select from I_ServiceEntrySheetItem 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,

      @Semantics.currencyCode:true
      _PurchaseOrderItem.DocumentCurrency                                               as PurchaseOrderCurrency,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      cast( sum(Document.NetAmount) as mmpur_ses_netprice_purord_crcy preserving type ) as NetAmountInPurchaseOrderCrcy
}
where
      _PurchaseOrderItem.PurchaseOrderItemCategory = 'A'
  and Document.IsDeleted                           is initial
  and Document.ParentObjectIsDeleted               is initial
group by
  Document.PurchaseOrder,
  Document.PurchaseOrderItem,
  _PurchaseOrderItem.DocumentCurrency

Learn More