P_PurgInfoRecdPrcCalc

DDL: P_PURGINFORECDPRCCALC SQL: PPIRPRCCALC Type: view CONSUMPTION

Info Record Price Conversion

P_PurgInfoRecdPrcCalc is a Consumption CDS View that provides data about "Info Record Price Conversion" in SAP S/4HANA. It reads from 1 data source (I_PurInfCndPeriod) and exposes 9 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant, ConditionValidityEndDate.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_PurInfCndPeriod I_PurInfCndPeriod from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPIRPRCCALC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Info Record Price Conversion view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord PurchasingInfoRecord
KEY PurchasingOrganization PurchasingOrganization
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory
KEY Plant Plant
KEY ConditionValidityEndDate ConditionValidityEndDate
KEY ConditionRecord ConditionRecord
ConditionValidityStartDate ConditionValidityStartDate
ConditionType ConditionType
Currency _InfoRecord Currency 
@AbapCatalog.sqlViewName: 'PPIRPRCCALC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Info Record Price Conversion'

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:#REQUIRED

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

@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_PurgInfoRecdPrcCalc as select from I_PurInfCndPeriod {
    
  key PurchasingInfoRecord,

  key PurchasingOrganization,

  key PurchasingInfoRecordCategory,

  key Plant,

  key ConditionValidityEndDate,
  
  key ConditionRecord,
      ConditionValidityStartDate,
      ConditionType,
      _InfoRecord.Currency,
  case when ConditionQuantity > 0
       then division(currency_conversion(
        amount             => ConditionRateValue,
        source_currency    => ConditionRateValueUnit,
        target_currency    => _InfoRecord.Currency,
        exchange_rate_date => cast(substring(cast(ConditionValidityStartDate as abap.char(23)),1,8) as abap.dats ),
        exchange_rate_type => 'M',
        error_handling     => 'SET_TO_NULL'
        ) , ConditionQuantity,2)
        else
        currency_conversion(
        amount             => ConditionRateValue,
        source_currency    => ConditionRateValueUnit,
        target_currency    => _InfoRecord.Currency,
        exchange_rate_date => cast(substring(cast(ConditionValidityStartDate as abap.char(23)),1,8) as abap.dats ),
        exchange_rate_type => 'M',
        error_handling     => 'SET_TO_NULL'
        )
        end                                                                                                                       as     NetAmount
       
}
where ConditionSequentialNumber = '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURGINFORECORDWITHORGDATA",
"I_PURINFCNDPERIOD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More