R_SlsContrPricingElementTP

DDL: R_SLSCONTRPRICINGELEMENTTP Type: view_entity TRANSACTIONAL
36 Fields 1 Data Sources

Pricing Elemnt for Sls Contr - TP

R_SlsContrPricingElementTP is a Transactional CDS View that provides data about "Pricing Elemnt for Sls Contr - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesContractPricingElement) and exposes 36 fields with key fields SalesContract, PricingProcedureStep, PricingProcedureCounter.

Data Sources (1)

SourceAliasJoin Type
I_SalesContractPricingElement SalesContractPrcgElmnt from

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 - TP view

Fields (36)

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

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_SlsContrPricingElementTP.
-- 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_SlsContrPricingElementTP AS
SELECT
  SalesContractPrcgElmnt.SalesContract AS SalesContract,
  SalesContractPrcgElmnt.PricingProcedureStep AS PricingProcedureStep,
  SalesContractPrcgElmnt.PricingProcedureCounter AS PricingProcedureCounter,
  SalesContractPrcgElmnt.ConditionApplication AS ConditionApplication,
  SalesContractPrcgElmnt.ConditionType AS ConditionType,
  SalesContractPrcgElmnt._PricingConditionType._Text_2[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  SalesContractPrcgElmnt.ConditionCalculationType AS ConditionCalculationType,
  SalesContractPrcgElmnt.ConditionRateAmount AS ConditionRateAmount,
  SalesContractPrcgElmnt.ConditionRateRatio AS ConditionRateRatio,
  SalesContractPrcgElmnt.ConditionBaseAmount AS ConditionBaseAmount,
  SalesContractPrcgElmnt.ConditionBaseQuantity AS ConditionBaseQuantity,
  SalesContractPrcgElmnt.ConditionQuantity AS ConditionQuantity,
  SalesContractPrcgElmnt.ConditionAmount AS ConditionAmount,
  SalesContractPrcgElmnt.ConditionCurrency AS ConditionCurrency,
  SalesContractPrcgElmnt.TransactionCurrency AS TransactionCurrency,
  SalesContractPrcgElmnt.ConditionQuantityUnit AS ConditionQuantityUnit,
  SalesContractPrcgElmnt.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  SalesContractPrcgElmnt.ConditionIsForStatistics AS ConditionIsForStatistics,
  SalesContractPrcgElmnt.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  SalesContractPrcgElmnt.ConditionInactiveReason AS ConditionInactiveReason,
  SalesContractPrcgElmnt.ConditionClass AS ConditionClass,
  SalesContractPrcgElmnt.ConditionOrigin AS ConditionOrigin,
  _SalesContract.SalesContractType AS SalesContractType,
  _SalesContract.SalesOrganization AS SalesOrganization,
  _SalesContract.DistributionChannel AS DistributionChannel,
  _SalesContract.OrganizationDivision AS OrganizationDivision,
  SalesContractPrcgElmnt._ConditionApplication AS _ConditionApplication,
  SalesContractPrcgElmnt._PricingConditionType AS _PricingConditionType,
  SalesContractPrcgElmnt._ConditionCurrency AS _ConditionCurrency,
  SalesContractPrcgElmnt._Currency AS _TransactionCurrency,
  SalesContractPrcgElmnt._ConditionQuantityUnit AS _ConditionQuantityUnit,
  SalesContractPrcgElmnt._ConditionInactiveReason AS _ConditionInactiveReason,
  SalesContractPrcgElmnt._ConditionClass AS _ConditionClass,
  SalesContractPrcgElmnt._ConditionOrigin AS _ConditionOrigin,
  SalesContractPrcgElmnt._ConditionRateRatioUnit AS _ConditionRateRatioUnit
FROM I_SalesContractPricingElement AS SalesContractPrcgElmnt
;

Learn More