R_SlsContrItemPricingElementTP

DDL: R_SLSCONTRITEMPRICINGELEMENTTP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources 1 Associations

Pricing Elemnt for Sls Contr Item - TP

R_SlsContrItemPricingElementTP is a Transactional CDS View that provides data about "Pricing Elemnt for Sls Contr Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SlsContrItemPricingElement) and exposes 39 fields with key fields SalesContract, SalesContractItem, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SlsContrItemPricingElement SalesContractItemPrcgElmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SalesContractTP _SalesContract $projection.SalesContract = _SalesContract.SalesContract

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Pricing Elemnt for Sls Contr Item - TP view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SalesContract I_SlsContrItemPricingElement SalesContract Sales Document
KEY SalesContractItem I_SlsContrItemPricingElement SalesContractItem Item
KEY PricingProcedureStep I_SlsContrItemPricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter I_SlsContrItemPricingElement PricingProcedureCounter Pricing Procedure Counter
ConditionApplication I_SlsContrItemPricingElement ConditionApplication Application
ConditionType I_SlsContrItemPricingElement ConditionType Condition type
ConditionTypeName
ConditionCalculationType I_SlsContrItemPricingElement ConditionCalculationType Calculat.Type
PriceConditionDeterminationDte I_SlsContrItemPricingElement PriceConditionDeterminationDte Condition Pricing Date
ConditionRateAmount I_SlsContrItemPricingElement ConditionRateAmount Condition Amount
ConditionRateRatio I_SlsContrItemPricingElement ConditionRateRatio Ratio
ConditionBaseAmount I_SlsContrItemPricingElement ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity I_SlsContrItemPricingElement ConditionBaseQuantity Quantity
ConditionQuantity I_SlsContrItemPricingElement ConditionQuantity Pricing Unit
ConditionAmount I_SlsContrItemPricingElement ConditionAmount Condition Value
ConditionCurrency I_SlsContrItemPricingElement ConditionCurrency Currency
TransactionCurrency I_SlsContrItemPricingElement TransactionCurrency Transaction Currency
ConditionQuantityUnit I_SlsContrItemPricingElement ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit I_SlsContrItemPricingElement ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics I_SlsContrItemPricingElement ConditionIsForStatistics Statistical
ConditionIsManuallyChanged I_SlsContrItemPricingElement ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason I_SlsContrItemPricingElement ConditionInactiveReason Inactive
ConditionClass I_SlsContrItemPricingElement ConditionClass Condition Class
ConditionOrigin I_SlsContrItemPricingElement ConditionOrigin Condit.Origin
SalesContractType _SalesContract SalesContractType
SalesOrganization _SalesContract SalesOrganization Sales Organization
DistributionChannel _SalesContract DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesContract OrganizationDivision Org. Division
_Item _Item
_SalesContract _SalesContract
_ConditionApplication I_SlsContrItemPricingElement _ConditionApplication
_PricingConditionType I_SlsContrItemPricingElement _PricingConditionType
_ConditionCurrency I_SlsContrItemPricingElement _ConditionCurrency
_TransactionCurrency I_SlsContrItemPricingElement _Currency
_ConditionQuantityUnit I_SlsContrItemPricingElement _ConditionQuantityUnit
_ConditionInactiveReason I_SlsContrItemPricingElement _ConditionInactiveReason
_ConditionCalculationType I_SlsContrItemPricingElement _ConditionCalculationType
_ConditionClass I_SlsContrItemPricingElement _ConditionClass
_ConditionOrigin I_SlsContrItemPricingElement _ConditionOrigin

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_SlsContrItemPricingElementTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_SlsContrItemPricingElementTP AS
SELECT
  SalesContractItemPrcgElmnt.SalesContract AS SalesContract,
  SalesContractItemPrcgElmnt.SalesContractItem AS SalesContractItem,
  SalesContractItemPrcgElmnt.PricingProcedureStep AS PricingProcedureStep,
  SalesContractItemPrcgElmnt.PricingProcedureCounter AS PricingProcedureCounter,
  SalesContractItemPrcgElmnt.ConditionApplication AS ConditionApplication,
  SalesContractItemPrcgElmnt.ConditionType AS ConditionType,
  SalesContractItemPrcgElmnt._PricingConditionType._Text_2[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  SalesContractItemPrcgElmnt.ConditionCalculationType AS ConditionCalculationType,
  SalesContractItemPrcgElmnt.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  SalesContractItemPrcgElmnt.ConditionRateAmount AS ConditionRateAmount,
  SalesContractItemPrcgElmnt.ConditionRateRatio AS ConditionRateRatio,
  SalesContractItemPrcgElmnt.ConditionBaseAmount AS ConditionBaseAmount,
  SalesContractItemPrcgElmnt.ConditionBaseQuantity AS ConditionBaseQuantity,
  SalesContractItemPrcgElmnt.ConditionQuantity AS ConditionQuantity,
  SalesContractItemPrcgElmnt.ConditionAmount AS ConditionAmount,
  SalesContractItemPrcgElmnt.ConditionCurrency AS ConditionCurrency,
  SalesContractItemPrcgElmnt.TransactionCurrency AS TransactionCurrency,
  SalesContractItemPrcgElmnt.ConditionQuantityUnit AS ConditionQuantityUnit,
  SalesContractItemPrcgElmnt.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  SalesContractItemPrcgElmnt.ConditionIsForStatistics AS ConditionIsForStatistics,
  SalesContractItemPrcgElmnt.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  SalesContractItemPrcgElmnt.ConditionInactiveReason AS ConditionInactiveReason,
  SalesContractItemPrcgElmnt.ConditionClass AS ConditionClass,
  SalesContractItemPrcgElmnt.ConditionOrigin AS ConditionOrigin,
  _SalesContract.SalesContractType AS SalesContractType,
  _SalesContract.SalesOrganization AS SalesOrganization,
  _SalesContract.DistributionChannel AS DistributionChannel,
  _SalesContract.OrganizationDivision AS OrganizationDivision,
  SalesContractItemPrcgElmnt._ConditionApplication AS _ConditionApplication,
  SalesContractItemPrcgElmnt._PricingConditionType AS _PricingConditionType,
  SalesContractItemPrcgElmnt._ConditionCurrency AS _ConditionCurrency,
  SalesContractItemPrcgElmnt._Currency AS _TransactionCurrency,
  SalesContractItemPrcgElmnt._ConditionQuantityUnit AS _ConditionQuantityUnit,
  SalesContractItemPrcgElmnt._ConditionInactiveReason AS _ConditionInactiveReason,
  SalesContractItemPrcgElmnt._ConditionCalculationType AS _ConditionCalculationType,
  SalesContractItemPrcgElmnt._ConditionClass AS _ConditionClass,
  SalesContractItemPrcgElmnt._ConditionOrigin AS _ConditionOrigin
FROM I_SlsContrItemPricingElement AS SalesContractItemPrcgElmnt
LEFT OUTER JOIN R_SalesContractTP AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- association [1..1]
;

Learn More