P_PurOrdServiceEntry

DDL: P_PURORDSERVICEENTRY SQL: PPURORDSERENT Type: view CONSUMPTION

Purchase Order Service Entry Sheet

P_PurOrdServiceEntry is a Consumption CDS View that provides data about "Purchase Order Service Entry Sheet" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItem) and exposes 2 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItem ServiceEntry from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDSERENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Service Entry Sheet view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem 
@AbapCatalog.sqlViewName: 'PPURORDSERENT'
@AbapCatalog.compiler.compareFilter: true 
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Order Service Entry Sheet'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_PurOrdServiceEntry
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : bedat,
    P_EndDate         : bedat
  as select from I_ServiceEntrySheetItem as ServiceEntry
  association [1..1] to I_PurchaseOrderItem as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                  and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [1..1] to I_PurchaseOrder     as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

{
  key PurchaseOrder,
  key PurchaseOrderItem,

      sum( case when ServicePerformanceDate is not null
              then currency_conversion(
                      amount => NetAmount,
                      source_currency => Currency,
                      target_currency => $parameters.P_DisplayCurrency,
                      exchange_rate_date =>  ServicePerformanceDate )
              else 0 end

      ) as NetAmount
}

where
      _PurchaseOrder.PurchaseOrderDate                  >= $parameters.P_StartDate
  and _PurchaseOrder.PurchaseOrderDate                  <= $parameters.P_EndDate
  and _PurchaseOrder.PurchasingDocumentDeletionCode     = ''
  and _PurchaseOrder.ReleaseIsNotCompleted              = ''
  and _PurchaseOrder.PurchasingCompletenessStatus       = ''
  and _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''

group by
  PurchaseOrder,
  PurchaseOrderItem
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_SERVICEENTRYSHEETITEM"
],
"ASSOCIATED":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More