I_CnsldtnVersionVH
Consolidation Version
I_CnsldtnVersionVH is a Composite CDS View that provides data about "Consolidation Version" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnVersion) and exposes 2 fields with key field ConsolidationVersion.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_CnsldtnVersion | _CnsldtnVersion | from |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICSVERSVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| ObjectModel.representativeKey | ConsolidationVersion | view | |
| ObjectModel.modelingPattern | #VALUE_HELP_PROVIDER | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| EndUserText.label | Consolidation Version | view |
Fields (2)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConsolidationVersion | I_CnsldtnVersion | ConsolidationVersion | |
| ConsolidationVersionText |
@AbapCatalog:{
sqlViewName: 'ICSVERSVH',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
usageType: {
dataClass: #CUSTOMIZING,
serviceQuality: #A,
sizeCategory: #S
},
dataCategory: #VALUE_HELP,
representativeKey: 'ConsolidationVersion',
modelingPattern: #VALUE_HELP_PROVIDER,
supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#VALUE_HELP_PROVIDER ]
}
@Search.searchable: true
@Consumption.ranked: true
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@EndUserText.label: 'Consolidation Version'
define view I_CnsldtnVersionVH
as select from I_CnsldtnVersion as _CnsldtnVersion
{
@ObjectModel.text.element: [ 'ConsolidationVersionText' ]
@Search:{
defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.8
}
key _CnsldtnVersion.ConsolidationVersion,
@Semantics.text
@Search: {
defaultSearchElement: true,
ranking: #LOW,
fuzzinessThreshold: 0.8
}
cast(_CnsldtnVersion._Text[1: Language=$session.system_language].ConsolidationVersionText as fincs_description_text_30 preserving type ) as ConsolidationVersionText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNVERSION",
"I_CNSLDTNVERSIONT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA