I_SESPricingElement

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_SESPricingElement.
-- 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: ISESPRCGELMNT

CREATE VIEW I_SESPricingElement AS
SELECT
  ServiceEntrySheet.ServiceEntrySheet AS ServiceEntrySheet,
  cast(substring(I_PricingElement.PricingDocumentItem,2,6) as numc5) AS ServiceEntrySheetItem,
  I_PricingElement.PricingDocument AS PricingDocument,
  I_PricingElement.PricingDocumentItem AS PricingDocumentItem,
  I_PricingElement.PricingProcedureStep AS PricingProcedureStep,
  I_PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  I_PricingElement.ConditionApplication AS ConditionApplication,
  I_PricingElement.ConditionType AS ConditionType,
  cast( '' as abap.dats ) AS PriceConditionDeterminationDte,
  I_PricingElement.ConditionCalculationType AS ConditionCalculationType,
  I_PricingElement.ConditionBaseValue AS ConditionBaseValue,
  I_PricingElement.ConditionRateValue AS ConditionRateValue,
  I_PricingElement.ConditionCurrency AS ConditionCurrency,
  I_PricingElement.ConditionQuantity AS ConditionQuantity,
  I_PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  I_PricingElement.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  I_PricingElement.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  I_PricingElement.ConditionCategory AS ConditionCategory,
  I_PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  I_PricingElement.PricingScaleType AS PricingScaleType,
  I_PricingElement.IsRelevantForAccrual AS IsRelevantForAccrual,
  I_PricingElement.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  I_PricingElement.ConditionOrigin AS ConditionOrigin,
  I_PricingElement.IsGroupCondition AS IsGroupCondition,
  I_PricingElement.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  I_PricingElement.ConditionRecord AS ConditionRecord,
  I_PricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
  I_PricingElement.AccountKeyForGLAccount AS AccountKeyForGLAccount,
  I_PricingElement.GLAccount AS GLAccount,
  I_PricingElement.TaxCode AS TaxCode,
  I_PricingElement.AcctKeyForAccrualsGLAccount AS AcctKeyForAccrualsGLAccount,
  I_PricingElement.AccrualsGLAccount AS AccrualsGLAccount,
  I_PricingElement.WithholdingTaxCode AS WithholdingTaxCode,
  I_PricingElement.FreightSupplier AS FreightSupplier,
  I_PricingElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  I_PricingElement.ConditionAmount AS ConditionAmount,
  I_PricingElement.TransactionCurrency AS TransactionCurrency,
  I_PricingElement.ConditionControl AS ConditionControl,
  I_PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  I_PricingElement.ConditionClass AS ConditionClass,
  I_PricingElement.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  I_PricingElement.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  I_PricingElement.StructureCondition AS StructureCondition,
  I_PricingElement.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  I_PricingElement.PricingScaleBasis AS PricingScaleBasis,
  I_PricingElement.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  I_PricingElement.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  I_PricingElement.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  I_PricingElement.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  I_PricingElement.ConditionAmountInLocalCrcy AS ConditionAmountInLocalCrcy,
  I_PricingElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  I_PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  I_PricingElement.BillingPriceSource AS BillingPriceSource,
  I_PricingElement.TaxJurisdictionLevel AS TaxJurisdictionLevel,
  I_PricingElement.ConditionByteSequence AS ConditionByteSequence,
  I_PricingElement.CndnIsRelevantForLimitValue AS CndnIsRelevantForLimitValue,
  I_PricingElement.ConditionBasisLimitExceeded AS ConditionBasisLimitExceeded,
  I_PricingElement.ConditionAmountLimitExceeded AS ConditionAmountLimitExceeded,
  I_PricingElement.CumulatedConditionBasisValue AS CumulatedConditionBasisValue,
  I_PricingElement.CustomerRebateRecipient AS CustomerRebateRecipient,
  I_PricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  I_PricingElement.VariantCondition AS VariantCondition,
  I_PricingElement.ConditionAcctAssgmtRelevance AS ConditionAcctAssgmtRelevance,
  I_PricingElement.ConditionMatrixMaintRelevance AS ConditionMatrixMaintRelevance,
  I_PricingElement.ConfigblParametersAndFormulas AS ConfigblParametersAndFormulas,
  I_PricingElement.ConditionAdjustedQuantity AS ConditionAdjustedQuantity,
  _PricingConditionTypeText.ConditionTypeName AS ConditionTypeName,
  ConditionCurrency AS ConditionRateValueUnit,
  cast(' ' as price_element_tax_code_descr) AS TaxCodeName,
  cast(' ' as abap.char( 1 )) AS ConditionIsDeletable,
  cast(' ' as kalsm_d ) AS PricingProcedure,
  cast(' ' as abap.char ( 32 )) AS SuperordinateDocument,
  cast(' ' as abap.char ( 70 )) AS SuperordinateDocumentItem,
  I_PricingElement._BillingPriceSource AS _BillingPriceSource,
  I_PricingElement._ConditionAcctAssgmtRelevance AS _ConditionAcctAssgmtRelevance,
  I_PricingElement._ConditionAlternativeCurrency AS _ConditionAlternativeCurrency,
  I_PricingElement._ConditionAmountLimitExceeded AS _ConditionAmountLimitExceeded,
  I_PricingElement._ConditionApplication AS _ConditionApplication,
  I_PricingElement._ConditionBasisLimitExceeded AS _ConditionBasisLimitExceeded,
  I_PricingElement._ConditionCalculationType AS _ConditionCalculationType,
  I_PricingElement._ConditionCategory AS _ConditionCategory,
  I_PricingElement._ConditionClass AS _ConditionClass,
  I_PricingElement._ConditionControl AS _ConditionControl,
  I_PricingElement._ConditionCurrency AS _ConditionCurrency,
  I_PricingElement._ConditionInactiveReason AS _ConditionInactiveReason,
  I_PricingElement._ConditionOrigin AS _ConditionOrigin,
  I_PricingElement._Currency AS _Currency,
  I_PricingElement._Customer AS _Customer,
  I_PricingElement._PricingConditionType AS _PricingConditionType,
  I_PricingElement._PricingScaleBasis AS _PricingScaleBasis,
  I_PricingElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
  I_PricingElement._ScaleCurrency AS _ScaleCurrency,
  I_PricingElement._ScaleUnitOfMeasure AS _ScaleUnitOfMeasure,
  I_PricingElement._StructureCondition AS _StructureCondition,
  I_PricingElement._Supplier AS _Supplier,
  I_PricingElement._VariantCondition AS _VariantCondition,
  _SESPurgDocItemFixedAmountDta.OrderQuantity AS OrderQuantity,
  _SESPurgDocItemFixedAmountDta.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _SESPurgDocItemFixedAmountDta.ConditionRateValue AS PurgDocConditionRateValue,
  _SESPurgDocItemFixedAmountDta.ConditionAmount AS PurgDocConditionAmount,
  _SESPurgDocItemFixedAmountDta.ConditionCurrency AS PurgDocConditionCurrency
FROM I_ServiceEntrySheet AS ServiceEntrySheet
INNER JOIN I_PricingElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServiceEntrySheet AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_ServiceEntrySheetItem AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItem.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
LEFT OUTER JOIN I_ConditionTypeText AS _PricingConditionTypeText ON _PricingConditionTypeText.ConditionApplication = ConditionApplication AND _PricingConditionTypeText.ConditionType = ConditionType AND _PricingConditionTypeText.ConditionUsage = 'A' AND _PricingConditionTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SESPurgDocItemFixedAmountDta AS _SESPurgDocItemFixedAmountDta ON _SESPurgDocItemFixedAmountDta.ServiceEntrySheet = ServiceEntrySheet AND _SESPurgDocItemFixedAmountDta.ServiceEntrySheetItem = PricingDocumentItem AND _SESPurgDocItemFixedAmountDta.PricingProcedureStep = PricingProcedureStep AND _SESPurgDocItemFixedAmountDta.PricingProcedureCounter = PricingProcedureCounter  -- association [0..1]
;