I_SALESORDERPRICINGELEMENT

CDS View

Sales Order Pricing Element

I_SALESORDERPRICINGELEMENT is a CDS View in S/4HANA. Sales Order Pricing Element. It contains 38 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 38 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SlsOrdPricingElementSimln_2 view_entity from CONSUMPTION Header Pricing Element Simulation
R_SalesOrderPricingElementTP view_entity from TRANSACTIONAL Sales Order Pricing Element - TP

Fields (38)

KeyField CDS FieldsUsed in Views
KEY PricingProcedureCounter PricingProcedureCounter 2
KEY PricingProcedureStep PricingProcedureStep 2
KEY SalesOrder SalesOrder 2
_ConditionApplication _ConditionApplication 1
_ConditionCalculationType _ConditionCalculationType 1
_ConditionClass _ConditionClass 1
_ConditionControl _ConditionControl 1
_ConditionCurrency _ConditionCurrency 1
_ConditionInactiveReason _ConditionInactiveReason 1
_ConditionOrigin _ConditionOrigin 1
_ConditionQuantityUnit _ConditionQuantityUnit 1
_ConditionRateRatioUnit _ConditionRateRatioUnit 1
_Currency _TransactionCurrency 1
_PricingConditionType _PricingConditionType 1
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount 2
ConditionAmount ConditionAmount 2
ConditionApplication ConditionApplication 1
ConditionBaseAmount ConditionBaseAmount 2
ConditionBaseQuantity ConditionBaseQuantity 2
ConditionCalculationType ConditionCalculationType 2
ConditionClass ConditionClass 2
ConditionControl ConditionControl 2
ConditionCurrency ConditionCurrency 2
ConditionInactiveReason ConditionInactiveReason 2
ConditionIsForStatistics ConditionIsForStatistics 2
ConditionIsManuallyChanged ConditionIsManuallyChanged 2
ConditionOrigin ConditionOrigin 2
ConditionQuantity ConditionQuantity 2
ConditionQuantityUnit ConditionQuantitySAPUnit,ConditionQuantityUnit 2
ConditionRateAmount ConditionRateAmount 2
ConditionRateRatio ConditionRateRatio 2
ConditionRateRatioUnit ConditionRateRatioSAPUnit,ConditionRateRatioUnit 2
ConditionType ConditionType 2
IsGroupCondition_2 IsGroupCondition 2
PriceConditionDeterminationDte PriceConditionDeterminationDte 1
TaxCode TaxCode 2
TransactionCurrency TransactionCurrency 2
VariantCondition VariantCondition 2 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Sales Order Pricing Element'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISDSLSORDPREL',
  compiler.compareFilter: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations: true

define view I_SalesOrderPricingElement as select from I_SalesDocumentPricingElement       as PricingElement
      
    association[1..1] to I_SalesOrder   as _SalesOrder   on $projection.SalesOrder  = _SalesOrder.SalesOrder
 
{
      @ObjectModel.foreignKey.association: '_SalesOrder'                                                                                                   
  key cast(SalesDocument as vdm_sales_order preserving type) as SalesOrder,  
  key PricingProcedureStep,
  key PricingProcedureCounter, 
      @ObjectModel.foreignKey.association: '_ConditionApplication'
      ConditionApplication, 
      @ObjectModel.foreignKey.association: '_PricingConditionType'
      ConditionType,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'PriceConditionDeterminationDte'
      PricingDateTime,
      PriceConditionDeterminationDte,
      @ObjectModel.foreignKey.association: '_ConditionCalculationType'
      ConditionCalculationType,
      ConditionBaseValue,
      ConditionRateValue,
      @ObjectModel.foreignKey.association: '_ConditionCurrency'
      ConditionCurrency,
      @DefaultAggregation:#NONE
      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      ConditionQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ConditionQuantityUnit'
      ConditionQuantityUnit,
      @ObjectModel.foreignKey.association: '_ConditionCategory'
      ConditionCategory,
      ConditionIsForStatistics,
      PricingScaleType,
      IsRelevantForAccrual,
      CndnIsRelevantForInvoiceList,
      @ObjectModel.foreignKey.association: '_ConditionOrigin'
      ConditionOrigin,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'IsGroupCondition_2'
      IsGroupCondition,
      IsGroupCondition_2,
      ConditionRecord,
      ConditionSequentialNumber,
      TaxCode,
      WithholdingTaxCode,
      @DefaultAggregation:#NONE
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CndnRoundingOffDiffAmount,
      @DefaultAggregation:#NONE
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ConditionAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_Currency'
      TransactionCurrency,
      @ObjectModel.foreignKey.association: '_ConditionControl'
      ConditionControl,
      @ObjectModel.foreignKey.association: '_ConditionInactiveReason'
      ConditionInactiveReason,
      @ObjectModel.foreignKey.association: '_ConditionClass'
      ConditionClass,
      PrcgProcedureCounterForHeader,
      FactorForConditionBasisValue,
      @ObjectModel.foreignKey.association: '_StructureCondition'
      StructureCondition,
      PeriodFactorForCndnBasisValue,
      @ObjectModel.foreignKey.association: '_PricingScaleBasis'
      PricingScaleBasis,
      ConditionScaleBasisValue,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ScaleUnitOfMeasure'
      ConditionScaleBasisUnit,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_ScaleCurrency'
      ConditionScaleBasisCurrency,
      CndnIsRelevantForIntcoBilling,
      ConditionIsManuallyChanged,
      ConditionIsForConfiguration,
      VariantCondition,
      @Semantics.amount.currencyCode: 'ConditionCurrency'
      @OData.v2.amount.noDecimalShift: true
      ConditionRateAmount,
      @Semantics.quantity.unitOfMeasure: 'ConditionRateRatioUnit'
      ConditionRateRatio,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ConditionRateRatioUnit'
      ConditionRateRatioUnit,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @OData.v2.amount.noDecimalShift: true
      ConditionBaseAmount,
      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      ConditionBaseQuantity,  
      
      //Association

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _SalesOrder,
      _ConditionApplication,
      _PricingConditionType,
      _ConditionCalculationType,
      _ConditionCurrency,
      _Currency, 
      _ConditionQuantityUnit,
      _ConditionCategory,
      _ConditionOrigin,
      _ConditionControl,
      _ConditionInactiveReason,
      _ConditionClass,
      _PricingScaleBasis,
      _ScaleUnitOfMeasure, 
      _ScaleCurrency, 
      _VariantCondition,
      _StructureCondition,
      _ConditionRateRatioUnit

}
where SDDocumentCategory = 'C';

Learn More