C_TripPricingElementsTP

DDL: C_TRIPPRICINGELEMENTSTP SQL: CPRICINGELEMTP Type: view CONSUMPTION
35 Fields 1 Data Sources 4 Associations

Trip demurrage pricing elements

C_TripPricingElementsTP is a Consumption CDS View that provides data about "Trip demurrage pricing elements" in SAP S/4HANA. It reads from 1 data source (I_TripPricingElementsTP) and exposes 35 fields with key fields TripDoc, TripDocItem, DemurrageChargeKey, PricingProcedure, ConditionType. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_TripPricingElementsTP I_TripPricingElementsTP from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_TripSchedOfChargesTP _TripSchedOfChargesTP $projection.TripDoc = _TripSchedOfChargesTP.TripDoc and $projection.TripDocItem = _TripSchedOfChargesTP.TripDocItem and $projection.DemurrageChargeKey = _TripSchedOfChargesTP.DemurrageChargeKey
[1..1] C_TripHeadTP _TripHeadTP $projection.TripDoc = _TripHeadTP.TripDoc
[1..*] C_PurgMasterConditionTypeVH _PurgMasterConditionTypeVH $projection.ConditionTypeForEdit = _PurgMasterConditionTypeVH.ConditionType
[0..1] C_NominationUoMVH _ConditionQuantityUnitVH $projection.ConditionQuantityUnit = _ConditionQuantityUnitVH.TicketUnitOfMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPRICINGELEMTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
AbapCatalog.preserveKey true view
EndUserText.label Trip demurrage pricing elements view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY TripDoc TripDoc Trip ID
KEY TripDocItem TripDocItem Trip Item
KEY DemurrageChargeKey DemurrageChargeKey Charge Key
KEY PricingProcedure PricingProcedure Pricing Procedure
KEY ConditionType ConditionType Condition type
PricingProcedureStep PricingProcedureStep Step Number
ConditionTypeForEdit ConditionTypeForEdit Condition Type
SDPricingProcedure _TripSchedOfChargesTP PricingProcedure Procedure
ConditionRateValue ConditionRateValue Condition Rate Value
ConditionRateValueCrcy ConditionRateValueCrcy Condition Rate Value Currency
ConditionQuantity ConditionQuantity Condition Quantity
ConditionQuantityUnit ConditionQuantityUnit Condition Quantity Unit
ConditionValue ConditionValue Condition Value
ConditionCurrency ConditionCurrency Currency
ConditionAgreementStatus ConditionAgreementStatus Status
CndnUnitCnvrsnNmrtr CndnUnitCnvrsnNmrtr Numerator
VariantCondition VariantCondition ATO/MTS Component
ConditionAmount ConditionAmount Amount
ConditionAmountCurrency ConditionAmountCurrency Amount Currency
TaxCode TaxCode Tax Code
ConditionControl ConditionControl Condition Control
ConditionCalculationType ConditionCalculationType Calculation Type
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue Condition Update
PrcgCndnValChgIsAllwd PrcgCndnValChgIsAllwd Scope for changing value
ConditionOrigin ConditionOrigin Condition Origin
CndnManualEntries CndnManualEntries Manual Entries
PrcgCndnTypeDeletionIsAllowed PrcgCndnTypeDeletionIsAllowed Delete
ConditionCategory ConditionCategory Condition Category
PrcgCndnAmtChgIsAllwd PrcgCndnAmtChgIsAllwd Amount/Percentage
TripPrcgCndnRateValueIsMnlEntr TripPrcgCndnRateValueIsMnlEntr Condition Rate Value Modified
_TripTaxCodeVH _TripTaxCodeVH
_ConditionQuantityUnitVH _ConditionQuantityUnitVH
_PurgMasterConditionTypeVH _PurgMasterConditionTypeVH
_TripSchedOfChargesTP _TripSchedOfChargesTP
_TripHeadTP _TripHeadTP

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_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: CPRICINGELEMTP

CREATE VIEW C_TripPricingElementsTP AS
SELECT
  TripDoc,
  TripDocItem,
  DemurrageChargeKey,
  PricingProcedure,
  ConditionType,
  PricingProcedureStep,
  ConditionTypeForEdit,
  _TripSchedOfChargesTP.PricingProcedure AS SDPricingProcedure,
  ConditionRateValue,
  ConditionRateValueCrcy,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionValue,
  ConditionCurrency,
  ConditionAgreementStatus,
  CndnUnitCnvrsnNmrtr,
  VariantCondition,
  ConditionAmount,
  ConditionAmountCurrency,
  TaxCode,
  ConditionControl,
  ConditionCalculationType,
  CndnIsRelevantForLimitValue,
  PrcgCndnValChgIsAllwd,
  ConditionOrigin,
  CndnManualEntries,
  PrcgCndnTypeDeletionIsAllowed,
  ConditionCategory,
  PrcgCndnAmtChgIsAllwd,
  TripPrcgCndnRateValueIsMnlEntr
FROM I_TripPricingElementsTP
LEFT OUTER JOIN C_TripSchedOfChargesTP AS _TripSchedOfChargesTP ON TripDoc = _TripSchedOfChargesTP.TripDoc AND TripDocItem = _TripSchedOfChargesTP.TripDocItem AND DemurrageChargeKey = _TripSchedOfChargesTP.DemurrageChargeKey  -- association [1..1]
LEFT OUTER JOIN C_TripHeadTP AS _TripHeadTP ON TripDoc = _TripHeadTP.TripDoc  -- association [1..1]
LEFT OUTER JOIN C_PurgMasterConditionTypeVH AS _PurgMasterConditionTypeVH ON ConditionTypeForEdit = _PurgMasterConditionTypeVH.ConditionType  -- association [1..*]
LEFT OUTER JOIN C_NominationUoMVH AS _ConditionQuantityUnitVH ON ConditionQuantityUnit = _ConditionQuantityUnitVH.TicketUnitOfMeasure  -- association [0..1]
;

Learn More