P_PurchaseOrderConvertedAmount

DDL: P_PURCHASEORDERCONVERTEDAMOUNT SQL: PPOITMCNVRTDAMT Type: view CONSUMPTION

Converted PO Net Amount

P_PurchaseOrderConvertedAmount is a Consumption CDS View that provides data about "Converted PO Net Amount" in SAP S/4HANA. It reads from 4 data sources (I_PurgAnalyticsConfiguration, I_PurgAnalyticsConfiguration, P_PurOrdAmountCalculation, P_PurOrdItmCastAmount) and exposes 3 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
I_PurgAnalyticsConfiguration MigrationStatus from
I_PurgAnalyticsConfiguration MigrationStatus union_all
P_PurOrdAmountCalculation P_PurOrdAmountCalculation inner
P_PurOrdItmCastAmount P_PurOrdItmCastAmount inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPOITMCNVRTDAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Converted PO Net Amount view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY PurchaseOrderItem PurchaseOrderItem 
@AbapCatalog.sqlViewName: 'PPOITMCNVRTDAMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true

@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Converted PO Net Amount'
define view P_PurchaseOrderConvertedAmount
  as select from I_PurgAnalyticsConfiguration as MigrationStatus
    inner join   P_PurOrdAmountCalculation on MigrationStatus.IsIntrastatReportingRelevant = 'X'
{

  key PurchaseOrder,
  key PurchaseOrderItem,
      NetAmountInCoCodeCurrency

}
where
  MigrationStatus.IsIntrastatReportingRelevant = 'X'

union all select from I_PurgAnalyticsConfiguration as MigrationStatus
  inner join          P_PurOrdItmCastAmount on MigrationStatus.IsIntrastatReportingRelevant = ''
{

  key PurchaseOrder,
  key PurchaseOrderItem,
  //Currency Conversion triggered on Company Code currency as target

      currency_conversion( amount => NetAmount,
                                      source_currency => DocumentCurrency,
                                      target_currency => Currency,
                                      exchange_rate_date => CreationDate,
                                      error_handling => 'SET_TO_NULL' )
                                   as  NetAmountInCoCodeCurrency

}
where
      MigrationStatus.IsIntrastatReportingRelevant  =  ''

Learn More