I_RU_FinancialContractTP

DDL: I_RU_FINANCIALCONTRACTTP Type: view_entity TRANSACTIONAL Package: GLO_FIN_IS_RU_CONTRACT_ACCTG
36 Fields 1 Data Sources 7 Associations

Contract in Accounting : Transactional layer

I_RU_FinancialContractTP is a Transactional CDS View that provides data about "Contract in Accounting : Transactional layer" in SAP S/4HANA. It reads from 1 data source (I_RU_FinancialContract) and exposes 36 fields with key fields CompanyCode, BusinessPartnerContract. It has 7 associations to related views. Part of development package GLO_FIN_IS_RU_CONTRACT_ACCTG.

Data Sources (1)

SourceAliasJoin Type
I_RU_FinancialContract I_RU_FinancialContract from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode
[0..1] I_CustomerCompany _CustomerCompany $projection.Customer = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode
[0..1] I_User _User $projection.CreatedByUser = _User.UserID
[0..1] I_RU_CustomerData _Customer _Customer.Customer = $projection.Customer and $projection.Customer <> ''
[0..1] I_RU_SupplierData _Supplier _Supplier.Supplier = $projection.Supplier and $projection.Supplier <> ''
[0..1] I_Z0_ContractCategoryValueHelp _ContractCategory $projection.ContractCategory = _ContractCategory.ContractCategory

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
EndUserText.label Contract in Accounting : Transactional layer view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY BusinessPartnerContract BusinessPartnerContract Int. Contract Number
BusinessPartnerContractExt BusinessPartnerContractExt Ext. Contract Number
ContractStartDate ContractStartDate Contract Start Date
ContractEndDate ContractEndDate Contract End Date
Customer I_RU_FinancialContract Customer Sold-to Party
Supplier I_RU_FinancialContract Supplier Supplier
Comments Comments User Notes
CreationDateTime I_RU_FinancialContract CreationDateTime Timestamp
CreatedByUser I_RU_FinancialContract CreatedByUser User Name
LastChangeDateTime I_RU_FinancialContract LastChangeDateTime Timestamp
LastChangeByUserName I_RU_FinancialContract LastChangeByUserName User Name
ContractCategory I_RU_FinancialContract ContractCategory
ContractSubject I_RU_FinancialContract ContractSubject
ContractServiceSite I_RU_FinancialContract ContractServiceSite
ContractTotalAmount I_RU_FinancialContract ContractTotalAmount
ContractCurrency I_RU_FinancialContract ContractCurrency
ContractSignedDate I_RU_FinancialContract ContractSignedDate
ContractAccountingNumber I_RU_FinancialContract ContractAccountingNumber
CustomerAccountGroup _Customer CustomerAccountGroup Account group
CustomerAuthznGrp _Customer AuthorizationGroup AuthorizGroup
CustomerIsBusPrpsCmpltd _Customer IsBusinessPurposeCompleted Purpose Completed
CustomerCompanyAuthznGroup _CustomerCompany AuthorizationGroup AuthorizGroup
CustCoIsBusPrpsCmpltd _CustomerCompany IsBusinessPurposeCompleted Purpose Completed
SupplierAccountGroup _Supplier SupplierAccountGroup Account group
SupplierAuthznGrp _Supplier AuthorizationGroup AuthorizGroup
SupplierIsBusPrpsCmpltd _Supplier IsBusinessPurposeCompleted Purpose Completed
SupplierCompanyAuthznGroup _SupplierCompany AuthorizationGroup AuthorizGroup
SuplrCoIsBusPrpsCmpltd _SupplierCompany IsBusinessPurposeCompleted Purpose Completed
_CompanyCode _CompanyCode
_Supplier _Supplier
_Customer _Customer
_SupplierCompany _SupplierCompany
_CustomerCompany _CustomerCompany
_User _User
_ContractCategory _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 I_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 I_RU_FinancialContractTP AS
SELECT
  CompanyCode,
  BusinessPartnerContract,
  BusinessPartnerContractExt,
  ContractStartDate,
  ContractEndDate,
  I_RU_FinancialContract.Customer AS Customer,
  I_RU_FinancialContract.Supplier AS Supplier,
  Comments,
  I_RU_FinancialContract.CreationDateTime AS CreationDateTime,
  I_RU_FinancialContract.CreatedByUser AS CreatedByUser,
  I_RU_FinancialContract.LastChangeDateTime AS LastChangeDateTime,
  I_RU_FinancialContract.LastChangeByUserName AS LastChangeByUserName,
  I_RU_FinancialContract.ContractCategory AS ContractCategory,
  I_RU_FinancialContract.ContractSubject AS ContractSubject,
  I_RU_FinancialContract.ContractServiceSite AS ContractServiceSite,
  I_RU_FinancialContract.ContractTotalAmount AS ContractTotalAmount,
  I_RU_FinancialContract.ContractCurrency AS ContractCurrency,
  I_RU_FinancialContract.ContractSignedDate AS ContractSignedDate,
  I_RU_FinancialContract.ContractAccountingNumber AS ContractAccountingNumber,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS CustomerAuthznGrp,
  _Customer.IsBusinessPurposeCompleted AS CustomerIsBusPrpsCmpltd,
  _CustomerCompany.AuthorizationGroup AS CustomerCompanyAuthznGroup,
  _CustomerCompany.IsBusinessPurposeCompleted AS CustCoIsBusPrpsCmpltd,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS SupplierAuthznGrp,
  _Supplier.IsBusinessPurposeCompleted AS SupplierIsBusPrpsCmpltd,
  _SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  _SupplierCompany.IsBusinessPurposeCompleted AS SuplrCoIsBusPrpsCmpltd
FROM I_RU_FinancialContract
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_RU_CustomerData AS _Customer ON _Customer.Customer = Customer AND Customer <> ''  -- association [0..1]
LEFT OUTER JOIN I_RU_SupplierData AS _Supplier ON _Supplier.Supplier = Supplier AND Supplier <> ''  -- association [0..1]
LEFT OUTER JOIN I_Z0_ContractCategoryValueHelp AS _ContractCategory ON ContractCategory = _ContractCategory.ContractCategory  -- association [0..1]
;

Learn More