I_TreasuryReference

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_TreasuryReference.
-- 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_TreasuryReference AS
SELECT
  cast( reftyp as trsy_ref_cat preserving type ) AS TreasuryReferenceCategory,
  cast( refnr as trsy_ref_nmbr preserving type ) AS TreasuryReferenceNumber,
  cast( status as trsy_ref_status preserving type ) AS TreasuryReferenceStatus,
  cast( dzterm as trsy_ref_payment_date preserving type ) AS TreasuryReferencePaymentDate,
  cast( kontrh as trsy_ref_business_partner preserving type ) AS TreasuryReferencePartner,
  cast( ext_ref_id as trsy_ref_ext_ref preserving type ) AS TrsyRefExtRefIdfr,
  cfi_code AS ClassificationOfFinInstr,
  upi AS UniqueProductIdentifier,
  isin AS InternationalSecuritiesIdnNmbr,
  cast( cruser as trsy_ref_cruser preserving type ) AS TreasuryReferenceCreatedByUser,
  cast( dcrdat as trsy_ref_dcrdat preserving type ) AS TreasuryReferenceCreationDate,
  cast( tcrtim as trsy_ref_tcrtim preserving type ) AS TrsyReferenceCreationTime,
  cast( upuser as trsy_ref_upuser preserving type ) AS TrsyReferenceLastChangedByUser,
  cast( dupdat as trsy_ref_dupdat preserving type ) AS TrsyReferenceLastChangeDate,
  cast( tuptim as trsy_ref_tuptim preserving type ) AS TrsyReferenceLastChangeTime
FROM refh
LEFT OUTER JOIN I_TreasuryReferenceCategory AS _TreasuryReferenceCategory ON TreasuryReferenceCategory = _TreasuryReferenceCategory.TreasuryReferenceCategory  -- association [1..1]
LEFT OUTER JOIN I_TreasuryReferenceItem AS _TreasuryReferenceItem ON TreasuryReferenceCategory = _TreasuryReferenceItem.TreasuryReferenceCategory AND TreasuryReferenceNumber = _TreasuryReferenceItem.TreasuryReferenceNumber  -- association [1..*]
;