A_CustRetPrcgElmntSimulation

DDL: A_CUSTRETPRCGELMNTSIMULATION Type: view_entity COMPOSITE

Header Pricing Element Simulation

A_CustRetPrcgElmntSimulation is a Composite CDS View that provides data about "Header Pricing Element Simulation" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_PricingElement) and exposes 43 fields with key fields CustomerReturn, PricingProcedureStep, PricingProcedureCounter.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CustomerReturn inner
I_PricingElement PricingElement from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Header Pricing Element Simulation view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_SalesDocumentBasic SalesDocument
KEY PricingProcedureStep I_PricingElement PricingProcedureStep
KEY PricingProcedureCounter I_PricingElement PricingProcedureCounter
ConditionType I_PricingElement ConditionType
PriceConditionDeterminationDte I_PricingElement PriceConditionDeterminationDte
ConditionCalculationType I_PricingElement ConditionCalculationType
ConditionBaseValue I_PricingElement ConditionBaseValue
ConditionRateValue I_PricingElement ConditionRateValue
ConditionCurrency I_PricingElement ConditionCurrency
ConditionQuantity I_PricingElement ConditionQuantity
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit
ConditionCategory I_PricingElement ConditionCategory
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics
PricingScaleType I_PricingElement PricingScaleType
ConditionOrigin I_PricingElement ConditionOrigin
IsGroupCondition I_PricingElement IsGroupCondition
ConditionRecord I_PricingElement ConditionRecord
ConditionSequentialNumber I_PricingElement ConditionSequentialNumber
TaxCode I_PricingElement TaxCode
WithholdingTaxCode I_PricingElement WithholdingTaxCode
CndnRoundingOffDiffAmount I_PricingElement CndnRoundingOffDiffAmount
ConditionAmount I_PricingElement ConditionAmount
TransactionCurrency I_PricingElement TransactionCurrency
ConditionControl I_PricingElement ConditionControl
ConditionInactiveReason I_PricingElement ConditionInactiveReason
ConditionClass I_PricingElement ConditionClass
PrcgProcedureCounterForHeader I_PricingElement PrcgProcedureCounterForHeader
FactorForConditionBasisValue I_PricingElement FactorForConditionBasisValue
StructureCondition I_PricingElement StructureCondition
PeriodFactorForCndnBasisValue I_PricingElement PeriodFactorForCndnBasisValue
PricingScaleBasis I_PricingElement PricingScaleBasis
ConditionScaleBasisValue I_PricingElement ConditionScaleBasisValue
ConditionScaleBasisUnit I_PricingElement ConditionScaleBasisUnit
ConditionScaleBasisCurrency I_PricingElement ConditionScaleBasisCurrency
CndnIsRelevantForIntcoBilling I_PricingElement CndnIsRelevantForIntcoBilling
ConditionIsManuallyChanged I_PricingElement ConditionIsManuallyChanged
ConditionIsForConfiguration I_PricingElement ConditionIsForConfiguration
VariantCondition I_PricingElement VariantCondition
CustomerReturnType I_SalesDocumentBasic SalesDocumentType
OrganizationDivision I_SalesDocumentBasic OrganizationDivision
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
_CustomerReturn _CustomerReturn
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Header Pricing Element Simulation'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity A_CustRetPrcgElmntSimulation as select from I_PricingElement as PricingElement
                                                inner join I_SalesDocumentBasic as CustomerReturn on CustomerReturn.SalesDocumentCondition = PricingElement.PricingDocument
                                                                                                  and CustomerReturn.SDDocumentCategory = 'H' 
                                                                                                  
                                                association to parent A_CustomerReturnSimulation   as _CustomerReturn on _CustomerReturn.CustomerReturn = $projection.CustomerReturn
{
      @ObjectModel.readOnly: true
  key CustomerReturn.SalesDocument as CustomerReturn,
      @ObjectModel.readOnly: true
  key PricingElement.PricingProcedureStep,
      @ObjectModel.readOnly: true
  key PricingElement.PricingProcedureCounter,

      PricingElement.ConditionType,

      @ObjectModel.readOnly: true
      PricingElement.PriceConditionDeterminationDte,

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionCalculationType'
      PricingElement.ConditionCalculationType,

      @ObjectModel.readOnly: true
      PricingElement.ConditionBaseValue,

      PricingElement.ConditionRateValue,

      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      PricingElement.ConditionCurrency,

      //PriceDetnExchangeRate,

      
      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      PricingElement.ConditionQuantity,

      PricingElement.ConditionQuantityUnit,

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionCategory'
      PricingElement.ConditionCategory,

      @ObjectModel.readOnly: true
      PricingElement.ConditionIsForStatistics,

      @ObjectModel.readOnly: true
      PricingElement.PricingScaleType,

      @ObjectModel.readOnly: true      
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionOrigin'
      PricingElement.ConditionOrigin,

      @ObjectModel.readOnly: true
      PricingElement.IsGroupCondition,

      @ObjectModel.readOnly: true
      PricingElement.ConditionRecord,

      @ObjectModel.readOnly: true
      PricingElement.ConditionSequentialNumber,

      @ObjectModel.readOnly: true
      PricingElement.TaxCode,

      @ObjectModel.readOnly: true
      PricingElement.WithholdingTaxCode,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @ObjectModel.readOnly: true
      PricingElement.CndnRoundingOffDiffAmount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @ObjectModel.readOnly: true
      PricingElement.ConditionAmount,

      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      PricingElement.TransactionCurrency,

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionControl'
      PricingElement.ConditionControl,

      @ObjectModel.readOnly: true
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionInactiveReason'
      PricingElement.ConditionInactiveReason,

      @ObjectModel.readOnly: true      
      @ObjectModel.sapObjectNodeTypeReference: 'PriceConditionClass'
      PricingElement.ConditionClass,

      @ObjectModel.readOnly: true
      PricingElement.PrcgProcedureCounterForHeader,

      @ObjectModel.readOnly: true
      PricingElement.FactorForConditionBasisValue,

      @ObjectModel.readOnly: true      
      @ObjectModel.sapObjectNodeTypeReference: 'PricingStructureCondition'
      PricingElement.StructureCondition,

      @ObjectModel.readOnly: true
      PricingElement.PeriodFactorForCndnBasisValue,

      @ObjectModel.readOnly: true
      PricingElement.PricingScaleBasis,

      @ObjectModel.readOnly: true
      PricingElement.ConditionScaleBasisValue,

      @ObjectModel.readOnly: true
      PricingElement.ConditionScaleBasisUnit,

      @ObjectModel.readOnly: true
      PricingElement.ConditionScaleBasisCurrency,

      @ObjectModel.readOnly: true
      PricingElement.CndnIsRelevantForIntcoBilling,

      @ObjectModel.readOnly: true
      PricingElement.ConditionIsManuallyChanged,

      @ObjectModel.readOnly: true
      PricingElement.ConditionIsForConfiguration,

      @ObjectModel.readOnly: true
      PricingElement.VariantCondition,

      // For Access control

      @Consumption.hidden: true
      CustomerReturn.SalesDocumentType as CustomerReturnType,
      @Consumption.hidden: true
      CustomerReturn.OrganizationDivision,
      @Consumption.hidden: true
      CustomerReturn.SalesOrganization,
      @Consumption.hidden: true
      CustomerReturn.DistributionChannel,
      
      //Expose associations

      _CustomerReturn
} 
where PricingElement.PricingDocumentItem = '000000'
and   PricingElement.PricingDocument = '0'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRICINGELEMENT",
"I_SALESDOCUMENTBASIC"
],
"ASSOCIATED":
[
"A_CUSTOMERRETURNSIMULATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/