I_TripAcctDeterminationTP

DDL: I_TRIPACCTDETERMINATIONTP SQL: ITRPACNTDETRTP Type: view TRANSACTIONAL
8 Fields 1 Data Sources 2 Associations

Account determination cds for Trips

I_TripAcctDeterminationTP is a Transactional CDS View that provides data about "Account determination cds for Trips" in SAP S/4HANA. It reads from 1 data source (oit_tripaccntdet) and exposes 8 fields with key fields TripDoc, TripDocItem, DemurrageChargeKey, PricingProcedure, ConditionType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
oit_tripaccntdet oit_tripaccntdet from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_TripSchedOfChargesTP _TripSchedOfChargesTP $projection.TripDoc = _TripSchedOfChargesTP.TripDoc and $projection.TripDocItem = _TripSchedOfChargesTP.TripDocItem and $projection.DemurrageChargeKey = _TripSchedOfChargesTP.DemurrageChargeKey
[1..1] I_TripHeadTP _TripHeadTP $projection.TripDoc = _TripHeadTP.TripDoc

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITRPACNTDETRTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ITRPACNTDETRTP_D view
AbapCatalog.preserveKey true view
EndUserText.label Account determination cds for Trips view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TripDoc trip_id Trip ID
KEY TripDocItem trip_item Trip Item Number
KEY DemurrageChargeKey charge_key Charge Key
KEY PricingProcedure kalsm Search Proced.
KEY ConditionType kschl Tax Item Type
DebitGLAccount saknr G/L Account
_TripHeadTP _TripHeadTP
_TripSchedOfChargesTP _TripSchedOfChargesTP

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_TripAcctDeterminationTP.
-- 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: ITRPACNTDETRTP

CREATE VIEW I_TripAcctDeterminationTP AS
SELECT
  trip_id AS TripDoc,
  trip_item AS TripDocItem,
  charge_key AS DemurrageChargeKey,
  kalsm AS PricingProcedure,
  kschl AS ConditionType,
  saknr AS DebitGLAccount
FROM oit_tripaccntdet
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]
;

Learn More