SHSM_BusinessPartnerCustomer

DDL: SHSM_BUSINESSPARTNERCUSTOMER Type: view
12 Fields 1 Data Sources

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.

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 Issuing Authority
Customer Customer Sold-to Party
CustomerAccountGroup _Customer CustomerAccountGroup Account group
CustomerName _Customer CustomerName Name of Customer
StreetName
PostalCode
CityName
Country
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
BusinessPartnerUUID I_CustomerToBusinessPartner BusinessPartnerUUID UUID
_BusinessPartner I_CustomerToBusinessPartner _BusinessPartner
_Customer _Customer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SHSM_BusinessPartnerCustomer.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW SHSM_BusinessPartnerCustomer AS
SELECT
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  Customer,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.CustomerName AS CustomerName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName AS StreetName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CityName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  I_CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_CustomerToBusinessPartner._BusinessPartner AS _BusinessPartner
FROM I_CustomerToBusinessPartner
;

Learn More