P_Ftr_Asgn_Facility

DDL: P_FTR_ASGN_FACILITY SQL: PFTRASGNFACILITY Type: view COMPOSITE
9 Fields 1 Data Sources

P_Ftr_Asgn_Facility is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (vtb_asgn_relat) and exposes 9 fields with key fields company_codeendasCompanyCode, deal_numberendasFinancialTransaction.

Data Sources (1)

SourceAliasJoin Type
vtb_asgn_relat Relat from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PFTRASGNFACILITY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY company_codeendasCompanyCode
KEY deal_numberendasFinancialTransaction
SyndicatedCounterparty vtb_asgn_relat partner With Partner
RelatObject vtb_asgn_relat relat_obj Assignment Obj.
RelatObjectCategory vtb_asgn_relat relat_obj_cat Assignment Obj.Cat.
TermStartDate vtb_asgn_relat start_date Valn start date
TermEndDate vtb_asgn_relat end_date Valn End date
CreditLine vtb_asgn_relat credit_line Credit Line
ref_objendasReferenceObject

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 P_Ftr_Asgn_Facility.
-- 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: PFTRASGNFACILITY
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date

CREATE VIEW P_Ftr_Asgn_Facility 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,
  Relat.relat_obj AS RelatObject,
  Relat.relat_obj_cat AS RelatObjectCategory,
  Relat.start_date AS TermStartDate,
  Relat.end_date AS TermEndDate,
  Relat.credit_line AS CreditLine,
  case when Relat.credit_line <> '' and Relat.partner = '' then '' else Relat.ref_obj end as ReferenceObject AS ref_objendasReferenceObject
FROM vtb_asgn_relat AS Relat
;

Learn More