I_JointVentureCompanyCodeVH

DDL: I_JOINTVENTURECOMPANYCODEVH SQL: IJVCOMPCODEVH Type: view BASIC

JVA Company Code Value Help

I_JointVentureCompanyCodeVH is a Basic CDS View (Dimension) that provides data about "JVA Company Code Value Help" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 2 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IJVCOMPCODEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label JVA Company Code Value Help view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
CompanyCodeName butxt
@AbapCatalog.sqlViewName: 'IJVCOMPCODEVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: { dataCategory: #DIMENSION }
@Analytics.internalName:#LOCAL 
@VDM.viewType: #BASIC
@ObjectModel:{
   dataCategory: #VALUE_HELP,
   representativeKey: 'CompanyCode',
   usageType: { sizeCategory: #S,
                dataClass: #ORGANIZATIONAL,
                serviceQuality: #A
                } }
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@EndUserText.label: 'JVA Company Code Value Help'

define view I_JointVentureCompanyCodeVH
  as select from t001
{
      @ObjectModel.text.element: ['CompanyCodeName']
  key cast(bukrs      as fis_bukrs preserving type) as CompanyCode,
      @Semantics.text: true
      butxt                                         as CompanyCodeName
}
where
  xjvaa = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/