P_PurgPrcgCndnRecdSuplmnt

DDL: P_PURGPRCGCNDNRECDSUPLMNT Type: view BASIC
43 Fields 2 Data Sources

P_PurgPrcgCndnRecdSuplmnt is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_PrcgCndnRecordHeader, P_PrcgCndnRecordItem) and exposes 43 fields with key fields ConditionRecord, ConditionSequentialNumber.

Data Sources (2)

SourceAliasJoin Type
P_PrcgCndnRecordHeader _Header from
P_PrcgCndnRecordItem _Item left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPURGPRCGCNDNSU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord P_PrcgCndnRecordItem ConditionRecord Cond.Record No.
KEY ConditionSequentialNumber P_PrcgCndnRecordItem ConditionSequentialNumber SequNo of Cond.
ConditionTable P_PrcgCndnRecordHeader ConditionTable Condition Table
ConditionApplication P_PrcgCndnRecordHeader ConditionApplication Application
ConditionType P_PrcgCndnRecordItem ConditionType Condition type
ConditionValidityEndDate P_PrcgCndnRecordHeader ConditionValidityEndDate Valid To
ConditionValidityStartDate P_PrcgCndnRecordHeader ConditionValidityStartDate Valid From
CreatedByUser P_PrcgCndnRecordHeader CreatedByUser User Name
CreationDate P_PrcgCndnRecordHeader CreationDate Time Stamp
ConditionTextID P_PrcgCndnRecordItem ConditionTextID Text number
PricingScaleType P_PrcgCndnRecordItem PricingScaleType Scale Type
PricingScaleBasis P_PrcgCndnRecordItem PricingScaleBasis Scale Basis
ConditionScaleQuantity P_PrcgCndnRecordItem ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit P_PrcgCndnRecordItem ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount P_PrcgCndnRecordItem ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency P_PrcgCndnRecordItem ConditionScaleAmountCurrency Scale Currency
ConditionCalculationType P_PrcgCndnRecordItem ConditionCalculationType Calculat.Type
ConditionRateValue P_PrcgCndnRecordItem ConditionRateValue Condition Rate Value
ConditionRateValueUnit P_PrcgCndnRecordItem ConditionRateValueUnit Unit of Condition Rate Value
ConditionRateRatio P_PrcgCndnRecordItem ConditionRateRatio Ratio
ConditionRateRatioUnit P_PrcgCndnRecordItem ConditionRateRatioUnit Unit of Measure
ConditionRateAmount P_PrcgCndnRecordItem ConditionRateAmount Condition Amount
ConditionCurrency P_PrcgCndnRecordItem ConditionCurrency Currency
ConditionQuantity P_PrcgCndnRecordItem ConditionQuantity Pricing Unit
ConditionQuantityUnit P_PrcgCndnRecordItem ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr P_PrcgCndnRecordItem ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr P_PrcgCndnRecordItem ConditionToBaseQtyDnmntr Denominator
BaseUnit P_PrcgCndnRecordItem BaseUnit Unit of Measure
ConditionLowerLimit P_PrcgCndnRecordItem ConditionLowerLimit Lower limit
ConditionUpperLimit P_PrcgCndnRecordItem ConditionUpperLimit Upper limit
ConditionAlternativeCurrency P_PrcgCndnRecordItem ConditionAlternativeCurrency Cndn Currency
ConditionExclusion P_PrcgCndnRecordItem ConditionExclusion Exclusion
ConditionIsDeleted P_PrcgCndnRecordItem ConditionIsDeleted Deletion Indic.
AdditionalValueDays P_PrcgCndnRecordItem AdditionalValueDays Add. Value Days
FixedValueDate P_PrcgCndnRecordItem FixedValueDate Fixed Val. Date
PaymentTerms P_PrcgCndnRecordItem PaymentTerms Pyt Terms
CndnMaxNumberOfSalesOrders P_PrcgCndnRecordItem CndnMaxNumberOfSalesOrders NumberOfOrders
MinimumConditionBasisValue P_PrcgCndnRecordItem MinimumConditionBasisValue MinCondBaseVal.
MaximumConditionBasisValue P_PrcgCndnRecordItem MaximumConditionBasisValue MaxCondBaseVal.
MaximumConditionAmount P_PrcgCndnRecordItem MaximumConditionAmount MaxConditValue
IncrementalScale P_PrcgCndnRecordItem IncrementalScale Increment scale
PricingScaleLine P_PrcgCndnRecordItem PricingScaleLine Pricing scale
ConditionReleaseStatus P_PrcgCndnRecordItem ConditionReleaseStatus Release Status

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 P_PurgPrcgCndnRecdSuplmnt.
-- 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 P_PurgPrcgCndnRecdSuplmnt AS
SELECT
  _Item.ConditionRecord AS ConditionRecord,
  _Item.ConditionSequentialNumber AS ConditionSequentialNumber,
  _Header.ConditionTable AS ConditionTable,
  _Header.ConditionApplication AS ConditionApplication,
  _Item.ConditionType AS ConditionType,
  _Header.ConditionValidityEndDate AS ConditionValidityEndDate,
  _Header.ConditionValidityStartDate AS ConditionValidityStartDate,
  _Header.CreatedByUser AS CreatedByUser,
  _Header.CreationDate AS CreationDate,
  _Item.ConditionTextID AS ConditionTextID,
  _Item.PricingScaleType AS PricingScaleType,
  _Item.PricingScaleBasis AS PricingScaleBasis,
  _Item.ConditionScaleQuantity AS ConditionScaleQuantity,
  _Item.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  _Item.ConditionScaleAmount AS ConditionScaleAmount,
  _Item.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  _Item.ConditionCalculationType AS ConditionCalculationType,
  _Item.ConditionRateValue AS ConditionRateValue,
  _Item.ConditionRateValueUnit AS ConditionRateValueUnit,
  _Item.ConditionRateRatio AS ConditionRateRatio,
  _Item.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  _Item.ConditionRateAmount AS ConditionRateAmount,
  _Item.ConditionCurrency AS ConditionCurrency,
  _Item.ConditionQuantity AS ConditionQuantity,
  _Item.ConditionQuantityUnit AS ConditionQuantityUnit,
  _Item.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  _Item.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  _Item.BaseUnit AS BaseUnit,
  _Item.ConditionLowerLimit AS ConditionLowerLimit,
  _Item.ConditionUpperLimit AS ConditionUpperLimit,
  _Item.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  _Item.ConditionExclusion AS ConditionExclusion,
  _Item.ConditionIsDeleted AS ConditionIsDeleted,
  _Item.AdditionalValueDays AS AdditionalValueDays,
  _Item.FixedValueDate AS FixedValueDate,
  _Item.PaymentTerms AS PaymentTerms,
  _Item.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  _Item.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  _Item.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  _Item.MaximumConditionAmount AS MaximumConditionAmount,
  _Item.IncrementalScale AS IncrementalScale,
  _Item.PricingScaleLine AS PricingScaleLine,
  _Item.ConditionReleaseStatus AS ConditionReleaseStatus
FROM P_PrcgCndnRecordHeader AS _Header
LEFT OUTER JOIN P_PrcgCndnRecordItem AS _Item ON /* join condition not captured in parsed metadata */
;

Learn More