C_JITSalesAreaValueHelp

DDL: C_JITSALESAREAVALUEHELP SQL: CJITSALESAREA_VH Type: view CONSUMPTION

Sales Area Value Help

C_JITSalesAreaValueHelp is a Consumption CDS View that provides data about "Sales Area Value Help" in SAP S/4HANA. It reads from 1 data source (I_SalesArea) and exposes 7 fields with key fields SalesOrganization, DistributionChannel, Division.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesArea I_SalesArea from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CJITSALESAREA_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Area Value Help view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
SalesArea
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOrganization _SalesOrganization 
@AbapCatalog.sqlViewName: 'CJITSALESAREA_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Area Value Help'
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: [ 'SalesOrganization', 'DistributionChannel','Division' ]
@ObjectModel.representativeKey: [ 'SalesOrganization', 'DistributionChannel','Division' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.dataCategory:#VALUE_HELP
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
define view C_JITSalesAreaValueHelp 
as select from I_SalesArea {
//I_SalesArea 


@Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 } 
key SalesOrganization,

@Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
key DistributionChannel,

@Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
key Division,
@EndUserText: { label: 'Sales Area'}
//@Consumption.filter.hidden: true

concat(SalesOrganization,concat('/', concat(DistributionChannel, concat('/', Division))))  as SalesArea,
        
/* Associations */ 
  //I_SalesArea 

  _DistributionChannel, 
  _Division, 
  _SalesOrganization  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESAREA"
],
"ASSOCIATED":
[
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESORGANIZATION"
],
"BASE":
[
"I_SALESAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More