C_SalesOrgVHTemp

DDL: C_SALESORGVHTEMP SQL: CSLSORGVH Type: view CONSUMPTION

Value Help for Sales Organization

C_SalesOrgVHTemp is a Consumption CDS View that provides data about "Value Help for Sales Organization" in SAP S/4HANA. It has 3 associations to related views.

8 fields

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_SalesOrgTextVHTemp _SalesOrgText $projection.SalesOrganization = _SalesOrgText.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..*] C_Distrchnltextvhtemp _DistrChnlText $projection.DistributionChannel = _DistrChnlText.DistributionChannel association[0..1] to I_Division as _Division on $projection.Division = _Division.Division
[0..*] C_Divisiontextvhtemp _DivisionText $projection.Division = _DivisionText.Division

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSLSORGVH view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey SalesOrganization view
Search.searchable true view
EndUserText.label Value Help for Sales Organization view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
AbapCatalog.preserveKey false view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization tvta vkorg
KEY DistributionChannel tvta vtwku Distribution Channel
KEY Division tvta spaku Division
_SalesOrgText _SalesOrgText
_DistributionChannel _DistributionChannel
_DistrChnlText _DistrChnlText
_Division _Division
_DivisionText _DivisionText 
@AbapCatalog.sqlViewName: 'CSLSORGVH'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:  #CHECK
@ObjectModel.representativeKey: 'SalesOrganization'
@Search.searchable: true
@EndUserText.label: 'Value Help for Sales Organization'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #VALUE_HELP
@Consumption.ranked: true
@AbapCatalog.preserveKey: false

define view C_SalesOrgVHTemp
  as select distinct from tvta

  association [0..*] to C_SalesOrgTextVHTemp  as _SalesOrgText  on $projection.SalesOrganization = _SalesOrgText.SalesOrganization

  association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..*] to C_Distrchnltextvhtemp as _DistrChnlText on $projection.DistributionChannel = _DistrChnlText.DistributionChannel

  association[0..1] to I_Division as _Division on $projection.Division = _Division.Division
  association [0..*] to C_Divisiontextvhtemp  as _DivisionText  on $projection.Division = _DivisionText.Division

{

      @ObjectModel.text.association: '_SalesOrgText'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH

  key tvta.vkorg as SalesOrganization,

      @ObjectModel.text.association: '_DistrChnlText'
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Distribution Channel'
  key tvta.vtwku as DistributionChannel,

      @ObjectModel.text.association: '_DivisionText'
      @ObjectModel.foreignKey.association: '_Division'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Division'
  key tvta.spaku as Division,
      _SalesOrgText,
      _DistributionChannel,
      _DistrChnlText,
      _Division,
      _DivisionText
}   
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVTA"
],
"ASSOCIATED":
[
"C_DISTRCHNLTEXTVHTEMP",
"C_DIVISIONTEXTVHTEMP",
"C_SALESORGTEXTVHTEMP",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More