P_PurchaseOrderNetAmountP01

DDL: P_PURCHASEORDERNETAMOUNTP01 Type: view_entity CONSUMPTION Package: ODATA_MM_ANALYTICS

Calculate Net Amount of Purchase Order

P_PurchaseOrderNetAmountP01 is a Consumption CDS View that provides data about "Calculate Net Amount of Purchase Order" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurchaseOrderItem) and exposes 2 fields with key field PurchaseOrder. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder from
I_PurchaseOrderItem PurchaseOrderItem inner

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (3)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder
DisplayCurrency 
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_PurchaseOrderNetAmountP01
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : vdm_validitystart,
    P_EndDate         : vdm_validityend

  as select from I_PurchaseOrder     as PurchaseOrder
    inner join   I_PurchaseOrderItem as PurchaseOrderItem on PurchaseOrder.PurchaseOrder = PurchaseOrderItem.PurchaseOrder

{
  key PurchaseOrder.PurchaseOrder,
      cast( $parameters.P_DisplayCurrency as displaycurrency) as DisplayCurrency,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      sum( currency_conversion( amount             => PurchaseOrderItem.NetAmount,
                                source_currency    => PurchaseOrderItem.DocumentCurrency,
                                target_currency    => $parameters.P_DisplayCurrency,
                                exchange_rate_date => PurchaseOrder.PurchaseOrderDate,
                                exchange_rate_type => 'M',
                                error_handling => 'FAIL_ON_ERROR'
                               ) )                            as PurOrdNetAmountInDisplayCrcy

}
where
      PurchaseOrder.PurchasingDocumentDeletionCode     =  ''
  and PurchaseOrderItem.PurchasingDocumentDeletionCode =  ''
  and PurchaseOrder.PurchaseOrderDate                  between $parameters.P_StartDate and $parameters.P_EndDate
  and PurchaseOrderItem.DocumentCurrency               != ''

group by
  PurchaseOrder.PurchaseOrder

Learn More