C_BusinessPartnerPopOver

DDL: C_BUSINESSPARTNERPOPOVER SQL: CBPPOPOVER Type: view CONSUMPTION

view for Business Partner PopOver reuse

C_BusinessPartnerPopOver is a Consumption CDS View that provides data about "view for Business Partner PopOver reuse" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerPopOver) and exposes 53 fields with key field BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerPopOver BusinessPartner from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CBPPOPOVER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label view for Business Partner PopOver reuse view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartnerPopOver BusinessPartner Issuing Authority
Customer I_BusinessPartnerPopOver Customer Sold-to Party
Supplier I_BusinessPartnerPopOver Supplier Supplier
BusinessPartnerUUID I_BusinessPartnerPopOver BusinessPartnerUUID UUID
BusinessPartnerCategory I_BusinessPartnerPopOver BusinessPartnerCategory Partner Cat.
BusinessPartnerName I_BusinessPartnerPopOver BusinessPartnerName Extracted Customer Name
BusinessPartnerFullName I_BusinessPartnerPopOver BusinessPartnerFullName Broker Name
CreatedByUser I_BusinessPartnerPopOver CreatedByUser User Name
CreationDate I_BusinessPartnerPopOver CreationDate Time Stamp
CreationTime I_BusinessPartnerPopOver CreationTime Time of Change
FirstName I_BusinessPartnerPopOver FirstName First Name
LastName I_BusinessPartnerPopOver LastName Last Name
PersonFullName I_BusinessPartnerPopOver PersonFullName Full Name
OrganizationBPName1 I_BusinessPartnerPopOver OrganizationBPName1 Name 1
OrganizationBPName2 I_BusinessPartnerPopOver OrganizationBPName2 Name 2
OrganizationBPName3 I_BusinessPartnerPopOver OrganizationBPName3 Name 3
OrganizationBPName4 I_BusinessPartnerPopOver OrganizationBPName4 Name 4
AuthorizationGroup I_BusinessPartnerPopOver AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_BusinessPartnerPopOver IsBusinessPurposeCompleted Purpose Completed
NameCountry I_BusinessPartnerPopOver NameCountry Country/Region
BusinessPartnerGrouping I_BusinessPartnerPopOver BusinessPartnerGrouping Grouping
IsNaturalPerson I_BusinessPartnerPopOver IsNaturalPerson Natural person
Country I_BusinessPartnerPopOver Country Venue: Ctry/Reg
CityName I_BusinessPartnerPopOver CityName Name
PostalCode I_BusinessPartnerPopOver PostalCode Postal Code
Region I_BusinessPartnerPopOver Region Venue Region
StreetName I_BusinessPartnerPopOver StreetName Text
HouseNumber I_BusinessPartnerPopOver HouseNumber House Number
PhoneNumber I_BusinessPartnerPopOver PhoneNumber Telephone no.
PhoneNumberExtension I_BusinessPartnerPopOver PhoneNumberExtension Extension
BPAddressIsProtected I_BusinessPartnerPopOver BPAddressIsProtected Sensitivity
InternationalPhoneNumber I_BusinessPartnerPopOver InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber I_BusinessPartnerPopOver InternationalMobilePhoneNumber
InternationalFaxNumber I_BusinessPartnerPopOver InternationalFaxNumber Fax Number
EmailAddress I_BusinessPartnerPopOver EmailAddress E-Mail Address
HasSupplierRole I_BusinessPartnerPopOver HasSupplierRole
HasCustomerRole I_BusinessPartnerPopOver HasCustomerRole
FormattedAddress I_BusinessPartnerPopOver FormattedAddress
BusinessPartnerGroupingText I_BusinessPartnerPopOver BusinessPartnerGroupingText
CountryName
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller
DataControllerSet DataControllerSet Data Ctrlr. Set
_CustLink _CustLink
_SupplLink _SupplLink

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 C_BusinessPartnerPopOver.
-- 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.
-- SQL view name: CBPPOPOVER

CREATE VIEW C_BusinessPartnerPopOver AS
SELECT
  BusinessPartner.BusinessPartner AS BusinessPartner,
  BusinessPartner.Customer AS Customer,
  BusinessPartner.Supplier AS Supplier,
  BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  BusinessPartner.CreatedByUser AS CreatedByUser,
  BusinessPartner.CreationDate AS CreationDate,
  BusinessPartner.CreationTime AS CreationTime,
  BusinessPartner.FirstName AS FirstName,
  BusinessPartner.LastName AS LastName,
  BusinessPartner.PersonFullName AS PersonFullName,
  BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  BusinessPartner.OrganizationBPName3 AS OrganizationBPName3,
  BusinessPartner.OrganizationBPName4 AS OrganizationBPName4,
  BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  BusinessPartner.NameCountry AS NameCountry,
  BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  BusinessPartner.IsNaturalPerson AS IsNaturalPerson,
  BusinessPartner.Country AS Country,
  BusinessPartner.CityName AS CityName,
  BusinessPartner.PostalCode AS PostalCode,
  BusinessPartner.Region AS Region,
  BusinessPartner.StreetName AS StreetName,
  BusinessPartner.HouseNumber AS HouseNumber,
  BusinessPartner.PhoneNumber AS PhoneNumber,
  BusinessPartner.PhoneNumberExtension AS PhoneNumberExtension,
  BusinessPartner.BPAddressIsProtected AS BPAddressIsProtected,
  BusinessPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  BusinessPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  BusinessPartner.InternationalFaxNumber AS InternationalFaxNumber,
  BusinessPartner.EmailAddress AS EmailAddress,
  BusinessPartner.HasSupplierRole AS HasSupplierRole,
  BusinessPartner.HasCustomerRole AS HasCustomerRole,
  BusinessPartner.FormattedAddress AS FormattedAddress,
  BusinessPartner.BusinessPartnerGroupingText AS BusinessPartnerGroupingText,
  concat_with_space( BusinessPartner._CountryText.CountryName,concat('(',concat(Country,')')),1) AS CountryName,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  DataControllerSet
FROM I_BusinessPartnerPopOver AS BusinessPartner
;