I_TrdgContrSlsPrcgElmnt

DDL: I_TRDGCONTRSLSPRCGELMNT Type: view_entity COMPOSITE
55 Fields 1 Data Sources 1 Associations

Sales PrgElm of Trading Contract

I_TrdgContrSlsPrcgElmnt is a Composite CDS View that provides data about "Sales PrgElm of Trading Contract" in SAP S/4HANA. It reads from 1 data source (R_TrdgContrSlsPrcgElmnt) and exposes 55 fields with key fields TradingContract, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

SAP Help Documentation

CategoryGlobal Trade Management
Purpose
This CDS view contains information about the pricing elements on the sales side on header level of a trading contract. This CDS view provides the data to answer the following business questions: What is the sales price for every item in the trading contract? How much tax is deducted for all the items in the trading contract? How high is my overall profit margin? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: W_WBHK_TCT (Trading Contract: Authorization for Trading Contract Type) W_WBHK_ORG (Trading Contract: Authorization for Organizational Data) V_KNA1_BRG (Customer: Account Authorization for Sales Areas) F_LFA1_BEK (Vendor: Account Authorization)

Structure
Fields Used for Filtering The main filters are as follows: TradingContract : This field is used to filter for the number of a trading contract. ConditionType : This field is used to filter for the condition type. Further Important Fields Important fields in this view include the following: Field Name Description PricingProcedureStep Step Number PricingProcedureCounter Pricing Condition Counter

Constraints
This CDS view only provides information about the sales pricing elements on header level. Data for purchasing pricing elements on header level can be retrieved from the Purchasing Pricing Element for Trading Contract view. Data for sales pricing elements on item level can be retrieved from the Sales Pricing Element for Trading Contract Item view.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_TrdgContrSlsPrcgElmnt TrdgContrSlsPrcgElmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TrdgContr _TrdgContr $projection.TradingContract = _TrdgContr.TradingContract

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales PrgElm of Trading Contract view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY TradingContract TradingContract
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType ConditionCalculationType Calculat.Type
CndnIsAcctDetnRelevant CndnIsAcctDetnRelevant Acct Detn Relevant
ConditionBaseAmount ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity ConditionBaseQuantity Quantity
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionRateRatio ConditionRateRatio Ratio
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionCurrency ConditionCurrency Currency
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionCategory ConditionCategory Condit.Category
ConditionIsForStatistics ConditionIsForStatistics Statistical
IsRelevantForAccrual IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin ConditionOrigin Condit.Origin
IsGroupCondition IsGroupCondition Group Condition
TaxCode TaxCode Tax Code
WithholdingTaxCode WithholdingTaxCode WTax Code
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmount ConditionAmount Condition Value
TransactionCurrency TransactionCurrency Transaction Currency
ConditionControl ConditionControl Cond.Control
ConditionInactiveReason ConditionInactiveReason Inactive
ConditionClass ConditionClass Condition Class
PrcgProcedureCounterForHeader PrcgProcedureCounterForHeader Pricing Procedure Counter for Header
FactorForConditionBasisValue FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleType PricingScaleType Scale Type
PricingScaleBasis PricingScaleBasis Scale Basis
ConditionScaleBaseAmount ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity ConditionScaleBaseQuantity Scale Base Qu.
ConditionScaleBasisUnit ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency ConditionScaleBasisCurrency Scale Currency
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionIsForConfiguration ConditionIsForConfiguration UsedfVarConfig
VariantCondition VariantCondition Variant Key
ConditionBasisLimitExceeded ConditionBasisLimitExceeded Max Basis Value
ConditionAmountLimitExceeded ConditionAmountLimitExceeded Maximum Amount
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue Condit. Update
TaxCountry TaxCountry Tax Ctry/Reg.
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy Cumulative Condition Value
ExpenseSupplier ExpenseSupplier Expense Supplier
PriceDetnExchangeRate PriceDetnExchangeRate Exchange Rate
_TrdgContr _TrdgContr

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 I_TrdgContrSlsPrcgElmnt.
-- 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 I_TrdgContrSlsPrcgElmnt AS
SELECT
  TradingContract,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  CndnIsAcctDetnRelevant,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionCategory,
  ConditionIsForStatistics,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  TaxCode,
  WithholdingTaxCode,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  ConditionInactiveReason,
  ConditionClass,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleType,
  PricingScaleBasis,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  CndnIsRelevantForIntcoBilling,
  ConditionIsManuallyChanged,
  ConditionIsForConfiguration,
  VariantCondition,
  ConditionBasisLimitExceeded,
  ConditionAmountLimitExceeded,
  CndnIsRelevantForLimitValue,
  TaxCountry,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  ConditionAlternativeCurrency,
  ConditionAmountInLocalCrcy,
  ExpenseSupplier,
  PriceDetnExchangeRate
FROM R_TrdgContrSlsPrcgElmnt AS TrdgContrSlsPrcgElmnt
LEFT OUTER JOIN I_TrdgContr AS _TrdgContr ON TradingContract = _TrdgContr.TradingContract  -- association [1..1]
;

Learn More