C_SalesOrderEnhancedValueHelp

DDL: C_SALESORDERENHANCEDVALUEHELP Type: view_entity CONSUMPTION

Sales Order

C_SalesOrderEnhancedValueHelp is a Consumption CDS View that provides data about "Sales Order" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 11 fields with key field SalesOrder. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder SalesOrder from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_SalesDocumentTypeText _SalesOrderTypeText $projection.SalesOrderType = _SalesOrderTypeText.SalesDocumentType
[0..*] I_SalesOrganizationText _SalesOrganizationText $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization
[0..*] I_DistributionChannelText _DistributionChannelText $projection.DistributionChannel = _DistributionChannelText.DistributionChannel
[0..*] I_DivisionText _DivisionText $projection.OrganizationDivision = _DivisionText.Division

Annotations (13)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SalesOrder view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
Search.searchable true view
Consumption.ranked true view
Consumption.valueHelpDefault.fetchValues #ON_EXPLICIT_REQUEST view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Sales Order view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder
SalesOrderType I_SalesOrder SalesOrderType
SalesOrganization I_SalesOrder SalesOrganization
DistributionChannel I_SalesOrder DistributionChannel
OrganizationDivision I_SalesOrder OrganizationDivision
SoldToParty I_SalesOrder SoldToParty
SoldToPartyName
_SalesOrderTypeText _SalesOrderTypeText
_SalesOrganizationText _SalesOrganizationText
_DistributionChannelText _DistributionChannelText
_DivisionText _DivisionText
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:#MANDATORY

@ObjectModel: {
  representativeKey: 'SalesOrder',
  dataCategory: #VALUE_HELP,
  usageType: {
    serviceQuality: #B,
    sizeCategory:   #XL,
    dataClass:      #TRANSACTIONAL
  },
  supportedCapabilities: [#VALUE_HELP_PROVIDER],
  modelingPattern:#NONE,
  text.control: #('ASSOCIATED_TEXT_UI_HIDDEN')
}

@Search.searchable: true
@Consumption:{
  ranked: true,
  valueHelpDefault.fetchValues:#ON_EXPLICIT_REQUEST
}

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Sales Order'
define root view entity C_SalesOrderEnhancedValueHelp
  as select from I_SalesOrder as SalesOrder
 
  association [0..*] to I_SalesDocumentTypeText   as _SalesOrderTypeText      on $projection.SalesOrderType = _SalesOrderTypeText.SalesDocumentType
  association [0..*] to I_SalesOrganizationText   as _SalesOrganizationText   on $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization
  association [0..*] to I_DistributionChannelText as _DistributionChannelText on $projection.DistributionChannel = _DistributionChannelText.DistributionChannel
  association [0..*] to I_DivisionText            as _DivisionText            on $projection.OrganizationDivision = _DivisionText.Division
{
  
  @UI:{ 
    lineItem: [{ position: 10, importance: #HIGH }],
    selectionField: [{ position: 10}] 
  }
  @Search: {
    defaultSearchElement: true,
    fuzzinessThreshold: 0.9,
    ranking: #HIGH
  }
  key SalesOrder.SalesOrder,
  
  @UI:{
    lineItem: [{ position: 30, importance: #LOW  }],
    selectionField: [{ position: 30}],
    textArrangement: #TEXT_FIRST
  }  
  @Consumption.valueHelpDefinition: [{entity:{name:'C_SalesOrderTypeValueHelp', element:'SalesOrderType'} }]
  @ObjectModel.text.association: '_SalesOrderTypeText'
  SalesOrder.SalesOrderType,
  
   @UI:{ 
    lineItem: [{ position: 40, importance: #LOW  }],
    selectionField: [{ position: 40 }],
    textArrangement: #TEXT_FIRST
  }  
  @Consumption.valueHelpDefinition: [{entity:{name:'C_SalesDocSalesOrganizationVH', element:'SalesOrganization'} }]
  @ObjectModel.text.association: '_SalesOrganizationText'
  SalesOrder.SalesOrganization,
  
  @UI:{
    lineItem: [{ position: 50, importance: #LOW  }],
    selectionField: [{ position: 50 }],
    textArrangement: #TEXT_FIRST } 
  @Consumption.valueHelpDefinition: [{entity:{name:'C_Dischannelvaluehelp', element:'DistributionChannel'},
                                      additionalBinding: [{element: 'SalesOrganization', localElement: 'SalesOrganization', usage: #FILTER_AND_RESULT}] }]
  @ObjectModel.text.association: '_DistributionChannelText'
  SalesOrder.DistributionChannel,
  
  @UI:{
    lineItem: [{ position: 60, importance: #LOW  }],
    selectionField: [{ position: 60}],
    textArrangement: #TEXT_FIRST }        
  @Consumption.valueHelpDefinition: [{entity:{name:'C_OrgDivisionValueHelp', element:'Division'},
                                      additionalBinding: [{element: 'SalesOrganization', localElement: 'SalesOrganization', usage: #FILTER_AND_RESULT},
                                                          {element: 'DistributionChannel',localElement: 'DistributionChannel', usage: #FILTER_AND_RESULT}] }]
  @ObjectModel.text.association: '_DivisionText'
  SalesOrder.OrganizationDivision,
  
  @UI:{
    lineItem: [{ position: 20, importance: #HIGH  }],
    selectionField: [{ position: 20}], 
    textArrangement: #TEXT_FIRST
  } 
  @Search:{
    defaultSearchElement: true,
    fuzzinessThreshold: 0.8,
    ranking: #LOW
  }
  @Consumption.valueHelpDefinition: [{ entity: {name: 'C_SoldToValueHelp', element: 'Customer' }}]
  @ObjectModel.text.element: ['SoldToPartyName']    
  SalesOrder.SoldToParty,
  
  @Semantics.text:true
  @ObjectModel.virtualElement: true
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_SD_SLSORD_UI_PARTNER_UTIL' 
  cast('' as ad_namtext )  as SoldToPartyName,   
  
  @Consumption.filter.hidden: true
  _SalesOrderTypeText, 
  @Consumption.filter.hidden: true
  _SalesOrganizationText,
  @Consumption.filter.hidden: true
  _DistributionChannelText,
  @Consumption.filter.hidden: true
  _DivisionText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDER"
],
"ASSOCIATED":
[
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISIONTEXT",
"I_SALESDOCUMENTTYPETEXT",
"I_SALESORGANIZATIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/