FAC_CDS_VE_COMPANYCODE

DDL: FAC_CDS_VE_COMPANYCODE SQL: FACV_VE_COCD Type: view

Company Code in Flexible Hierarchy

FAC_CDS_VE_COMPANYCODE is a CDS View that provides data about "Company Code in Flexible Hierarchy" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 3 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FACV_VE_COCD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Code in Flexible Hierarchy view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
CompanyCode_T t001 butxt
NodeTextUpper
@AbapCatalog.sqlViewName: 'FACV_VE_COCD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Company Code in Flexible Hierarchy'

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #D,
  sizeCategory: #L
}

//@VDM.viewType: #CONSUMPTION

define view FAC_CDS_VE_COMPANYCODE
  as select from t001
 
{
  key t001.bukrs                                                                                                                                                       as CompanyCode,
      t001.butxt                                                                                                                                                       as CompanyCode_T,
      cast(upper(t001.butxt) as butxt )                                                                                                                                as NodeTextUpper
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/