I_DiftPosIdent

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_DiftPosIdent.
-- 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: IDIFTPOSIDENT

CREATE VIEW I_DiftPosIdent AS
SELECT
  TrsyPositionIdentificationUUID,
  TreasuryPosition,
  TreasuryValuationArea,
  cast(_TreasuryValuationArea.TreasuryValuationAreaName as ftr_gen_valuation_area_name) AS TreasuryValuationAreaName,
  FinancialInstrValuationClass,
  cast(_FinancialInstrValClassText.FinancialInstrValClassName as ftr_gen_fin_instr_val_cls_name) AS FinancialInstrValClassName,
  TreasuryValuationClass,
  cast(_TreasuryValuationClassText.TreasuryValuationClassName as ftr_gen_valuation_class_name) AS TreasuryValuationClassName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  FinancialInstrumentProductType,
  cast(_FinancialInstrProdTypeText.FinancialInstrProdTypeName as ftr_gen_product_type_name) AS FinancialInstrProdTypeName,
  SecurityAccount,
  cast(_SecurityAccount.SecurityAccountName as ftr_gen_security_account_name) AS SecurityAccountName,
  SecurityClass,
  cast(_SecurityClass.SecurityClassName as ftr_gen_security_class_name) AS SecurityClassName,
  cast(_SecurityClass.SecurityClassDescription as ftr_gen_security_class_lname) AS SecurityClassDescription,
  cast(_SecurityClass.Issuer as repke_new) AS Issuer,
  DifferentiationPortfolio,
  cast(_DifferentiationPortfolioText.DifferentiationPortfolioName as ftr_gen_portfolio_diff_name) AS DifferentiationPortfolioName,
  dift.Trader AS Trader,
  SecurityAccountGroup,
  cast(_SecurityAccountGroup.SecurityAccountGroupName as ftr_gen_sec_account_group_name) AS SecurityAccountGroupName,
  LoanContract,
  cast(_LoanContract.LoanContractName as ftr_gen_loan_contract_name) AS LoanContractName,
  TreasuryPositionAccount,
  cast(_TreasuryPositionAccount.TreasuryPositionAccountName as ftr_gen_pos_accnt_future_name) AS TreasuryPositionAccountName,
  TreasuryPositionLongShortCode,
  TreasuryPositionLot,
  FinancialTransaction,
  dift.Fund AS Fund,
  GrantID,
  CentralClearingAccount,
  cast(_CentralClearingAccount.CentralClearingAccountName as ftr_gen_cntrl_clrng_accnt_name) AS CentralClearingAccountName,
  CentralClearingAccountCurrency,
  TreasuryPositionContext,
  TreasuryAccountingCode,
  FinancialExposureItem,
  FinancialExposureSubItem
FROM I_PositionIdentifier AS dift
;