I_CollsCustomerVH

DDL: I_COLLSCUSTOMERVH Type: view COMPOSITE Package: ODATA_PROCREC_COMMONS

Customer VH

I_CollsCustomerVH is a Composite CDS View that provides data about "Customer VH" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 9 fields with key field Customer. It has 2 associations to related views. Part of development package ODATA_PROCREC_COMMONS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Customer_VH _CustomerVH $projection.Customer = _CustomerVH.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICLLCSTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Customer VH view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
Search.searchable true view
Consumption.ranked true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
CustomerName CustomerName
Country Country
CityName CityName
StreetName StreetName
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
_Customer _Customer
_CustomerVH _CustomerVH 
@AbapCatalog: { sqlViewName: 'ICLLCSTVH',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData: { blocking: #BLOCKED_DATA_EXCLUDED } }
@EndUserText: { label: 'Customer VH' }
@VDM: { viewType:  #COMPOSITE,
        lifecycle: { contract: { type: #PUBLIC_LOCAL_API } } }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #C,
                             sizeCategory: #XL,
                             dataClass: #MASTER },
                dataCategory: #VALUE_HELP,
                semanticKey: [ 'Customer' ],
                representativeKey: 'Customer' }
@Search: { searchable: true }
@Consumption: { ranked: true,
                dbHints: [ 'USE_HEX_PLAN' ] }

define view I_CollsCustomerVH
  as select from I_Customer

  // VDM Associations

  // Customer

  association [1..1] to I_Customer    as _Customer   on $projection.Customer = _Customer.Customer

  // Customer Value Help

  association [0..1] to I_Customer_VH as _CustomerVH on $projection.Customer = _CustomerVH.Customer

{

      // VDM Fields

      @UI: { lineItem: [ { position:   10,
                           importance: #HIGH } ] }
      @ObjectModel: { text: { element: [ 'CustomerName' ] } }
      @Search: { defaultSearchElement: true,
                 ranking:              #HIGH,
                 fuzzinessThreshold:   0.8 }
      @Consumption: { valueHelpDefinition: [ { association: '_CustomerVH' } ] }
  key Customer,

      @UI: { lineItem: [ { position:   20,
                           importance: #HIGH } ] }
      CustomerName,

      @UI: { lineItem: [ { position: 30,
                           importance: #HIGH } ] }
      @Consumption: { valueHelpDefinition: [ { entity: { name:    'I_CountryVH',
                                                         element: 'Country' } } ] }
      Country,

      @UI: { lineItem: [ { position: 40,
                           importance: #HIGH } ] }
      @Search: { ranking:              #LOW,
                 fuzzinessThreshold:   0.9 }
      CityName,

      @UI: { lineItem: [ { position: 50,
                           importance: #HIGH } ] }
      @Search: { ranking:              #LOW,
                 fuzzinessThreshold:   0.9 }
      StreetName,

      @UI: { hidden: true }
      @Search: { ranking:              #LOW,
                 fuzzinessThreshold:   0.9 }
      OrganizationBPName1,

      @UI: { hidden: true }
      @Search: { ranking:              #LOW,
                 fuzzinessThreshold:   0.9 }
      OrganizationBPName2,

      // Exposed associations

      _Customer,
      _CustomerVH

}

Learn More