What is I_FacilityContract in SAP S/4HANA?

I_FacilityContract is a composite CDS view in SAP S/4HANA. Treasury Facility Contract It contains 21 fields.

Which tables does I_FacilityContract read from?

I_FacilityContract reads data from: P_Ftr_Asgn_Utilize.

What VDM layer is I_FacilityContract?

I_FacilityContract is classified as a Composite view that combines data from multiple basic views.

I_FacilityContract

DDL: I_FACILITYCONTRACT Type: view COMPOSITE

21 Fields 1 Data Sources 7 Associations

Treasury Facility Contract

I_FacilityContract (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FacilityContract is a Composite CDS View that provides data about "Treasury Facility Contract" in SAP S/4HANA. It reads from 1 data source (P_Ftr_Asgn_Utilize) and exposes 21 fields with key fields CompanyCode, FinancialTransaction, KeyDate, Counterparty, SyndicatedCounterparty. It has 7 associations to related views.

SAP Help Documentation

Category	Facilities
Data Category	Composite
Status	Released

Purpose
This CDS view meets the prerequisites for answering the following business questions: What is the credit line with a counterparty or syndicate counterparty on the key date? What is the credit line with a counterparty or syndicate counterparty in the specified currency?

Prerequisites
The role must grant display authorization for the following authorization objects and fields: Authorization for Product/Transaction Types ( T_DEAL_PD ) Company Code Product Type Transaction Type

Structure
Object types This view is built on the facility object type. Main CDS parameters and filters The main CDS parameter is Key Date. The main filters are: Counterparty Syndicate counterparty Credit line in transaction currency Measures and attributes Some important measures and attributes are: Company code Transaction Business partner Transaction category Product type Transaction type Portfolio Financial instrument assignment Financial instrument reference Financial instrument characteristic Transaction currency

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-TRM
Capabilities	Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Financial Operations for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view meets the prerequisites for answering the following business questions:</p> <ul> <li><p>What is the credit line with a counterparty or syndicate counterparty on the key date?</p></li> <li><p>What is the credit line with a counterparty or syndicate counterparty in the specified currency?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_Ftr_Asgn_Utilize	P_Ftr_Asgn_Utilize	from

Parameters (1)

Name	Type	Default
P_KeyDate	vdm_v_key_date

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_FinancialTransaction	_FinancialTransaction	`_FinancialTransaction.CompanyCode = Utilization.CompanyCode and _FinancialTransaction.FinancialTransaction = Utilization.FinancialTransaction`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_BusinessPartner	_Counterparty	`$projection.counterparty = _Counterparty.BusinessPartner`
[0..1]	I_BusinessPartner	_SynCounterparty	`$projection.SyndicatedCounterparty = _SynCounterparty.BusinessPartner`
[0..1]	I_FinInstrTransCat	_FinInstrTransCat	`_FinInstrTransCat.FinancialInstrProductCategory = '560' and _FinInstrTransCat.FinInstrTransactionCategory = $projection.fininstrtransactioncategory`
[0..1]	I_Currency	_TransactionCurrency	`$projection.TransactionCurrency = _TransactionCurrency.Currency`
[1..1]	I_CalendarDate	_KeyDate	`$projection.KeyDate = _KeyDate.CalendarDate`

Annotations (13)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Treasury Facility Contract	view
AbapCatalog.sqlViewName	IFACCONTRACT	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.representativeKey	FinancialTransaction	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (21)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	Utilization	CompanyCode	Receiver Company Code
KEY	FinancialTransaction	Utilization	FinancialTransaction	Financial Transaction
KEY	KeyDate	Utilization	KeyDate	Maturity Key Date
KEY	Counterparty	_FinancialTransaction	Counterparty	Counterparty Number
KEY	SyndicatedCounterparty	Utilization	SyndicatedCounterparty	Business Partner Number
	FinInstrTransactionCategory	_FinancialTransaction	FinInstrTransactionCategory	Transaction Category
	FinancialInstrumentProductType	_FinancialTransaction	FinancialInstrumentProductType	Product Type
	FinancialInstrTransactionType	_FinancialTransaction	FinancialInstrTransactionType	Financial Instrument Transaction Type
	Portfolio	_FinancialTransaction	Portfolio	Portfolio
	FinancialInstrumentAssignment	_FinancialTransaction	FinancialInstrumentAssignment	Free Assignment of Financial Transaction
	FinancialInstrumentReference	_FinancialTransaction	FinancialInstrumentReference	Free Internal Reference of Financial Transaction
	FinancialInstrCharacteristic	_FinancialTransaction	FinancialInstrCharacteristic	Free Characteristic of Financial Transaction
	TransactionCurrency	Utilization	TransactionCurrency	Transaction Currency
	TotalAmountInTransactionCrcy	Utilization	TotalAmount	Credit Line in Transaction Currency
	_FinancialTransaction		_FinancialTransaction
	_CompanyCode		_CompanyCode
	_Counterparty		_Counterparty
	_SynCounterparty		_SynCounterparty
	_FinInstrTransCat		_FinInstrTransCat
	_KeyDate		_KeyDate
	_TransactionCurrency		_TransactionCurrency

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

CREATE VIEW I_FacilityContract AS
SELECT
  Utilization.CompanyCode AS CompanyCode,
  Utilization.FinancialTransaction AS FinancialTransaction,
  Utilization.KeyDate AS KeyDate,
  _FinancialTransaction.Counterparty AS Counterparty,
  Utilization.SyndicatedCounterparty AS SyndicatedCounterparty,
  _FinancialTransaction.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  _FinancialTransaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _FinancialTransaction.Portfolio AS Portfolio,
  _FinancialTransaction.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  _FinancialTransaction.FinancialInstrumentReference AS FinancialInstrumentReference,
  _FinancialTransaction.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  Utilization.TransactionCurrency AS TransactionCurrency,
  Utilization.TotalAmount AS TotalAmountInTransactionCrcy
FROM P_Ftr_Asgn_Utilize
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON _FinancialTransaction.CompanyCode = Utilization.CompanyCode AND _FinancialTransaction.FinancialTransaction = Utilization.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Counterparty ON counterparty = _Counterparty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SynCounterparty ON SyndicatedCounterparty = _SynCounterparty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FinInstrTransCat AS _FinInstrTransCat ON _FinInstrTransCat.FinancialInstrProductCategory = '560' AND _FinInstrTransCat.FinInstrTransactionCategory = fininstrtransactioncategory  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _KeyDate ON KeyDate = _KeyDate.CalendarDate  -- association [1..1]
;

Depth:

I_FacilityContract view

P_Ftr_Asgn_Utilize view