R_TrdgContrPurgPrcgElmnt

DDL: R_TRDGCONTRPURGPRCGELMNT Type: view_entity COMPOSITE
64 Fields 1 Data Sources 1 Associations

Purg Prcg Elmnt for Trading Contract

R_TrdgContrPurgPrcgElmnt is a Composite CDS View that provides data about "Purg Prcg Elmnt for Trading Contract" in SAP S/4HANA. It reads from 1 data source (R_TrdgDocPurgPrcgElmnt) and exposes 64 fields with key fields TradingContract, PurgPrcgElmntItemGroupValue, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_TrdgDocPurgPrcgElmnt TrdgDocPurgPrcgElmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgContr _TradingContract $projection.TradingContract = _TradingContract.TradingContract

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purg Prcg Elmnt for Trading Contract view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY TradingContract TradingDocument
KEY PurgPrcgElmntItemGroupValue PurgPrcgElmntItemGroupValue
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
PricingDocument PricingDocument Document Condition
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType ConditionCalculationType Calculat.Type
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
ConditionRecord ConditionRecord Cond.Record No.
ConditionSequentialNumber ConditionSequentialNumber SequNo of Cond.
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
CndnIsAcctDetnRelevant CndnIsAcctDetnRelevant Acct Detn Relevant
AccountKeyForGLAccount AccountKeyForGLAccount Account Key
GLAccount GLAccount General Ledger
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount Accruals
AccrualsGLAccount AccrualsGLAccount Accruals Acc.
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy Cumulative Condition Value
ExpenseSupplier ExpenseSupplier Expense Supplier
PriceDetnExchangeRate PriceDetnExchangeRate Exchange Rate
TradingContractCategory _TradingContract TradingContractCategory
_TradingContract _TradingContract

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_TrdgContrPurgPrcgElmnt.
-- 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_TrdgContrPurgPrcgElmnt AS
SELECT
  TradingDocument AS TradingContract,
  PurgPrcgElmntItemGroupValue,
  PricingProcedureStep,
  PricingProcedureCounter,
  PricingDocument,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  ConditionBaseAmount,
  ConditionBaseQuantity,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionCategory,
  ConditionIsForStatistics,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  ConditionRecord,
  ConditionSequentialNumber,
  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,
  CndnIsAcctDetnRelevant,
  AccountKeyForGLAccount,
  GLAccount,
  AcctKeyForAccrualsGLAccount,
  AccrualsGLAccount,
  ConditionAlternativeCurrency,
  ConditionAmountInLocalCrcy,
  ExpenseSupplier,
  PriceDetnExchangeRate,
  _TradingContract.TradingContractCategory AS TradingContractCategory
FROM R_TrdgDocPurgPrcgElmnt AS TrdgDocPurgPrcgElmnt
LEFT OUTER JOIN R_TrdgContr AS _TradingContract ON TradingContract = _TradingContract.TradingContract  -- association [1..1]
;

Learn More