R_TrsyLdgrTransOfProdGrpExpsr

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 R_TrsyLdgrTransOfProdGrpExpsr.
-- 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 R_TrsyLdgrTransOfProdGrpExpsr AS
SELECT
  os_guid 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,
  bustransstate AS TrsyDerivedBusinessTransStatus,
  cast(booking_state as ftr_gen_trl_bookingstate preserving type) AS TreasuryBusinessTransStatus,
  valuation_area AS TreasuryValuationArea,
  tr_acc_code 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
;