C_FinTransactionManage

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 C_FinTransactionManage.
-- 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: CFINTRSMANAGE
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW C_FinTransactionManage AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinTransWithCompanyCode,
  CreatedByUser,
  _CreatedBy.FullName AS CreatedByUserDescription,
  FinTransCreationDate,
  FinTransCreationTime,
  LastChangedByUser,
  _LastChangedBy.FullName AS LastChangedByUserDescription,
  LastChangeDate,
  FinInstrumentLastChangedTime,
  TreasuryContractType,
  _ContractType._Text[1:Language = $session.system_language].TreasuryContractTypeName AS TreasuryContractTypeName,
  FinancialInstrProductCategory,
  _FinancialInstrProdCat._Text[1:Language = $session.system_language].FinInstrProductCategoryName AS FinInstrProductCategoryName,
  FinancialInstrumentProductType,
  _FinancialInstrProdType._Text[1:Language = $session.system_language].FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
  FinInstrTransactionCategory,
  _FinInstrTransCat._Text[1:Language = $session.system_language].FinInstrTransCategoryName AS FinInstrTransCategoryName,
  FinancialInstrTransactionType,
  _FinancialInstrTransType._Text[1:Language = $session.system_language].FinancialInstrTransTypeName AS FinancialInstrTransTypeName,
  FinTransGenActivityCategory,
  _GenActivityCategory._Text[1:Language = $session.system_language].FinTransGenActyCatName AS FinTransGenActyCatName,
  FinancialInstrActivityCategory,
  _FinInstrActivityCategory._ActivityCategoryText[1:Language = $session.system_language].FinInstrActivityCategoryName AS FinInstrActivityCategoryName,
  Counterparty,
  _Counterparty.BusinessPartnerName AS BusinessPartnerName,
  Portfolio,
  _Portfolio._TreasuryPortfolioText[1:Language = $session.system_language].PortfolioName AS PortfolioName,
  FinancialInstrumentAssignment,
  FinancialInstrumentReference,
  FinancialInstrCharacteristic,
  TreasuryValuationClass,
  _ValuationClass._Text[1:Language = $session.system_language].FinancialInstrValClassName AS FinancialInstrValClassName,
  HedgingClassification,
  HedgeRequestIdentifier,
  ProfitCenter,
  CostCenter,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  OnBehalfOfCompany,
  ClassificationOfFinInstr,
  UniqueProductIdentifier,
  InternationalSecuritiesIdnNmbr,
  ReportTrackingNumber,
  FinTransIsRiskMitigating,
  TreasuryFacilityCompanyCode,
  TreasuryFacility,
  FinancialInstrumentStatus,
  _Status._Text[1:Language = $session.system_language].FinancialInstrumentStatusName AS FinancialInstrumentStatusName,
  TermStartDate,
  FinTransActyConclusionDate,
  Trader,
  FinInstrExternalReference,
  TermEndDate,
  TreasuryFinanceProject,
  TransactionCurrency,
  AmountInTransactionCurrency,
  FinTransFlowNomAmtCrcy,
  FinTransFlowNomAmt,
  FinInstrOutgoingNominalAmount,
  FinInstrumentOutgoingCurrency,
  FinInstrIncomingNominalAmount,
  FinInstrumentIncomingCurrency,
  FinTransFlowPaytAmtCrcy,
  FinTransFlowPaytAmt,
  FinConditionInterestCategory,
  _InterestCategory._Text[1:Language = $session.system_language].FinCndnInterestCategoryName AS FinCndnInterestCategoryName,
  InterestCalculationMethod,
  _InterestCalcualationMethod._Text[1:Language = $session.system_language].InterestCalculationMethodName AS InterestCalculationMethodName,
  ConditionPercentageRate,
  InterestReference,
  FinCndnUpperLimitPctgRate,
  FinCndnLowerLimitPctgRate,
  FinInstrOutgCndnIntrstCategory,
  cast(_OutgInterestCategory._Text[1:Language = $session.system_language].FinCndnInterestCategoryName as ftr_instr_outg_intrst_cat_name preserving type ) AS FinInstrOutgCndnIntrstCatName,
  FinInstrOutgCndnPctgRate,
  FinInstrOutgIntrstReference,
  FinInstrOutgIntrstCalcMeth,
  cast(_OutgInterestCalMethod._Text[1:Language = $session.system_language].InterestCalculationMethodName as ftr_outg_intrst_cacl_mthd_name preserving type ) AS FinInstrOutgIntrstCalcMethName,
  FinInstrIncgCndnIntrstCategory,
  cast(_IncgInterestCategory._Text[1:Language = $session.system_language].FinCndnInterestCategoryName as ftr_instr_incg_intrst_cat_name preserving type ) AS FinInstrIncgCndnIntrstCatName,
  FinInstrIncgCndnPctgRate,
  FinInstrIncgIntrstReference,
  FinInstrIncgIntrstCalcMeth,
  cast(_IncgInterestCalMethod._Text[1:Language = $session.system_language].InterestCalculationMethodName as ftr_incg_intrst_cacl_mthd_name preserving type ) AS FinInstrIncgIntrstCalcMethName,
  InterestMarkupMarkdownValue,
  OutgIntrstMarkupMarkdownVal,
  IncgIntrstMarkupMarkdownVal,
  FwdRateAgrmtLeadTmeStrtDte,
  FwdRateAgrmtHdgPerdStrtDte,
  FwdRateAgrmtHdgPerdEndDte,
  LetterOfCredit,
  TreasuryBeneficiary,
  cast( _BeneficiaryBP.OrganizationBPName1 as ftr_gen_trsy_beneficiary_name preserving type) AS TreasuryBeneficiaryName,
  TreasuryAdvisingBank,
  _AdvisingBank.BusinessPartnerName AS TreasuryAdvisingBankName,
  TreasuryApplicant,
  cast( _ApplicantBP.OrganizationBPName1 as ftr_gen_trsy_applicant_name preserving type ) AS TreasuryApplicantName,
  _CounterpartyBP.SearchTerm1 AS SearchTerm1,
  _CounterpartyBP.SearchTerm2 AS SearchTerm2,
  _CounterpartyBP._BPFinancialServicesExtn.TradingPartner AS TradingPartner,
  TreasuryIssuingBank,
  _IssuingBank.BusinessPartnerName AS TreasuryIssuingBankName,
  BankGuaranteeNumber,
  BankGuaranteeType,
  _BankGuaranteeType._Text[1:Language = $session.system_language].BankGuaranteeTypeName AS BankGuaranteeTypeName,
  SecurityClass,
  _SecurityClass.SecurityClassName AS SecurityClassName,
  SecurityAccount,
  _SecurityAccount.SecurityAccountName AS SecurityAccountName,
  FinTransTradedNumberOfUnits,
  FinTransTrdPriceCrcyUnitRate,
  FinTransTradedPricePercent,
  FinTransTradedPriceCrcyUnit,
  FinTransFlowPaymentDate,
  CalculationDate,
  FinTransPositionValueDate,
  QuotationCurrency,
  MarketValueInQtanCurrency,
  SecurityExchange,
  _SecurityExchange.SecurityExchangeShortName AS SecurityExchangeShortName,
  TrsyTradedAmountBuySellCode,
  _BuySell._Text[1:Language = $session.system_language].FXTradingActivityName AS FXTradingActivityName,
  FinTransFixingDate
FROM I_FinancialTransactionManage
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.Language = $session.system_language  -- association [0..1]
;