R_TrdgDocPurgPrcgElmnt

DDL: R_TRDGDOCPURGPRCGELMNT Type: view_entity COMPOSITE
81 Fields 2 Data Sources 1 Associations

Purg Prcg Elmnt for Trading Document

R_TrdgDocPurgPrcgElmnt is a Composite CDS View that provides data about "Purg Prcg Elmnt for Trading Document" in SAP S/4HANA. It reads from 2 data sources (P_PurgPrcgElmntItmGrpTF, P_TrdgDocPurgPrcgElmnt) and exposes 81 fields with key fields TradingDocument, PurgPrcgElmntItemGroupValue, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_PurgPrcgElmntItmGrpTF P_PurgPrcgElmntItmGrpTF inner
P_TrdgDocPurgPrcgElmnt TrdgDocPurgPrcgElmnt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TrdgDoc _TrdgDoc $projection.TradingDocument = _TrdgDoc.TradingDocument

Annotations (9)

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

Fields (81)

KeyFieldSource TableSource FieldDescription
KEY TradingDocument P_TrdgDocPurgPrcgElmnt TradingDocument
KEY PurgPrcgElmntItemGroupValue
KEY PricingProcedureStep P_TrdgDocPurgPrcgElmnt PricingProcedureStep Step Number
KEY PricingProcedureCounter P_TrdgDocPurgPrcgElmnt PricingProcedureCounter Pricing Procedure Counter
PricingDocument P_TrdgDocPurgPrcgElmnt PricingDocument Document Condition
ConditionApplication P_TrdgDocPurgPrcgElmnt ConditionApplication Application
ConditionType P_TrdgDocPurgPrcgElmnt ConditionType Condition type
PriceConditionDeterminationDte P_TrdgDocPurgPrcgElmnt PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType P_TrdgDocPurgPrcgElmnt ConditionCalculationType Calculat.Type
ConditionBaseAmount P_TrdgDocPurgPrcgElmnt ConditionBaseAmount Condition Basis Amount
ConditionRateAmount P_TrdgDocPurgPrcgElmnt ConditionRateAmount Condition Amount
ConditionRateRatio P_TrdgDocPurgPrcgElmnt ConditionRateRatio Ratio
ConditionRateRatioUnit P_TrdgDocPurgPrcgElmnt ConditionRateRatioUnit Unit of Measure
ConditionCurrency P_TrdgDocPurgPrcgElmnt ConditionCurrency Currency
ConditionQuantityUnit P_TrdgDocPurgPrcgElmnt ConditionQuantityUnit Unit of Measure
ConditionCategory P_TrdgDocPurgPrcgElmnt ConditionCategory Condit.Category
ConditionIsForStatistics P_TrdgDocPurgPrcgElmnt ConditionIsForStatistics Statistical
IsRelevantForAccrual P_TrdgDocPurgPrcgElmnt IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList P_TrdgDocPurgPrcgElmnt CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin P_TrdgDocPurgPrcgElmnt ConditionOrigin Condit.Origin
IsGroupCondition P_TrdgDocPurgPrcgElmnt IsGroupCondition Group Condition
ConditionRecord P_TrdgDocPurgPrcgElmnt ConditionRecord Cond.Record No.
ConditionSequentialNumber P_TrdgDocPurgPrcgElmnt ConditionSequentialNumber SequNo of Cond.
TaxCode P_TrdgDocPurgPrcgElmnt TaxCode Tax Code
WithholdingTaxCode P_TrdgDocPurgPrcgElmnt WithholdingTaxCode WTax Code
CndnRoundingOffDiffAmount P_TrdgDocPurgPrcgElmnt CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmount P_TrdgDocPurgPrcgElmnt ConditionAmount Condition Value
TransactionCurrency P_TrdgDocPurgPrcgElmnt TransactionCurrency Transaction Currency
ConditionControl P_TrdgDocPurgPrcgElmnt ConditionControl Cond.Control
ConditionInactiveReason P_TrdgDocPurgPrcgElmnt ConditionInactiveReason Inactive
ConditionClass P_TrdgDocPurgPrcgElmnt ConditionClass Condition Class
PrcgProcedureCounterForHeader P_TrdgDocPurgPrcgElmnt PrcgProcedureCounterForHeader Pricing Procedure Counter for Header
FactorForConditionBasisValue P_TrdgDocPurgPrcgElmnt FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition P_TrdgDocPurgPrcgElmnt StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue P_TrdgDocPurgPrcgElmnt PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleType P_TrdgDocPurgPrcgElmnt PricingScaleType Scale Type
PricingScaleBasis P_TrdgDocPurgPrcgElmnt PricingScaleBasis Scale Basis
ConditionScaleBaseAmount P_TrdgDocPurgPrcgElmnt ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity P_TrdgDocPurgPrcgElmnt ConditionScaleBaseQuantity Scale Base Qu.
ConditionScaleBasisUnit P_TrdgDocPurgPrcgElmnt ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency P_TrdgDocPurgPrcgElmnt ConditionScaleBasisCurrency Scale Currency
CndnIsRelevantForIntcoBilling P_TrdgDocPurgPrcgElmnt CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionIsManuallyChanged P_TrdgDocPurgPrcgElmnt ConditionIsManuallyChanged Changed Manual.
ConditionIsForConfiguration P_TrdgDocPurgPrcgElmnt ConditionIsForConfiguration UsedfVarConfig
VariantCondition P_TrdgDocPurgPrcgElmnt VariantCondition Variant Key
ConditionBasisLimitExceeded P_TrdgDocPurgPrcgElmnt ConditionBasisLimitExceeded Max Basis Value
ConditionAmountLimitExceeded P_TrdgDocPurgPrcgElmnt ConditionAmountLimitExceeded Maximum Amount
CndnIsRelevantForLimitValue P_TrdgDocPurgPrcgElmnt CndnIsRelevantForLimitValue Condit. Update
TaxCountry P_TrdgDocPurgPrcgElmnt TaxCountry Tax Ctry/Reg.
ConditionToBaseQtyNmrtr P_TrdgDocPurgPrcgElmnt ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr P_TrdgDocPurgPrcgElmnt ConditionToBaseQtyDnmntr Denominator
CndnIsAcctDetnRelevant P_TrdgDocPurgPrcgElmnt CndnIsAcctDetnRelevant Acct Detn Relevant
AccountKeyForGLAccount P_TrdgDocPurgPrcgElmnt AccountKeyForGLAccount Account Key
GLAccount P_TrdgDocPurgPrcgElmnt GLAccount General Ledger
AcctKeyForAccrualsGLAccount P_TrdgDocPurgPrcgElmnt AcctKeyForAccrualsGLAccount Accruals
AccrualsGLAccount P_TrdgDocPurgPrcgElmnt AccrualsGLAccount Accruals Acc.
ConditionAlternativeCurrency P_TrdgDocPurgPrcgElmnt ConditionAlternativeCurrency Cndn Currency
ConditionAmountInLocalCrcy P_TrdgDocPurgPrcgElmnt ConditionAmountInLocalCrcy Cumulative Condition Value
ExpenseSupplier P_TrdgDocPurgPrcgElmnt ExpenseSupplier Expense Supplier
PriceDetnExchangeRate P_TrdgDocPurgPrcgElmnt PriceDetnExchangeRate Exchange Rate
_TrdgDoc _TrdgDoc
_ConditionApplication P_TrdgDocPurgPrcgElmnt _ConditionApplication
_PricingConditionType P_TrdgDocPurgPrcgElmnt _PricingConditionType
_ConditionCalculationType P_TrdgDocPurgPrcgElmnt _ConditionCalculationType
_ConditionCurrency P_TrdgDocPurgPrcgElmnt _ConditionCurrency
_Currency P_TrdgDocPurgPrcgElmnt _Currency
_ConditionQuantityUnit P_TrdgDocPurgPrcgElmnt _ConditionQuantityUnit
_ConditionCategory P_TrdgDocPurgPrcgElmnt _ConditionCategory
_ConditionOrigin P_TrdgDocPurgPrcgElmnt _ConditionOrigin
_ConditionControl P_TrdgDocPurgPrcgElmnt _ConditionControl
_ConditionInactiveReason P_TrdgDocPurgPrcgElmnt _ConditionInactiveReason
_ConditionClass P_TrdgDocPurgPrcgElmnt _ConditionClass
_PricingScaleBasis P_TrdgDocPurgPrcgElmnt _PricingScaleBasis
_ScaleUnitOfMeasure P_TrdgDocPurgPrcgElmnt _ScaleUnitOfMeasure
_ScaleCurrency P_TrdgDocPurgPrcgElmnt _ScaleCurrency
_VariantCondition P_TrdgDocPurgPrcgElmnt _VariantCondition
_StructureCondition P_TrdgDocPurgPrcgElmnt _StructureCondition
_ConditionBasisLimitExceeded P_TrdgDocPurgPrcgElmnt _ConditionBasisLimitExceeded
_ConditionAmountLimitExceeded P_TrdgDocPurgPrcgElmnt _ConditionAmountLimitExceeded
_ConditionAlternativeCurrency P_TrdgDocPurgPrcgElmnt _ConditionAlternativeCurrency
_Supplier P_TrdgDocPurgPrcgElmnt _Supplier

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_TrdgDocPurgPrcgElmnt.
-- 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_TrdgDocPurgPrcgElmnt AS
SELECT
  TrdgDocPurgPrcgElmnt.TradingDocument AS TradingDocument,
  cast( PurgPrcgElmntItmGrpTF.ItemGroup as wb2_item_group preserving type ) AS PurgPrcgElmntItemGroupValue,
  TrdgDocPurgPrcgElmnt.PricingProcedureStep AS PricingProcedureStep,
  TrdgDocPurgPrcgElmnt.PricingProcedureCounter AS PricingProcedureCounter,
  TrdgDocPurgPrcgElmnt.PricingDocument AS PricingDocument,
  TrdgDocPurgPrcgElmnt.ConditionApplication AS ConditionApplication,
  TrdgDocPurgPrcgElmnt.ConditionType AS ConditionType,
  TrdgDocPurgPrcgElmnt.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  TrdgDocPurgPrcgElmnt.ConditionCalculationType AS ConditionCalculationType,
  TrdgDocPurgPrcgElmnt.ConditionBaseAmount AS ConditionBaseAmount,
  TrdgDocPurgPrcgElmnt.ConditionRateAmount AS ConditionRateAmount,
  TrdgDocPurgPrcgElmnt.ConditionRateRatio AS ConditionRateRatio,
  TrdgDocPurgPrcgElmnt.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  TrdgDocPurgPrcgElmnt.ConditionCurrency AS ConditionCurrency,
  TrdgDocPurgPrcgElmnt.ConditionQuantityUnit AS ConditionQuantityUnit,
  TrdgDocPurgPrcgElmnt.ConditionCategory AS ConditionCategory,
  TrdgDocPurgPrcgElmnt.ConditionIsForStatistics AS ConditionIsForStatistics,
  TrdgDocPurgPrcgElmnt.IsRelevantForAccrual AS IsRelevantForAccrual,
  TrdgDocPurgPrcgElmnt.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  TrdgDocPurgPrcgElmnt.ConditionOrigin AS ConditionOrigin,
  TrdgDocPurgPrcgElmnt.IsGroupCondition AS IsGroupCondition,
  TrdgDocPurgPrcgElmnt.ConditionRecord AS ConditionRecord,
  TrdgDocPurgPrcgElmnt.ConditionSequentialNumber AS ConditionSequentialNumber,
  TrdgDocPurgPrcgElmnt.TaxCode AS TaxCode,
  TrdgDocPurgPrcgElmnt.WithholdingTaxCode AS WithholdingTaxCode,
  TrdgDocPurgPrcgElmnt.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  TrdgDocPurgPrcgElmnt.ConditionAmount AS ConditionAmount,
  TrdgDocPurgPrcgElmnt.TransactionCurrency AS TransactionCurrency,
  TrdgDocPurgPrcgElmnt.ConditionControl AS ConditionControl,
  TrdgDocPurgPrcgElmnt.ConditionInactiveReason AS ConditionInactiveReason,
  TrdgDocPurgPrcgElmnt.ConditionClass AS ConditionClass,
  TrdgDocPurgPrcgElmnt.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  TrdgDocPurgPrcgElmnt.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  TrdgDocPurgPrcgElmnt.StructureCondition AS StructureCondition,
  TrdgDocPurgPrcgElmnt.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  TrdgDocPurgPrcgElmnt.PricingScaleType AS PricingScaleType,
  TrdgDocPurgPrcgElmnt.PricingScaleBasis AS PricingScaleBasis,
  TrdgDocPurgPrcgElmnt.ConditionScaleBaseAmount AS ConditionScaleBaseAmount,
  TrdgDocPurgPrcgElmnt.ConditionScaleBaseQuantity AS ConditionScaleBaseQuantity,
  TrdgDocPurgPrcgElmnt.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  TrdgDocPurgPrcgElmnt.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  TrdgDocPurgPrcgElmnt.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  TrdgDocPurgPrcgElmnt.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  TrdgDocPurgPrcgElmnt.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  TrdgDocPurgPrcgElmnt.VariantCondition AS VariantCondition,
  TrdgDocPurgPrcgElmnt.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  TrdgDocPurgPrcgElmnt.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  TrdgDocPurgPrcgElmnt.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  TrdgDocPurgPrcgElmnt.TaxCountry AS TaxCountry,
  TrdgDocPurgPrcgElmnt.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  TrdgDocPurgPrcgElmnt.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  TrdgDocPurgPrcgElmnt.CndnIsAcctDetnRelevant AS CndnIsAcctDetnRelevant,
  TrdgDocPurgPrcgElmnt.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  TrdgDocPurgPrcgElmnt.GLAccount AS GLAccount,
  TrdgDocPurgPrcgElmnt.AcctKeyForAccrualsGLAccount AS AcctKeyForAccrualsGLAccount,
  TrdgDocPurgPrcgElmnt.AccrualsGLAccount AS AccrualsGLAccount,
  TrdgDocPurgPrcgElmnt.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  TrdgDocPurgPrcgElmnt.ConditionAmountInLocalCrcy AS ConditionAmountInLocalCrcy,
  TrdgDocPurgPrcgElmnt.ExpenseSupplier AS ExpenseSupplier,
  TrdgDocPurgPrcgElmnt.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  TrdgDocPurgPrcgElmnt._ConditionApplication AS _ConditionApplication,
  TrdgDocPurgPrcgElmnt._PricingConditionType AS _PricingConditionType,
  TrdgDocPurgPrcgElmnt._ConditionCalculationType AS _ConditionCalculationType,
  TrdgDocPurgPrcgElmnt._ConditionCurrency AS _ConditionCurrency,
  TrdgDocPurgPrcgElmnt._Currency AS _Currency,
  TrdgDocPurgPrcgElmnt._ConditionQuantityUnit AS _ConditionQuantityUnit,
  TrdgDocPurgPrcgElmnt._ConditionCategory AS _ConditionCategory,
  TrdgDocPurgPrcgElmnt._ConditionOrigin AS _ConditionOrigin,
  TrdgDocPurgPrcgElmnt._ConditionControl AS _ConditionControl,
  TrdgDocPurgPrcgElmnt._ConditionInactiveReason AS _ConditionInactiveReason,
  TrdgDocPurgPrcgElmnt._ConditionClass AS _ConditionClass,
  TrdgDocPurgPrcgElmnt._PricingScaleBasis AS _PricingScaleBasis,
  TrdgDocPurgPrcgElmnt._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  TrdgDocPurgPrcgElmnt._ScaleCurrency AS _ScaleCurrency,
  TrdgDocPurgPrcgElmnt._VariantCondition AS _VariantCondition,
  TrdgDocPurgPrcgElmnt._StructureCondition AS _StructureCondition,
  TrdgDocPurgPrcgElmnt._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  TrdgDocPurgPrcgElmnt._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  TrdgDocPurgPrcgElmnt._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  TrdgDocPurgPrcgElmnt._Supplier AS _Supplier
FROM P_TrdgDocPurgPrcgElmnt AS TrdgDocPurgPrcgElmnt
INNER JOIN P_PurgPrcgElmntItmGrpTF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_TrdgDoc AS _TrdgDoc ON TradingDocument = _TrdgDoc.TradingDocument  -- association [1..1]
;

Learn More