I_TreasuryBusinessTransaction

DDL: I_TREASURYBUSINESSTRANSACTION Type: view_entity BASIC Package: FTR_GENERAL_CORE
7 Fields 1 Data Sources

Business Transaction

I_TreasuryBusinessTransaction is a Basic CDS View that provides data about "Business Transaction" in SAP S/4HANA. It reads from 1 data source (trdt_trdbustrans) and exposes 7 fields with key field TreasuryBusinessTransaction. Part of development package FTR_GENERAL_CORE.

Data Sources (1)

SourceAliasJoin Type
trdt_trdbustrans trdt_trdbustrans from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
EndUserText.label Business Transaction view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TreasuryBusinessTransaction Bus. Trans. ID
TrsyTransacMgmtBizTransaction External BT ID
CompanyCode company_code Company Code
FinancialTransaction deal_number Transaction
TrsyBusTransactionCreationDate create_date Time Stamp
TrsyBusTransactionCreationTime trdt_trdbustrans create_time Time
TreasuryUserStatisticsUUID DB Object ID

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_TreasuryBusinessTransaction.
-- 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_TreasuryBusinessTransaction AS
SELECT
  cast(bustransid as ftr_gen_business_transaction preserving type ) AS TreasuryBusinessTransaction,
  cast(extbustransid as ftr_gen_tm_bus_transaction preserving type ) AS TrsyTransacMgmtBizTransaction,
  company_code AS CompanyCode,
  deal_number AS FinancialTransaction,
  create_date AS TrsyBusTransactionCreationDate,
  trdt_trdbustrans.create_time AS TrsyBusTransactionCreationTime,
  cast(user_data_oid as ftr_gen_user_statistics_uuid preserving type ) AS TreasuryUserStatisticsUUID
FROM trdt_trdbustrans
;

Learn More