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 (P_PurOrdServiceEntryItem1) and exposes 2 fields with key fields PurchaseOrder, PurchaseOrderItem.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
P_PurOrdServiceEntryItem1 P_PurOrdServiceEntryItem1 from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

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 P_PurOrdServiceEntryItem1( P_StartDate:$parameters.P_StartDate , P_EndDate: $parameters.P_EndDate) as ServiceEntry   //3484126



{
  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
}

group by
  PurchaseOrder,
  PurchaseOrderItem

Learn More