C_SlsOrdReqCustomerAddressVH

DDL: C_SLSORDREQCUSTOMERADDRESSVH Type: view_entity CONSUMPTION

Customer by Sales Area and Address

C_SlsOrdReqCustomerAddressVH is a Consumption CDS View that provides data about "Customer by Sales Area and Address" in SAP S/4HANA. It reads from 1 data source (I_CustomerSalesArea) and exposes 22 fields with key fields Customer, SalesOrganization, DistributionChannel, Division. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustomerSalesArea I_CustomerSalesArea from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_SalesOrganizationText _SalesOrganizationText $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization
[0..*] I_DistributionChannelText _DistributionChannelText $projection.DistributionChannel = _DistributionChannelText.DistributionChannel
[0..*] I_DivisionText _DivisionText $projection.Division = _DivisionText.Division

Annotations (12)

NameValueLevelField
EndUserText.label Customer by Sales Area and Address view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
AddressID _Customer AddressID
CustomerName _Customer CustomerName
SalesOrganizationName
DistributionChannelName
DivisionName
OrganizationBPName1 _Customer OrganizationBPName1
OrganizationBPName2 _Customer OrganizationBPName2
PostalCode
CityName
Country
StreetName
HouseNumber
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
_Customer _Customer
_SalesOrganizationText _SalesOrganizationText
_DistributionChannelText _DistributionChannelText
_DivisionText _DivisionText
@EndUserText.label: 'Customer by Sales Area and Address'

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking:#REQUIRED
}

@VDM.viewType: #CONSUMPTION

@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #XXL,
    dataClass: #MASTER
  },
  dataCategory: #VALUE_HELP,
  representativeKey:'Customer'
}

@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@Consumption.ranked: true

define view entity C_SlsOrdReqCustomerAddressVH
  as select from I_CustomerSalesArea
  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.Division = _DivisionText.Division
{
      @Search: {
       defaultSearchElement: true,
       ranking: #HIGH,
       fuzzinessThreshold: 0.9
      }
      @ObjectModel.text.element:  [ 'CustomerName' ]
      @UI: {
       lineItem: [{ position: 10, importance: #HIGH }],
       selectionField: [{ position: 10 }],
       textArrangement: #TEXT_FIRST }
  key Customer,

      @ObjectModel.text.association: '_SalesOrganizationText'
      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 30, importance: #HIGH }],
       selectionField: [{ position: 30 }],
       textArrangement: #TEXT_FIRST }
  key SalesOrganization,

      @ObjectModel.text.association: '_DistributionChannelText'
      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 40, importance: #HIGH }],
       selectionField: [{ position: 40 }],
       textArrangement: #TEXT_FIRST }
  key DistributionChannel,

      @ObjectModel.text.association: '_DivisionText'
      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 50, importance: #HIGH }],
       selectionField: [{ position: 50 }],
       textArrangement: #TEXT_FIRST }
  key Division,

      @UI.hidden: true
      _Customer.AddressID,

      @Semantics.text: true
      _Customer.CustomerName,
      
      @Semantics.text: true
      @UI.hidden: true      
      _SalesOrganizationText[1:Language = $session.system_language].SalesOrganizationName,
      
      @Semantics.text: true
      @UI.hidden: true      
      _DistributionChannelText[1:Language = $session.system_language].DistributionChannelName,
      
      @Semantics.text: true
      @UI.hidden: true      
      _DivisionText[1:Language = $session.system_language].DivisionName,

      @UI.hidden: true
      @Search: {
         defaultSearchElement: true,
         ranking: #LOW,
         fuzzinessThreshold: 0.8
      }
      _Customer.OrganizationBPName1,

      @UI.hidden: true
      @Search: {
         defaultSearchElement: true,
         ranking: #LOW,
         fuzzinessThreshold: 0.8
      }
      _Customer.OrganizationBPName2,

      @UI: {
      lineItem: [{ position: 80, importance: #LOW }],
      selectionField: [{ position: 80 }]
      }
      @Semantics.address.zipCode:true
      @Search.defaultSearchElement: true
      _Customer._AddressRepresentation.PostalCode,

      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 90, importance: #HIGH }],
       selectionField: [{ position: 90 }] }
      _Customer._AddressRepresentation.CityName,

      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 100, importance: #HIGH }],
       selectionField: [{ position: 100 }] }
      _Customer._AddressRepresentation.Country,

      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 60, importance: #HIGH }],
       selectionField: [{ position: 60 }] }
      _Customer._AddressRepresentation.StreetName,

      @Search.defaultSearchElement: true
      @UI: {
       lineItem: [{ position: 70, importance: #HIGH }],
       selectionField: [{ position: 70 }] }
      _Customer._AddressRepresentation.HouseNumber,

      @Consumption.hidden: true
      //     For DCL Purposes

      AuthorizationGroup,

      @Consumption.hidden: true
      @Semantics.booleanIndicator: true
      IsBusinessPurposeCompleted,

      @Consumption.hidden: true
      _Customer,

      @Consumption.hidden: true
      _SalesOrganizationText,

      @Consumption.hidden: true
      _DistributionChannelText,

      @Consumption.hidden: true
      _DivisionText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_CUSTOMER",
"I_CUSTOMERSALESAREA",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISIONTEXT",
"I_SALESORGANIZATIONTEXT"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISIONTEXT",
"I_SALESORGANIZATIONTEXT"
],
"BASE":
[
"I_CUSTOMERSALESAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/