I_TripItemPayableChrg

DDL: I_TRIPITEMPAYABLECHRG SQL: ISCHEDCHRGPAY Type: view BASIC
9 Fields 4 Data Sources

Trip Item Payable Charges

I_TripItemPayableChrg is a Basic CDS View that provides data about "Trip Item Payable Charges" in SAP S/4HANA. It reads from 4 data sources (oij08_tripchrg, oij08_tripchrg, oij08_tripitm, oij08_tripitm) and exposes 9 fields with key fields TripDoc, TripDocItem, DemurrageChargeKey, TripDocItem, DemurrageChargeKey.

Data Sources (4)

SourceAliasJoin Type
oij08_tripchrg oij08_tripchrg left_outer
oij08_tripchrg oij08_tripchrg left_outer
oij08_tripitm oij08_tripitm from
oij08_tripitm oij08_tripitm union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISCHEDCHRGPAY view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
EndUserText.label Trip Item Payable Charges view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TripDoc oij08_tripitm trip_id Trip ID
KEY TripDocItem oij08_tripitm trip_item Trip Item Number
KEY DemurrageChargeKey charge_key Charge Key
TripNetPrice netwr_trip_curr Net Value
trip_idasTripDoc
KEY TripDocItem oij08_tripitm trip_item Trip Item Number
KEY DemurrageChargeKey charge_key Charge Key
TripNetPrice Net Value
TripCurrency trip_curr Currency

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_TripItemPayableChrg.
-- 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: ISCHEDCHRGPAY

CREATE VIEW I_TripItemPayableChrg AS
SELECT
  oij08_tripitm.trip_id AS TripDoc,
  oij08_tripitm.trip_item AS TripDocItem,
  charge_key AS DemurrageChargeKey,
  netwr_trip_curr AS TripNetPrice,
  trip_curr as TripCurrency AS trip_idasTripDoc,
  trip_curr AS TripCurrency
FROM oij08_tripitm
LEFT OUTER JOIN oij08_tripchrg ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): oij08_tripitm
;

Learn More