I_TreasuryLedgerTransaction

DDL: I_TREASURYLEDGERTRANSACTION Type: view_entity BASIC
16 Fields 1 Data Sources 1 Associations

Treasury Ledger Transaction

I_TreasuryLedgerTransaction (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

TreasuryLedgerTransaction · Financial Operations

I_TreasuryLedgerTransaction is a Basic CDS View that provides data about "Treasury Ledger Transaction" in SAP S/4HANA. It reads from 1 data source (trlt_transaction) and exposes 16 fields with key field TreasuryLedgerTransaction. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Transactional Data
Purpose
This CDS view retrieves all treasury ledger transactions in the system. A treasury ledger transaction is a business transaction in the treasury ledger. A business transaction is a business event that implies a change in quantity or value. In the context of the treasury ledger a business transaction carries treasury ledger specific information, for example the valuation area. The valuation area usually represents an accounting principle. This CDS view provides the data to answer the following business questions: Which treasury ledger transactions exist in the system? What is the business transaction category of a treasury ledger transaction? What is the original business transaction? What is the status of a treasury ledger transaction? What is the posting date of a treasury ledger transaction? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: Field Name Is Key Data Element Label Comment TreasuryLedgerTransaction X FTR_GEN_TRL_TRANS TRL Transaction Treasury Ledger Transaction TreasuryBusinessTransCategory FTR_GEN_BUSINESS_TRANS_CATEG Business Trans. Cat. Business Transaction Category Examples: 4002 Purchase OTC transaction 4003 Sell OTC transaction 4004 Exercise/expiration/termination OTC transactions 4005 OTC Transaction: Change in Nominal Value 4006 OTC Transaction: Cash Settlement TreasuryPositionLedgerDate TPM_TRLDATE TRL Date Treasury Ledger Date TreasuryBusinessTransaction FTR_GEN_BUSINESS_TRANSACTION Business Transaction Identifier of the Distributor Business Transaction TrsyBusTransactionCreationDate TPM_BT_CREATE_DATE Creation Date Creation Date of the Operative Business Transaction TrsyBusTransactionCreationTime TPM_BT_CREATE_TIME Creation Time Creation Time of the Operative Business Transaction TrsyDerivedBusinessTransStatus FTR_GEN_TRLTRANSTATE TRL Trans.State Gives for all treasury ledger (business) transactions the status of the derived business transactions: If the treasury ledger transaction is a derived business transaction, the status gives the information whether the derived business transaction is up to date. If the treasury ledger transaction is an operational business transaction the status gives the information whether the related derived business transaction is up to date. TreasuryBusinessTransStatus FTR_GEN_TRL_BOOKINGSTATE Posting Status Posting Status Treasury Ledger Business Transaction TreasuryValuationArea TPM_VAL_AREA Valuation Area Treasury Valuation Area CompanyCode BUKRS Company Code Company Code OriglTrsyBusinessTransaction FTR_GEN_BUSTRANSID_ORIG Orig. Business Trans Original Business Transaction PostingDate TPM_FI_POSTING_DATE FI Posting Date Different FI Posting Date PostingReversalDate TPM_FI_REVERSAL_DATE FI Reversal Date Different FI Reversal Date TreasuryUserStatisticsUUID FTR_GEN_USER_DATA_GUID User Data (GUID) User Data (GUID)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
trlt_transaction trlt_transaction from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TrsyLedgerTransactionFlow _TrlFlow $projection.TreasuryLedgerTransaction = _TrlFlow.TreasuryLedgerTransaction

Annotations (8)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name TreasuryLedgerTransaction view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Treasury Ledger Transaction view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TreasuryLedgerTransaction Treasury Ledger Transaction
TreasuryBusinessTransCategory Business Transaction Category
TreasuryPositionLedgerDate trldate Treasury Ledger Date
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction
TrsyBusTransactionCreationDate Creation Date of the Operative Business Transaction
TrsyBusTransactionCreationTime Creation Time of the Operative Business Transaction
TrsyDerivedBusinessTransStatus Status of Derived Business Transaction
TreasuryBusinessTransStatus Posting Status Treasury Ledger Business Transaction
TreasuryValuationArea valuation_area Treasury Valuation Area
CompanyCode Accounting Code
OriglTrsyBusinessTransaction Original Business Transaction
PostingDate fi_post_date Different FI Posting Date
PostingReversalDate fi_rev_date Different FI Reversal Date
TrsyIntragroupTransacStatus Intragroup Transaction Status
TreasuryUserStatisticsUUID User Data (GUID)
_TrlFlow _TrlFlow

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_TreasuryLedgerTransaction.
-- 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.

CREATE VIEW I_TreasuryLedgerTransaction AS
SELECT
  cast(os_guid as ftr_gen_trl_trans preserving type ) AS TreasuryLedgerTransaction,
  cast( bustranscat as ftr_gen_business_trans_categ preserving type ) AS TreasuryBusinessTransCategory,
  trldate AS TreasuryPositionLedgerDate,
  cast( bustransid as ftr_gen_business_transaction preserving type ) AS TreasuryBusinessTransaction,
  cast( create_date as tpm_bt_create_date preserving type ) AS TrsyBusTransactionCreationDate,
  cast( create_time as tpm_bt_create_time preserving type ) AS TrsyBusTransactionCreationTime,
  cast( bustransstate as ftr_gen_trltranstate preserving type ) AS TrsyDerivedBusinessTransStatus,
  cast( booking_state as ftr_gen_trl_bookingstate preserving type ) AS TreasuryBusinessTransStatus,
  valuation_area AS TreasuryValuationArea,
  cast( tr_acc_code as bukrs preserving type ) AS CompanyCode,
  cast( refbustransid as ftr_gen_bustransid_orig preserving type ) AS OriglTrsyBusinessTransaction,
  fi_post_date AS PostingDate,
  fi_rev_date AS PostingReversalDate,
  cast( igt_status as ftr_gen_igt_status preserving type ) AS TrsyIntragroupTransacStatus,
  cast( user_data_oid as ftr_gen_user_data_guid preserving type ) AS TreasuryUserStatisticsUUID
FROM trlt_transaction
LEFT OUTER JOIN I_TrsyLedgerTransactionFlow AS _TrlFlow ON TreasuryLedgerTransaction = _TrlFlow.TreasuryLedgerTransaction  -- association [0..*]
;

Learn More