TRAC_ACCNT_KEYFIG_SOURCE

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 TRAC_ACCNT_KEYFIG_SOURCE.
-- 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 TRAC_ACCNT_KEYFIG_SOURCE AS
SELECT
  cast ( '1111' as ftr_gen_business_trans_categ preserving type ) AS TreasuryBusinessTransCategory,
  cast ( 'Z99' as tpm_val_area preserving type ) AS TreasuryValuationArea,
  cast ( '9999' as ftr_gen_valuation_class preserving type ) AS TreasuryValuationClass,
  cast ( 'Z999' as fis_bukrs preserving type ) AS CompanyCode,
  cast ( 'ZZZ' as vvsart preserving type ) AS FinancialInstrumentProductType,
  cast ( 'Z123456789' as fm_fund preserving type ) AS Fund,
  cast ( 'Z1234567891234567890' as gm_grant_nbr preserving type ) AS GrantID,
  cast ( 'ZSEACCOUNT' as ftr_gen_security_account preserving type ) AS SecurityAccount,
  cast( 'ZDEPOTGRP1' as ftr_gen_sec_account_group preserving type) AS SecurityAccountGroup,
  cast ( 'ZPORT12345' as rportb preserving type ) AS Portfolio,
  cast ( 'Z123456789012' as ftr_gen_security_class preserving type ) AS SecurityClass,
  cast ( 'ZYX' as ftr_gen_transaction_type preserving type ) AS FinancialInstrTransactionType,
  cast ( 'ZFLOWTYP' as tpm_dis_flowtype preserving type ) AS TreasuryUpdateType,
  cast ('ABCDEFGHIJKL' as tpm_aa_ref preserving type ) AS TreasuryGLAccountAssignmentRef,
  cast ( '20221201' as fis_budat ) AS PostingDate,
  cast ( '99' as monat preserving type ) AS PostingFiscalPeriod,
  cast ( '2022' as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  cast ( '20221201' as fis_bldat ) AS DocumentDate,
  cast ( 'ZZ' as farp_blart preserving type ) AS AccountingDocumentType,
  cast ( 'YY' as fis_bschl preserving type ) AS PostingKey,
  cast ( 123 as ftr_gen_posting_category preserving type ) AS TreasuryPostingCategory,
  cast( 'Z123456789012345' as tpm_acc_symbol preserving type ) AS TreasuryGLAccountSymbol,
  cast ( 'Z123456789' as fis_racct preserving type ) AS GLAccount,
  cast ( 'ZZXX' as fis_ktopl preserving type ) AS ChartOfAccounts,
  cast ( 'ZBUPARTNER' as rkontrah_new preserving type ) AS Counterparty,
  cast( 'ZBPROL' as bu_partnerrole preserving type ) AS BusinessPartnerRole,
  cast ( 'ZBUPARTNER' as repke_new preserving type ) AS Issuer,
  cast ( 'Z12345' as fis_rassc preserving type ) AS PartnerCompany,
  cast ( '12345678' as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast ( 'Z123456789' as fis_kostl preserving type ) AS CostCenter,
  cast ( 'Z123456789' as fis_prctr preserving type ) AS ProfitCenter,
  cast ( 'Z123456789012345' as fm_farea preserving type ) AS FunctionalArea
FROM I_Currency
;