I_TrsyFinancialObject

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_TrsyFinancialObject.
-- 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_TrsyFinancialObject AS
SELECT
  FinObjBase.objnr AS TreasuryFinancialObject,
  FinObjBase.bukrs AS CompanyCode,
  FinObjBase.drmbeg AS TrsyFinObjValidityStartDate,
  FinObjBase.drmend AS TrsyFinObjValidityEndDate,
  FinObjChars.contract_type AS TreasuryContractType,
  FinObjChars.product_category AS FinancialInstrProductCategory,
  FinObjChars.product_type AS FinancialInstrumentProductType,
  FinObjChars.portfolio AS Portfolio,
  FinObjChars.financial_transaction AS FinancialTransaction,
  FinObjChars.security_id AS SecurityClass,
  FinObjChars.security_account AS SecurityAccount,
  FinObjChars.futures_account AS TreasuryPositionAccount,
  FinObjChars.exposure_position AS FinancialExposurePosition,
  FinObjChars.loan_contract AS LoanContract,
  FinObjChars.business_partner AS BusinessPartner,
  FinObjChars.pos_currency AS MktRiskCharacteristicCurrency,
  FinObjChars.country AS Country,
  FinObjChars.characteristics AS FinancialInstrCharacteristic
FROM jbdobj1 AS FinObjBase
INNER JOIN ftb_i73_static AS FinObjChars ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialInstrProdCat AS _ProductCategory ON FinancialInstrProductCategory = _ProductCategory.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND Portfolio = _Portfolio.Portfolio  -- association [0..1]
LEFT OUTER JOIN I_TreasuryContractType AS _ContractType ON TreasuryContractType = _ContractType.TreasuryContractType  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON CompanyCode = _SecurityAccount.CompanyCode AND SecurityAccount = _SecurityAccount.SecurityAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CharacteristicCurrency ON MktRiskCharacteristicCurrency = _CharacteristicCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
;