P_PURCHASINGSPNDCOMPARISON1

CDS View

Purchasing Spend Comparison 1

P_PURCHASINGSPNDCOMPARISON1 is a CDS View in S/4HANA. Purchasing Spend Comparison 1. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurchasingSpndComparison2 view from CONSUMPTION Purchasing Spend Comparison 2 
@AbapCatalog.sqlViewName: 'PMMPURSPNDCOMP1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchasing Spend Comparison 1'
define view P_PurchasingSpndComparison1
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : bedat,
    P_EndDate         : bedat


  as select from P_PurchasingSpndComparison ( P_DisplayCurrency: $parameters.P_DisplayCurrency,
                                              P_StartDate  : $parameters.P_StartDate,
                                              P_EndDate   : $parameters.P_EndDate) 

{
  key  PurchaseOrder,
  key  PurchaseOrderItem,

       Supplier,
       PurchasingOrganization,
       PurchasingGroup,
       PurgDocHdrCompanyCode,
       CompanyCode,
       PurchaseOrderType,
       PurchaseOrderDate,
       CreatedByUser,
       DocumentCurrency                                 as Currency,
       MaterialGroup,
       Material,
       Plant,
       PurchaseOrderItemCategory,
       PurchaseOrderCategory,
       ProductType,
       ServicePerformer,
       AccountAssignmentCategory,
       MultipleAcctAssgmtDistribution,
       PurchaseOrderQuantityUnit,
       DocumentCurrency,

       PurchaseOrderAmount,
       case when IsReturnsItem = 'X' then -1 else 1 end as ReturnItems,
       OrderQuantity


}

union all select from  P_PurchasingSpndComparison3           //3369847

{
  key  PurchaseOrder,
  key  PurchaseOrderItem,

       Supplier,
       PurchasingOrganization,
       PurchasingGroup,
       PurgDocHdrCompanyCode,
       CompanyCode as CompanyCode,
       PurchaseOrderType,
       PurchaseOrderDate,
       CreatedByUser,
       DocumentCurrency               as Currency,
       MaterialGroup,
       Material,
       Plant,
       PurchaseOrderItemCategory,
       PurchaseOrderCategory,
       ProductType,
       ServicePerformer,
       AccountAssignmentCategory,
       MultipleAcctAssgmtDistribution,
       PurchaseOrderQuantityUnit,
       DocumentCurrency,
       currency_conversion(
                                   amount             => NetAmount,
                                   source_currency    => DocumentCurrency,
                                   target_currency    => :P_DisplayCurrency,
                                   exchange_rate_date => PurchaseOrderDate,
                                   exchange_rate_type => 'M',
                                   error_handling => 'FAIL_ON_ERROR'
                                )                       as PurchaseOrderAmount,
       ReturnItems,
       OrderQuantity
}
where
  PurchaseOrderDate                                <= $parameters.P_EndDate
  and PurchaseOrderDate                                >= $parameters.P_StartDate

Learn More