R_FinancialTransactionFacility

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 R_FinancialTransactionFacility.
-- 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: RFINTRANSFCITY

CREATE VIEW R_FinancialTransactionFacility AS
SELECT
  case Relat.relat_obj_cat when 'FAC' then substring(Relat.relat_obj,1,4) else Relat.company_code end as CompanyCode AS company_codeendasCompanyCode,
  case Relat.relat_obj_cat when 'FAC' then substring(Relat.relat_obj,5,13) else Relat.deal_number end as FinancialTransaction AS deal_numberendasFinancialTransaction,
  Relat.partner AS SyndicatedCounterparty,
  cast(Relat.relat_obj as crdt_line_assgmt_obj preserving type ) AS CreditLineAssignmentObject,
  Relat.relat_obj_cat AS CreditLineAssgmtObjectCategory,
  Relat.start_date AS TermStartDate,
  Relat.end_date AS TermEndDate,
  Relat.credit_line AS CreditLineIdentifier,
  cast(Relat.ref_obj as crdt_line_refcd_assgmt_obj preserving type ) AS CrdtLineRefcdAssgmtObj,
  Limit.limit_date AS CreditLineValidFromDate,
  Limit.limit_currency AS CreditLineCurrency,
  cast(Limit.limit_chg_amount as credit_line_change_amt preserving type ) AS CreditLineChangeAmount,
  cast(Limit.limit_pos_amount as credit_line_position_amt preserving type ) AS CreditLinePositionAmount
FROM vtb_asgn_limit AS Limit
INNER JOIN vtb_asgn_relat AS Relat ON /* join condition not captured in parsed metadata */
;