C_QltyCertCustomerVH

DDL: C_QLTYCERTCUSTOMERVH SQL: CQCCUSTOMERVH Type: view CONSUMPTION Package: ODATA_QM_CERT_INSPLOT

Quality Certificate Customer

C_QltyCertCustomerVH is a Consumption CDS View that provides data about "Quality Certificate Customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 26 fields with key field Customer. It has 1 association to related views. Part of development package ODATA_QM_CERT_INSPLOT.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer Customer from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CountryText _Text $projection.Country = _Text.Country and _Text.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CQCCUSTOMERVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Quality Certificate Customer view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Customer view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
OrganizationBPName1 I_Customer OrganizationBPName1 Name 1
OrganizationBPName2 I_Customer OrganizationBPName2 Name 2
CustomerName I_Customer CustomerName Customer Name
Country I_Customer Country
CityName I_Customer CityName City
StreetName I_Customer StreetName Street
PostalCode I_Customer PostalCode Postal Code
EmailAddress Email Address
CustomerAccountGroup I_Customer CustomerAccountGroup
AuthorizationGroup I_Customer AuthorizationGroup
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted Purpose Complete Flag
DataController1 I_Customer DataController1
DataController2 I_Customer DataController2
DataController3 I_Customer DataController3
DataController4 I_Customer DataController4
DataController5 I_Customer DataController5
DataController6 I_Customer DataController6
DataController7 I_Customer DataController7
DataController8 I_Customer DataController8
DataController9 I_Customer DataController9
DataController10 I_Customer DataController10
DataControllerSet I_Customer DataControllerSet
Language _Text Language
NationalityName _Text NationalityName
_Text _Text 
@AbapCatalog.sqlViewName: 'CQCCUSTOMERVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Quality Certificate Customer'

@VDM.viewType: #CONSUMPTION

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'Customer'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

//<TODO> Please double-check personal data blocking 

@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true
@Consumption.ranked: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@Metadata.ignorePropagatedAnnotations: true

define view C_QltyCertCustomerVH as select from I_Customer as Customer
    association [1..1] to I_CountryText as _Text on $projection.Country = _Text.Country
    and _Text.Language = $session.system_language

{  
        
        @ObjectModel.text.element: ['CustomerName']
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #HIGH
        key     Customer.Customer  ,//as Customer

        
        @EndUserText.label: 'Name 1'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
        Customer.OrganizationBPName1,
        
         @EndUserText.label: 'Name 2'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
        Customer.OrganizationBPName2,
       
        @EndUserText.label: 'Customer Name'
 //       @Search.defaultSearchElement: true

//        @Search.fuzzinessThreshold: 0.8

//        @Search.ranking: #HIGH

        Customer.CustomerName,
        
       // @EndUserText.label: 'Country'

        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW 
        @ObjectModel.text.association :'_Text'
        Customer.Country,
        
//        @EndUserText.label: 'Country Name'

//        @Search.defaultSearchElement: true

//        @Search.fuzzinessThreshold: 0.8

//        @Search.ranking: #HIGH

//        _Text.CountryName  as CountryName,    


        @EndUserText.label: 'City'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
         Customer.CityName, 
         
        @EndUserText.label: 'Street'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
         Customer.StreetName, 
         
        @EndUserText.label: 'Postal Code'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
         Customer.PostalCode, 

         @EndUserText.label: 'Email Address'
        @Search.defaultSearchElement: true
        @Search.fuzzinessThreshold: 0.8
        @Search.ranking: #LOW
        Customer._StandardAddress._DefaultEmailAddress.EmailAddress as EmailAddress ,
        
               
        @UI.hidden: true
        @Consumption.filter.hidden: true        
        Customer.CustomerAccountGroup,

        @UI.hidden: true
        @Consumption.filter.hidden: true        
        Customer.AuthorizationGroup,
        
        @Semantics.booleanIndicator 
        @UI.hidden: true
        @Consumption.filter.hidden: true
        @EndUserText.label: 'Purpose Complete Flag'        
         Customer.IsBusinessPurposeCompleted,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController1,

        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController2,

        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController3,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController4,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController5,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController6,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController7,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController8,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController9,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataController10,
         
        @UI.hidden: true
        @Consumption.filter.hidden: true
        Customer.DataControllerSet,         
         
         _Text.Language,
         _Text.NationalityName,
       //association

       @Consumption.filter.hidden: true
       _Text
    
}
//where _Text.Language = $session.system_language

Learn More