I_CompanyCodeStdVH

DDL: I_COMPANYCODESTDVH SQL: IFICC__VH Type: view BASIC

Company Code

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

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IFICC__VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Company Code view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
CompanyCodeName t001 butxt 
//GENERATED:001:GlBfhyFV7jUzaDT}MP9DVm

@AbapCatalog.sqlViewName: 'IFICC__VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@VDM.viewType: #BASIC

@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'CompanyCode',
                usageType.sizeCategory: #S,
                usageType.dataClass: #ORGANIZATIONAL,
                usageType.serviceQuality: #A,
                supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY],
                modelingPattern: #VALUE_HELP_PROVIDER }
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@Consumption.ranked: true
@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'Company Code'
define view I_CompanyCodeStdVH as select from t001 // direct select from T001 as field f_obsolete to be used in where condition

  
left outer to one join  P_UserParameter
  on t001.mandt = P_UserParameter.mandt 
  and P_UserParameter.UserParameter = 'F_SHOW_OBSOLETE_T001'
{
  @ObjectModel.text.element: ['CompanyCodeName']
  @Search.defaultSearchElement: true
//  @Search.fuzzinessThreshold: 0.8

  @Search.ranking: #HIGH
  key t001.bukrs    as CompanyCode,
  @Semantics.text: true
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.butxt    as CompanyCodeName
} where P_UserParameter.UserParameterValue = 'X' or t001.f_obsolete <> 'X' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_USERPARAMETER",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More