P_Comonavg_Relconrate_Base

DDL: P_COMONAVG_RELCONRATE_BASE SQL: PCOMONRELCBASE Type: view COMPOSITE

P_Comonavg_Relconrate_Base is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContract, I_PurchaseContractHistory) and exposes 9 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContract _PurchaseContract inner
I_PurchaseContractHistory PurchaseContractHistory from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCOMONRELCBASE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractHistory PurchaseContract
KEY PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem
KEY ReleaseOrder I_PurchaseContractHistory ReleaseOrder
KEY ReleaseOrderItem I_PurchaseContractHistory ReleaseOrderItem
ReleaseOrderItemOrderQuantity I_PurchaseContractHistory ReleaseOrderItemOrderQuantity
ReleaseOrderItemQuantityUnit I_PurchaseContractHistory ReleaseOrderItemQuantityUnit
ReleaseOrderCurrency I_PurchaseContractHistory ReleaseOrderCurrency
ReleaseOrderDate
ReleaseOrderItemLastChgDate 
@AbapCatalog.sqlViewName: 'PCOMONRELCBASE'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_Comonavg_Relconrate_Base
  as select from I_PurchaseContractHistory as PurchaseContractHistory
    inner join   I_PurchaseContract        as _PurchaseContract on PurchaseContractHistory.PurchaseContract = _PurchaseContract.PurchaseContract
  //inner join I_SAPClient as sapClient

  //on PurchaseContractHistory.mandt = sapClient.sapclient

{
  key PurchaseContractHistory.PurchaseContract,

  key PurchaseContractHistory.PurchaseContractItem,

  key PurchaseContractHistory.ReleaseOrder,

  key PurchaseContractHistory.ReleaseOrderItem,

      PurchaseContractHistory.ReleaseOrderItemOrderQuantity,

      @Semantics.amount.currencyCode: 'ReleaseOrderCurrency'
      @DefaultAggregation: #NONE
      case ReleaseOrderCurrency
      //      when sapClient.GroupCurrency

          when _PurchaseContract.DocumentCurrency
          then ReleaseOrderItemNetAmount
        else currency_conversion (
             amount             => PurchaseContractHistory.ReleaseOrderItemNetAmount,
             source_currency    => PurchaseContractHistory.ReleaseOrderCurrency,
             target_currency    => _PurchaseContract.DocumentCurrency,
      //           target_currency    => sapClient.GroupCurrency,

             exchange_rate_date => cast( substring( cast( tstmp_current_utctimestamp() as abap.char(17) ), 1, 8 ) as abap.dats),//ReleaseOrderDate

             exchange_rate_type => 'M' ,
             error_handling     => 'FAIL_ON_ERROR' )
      end                                                     as ReleaseOrderItemNetAmount,

      PurchaseContractHistory.ReleaseOrderItemQuantityUnit,

      PurchaseContractHistory.ReleaseOrderCurrency,

      cast(PurchaseContractHistory.ReleaseOrderDate as bedat) as ReleaseOrderDate,

      cast(ReleaseOrderItemLastChgDate as aedat)              as ReleaseOrderItemLastChgDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTHISTORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More