I_SESPricingElementTP

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_SESPricingElementTP.
-- 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.
-- SQL view name: ISESPRCGELMNTTP

CREATE VIEW I_SESPricingElementTP AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  Document.PricingDocument AS PricingDocument,
  Document.PricingDocumentItem AS PricingDocumentItem,
  Document.PricingProcedureStep AS PricingProcedureStep,
  Document.PricingProcedureCounter AS PricingProcedureCounter,
  Document.ConditionApplication AS ConditionApplication,
  Document.ConditionType AS ConditionType,
  Document.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  Document.ConditionCalculationType AS ConditionCalculationType,
  Document.ConditionBaseValue AS ConditionBaseValue,
  Document.ConditionRateValue AS ConditionRateValue,
  Document.ConditionCurrency AS ConditionCurrency,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  Document.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  Document.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  Document.ConditionCategory AS ConditionCategory,
  Document.ConditionIsForStatistics AS ConditionIsForStatistics,
  Document.PricingScaleType AS PricingScaleType,
  Document.IsRelevantForAccrual AS IsRelevantForAccrual,
  Document.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  Document.ConditionOrigin AS ConditionOrigin,
  Document.IsGroupCondition AS IsGroupCondition,
  Document.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  Document.ConditionRecord AS ConditionRecord,
  Document.ConditionSequentialNumber AS ConditionSequentialNumber,
  Document.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  Document.GLAccount AS GLAccount,
  Document.TaxCode AS TaxCode,
  Document.AcctKeyForAccrualsGLAccount AS AcctKeyForAccrualsGLAccount,
  Document.AccrualsGLAccount AS AccrualsGLAccount,
  Document.WithholdingTaxCode AS WithholdingTaxCode,
  Document.FreightSupplier AS FreightSupplier,
  Document.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  Document.ConditionAmount AS ConditionAmount,
  Document.TransactionCurrency AS TransactionCurrency,
  Document.ConditionControl AS ConditionControl,
  Document.ConditionInactiveReason AS ConditionInactiveReason,
  _ConditionInactiveReason._Text[ 1: Language = $session.system_language ].ConditionInactiveReasonName AS ConditionInactiveReasonName,
  Document.ConditionClass AS ConditionClass,
  Document.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  Document.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  Document.StructureCondition AS StructureCondition,
  Document.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  Document.PricingScaleBasis AS PricingScaleBasis,
  Document.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  Document.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  Document.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  Document.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  Document.ConditionAmountInLocalCrcy AS ConditionAmountInLocalCrcy,
  Document.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  Document.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  Document.BillingPriceSource AS BillingPriceSource,
  Document.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  Document.ConditionByteSequence AS ConditionByteSequence,
  Document.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  Document.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  Document.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  Document.CumulatedConditionBasisValue AS CumulatedConditionBasisValue,
  Document.CustomerRebateRecipient AS CustomerRebateRecipient,
  Document.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  Document.VariantCondition AS VariantCondition,
  Document.ConditionAcctAssgmtRelevance AS ConditionAcctAssgmtRelevance,
  Document.ConditionMatrixMaintRelevance AS ConditionMatrixMaintRelevance,
  Document.ConfigblParametersAndFormulas AS ConfigblParametersAndFormulas,
  Document.ConditionAdjustedQuantity AS ConditionAdjustedQuantity,
  Document.ConditionTypeName AS ConditionTypeName,
  Document.ConditionBaseValueIntlUnit AS ConditionBaseValueIntlUnit,
  Document.ConditionBaseValueUnit AS ConditionBaseValueUnit,
  Document.ConditionRateValueIntlUnit AS ConditionRateValueIntlUnit,
  Document.TaxCodeName AS TaxCodeName,
  Document.ConditionIsDeletable AS ConditionIsDeletable,
  Document.PricingProcedure AS PricingProcedure,
  Document.SuperordinateDocument AS SuperordinateDocument,
  Document.SuperordinateDocumentItem AS SuperordinateDocumentItem,
  Document.ConditionRateValueUnit AS ConditionRateValueUnit,
  Document.OrderQuantity AS OrderQuantity,
  Document.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Document.PurgDocConditionRateValue AS PurgDocConditionRateValue,
  Document.PurgDocConditionAmount AS PurgDocConditionAmount,
  Document.PurgDocConditionCurrency AS PurgDocConditionCurrency,
  Document._BillingPriceSource AS _BillingPriceSource,
  Document._ConditionAcctAssgmtRelevance AS _ConditionAcctAssgmtRelevance,
  Document._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  Document._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  Document._ConditionApplication AS _ConditionApplication,
  Document._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  Document._ConditionCalculationType AS _ConditionCalculationType,
  Document._ConditionCategory AS _ConditionCategory,
  Document._ConditionClass AS _ConditionClass,
  Document._ConditionControl AS _ConditionControl,
  Document._ConditionCurrency AS _ConditionCurrency,
  Document._ConditionInactiveReason AS _ConditionInactiveReason,
  Document._ConditionOrigin AS _ConditionOrigin,
  Document._Customer AS _Customer,
  Document._PricingScaleBasis AS _PricingScaleBasis,
  Document._ConditionQuantityUnit AS _ConditionQuantityUnit,
  Document._ScaleCurrency AS _ScaleCurrency,
  Document._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  Document._StructureCondition AS _StructureCondition,
  Document._Supplier AS _Supplier,
  Document._VariantCondition AS _VariantCondition
FROM I_SESPricingElement AS Document
LEFT OUTER JOIN I_ServiceEntrySheetTP AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_ServiceEntrySheetItemTP AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItem.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
;