C_RU_MonitorContractCube

DDL: C_RU_MONITORCONTRACTCUBE SQL: CRUMONCNT Type: view CONSUMPTION Package: GLO_FIN_IS_RU_CONTRACT_ACCTG
32 Fields 1 Data Sources

Russia monitor contracts - Cube

C_RU_MonitorContractCube is a Consumption CDS View (Cube) that provides data about "Russia monitor contracts - Cube" in SAP S/4HANA. It reads from 1 data source (P_RU_MONITOR_CONTRACTS) and exposes 32 fields with key fields CompanyCode, BusinessPartnerContract. Part of development package GLO_FIN_IS_RU_CONTRACT_ACCTG.

Data Sources (1)

SourceAliasJoin Type
P_RU_MONITOR_CONTRACTS Contracts from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CRUMONCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Russia monitor contracts - Cube view
ObjectModel.usageType.sizeCategory S view
ObjectModel.usageType.serviceQuality D view
ObjectModel.usageType.dataClass Customizing view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Search.searchable true view
UI.headerInfo.typeNamePlural Contracts view
UI.headerInfo.typeName Contracts view
ObjectModel.updateEnabled true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY BusinessPartnerContract P_RU_MONITOR_CONTRACTS BusinessPartnerContract Int. Contract Number
ContractCategory ContractCategory
ContractAccountingNumber P_RU_MONITOR_CONTRACTS ContractAccountingNumber
BusinessPartnerContractExt P_RU_MONITOR_CONTRACTS BusinessPartnerContractExt Ext. Contract Number
ContractStartDate P_RU_MONITOR_CONTRACTS ContractStartDate Contract Start Date
ContractEndDate P_RU_MONITOR_CONTRACTS ContractEndDate Contract End Date
CndnContrType CndnContrType Contract Type
Customer P_RU_MONITOR_CONTRACTS Customer Sold-to Party
CustomerAccountGroup P_RU_MONITOR_CONTRACTS CustomerAccountGroup Account group
CustomerAuthznGrp P_RU_MONITOR_CONTRACTS CustomerAuthznGrp
CustomerIsBusPrpsCmpltd P_RU_MONITOR_CONTRACTS CustomerIsBusPrpsCmpltd
CustomerCompanyAuthznGroup P_RU_MONITOR_CONTRACTS CustomerCompanyAuthznGroup Authorization
CustCoIsBusPrpsCmpltd P_RU_MONITOR_CONTRACTS CustCoIsBusPrpsCmpltd
Supplier P_RU_MONITOR_CONTRACTS Supplier Supplier
SupplierAccountGroup P_RU_MONITOR_CONTRACTS SupplierAccountGroup Account group
SupplierAuthznGrp P_RU_MONITOR_CONTRACTS SupplierAuthznGrp Authorization
SupplierIsBusPrpsCmpltd P_RU_MONITOR_CONTRACTS SupplierIsBusPrpsCmpltd
SupplierCompanyAuthznGroup P_RU_MONITOR_CONTRACTS SupplierCompanyAuthznGroup
SuplrCoIsBusPrpsCmpltd P_RU_MONITOR_CONTRACTS SuplrCoIsBusPrpsCmpltd Purpose Completed
CreatedByUser P_RU_MONITOR_CONTRACTS CreatedByUser User Name
BPCustomerName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
BPSupplierName
ContractCategoryDescription _ContractCategory ContractCategoryDescription
_CompanyCode _CompanyCode
_Supplier _Supplier
_Customer _Customer
_SupplierCompany _SupplierCompany
_CustomerCompany _CustomerCompany
_ContractsValueHelp _ContractsValueHelp
_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 C_RU_MonitorContractCube.
-- 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: CRUMONCNT

CREATE VIEW C_RU_MonitorContractCube AS
SELECT
  CompanyCode,
  Contracts.BusinessPartnerContract AS BusinessPartnerContract,
  ContractCategory,
  Contracts.ContractAccountingNumber AS ContractAccountingNumber,
  Contracts.BusinessPartnerContractExt AS BusinessPartnerContractExt,
  Contracts.ContractStartDate AS ContractStartDate,
  Contracts.ContractEndDate AS ContractEndDate,
  CndnContrType,
  Contracts.Customer AS Customer,
  Contracts.CustomerAccountGroup AS CustomerAccountGroup,
  Contracts.CustomerAuthznGrp AS CustomerAuthznGrp,
  Contracts.CustomerIsBusPrpsCmpltd AS CustomerIsBusPrpsCmpltd,
  Contracts.CustomerCompanyAuthznGroup AS CustomerCompanyAuthznGroup,
  Contracts.CustCoIsBusPrpsCmpltd AS CustCoIsBusPrpsCmpltd,
  Contracts.Supplier AS Supplier,
  Contracts.SupplierAccountGroup AS SupplierAccountGroup,
  Contracts.SupplierAuthznGrp AS SupplierAuthznGrp,
  Contracts.SupplierIsBusPrpsCmpltd AS SupplierIsBusPrpsCmpltd,
  Contracts.SupplierCompanyAuthznGroup AS SupplierCompanyAuthznGroup,
  Contracts.SuplrCoIsBusPrpsCmpltd AS SuplrCoIsBusPrpsCmpltd,
  Contracts.CreatedByUser AS CreatedByUser,
  _CustomerCompany._Customer.BPCustomerName AS BPCustomerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _SupplierCompany._Supplier.BPSupplierName AS BPSupplierName,
  _ContractCategory.ContractCategoryDescription AS ContractCategoryDescription
FROM P_RU_MONITOR_CONTRACTS AS Contracts
;

Learn More