I_DbtflAcctsValnCustomer

DDL: I_DBTFLACCTSVALNCUSTOMER SQL: IDAVCUST Type: view COMPOSITE Package: ODATA_DOUBTFUL_ACCTS_VALUATION

DAV Customer Information

I_DbtflAcctsValnCustomer is a Composite CDS View that provides data about "DAV Customer Information" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 27 fields with key field Customer. It has 1 association to related views. Part of development package ODATA_DOUBTFUL_ACCTS_VALUATION.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Country _Country _Country.Country = $projection.Country

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDAVCUST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
EndUserText.label DAV Customer Information view
Metadata.allowExtensions true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
OrganizationBPName1 BusinessPartnerName1
OrganizationBPName2 BusinessPartnerName2
CustomerName BPCustomerName
CustomerFullName BPCustomerFullName
CustomerAccountGroup CustomerAccountGroup
AuthorizationGroup AuthorizationGroup
StreetName BPAddrStreetName
CityName BPAddrCityName
PostalCode PostalCode
Country
CountryName Country
PhoneNumber
EmailAddress
CompleteAddress
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
_Country _Country 
@AbapCatalog.sqlViewName: 'IDAVCUST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory: #L
}
@ObjectModel.semanticKey:  [ 'Customer' ]
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'DAV Customer Information'
@Metadata.allowExtensions: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_DbtflAcctsValnCustomer
  as select from I_Customer

  association [0..1] to I_Country as _Country on _Country.Country = $projection.Country
{
      @Semantics.contact.type: #PERSON
  key Customer,

      BusinessPartnerName1                                                                                                                                                         as OrganizationBPName1,
      BusinessPartnerName2                                                                                                                                                         as OrganizationBPName2,

      @Semantics.name.fullName: true
      BPCustomerName                                                                                                                                                               as CustomerName,

      // contains CustomerName + PostalCode, not suitable for @Semantics.name.fullname

      BPCustomerFullName                                                                                                                                                           as CustomerFullName,

      @UI.hidden: true
      CustomerAccountGroup,
      @UI.hidden: true
      AuthorizationGroup,

      BPAddrStreetName                                                                                                                                                             as StreetName,

      BPAddrCityName                                                                                                                                                               as CityName,

      PostalCode,

      @ObjectModel.text.element:  [ 'CountryName' ]
      _StandardAddress._Country.Country                                                                                                                                            as Country,
      @EndUserText.label: 'Country'
      _StandardAddress._Country._Text[1: Language = $session.system_language ].CountryName                                                                                         as CountryName,

      @Semantics.telephone.type:  [ #WORK ]
      _StandardAddress._DefaultCorporatePhoneNumber.PhoneNumber                                                                                                                    as PhoneNumber,

      @Semantics.eMail.type:[ #WORK ]
      @Semantics.eMail.address: true
      _StandardAddress._DefaultCorpEmailAddress.EmailAddress                                                                                                                       as EmailAddress,

      // create a one-line address in the form 'StreetName House Number, PostalCode CityName'; (StreetName doesn't contain HouseNumber)

      concat_with_space(concat(concat_with_space(BPAddrStreetName, coalesce( _StandardAddress.HouseNumber, '' ), 1), ','), concat_with_space( PostalCode, BPAddrCityName, 1 ), 1 ) as CompleteAddress,

      /* DCL relevant */
      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataControllerSet,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController1,

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

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController3,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController4,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController5,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController6,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController7,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController8,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController9,

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController10,

      _Country
}

Learn More