SHSM_BusinessPartnerCustomer

DDL: SHSM_BUSINESSPARTNERCUSTOMER Type: view

Business partner customer search help

SHSM_BusinessPartnerCustomer is a CDS View that provides data about "Business partner customer search help" in SAP S/4HANA. It reads from 1 data source (I_CustomerToBusinessPartner) and exposes 12 fields with key field BusinessPartner.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerToBusinessPartner I_CustomerToBusinessPartner from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSM_IBPCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Business partner customer search help view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner _BusinessPartner BusinessPartner
Customer Customer
CustomerAccountGroup _Customer CustomerAccountGroup
CustomerName _Customer CustomerName
StreetName
PostalCode
CityName
Country
AuthorizationGroup _BusinessPartner AuthorizationGroup
BusinessPartnerUUID I_CustomerToBusinessPartner BusinessPartnerUUID
_BusinessPartner I_CustomerToBusinessPartner _BusinessPartner
_Customer _Customer 
@AbapCatalog: {
  sqlViewName: 'SHSM_IBPCUST',
  compiler.compareFilter: true,
  preserveKey: true
 }
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
  dataCategory: #VALUE_HELP,
  representativeKey: 'BusinessPartner',
  usageType : {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L
  }
 }
@EndUserText.label: 'Business partner customer search help'
define view SHSM_BusinessPartnerCustomer
  as select from I_CustomerToBusinessPartner
{
  key _BusinessPartner.BusinessPartner,
      Customer,
      _Customer.CustomerAccountGroup,
      _Customer.CustomerName,
      //    _BusinessPartner._CurrentDefaultAddress._Address.StreetName,

      //    _BusinessPartner._CurrentDefaultAddress._Address.PostalCode,

      //    _BusinessPartner._CurrentDefaultAddress._Address.CityName,

      //    _BusinessPartner._CurrentDefaultAddress._Address.Country,


      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName,
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode,
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName,
      _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country,

      _BusinessPartner.AuthorizationGroup,

      I_CustomerToBusinessPartner.BusinessPartnerUUID,
      I_CustomerToBusinessPartner._BusinessPartner,
      _Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTOMERTOBUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More