C_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 C_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: CSESPRCGELMNTTP

CREATE VIEW C_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,
  _PricingElement.ConditionTypeName AS ConditionTypeName,
  Document.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  Document.ConditionCalculationType AS ConditionCalculationType,
  _PricingElement.ConditionBaseValue AS ConditionBaseValue,
  _PricingElement.ConditionBaseValueIntlUnit AS ConditionBaseValueIntlUnit,
  _PricingElement.ConditionBaseValueUnit AS ConditionBaseValueUnit,
  Document.ConditionRateValue AS ConditionRateValue,
  _PricingElement.ConditionRateValueIntlUnit AS ConditionRateValueIntlUnit,
  Document.ConditionRateValueUnit AS ConditionRateValueUnit,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  _PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  _PricingElement.IsGroupCondition AS IsGroupCondition,
  _PricingElement.TaxCode AS TaxCode,
  _PricingElement.TaxCodeName AS TaxCodeName,
  Document.ConditionAmount AS ConditionAmount,
  _PricingElement.TransactionCurrency AS TransactionCurrency,
  _PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  _PricingElement.ConditionInactiveReasonName AS ConditionInactiveReasonName,
  _PricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  _PricingElement.ConditionIsDeletable AS ConditionIsDeletable,
  _PricingElement.PricingProcedure AS PricingProcedure,
  _PricingElement.SuperordinateDocument AS SuperordinateDocument,
  _PricingElement.SuperordinateDocumentItem AS SuperordinateDocumentItem,
  Document.OrderQuantity AS OrderQuantity,
  Document.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Document.PurgDocConditionRateValue AS PurgDocConditionRateValue,
  Document.PurgDocConditionAmount AS PurgDocConditionAmount,
  Document.PurgDocConditionCurrency AS PurgDocConditionCurrency
FROM I_SESPricingElementTP AS Document
LEFT OUTER JOIN C_ServiceEntrySheetWD AS _ServiceEntrySheetWD ON _ServiceEntrySheetWD.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN C_ServiceEntrySheetItemWD AS _ServiceEntrySheetItemWD ON _ServiceEntrySheetItemWD.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItemWD.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON _PricingElement.PricingDocument = PricingDocument AND _PricingElement.PricingDocumentItem = PricingDocumentItem AND _PricingElement.PricingProcedureStep = PricingProcedureStep AND _PricingElement.PricingProcedureCounter = PricingProcedureCounter  -- association [1..1]
LEFT OUTER JOIN C_PricingConditionType_VH AS _PricingConditionTypeVH ON ConditionType = _PricingConditionTypeVH.ConditionType  -- association [0..*]
LEFT OUTER JOIN C_ConditionRateValueUnit_VH AS _ConditionRateValueUnitVH ON ConditionRateValueUnit = _ConditionRateValueUnitVH.ConditionRateValueUnit  -- association [0..1]
LEFT OUTER JOIN C_ConditionQuantityUnit_VH AS _ConditionQuantityUnitVH ON ConditionQuantityUnit = _ConditionQuantityUnitVH.ConditionQuantityUnit  -- association [0..1]
;