C_RU_FinancialContractTP

DDL: C_RU_FINANCIALCONTRACTTP Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

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 29 fields with key fields CompanyCode, BusinessPartnerContract.

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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RU_FinancialContractTP CompanyCode Receiver 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
CustomerName
SupplierName
CreatedByUser I_RU_FinancialContractTP CreatedByUser User Name
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
CompanyCodeName
_Supplier I_RU_FinancialContractTP _Supplier
_Customer I_RU_FinancialContractTP _Customer
_SupplierCompany I_RU_FinancialContractTP _SupplierCompany
_CustomerCompany I_RU_FinancialContractTP _CustomerCompany

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._CustomerCompany._Customer.BPCustomerName AS CustomerName,
  I_RU_FinancialContractTP._SupplierCompany._Supplier.BPSupplierName AS SupplierName,
  I_RU_FinancialContractTP.CreatedByUser AS CreatedByUser,
  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._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_RU_FinancialContractTP._Supplier AS _Supplier,
  I_RU_FinancialContractTP._Customer AS _Customer,
  I_RU_FinancialContractTP._SupplierCompany AS _SupplierCompany,
  I_RU_FinancialContractTP._CustomerCompany AS _CustomerCompany
FROM I_RU_FinancialContractTP
;

Learn More