I_PositionIdentifier

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_PositionIdentifier.
-- 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.
-- SQL view name: IPOSIDENT

CREATE VIEW I_PositionIdentifier AS
SELECT
  cast(dift.os_guid as ftr_gen_position_ident_uuid preserving type) AS TrsyPositionIdentificationUUID,
  cast (dift.identified_oid as ftr_gen_position_uuid preserving type) AS TreasuryPosition,
  dift.valuation_area AS TreasuryValuationArea,
  cast(dift.com_val_class as ftr_gen_fin_instr_val_class preserving type) AS FinancialInstrValuationClass,
  cast(dift.valuation_class as ftr_gen_valuation_class preserving type) AS TreasuryValuationClass,
  dift.company_code AS CompanyCode,
  dift.product_type AS FinancialInstrumentProductType,
  cast(dift.security_account as ftr_gen_security_account preserving type) AS SecurityAccount,
  cast(dift.security_id as ftr_gen_security_class preserving type) AS SecurityClass,
  cast(dift.portfolio as ftr_gen_portfolio_diff preserving type) AS DifferentiationPortfolio,
  dift.trader AS Trader,
  cast(dift.account_group as ftr_gen_sec_account_group preserving type) AS SecurityAccountGroup,
  cast(loans_contract as ftr_gen_loan_contract preserving type) AS LoanContract,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  cast(dift.position_account as ftr_gen_pos_account_future preserving type) AS TreasuryPositionAccount,
  cast(dift.flag_long_short as ftr_gen_long_short_code preserving type) AS TreasuryPositionLongShortCode,
  dift.lot_id AS TreasuryPositionLot,
  cast(dift.deal_number as tb_rfha preserving type) AS FinancialTransaction,
  dift.fund AS Fund,
  dift.grant_nbr AS GrantID,
  cast(dift.wbs_element as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  dift.profit_center AS ProfitCenter,
  dift.cost_center AS CostCenter,
  dift.functional_area AS FunctionalArea,
  cast(dift.external_account as ftr_gen_cntrl_clearing_account preserving type) AS CentralClearingAccount,
  cast(diff_currency as ftr_gen_cntrl_clrng_accnt_crcy preserving type) AS CentralClearingAccountCurrency,
  dift.context AS TreasuryPositionContext,
  dift.accounting_code AS TreasuryAccountingCode,
  dift.exposure_item_id AS FinancialExposureItem,
  dift.exposure_subitem_id AS FinancialExposureSubItem,
  cast(dift.custom_diff_term_1 as tpm_cust_diff_term_1_value preserving type ) AS TrsyPosCustomDiffntnTerm1,
  cast(dift.custom_diff_term_2 as tpm_cust_diff_term_2_value preserving type ) AS TrsyPosCustomDiffntnTerm2,
  cast(dift.custom_diff_term_3 as tpm_cust_diff_term_3_value preserving type ) AS TrsyPosCustomDiffntnTerm3,
  cast(dift.custom_diff_term_4 as tpm_cust_diff_term_4_value preserving type ) AS TrsyPosCustomDiffntnTerm4,
  cast(dift.custom_diff_term_5 as tpm_cust_diff_term_5_value preserving type ) AS TrsyPosCustomDiffntnTerm5
FROM dift_pos_ident AS dift
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrValClassText AS _FinancialInstrValClassText ON FinancialInstrValuationClass = _FinancialInstrValClassText.FinancialInstrValuationClass AND _FinancialInstrValClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Financialinstrvaluationclass AS _FinancialInstrValuationClass ON FinancialInstrValuationClass = _FinancialInstrValuationClass.FinancialInstrValuationClass  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClassText AS _TreasuryValuationClassText ON TreasuryValuationClass = _TreasuryValuationClassText.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClassText.TreasuryValuationArea AND _TreasuryValuationClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProdType ON FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdTypeText AS _FinancialInstrProdTypeText ON FinancialInstrumentProductType = _FinancialInstrProdTypeText.FinancialInstrumentProductType AND _FinancialInstrProdTypeText.Language = $session.system_language  -- 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 SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccountGroup AS _SecurityAccountGroup ON SecurityAccountGroup = _SecurityAccountGroup.SecurityAccountGroup AND CompanyCode = _SecurityAccountGroup.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DifferentiationPortfolioText AS _DifferentiationPortfolioText ON DifferentiationPortfolio = _DifferentiationPortfolioText.DifferentiationPortfolio AND CompanyCode = _DifferentiationPortfolioText.CompanyCode AND _DifferentiationPortfolioText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount AND CompanyCode = _TreasuryPositionAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccount AS _CentralClearingAccount ON CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount AND CompanyCode = _CentralClearingAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LoanContract AS _LoanContract ON LoanContract = _LoanContract.LoanContract AND CompanyCode = _LoanContract.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm1 AS _TrsyPosCustomDiffntnTerm1 ON TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;