I_TrsyBookValManualValuation

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_TrsyBookValManualValuation.
-- 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_TrsyBookValManualValuation AS
SELECT
  key_date AS KeyDate,
  valuation_area AS TreasuryValuationArea,
  cast( valuation_class as ftr_gen_valuation_class preserving type ) AS TreasuryValuationClass,
  company_code AS CompanyCode,
  cast(security_account as ftr_gen_security_account preserving type ) AS SecurityAccount,
  cast(security_id as ftr_gen_security_class preserving type ) AS SecurityClass,
  cast(loans_contract as ftr_gen_loan_contract preserving type ) AS LoanContract,
  Portfolio,
  cast( account_group as ftr_gen_sec_account_group preserving type ) AS SecurityAccountGroup,
  lot_id AS TreasuryPositionLotUUID,
  deal_number AS FinancialTransaction,
  Fund,
  grant_nbr AS GrantID,
  cast(wbs_element as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  cost_center AS CostCenter,
  profit_center AS ProfitCenter,
  functional_area AS FunctionalArea,
  cast(custom_diff_term_1 as tpm_cust_diff_term_1_value preserving type ) AS TrsyPosCustomDiffntnTerm1,
  cast(custom_diff_term_2 as tpm_cust_diff_term_2_value preserving type ) AS TrsyPosCustomDiffntnTerm2,
  cast( custom_diff_term_3 as tpm_cust_diff_term_3_value preserving type ) AS TrsyPosCustomDiffntnTerm3,
  cast(custom_diff_term_4 as tpm_cust_diff_term_4_value preserving type ) AS TrsyPosCustomDiffntnTerm4,
  cast(custom_diff_term_5 as tpm_cust_diff_term_5_value preserving type ) AS TrsyPosCustomDiffntnTerm5,
  obv_ec_pc AS CostExcldBookValueAmtInPosCrcy,
  position_curr AS PositionCurrency,
  obv_ec_vc AS CostExcldBookValAmtInValnCrcy,
  valuation_curr AS ValuationCurrency
FROM tlvt_manual_val
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON FinancialTransaction = _FinancialTransaction.FinancialTransaction AND CompanyCode = _FinancialTransaction.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SecurityClassBasic AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON PositionCurrency = _PositionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ValuationCurrency ON PositionCurrency = _ValuationCurrency.Currency  -- association [0..1]
;