I_FinancialTransaction

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_FinancialTransaction.
-- 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: IFINTRAN

CREATE VIEW I_FinancialTransaction AS
SELECT
  FinancialTransactionTable.bukrs AS CompanyCode,
  FinancialTransactionTable.rfha AS FinancialTransaction,
  FinancialTransactionTable.objnr AS TreasuryFinancialObject,
  FinancialTransactionTable.cruser AS CreatedByUser,
  cast( FinancialTransactionTable.dcrdat as ftr_creation_date preserving type ) AS FinTransCreationDate,
  FinancialTransactionTable.tcrtim AS FinTransCreationTime,
  cast(FinancialTransactionTable.upuser as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  FinancialTransactionTable.dupdat AS LastChangeDate,
  FinancialTransactionTable.tuptim AS FinInstrumentLastChangedTime,
  FinancialTransactionTable.rantyp AS TreasuryContractType,
  cast(FinancialTransactionTable.sanlf as ftr_gen_fin_instr_prod_categ preserving type) AS FinancialInstrProductCategory,
  FinancialTransactionTable.sgsart AS FinancialInstrumentProductType,
  FinancialTransactionTable.sfgtyp AS FinInstrTransactionCategory,
  cast(FinancialTransactionTable.sfhaart as ftr_gen_transaction_type preserving type) AS FinancialInstrTransactionType,
  FinancialTransactionTable.abwtyp AS FinTransProcessingCategory,
  FinancialTransactionTable.dblfz AS TermStartDate,
  cast(FinancialTransactionTable.sinclbe as abap_boolean preserving type ) AS TermStartDateIsInclusive,
  FinancialTransactionTable.akuend AS FinTransNoticePeriod,
  FinancialTransactionTable.skuend AS FinTransNoticePeriodUnit,
  FinancialTransactionTable.skalid AS FinTransFactoryCalendar1,
  FinancialTransactionTable.skalid2 AS FinTransFactoryCalendar2,
  cast(FinancialTransactionTable.kontrh as rkontrah_new preserving type) AS Counterparty,
  FinancialTransactionTable.rgarant AS FinancialInstrumentGuarantor,
  FinancialTransactionTable.rportb AS Portfolio,
  FinancialTransactionTable.zuonr AS TreasuryFinanceProject,
  cast(FinancialTransactionTable.zuond as ftr_gen_fin_instr_assignment preserving type) AS FinancialInstrumentAssignment,
  cast(FinancialTransactionTable.refer as ftr_gen_fin_instr_internal_ref preserving type) AS FinancialInstrumentReference,
  cast(FinancialTransactionTable.merkm as ftr_gen_fin_instr_char preserving type) AS FinancialInstrCharacteristic,
  FinancialTransactionTable.rcomvalcl AS TreasuryValuationClass,
  FinancialTransactionTable.rbusa AS BusinessArea,
  _CompanyCode.ControllingArea AS ControllingArea,
  FinancialTransactionTable.rcntr AS CostCenter,
  FinancialTransactionTable.hedge_class AS HedgingClassification,
  cast( FinancialTransactionTable.hedge_request_id as hedge_request_identifier preserving type ) AS HedgeRequestIdentifier,
  FinancialTransactionTable.prctr AS ProfitCenter,
  cast(FinancialTransactionTable.ps_posid as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  FinancialTransactionTable.facilitybukrs AS TreasuryFacilityCompanyCode,
  FinancialTransactionTable.facilitynr AS TreasuryFacility,
  FinancialTransactionTable.saktiv AS FinancialInstrumentStatus,
  FinancialTransactionTable.sfrgzust AS FinTransReleaseStatus,
  FinancialTransactionTable.wgschft AS TransactionCurrency,
  FinancialTransactionTable.wgschft1 AS FinInstrumentOutgoingCurrency,
  FinancialTransactionTable.wgschft2 AS FinInstrumentIncomingCurrency,
  FinancialTransactionTable.traded_currency AS TradedCurrency,
  cast(FinancialTransactionTable.ranl as ftr_gen_security_class preserving type) AS SecurityClass,
  FinancialTransactionTable.isin AS SecurityClassIntlScrtyIdnNmbr,
  FinancialTransactionTable.cfi_code AS ClassificationOfFinInstr,
  cast(FinancialTransactionTable.rldepo as ftr_gen_security_account preserving type) AS SecurityAccount,
  FinancialTransactionTable.posacc AS FuturesAccount,
  FinancialTransactionTable.clearing_option AS FinTransCentralClearingOption,
  FinancialTransactionTable.clearing_status AS FinTransCentralClearingStatus,
  FinancialTransactionTable.clearing_date AS FinTransCentralClearingDate,
  FinancialTransactionTable.clear_date_act AS FinTransCntrlClrgActualDate,
  FinancialTransactionTable.ext_account AS CentralClearingAccount,
  FinancialTransactionTable.risk_mitigating AS FinTransIsRiskMitigating,
  cast(FinancialTransactionTable.rfhazul as ftr_gen_fin_instr_last_act_act preserving type) AS FinInstrLastActiveActivity,
  FinancialTransactionTable.delfz AS TermEndDate,
  FinancialTransactionTable.fb_segment AS Segment,
  FinancialTransactionTable.behalf_of_company AS OnBehalfOfCompany,
  FinancialTransactionTable.mic AS MarketIdentifierCode,
  FinancialTransactionTable.srndng AS FinTransRoundingCategory,
  FinancialTransactionTable.rcomvalcl AS FinTransGeneralValuationClass,
  FinancialTransactionTable.fund AS Fund,
  FinancialTransactionTable.grant_nbr AS GrantID,
  FinancialTransactionTable.tbegru AS FinTransAuthorizationGroup,
  FinancialTransactionTable.bupla AS BusinessPlace,
  FinancialTransactionTable.fkber AS FunctionalArea,
  FinancialTransactionTable.custom_diff_term_1 AS TrsyPosCustomDiffntnTerm1,
  FinancialTransactionTable.custom_diff_term_2 AS TrsyPosCustomDiffntnTerm2,
  FinancialTransactionTable.custom_diff_term_3 AS TrsyPosCustomDiffntnTerm3,
  FinancialTransactionTable.custom_diff_term_4 AS TrsyPosCustomDiffntnTerm4,
  FinancialTransactionTable.custom_diff_term_5 AS TrsyPosCustomDiffntnTerm5,
  FinancialTransactionTable.upi AS UniqueProductIdentifier,
  FinancialTransactionTable.isin AS InternationalSecuritiesIdnNmbr,
  FinancialTransactionTable.rtn AS ReportTrackingNumber,
  FinancialTransactionTable.rgatt AS FinTransOptionNumber
FROM vtbfha AS FinancialTransactionTable
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_TreasuryContractType AS _ContractType ON TreasuryContractType = _ContractType.TreasuryContractType  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrProdCat AS _FinancialInstrProdCat ON FinancialInstrProductCategory = _FinancialInstrProdCat.FinancialInstrProductCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _FinancialInstrProdType ON FinancialInstrumentProductType = _FinancialInstrProdType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_FinInstrTransCat AS _FinInstrTransCat ON FinancialInstrProductCategory = _FinInstrTransCat.FinancialInstrProductCategory AND FinInstrTransactionCategory = _FinInstrTransCat.FinInstrTransactionCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _FinancialInstrTransType ON FinancialInstrTransactionType = _FinancialInstrTransType.FinancialInstrTransactionType AND FinancialInstrumentProductType = _FinancialInstrTransType.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_FinTransProcgCategory AS _ProcessingCategory ON FinancialInstrProductCategory = _ProcessingCategory.FinancialInstrProductCategory AND FinInstrTransactionCategory = _ProcessingCategory.FinInstrTransactionCategory AND FinTransProcessingCategory = _ProcessingCategory.FinTransProcessingCategory  -- association [0..1]
LEFT OUTER JOIN I_FinTransNoticePeriodUnit AS _NoticePeriodUnit ON FinTransNoticePeriodUnit = _NoticePeriodUnit.FinTransNoticePeriodUnit  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar ON FinTransFactoryCalendar1 = _Calendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _Calendar2 ON FinTransFactoryCalendar2 = _Calendar2.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Counterparty ON Counterparty = _Counterparty.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _Guarantor ON FinancialInstrumentGuarantor = _Guarantor.BusinessPartner  -- 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_FinancialInstrAssignment AS _Assignment ON FinancialInstrumentAssignment = _Assignment.FinancialInstrumentAssignment  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrReference AS _Reference ON FinancialInstrumentReference = _Reference.FinancialInstrumentReference  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrCharacteristic AS _Characteristics ON FinancialInstrCharacteristic = _Characteristics.FinancialInstrCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_Financialinstrvaluationclass AS _ValuationClass ON TreasuryValuationClass = _ValuationClass.FinancialInstrValuationClass  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CompanyCode = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter_2 ON ControllingArea = _CostCenter_2.ControllingArea AND CostCenter = _CostCenter_2.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_TreasuryHedgingClassfctn AS _TreasuryHedgingClassfctn ON HedgingClassification = _TreasuryHedgingClassfctn.HedgingClassification  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON CompanyCode = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter_2 ON ControllingArea = _ProfitCenter_2.ControllingArea AND ProfitCenter = _ProfitCenter_2.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _FacilityCompanyCode ON TreasuryFacilityCompanyCode = _FacilityCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinInstrumentStatus AS _Status ON FinancialInstrumentStatus = _Status.FinancialInstrumentStatus  -- association [0..1]
LEFT OUTER JOIN I_FinTransReleaseStatus AS _ReleaseStatus ON FinTransReleaseStatus = _ReleaseStatus.FinTransReleaseStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OutgoingCurrency ON FinInstrumentOutgoingCurrency = _OutgoingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _IncomingCurrency ON FinInstrumentIncomingCurrency = _IncomingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TradedCurrency ON TradedCurrency = _TradedCurrency.Currency  -- 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_TreasuryPositionAccount AS _FuturesAccount ON CompanyCode = _FuturesAccount.CompanyCode AND FuturesAccount = _FuturesAccount.TreasuryPositionAccount  -- association [0..1]
LEFT OUTER JOIN I_FinTransCntrlClrgOption AS _CentralClearingOption ON FinTransCentralClearingOption = _CentralClearingOption.FinTransCentralClearingOption  -- association [0..1]
LEFT OUTER JOIN I_FinTransCntrlClrgStatus AS _CentralClearingStatus ON FinTransCentralClearingStatus = _CentralClearingStatus.FinTransCentralClearingStatus  -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccount AS _CentralClearingAccount ON CompanyCode = _CentralClearingAccount.CompanyCode AND CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount  -- association [0..*]
LEFT OUTER JOIN I_FinTransContractActivity AS _ContractActivity ON CompanyCode = _ContractActivity.CompanyCode AND FinancialTransaction = _ContractActivity.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransActivity AS _CurrentActivity ON CompanyCode = _CurrentActivity.CompanyCode AND FinancialTransaction = _CurrentActivity.FinancialTransaction AND FinInstrLastActiveActivity = _CurrentActivity.FinancialInstrumentActivity  -- association [0..1]
LEFT OUTER JOIN I_FinTransSecurity AS _Security ON CompanyCode = _Security.CompanyCode AND FinancialTransaction = _Security.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransInterest AS _Interest ON CompanyCode = _Interest.CompanyCode AND FinancialTransaction = _Interest.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransNominal AS _Nominal ON CompanyCode = _Nominal.CompanyCode AND FinancialTransaction = _Nominal.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransActivity AS _TabActivity ON CompanyCode = _TabActivity.CompanyCode AND FinancialTransaction = _TabActivity.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransFlow AS _TabFlow ON CompanyCode = _TabFlow.CompanyCode AND FinancialTransaction = _TabFlow.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_FinTransCondition AS _TabCondition ON CompanyCode = _TabCondition.CompanyCode AND FinancialTransaction = _TabCondition.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN I_LetterOfCredit AS _LetterOfCredit ON CompanyCode = _LetterOfCredit.CompanyCode AND FinancialTransaction = _LetterOfCredit.FinancialTransaction AND FinInstrLastActiveActivity = _LetterOfCredit.FinancialInstrumentActivity  -- association [0..1]
;