I_TripAccrualLog

DDL: I_TRIPACCRUALLOG SQL: ITRPACCRUALLOG Type: view BASIC
9 Fields 1 Data Sources

Trip Accrual log history

I_TripAccrualLog is a Basic CDS View that provides data about "Trip Accrual log history" in SAP S/4HANA. It reads from 1 data source (oij08_trpaccrlog) and exposes 9 fields with key fields TripDoc, TripDocItem, DemurrageChargeKey, SequenceNumber.

Data Sources (1)

SourceAliasJoin Type
oij08_trpaccrlog oij08_trpaccrlog from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ITRPACCRUALLOG view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view
EndUserText.label Trip Accrual log history view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY TripDoc trip_id Trip ID
KEY TripDocItem trip_item Trip Item Number
KEY DemurrageChargeKey charge_key Charge Key
KEY SequenceNumber seqnr Tank ID
DebitGLAccount debit_glaccount G/L Account
CreditGLAccount credit_glaccount G/L Account
LastAccruedMonth last_accur_month Last Accrual Month
PostedAccrualAmount accural_amount Accrual Amount
PostedAccrualCurrency accural_curr Accrual Amount Curr

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_TripAccrualLog.
-- 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: ITRPACCRUALLOG

CREATE VIEW I_TripAccrualLog AS
SELECT
  trip_id AS TripDoc,
  trip_item AS TripDocItem,
  charge_key AS DemurrageChargeKey,
  seqnr AS SequenceNumber,
  debit_glaccount AS DebitGLAccount,
  credit_glaccount AS CreditGLAccount,
  last_accur_month AS LastAccruedMonth,
  accural_amount AS PostedAccrualAmount,
  accural_curr AS PostedAccrualCurrency
FROM oij08_trpaccrlog
;

Learn More