I_BPCustomerMultiAddrVH

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 I_BPCustomerMultiAddrVH.
-- 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: IMULTIADDRCUSTVH

CREATE VIEW I_BPCustomerMultiAddrVH AS
SELECT
  I_BusPartAddress.AddressID AS AddressID,
  I_BusinessPartnerCustomer.BusinessPartner AS BusinessPartner,
  I_BusinessPartnerCustomer.Customer AS Customer,
  I_Address_2.Country AS Country,
  I_Address_2.CityName AS CityName,
  I_Address_2.StreetName AS StreetName,
  I_Address_2.HouseNumber AS HouseNumber,
  I_Address_2.PostalCode AS PostalCode,
  I_Customer.CustomerName AS CustomerName,
  I_Customer.BPCustomerName AS BPCustomerName,
  I_BusinessPartnerCustomer.CustomerAccountGroup AS CustomerAccountGroup,
  I_BusinessPartnerCustomer.AuthorizationGroup AS AuthorizationGroup,
  I_BusinessPartnerCustomer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerType AS BusinessPartnerType,
  tstmp_to_dats(I_BusPartAddress.ValidityStartDate,'UTC', $session.client, 'NULL') AS AddressValidityStartDate,
  tstmp_to_dats(I_BusPartAddress.ValidityEndDate,'UTC', $session.client, 'NULL') AS AddressValidityEndDate,
  I_Businesspartneraddressusage.AddressUsage AS AddressUsage,
  I_Customer.OrganizationBPName1 AS OrganizationBPName1,
  I_Customer.BusinessPartnerName1 AS BusinessPartnerName1,
  I_Customer.OrganizationBPName2 AS OrganizationBPName2,
  I_Customer.BusinessPartnerName2 AS BusinessPartnerName2,
  I_Address_2.AddressSearchTerm1 AS AddressSearchTerm1,
  I_Address_2.AddressSearchTerm2 AS AddressSearchTerm2,
  cast(' ' as abap_boolean preserving type) AS BusPartAddrLayoutStdIsHidden,
  I_Customer.DataControllerSet AS DataControllerSet,
  I_Customer.DataController1 AS DataController1,
  I_Customer.DataController2 AS DataController2,
  I_Customer.DataController3 AS DataController3,
  I_Customer.DataController4 AS DataController4,
  I_Customer.DataController5 AS DataController5,
  I_Customer.DataController6 AS DataController6,
  I_Customer.DataController7 AS DataController7,
  I_Customer.DataController8 AS DataController8,
  I_Customer.DataController9 AS DataController9,
  I_Customer.DataController10 AS DataController10
FROM I_BusinessPartnerCustomer
INNER JOIN I_BusPartAddress ON /* join condition not captured in parsed metadata */
INNER JOIN I_Address_2 ON /* join condition not captured in parsed metadata */
INNER JOIN I_Customer ON /* join condition not captured in parsed metadata */
;