C_CntrlContrItmValHelp

DDL: C_CNTRLCONTRITMVALHELP SQL: CMMCCTRITMVH Type: view CONSUMPTION Package: ODATA_MM_PUR_CCTR_ANALYTICS
11 Fields 1 Data Sources 1 OData Services

Central Contract Item Value Help

C_CntrlContrItmValHelp is a Consumption CDS View that provides data about "Central Contract Item Value Help" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurchaseContractItem) and exposes 11 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem. It is exposed through 1 OData service (ASQL_F3492). Part of development package ODATA_MM_PUR_CCTR_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurchaseContractItem I_CntrlPurchaseContractItem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMMCCTRITMVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Contract Item Value Help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
Consumption.valueHelpDefault.fetchValues #ON_EXPLICIT_REQUEST view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3492 ASQL_F3492 C2 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
FormattedPurchasingDocItem Purchase Contract Item
CntrlPurContrDistributionLevel Item Distribution Number
MaterialGroup MaterialGroup Product Group
PurchasingCentralMaterial PurchasingCentralMaterial Material
Plant Plant Valuation Area
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseContractType PurchaseContractType Order Type
ProcmtHubCompanyCodeGroupingID _Distribution ProcmtHubCompanyCodeGroupingID Brand

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_CntrlContrItmValHelp.
-- 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: CMMCCTRITMVH

CREATE VIEW C_CntrlContrItmValHelp AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  concat( CentralPurchaseContract, concat( '/', CentralPurchaseContractItem) ) AS FormattedPurchasingDocItem,
  concat( CentralPurchaseContract, concat( '/', concat( CentralPurchaseContractItem, concat( '/', _Distribution.DistributionKey) ) ) ) AS CntrlPurContrDistributionLevel,
  MaterialGroup,
  PurchasingCentralMaterial,
  Plant,
  PurchasingOrganization,
  PurchasingGroup,
  PurchaseContractType,
  _Distribution.ProcmtHubCompanyCodeGroupingID AS ProcmtHubCompanyCodeGroupingID
FROM I_CntrlPurchaseContractItem
;

Learn More