I_TripPricingElementsTP

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_TripPricingElementsTP.
-- 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: IPRICINGELEMTP

CREATE VIEW I_TripPricingElementsTP AS
SELECT
  trip_id AS TripDoc,
  trip_item AS TripDocItem,
  charge_key AS DemurrageChargeKey,
  kalsm AS PricingProcedure,
  kschl AS ConditionType,
  cast( '' as abap.numc( 3 ) ) AS PricingProcedureStep,
  kschl AS ConditionTypeForEdit,
  kbetr AS ConditionRateValue,
  koein AS ConditionRateValueCrcy,
  kpein AS ConditionQuantity,
  kmein AS ConditionQuantityUnit,
  kwert AS ConditionValue,
  waerk AS ConditionCurrency,
  bosta AS ConditionAgreementStatus,
  kumza AS CndnUnitCnvrsnNmrtr,
  varcond AS VariantCondition,
  amount AS ConditionAmount,
  amount_curr AS ConditionAmountCurrency,
  tax_code AS TaxCode,
  ksteu AS ConditionControl,
  krech AS ConditionCalculationType,
  koupd AS CndnIsRelevantForLimitValue,
  kaend_wrt AS PrcgCndnValChgIsAllwd,
  kherk AS ConditionOrigin,
  kmanu AS CndnManualEntries,
  kaend_loe AS PrcgCndnTypeDeletionIsAllowed,
  kntyp AS ConditionCategory,
  kaend_btr AS PrcgCndnAmtChgIsAllwd,
  kbetr_manual AS TripPrcgCndnRateValueIsMnlEntr,
  _TripSchedOfChargesTP.PricingProcedure AS SDPricingProcedure
FROM oij08_tripprcng
LEFT OUTER JOIN I_TripSchedOfChargesTP AS _TripSchedOfChargesTP ON TripDoc = _TripSchedOfChargesTP.TripDoc AND TripDocItem = _TripSchedOfChargesTP.TripDocItem AND DemurrageChargeKey = _TripSchedOfChargesTP.DemurrageChargeKey  -- association [1..1]
LEFT OUTER JOIN I_TripHeadTP AS _TripHeadTP ON TripDoc = _TripHeadTP.TripDoc  -- association [1..1]
LEFT OUTER JOIN I_TripTaxCodeVH AS _TripTaxCodeVH ON TaxCode = _TripTaxCodeVH.TaxCode  -- association [1..*]
;