C_RU_FinancialContractTP

DDL: C_RU_FINANCIALCONTRACTTP Type: view_entity CONSUMPTION Package: GLO_FIN_IS_RU_CONTRACT_ACCTG
38 Fields 1 Data Sources 1 Fiori Apps

Accounting Contract Consumption View

C_RU_FinancialContractTP is a Consumption CDS View that provides data about "Accounting Contract Consumption View" in SAP S/4HANA. It reads from 1 data source (I_RU_FinancialContractTP) and exposes 38 fields with key fields CompanyCode, BusinessPartnerContract. It is used in 1 Fiori application: Manage Contracts in Accounting. Part of development package GLO_FIN_IS_RU_CONTRACT_ACCTG.

Data Sources (1)

SourceAliasJoin Type
I_RU_FinancialContractTP I_RU_FinancialContractTP projection

Annotations (15)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Accounting Contract Consumption View view
UI.headerInfo.description.value CompanyCode view
UI.headerInfo.description.label Company Code view
UI.headerInfo.title.value BusinessPartnerContract view
UI.headerInfo.title.label Internal Contract Number view
UI.headerInfo.typeNamePlural Contracts in Accounting view
UI.headerInfo.typeName Contract in Accounting view
OData.publish true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view

Fiori Apps (1)

App IDApp NameTypeDescription
F3758 Manage Contracts in Accounting Transactional Manage Contracts in Accounting

Manage Contracts in Accounting

Business Role: Accounts Receivable Accountant

With this app you can process contracts that you sign with your business partners for services on the level of Financial Accounting. For contracts that involve sales or purchases of goods, use the Manage Sales Contracts, the Manage Purchase Contracts or the Manage Service Contracts apps.

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RU_FinancialContractTP CompanyCode Company Code
KEY BusinessPartnerContract I_RU_FinancialContractTP BusinessPartnerContract Int. Contract Number
BusinessPartnerContractExt I_RU_FinancialContractTP BusinessPartnerContractExt Ext. Contract Number
ContractStartDate I_RU_FinancialContractTP ContractStartDate Contract Start Date
ContractEndDate I_RU_FinancialContractTP ContractEndDate Contract End Date
Customer I_RU_FinancialContractTP Customer Sold-to Party
Supplier I_RU_FinancialContractTP Supplier Supplier
Comments I_RU_FinancialContractTP Comments User Notes
CreationDateTime I_RU_FinancialContractTP CreationDateTime Timestamp
ContractCategory I_RU_FinancialContractTP ContractCategory
CreatedByUser I_RU_FinancialContractTP CreatedByUser User Name
ContractSubject I_RU_FinancialContractTP ContractSubject
ContractServiceSite I_RU_FinancialContractTP ContractServiceSite
ContractCurrency I_RU_FinancialContractTP ContractCurrency
ContractTotalAmount I_RU_FinancialContractTP ContractTotalAmount
ContractSignedDate I_RU_FinancialContractTP ContractSignedDate
ContractAccountingNumber I_RU_FinancialContractTP ContractAccountingNumber
CompanyCodeName
CustomerName
SupplierName
LastChangeDateTime I_RU_FinancialContractTP LastChangeDateTime Timestamp
LastChangeByUserName I_RU_FinancialContractTP LastChangeByUserName User Name
CustomerAccountGroup CustomerAccountGroup Account group
CustomerAuthznGrp CustomerAuthznGrp AuthorizGroup
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd Purpose Completed
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup Authorization
CustCoIsBusPrpsCmpltd CustCoIsBusPrpsCmpltd Purpose Completed
SupplierAccountGroup SupplierAccountGroup Account group
SupplierAuthznGrp SupplierAuthznGrp Authorization
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd Purpose Completed
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup AuthorizGroup
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd Purpose Completed
ContractCategoryDescription
_Supplier I_RU_FinancialContractTP _Supplier
_Customer I_RU_FinancialContractTP _Customer
_SupplierCompany I_RU_FinancialContractTP _SupplierCompany
_CustomerCompany I_RU_FinancialContractTP _CustomerCompany
_ContractCategory I_RU_FinancialContractTP _ContractCategory

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_RU_FinancialContractTP.
-- 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.

CREATE VIEW C_RU_FinancialContractTP AS
SELECT
  I_RU_FinancialContractTP.CompanyCode AS CompanyCode,
  I_RU_FinancialContractTP.BusinessPartnerContract AS BusinessPartnerContract,
  I_RU_FinancialContractTP.BusinessPartnerContractExt AS BusinessPartnerContractExt,
  I_RU_FinancialContractTP.ContractStartDate AS ContractStartDate,
  I_RU_FinancialContractTP.ContractEndDate AS ContractEndDate,
  I_RU_FinancialContractTP.Customer AS Customer,
  I_RU_FinancialContractTP.Supplier AS Supplier,
  I_RU_FinancialContractTP.Comments AS Comments,
  I_RU_FinancialContractTP.CreationDateTime AS CreationDateTime,
  I_RU_FinancialContractTP.ContractCategory AS ContractCategory,
  I_RU_FinancialContractTP.CreatedByUser AS CreatedByUser,
  I_RU_FinancialContractTP.ContractSubject AS ContractSubject,
  I_RU_FinancialContractTP.ContractServiceSite AS ContractServiceSite,
  I_RU_FinancialContractTP.ContractCurrency AS ContractCurrency,
  I_RU_FinancialContractTP.ContractTotalAmount AS ContractTotalAmount,
  I_RU_FinancialContractTP.ContractSignedDate AS ContractSignedDate,
  I_RU_FinancialContractTP.ContractAccountingNumber AS ContractAccountingNumber,
  I_RU_FinancialContractTP._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_RU_FinancialContractTP._CustomerCompany._Customer.BPCustomerName AS CustomerName,
  I_RU_FinancialContractTP._SupplierCompany._Supplier.BPSupplierName AS SupplierName,
  I_RU_FinancialContractTP.LastChangeDateTime AS LastChangeDateTime,
  I_RU_FinancialContractTP.LastChangeByUserName AS LastChangeByUserName,
  CustomerAccountGroup,
  CustomerAuthznGrp,
  CustomerIsBusPrpsCmpltd,
  CustomerCompanyAuthznGroup,
  CustCoIsBusPrpsCmpltd,
  SupplierAccountGroup,
  SupplierAuthznGrp,
  SupplierIsBusPrpsCmpltd,
  SupplierCompanyAuthznGroup,
  SuplrCoIsBusPrpsCmpltd,
  I_RU_FinancialContractTP._ContractCategory.ContractCategoryDescription AS ContractCategoryDescription,
  I_RU_FinancialContractTP._Supplier AS _Supplier,
  I_RU_FinancialContractTP._Customer AS _Customer,
  I_RU_FinancialContractTP._SupplierCompany AS _SupplierCompany,
  I_RU_FinancialContractTP._CustomerCompany AS _CustomerCompany,
  I_RU_FinancialContractTP._ContractCategory AS _ContractCategory
FROM I_RU_FinancialContractTP
;

Learn More