I_RU_FinancialContract

DDL: I_RU_FINANCIALCONTRACT SQL: IRUFINCNT Type: view BASIC
12 Fields 1 Data Sources

Interface view for Contracts in Accounting

I_RU_FinancialContract is a Basic CDS View that provides data about "Interface view for Contracts in Accounting" in SAP S/4HANA. It reads from 1 data source (firud_acc_cntrct) and exposes 12 fields with key fields CompanyCode, BusinessPartnerContract.

Data Sources (1)

SourceAliasJoin Type
firud_acc_cntrct firud_acc_cntrct from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUFINCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Interface view for Contracts in Accounting view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode firud_acc_cntrct companycode Receiver Company Code
KEY BusinessPartnerContract firud_acc_cntrct businesspartnercontract Int. Contract Number
BusinessPartnerContractExt firud_acc_cntrct businesspartnercontractext Ext. Contract Number
ContractStartDate firud_acc_cntrct contractstartdate Contract Start Date
ContractEndDate firud_acc_cntrct contractenddate Contract End Date
Customer firud_acc_cntrct customer Sold-to Party
Supplier firud_acc_cntrct supplier Supplier
Comments firud_acc_cntrct comments User Notes
CreationDateTime firud_acc_cntrct creationdatetime Timestamp
CreatedByUser firud_acc_cntrct createdbyuser User Name
LastChangeDateTime firud_acc_cntrct lastchangedatetime Timestamp
LastChangeByUserName firud_acc_cntrct lastchangebyusername User Name

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_RU_FinancialContract.
-- 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: IRUFINCNT

CREATE VIEW I_RU_FinancialContract AS
SELECT
  firud_acc_cntrct.companycode AS CompanyCode,
  firud_acc_cntrct.businesspartnercontract AS BusinessPartnerContract,
  firud_acc_cntrct.businesspartnercontractext AS BusinessPartnerContractExt,
  firud_acc_cntrct.contractstartdate AS ContractStartDate,
  firud_acc_cntrct.contractenddate AS ContractEndDate,
  firud_acc_cntrct.customer AS Customer,
  firud_acc_cntrct.supplier AS Supplier,
  firud_acc_cntrct.comments AS Comments,
  firud_acc_cntrct.creationdatetime AS CreationDateTime,
  firud_acc_cntrct.createdbyuser AS CreatedByUser,
  firud_acc_cntrct.lastchangedatetime AS LastChangeDateTime,
  firud_acc_cntrct.lastchangebyusername AS LastChangeByUserName
FROM firud_acc_cntrct
;

Learn More