P_SlsPrcgConditionRecord

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_SlsPrcgConditionRecord.
-- 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_SlsPrcgConditionRecord AS
SELECT
  header.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.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  item.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  item.ConditionUpperLimit AS ConditionUpperLimit,
  item.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  item.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  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,
  header.PriceApprovalRequest AS SalesPriceApprovalRequest,
  item.ConditionChangeReason AS ConditionChangeReason,
  header.PrevApprovedConditionRecord AS PrevApprovedConditionRecord,
  item.ConditionTaxCode AS ConditionTaxCode,
  item.ConditionWithholdingTaxCode AS ConditionWithholdingTaxCode,
  header.TaxExemptionLicense AS TaxExemptionLicense,
  header.LicenseGrantDate AS LicenseGrantDate,
  header.LastChangeDateTime AS LastChangeDateTime,
  header.ConditionSearchTermValue AS ConditionSearchTermValue,
  header.ConditionResponsibility AS ConditionResponsibility,
  SAPObjectNodeType
FROM P_PrcgCndnRecordHeader AS header
INNER JOIN P_PrcgCndnRecordItem AS item ON /* join condition not captured in parsed metadata */
;