I_BPCustomerGeneralAddressInfo

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_BPCustomerGeneralAddressInfo.
-- 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: IBPCUSTADDRINFO

CREATE VIEW I_BPCustomerGeneralAddressInfo AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressID AS AddressID,
  BusinessPartnerCustomer.Customer AS Customer,
  case when CustAddrDepdntInformation.AddressID is not initial then CustAddrDepdntInformation.TrainStationName else BusinessPartnerCustomer.TrainStationName end as TrainStationName AS TrainStationNameendasTrainStationName,
  case when CustAddrDepdntInformation.AddressID is not initial then CustAddrDepdntInformation.CityCode else BusinessPartnerCustomer.CityCode end as CityCode AS CityCodeendasCityCode,
  case when CustAddrDepdntInformation.AddressID is not initial then CustAddrDepdntInformation.County else BusinessPartnerCustomer.County end as County AS CountyendasCounty,
  BusinessPartnerCustomer.CustomerAccountGroup AS CustomerAccountGroup,
  BusinessPartnerCustomer.CustomerClassification AS CustomerClassification,
  BusinessPartnerCustomer.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerCustomer.DeliveryIsBlocked AS DeliveryIsBlocked,
  BusinessPartnerCustomer.PostingIsBlocked AS PostingIsBlocked,
  BusinessPartnerCustomer.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BusinessPartnerCustomer.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BusinessPartnerCustomer.CustomerCorporateGroup AS CustomerCorporateGroup,
  BusinessPartnerCustomer.Supplier AS Supplier,
  BusinessPartnerCustomer.IndustryCode1 AS IndustryCode1,
  BusinessPartnerCustomer.IndustryCode2 AS IndustryCode2,
  BusinessPartnerCustomer.IndustryCode3 AS IndustryCode3,
  BusinessPartnerCustomer.AlternativePayerAccount AS AlternativePayerAccount,
  BusinessPartnerCustomer.DataMediumExchangeIndicator AS DataMediumExchangeIndicator,
  BusinessPartnerCustomer.VATLiability AS VATLiability,
  BusinessPartnerCustomer.FiscalAddress AS FiscalAddress,
  BusinessPartnerCustomer.IsNaturalPerson AS IsNaturalPerson,
  BusinessPartnerCustomer.CityLocationCoordinatesCode AS CityLocationCoordinatesCode,
  BusinessPartnerCustomer.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  BusinessPartnerCustomer.Plant AS Plant,
  BusinessPartnerCustomer.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  BusinessPartnerCustomer.IsCompetitor AS IsCompetitor,
  BusinessPartnerCustomer.IsSalesPartner AS IsSalesPartner,
  BusinessPartnerCustomer.IsDefaultSoldToParty AS IsDefaultSoldToParty,
  BusinessPartnerCustomer.IsConsumer AS IsConsumer,
  BusinessPartnerCustomer.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  BusinessPartnerCustomer.CustomerConditionGroup1 AS CustomerConditionGroup1,
  BusinessPartnerCustomer.CustomerConditionGroup2 AS CustomerConditionGroup2,
  BusinessPartnerCustomer.CustomerConditionGroup3 AS CustomerConditionGroup3,
  BusinessPartnerCustomer.CustomerConditionGroup4 AS CustomerConditionGroup4,
  BusinessPartnerCustomer.CustomerConditionGroup5 AS CustomerConditionGroup5
FROM I_BusPartAddress AS BusinessPartnerAddress
INNER JOIN I_BusinessPartnerCustomer AS BusinessPartnerCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;