I_BPCustDeptAddrDepdntInfo

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_BPCustDeptAddrDepdntInfo.
-- 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: IBPCUSTDEPTADDR

CREATE VIEW I_BPCustDeptAddrDepdntInfo AS
SELECT
  BusinessPartnerAddress.BusinessPartner AS BusinessPartner,
  BusinessPartnerAddress.AddressID AS AddressID,
  BusinessPartnerCustomer.Customer AS Customer,
  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
INNER JOIN I_BusinessPartnerCustomer AS BusinessPartnerCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _DefaultAddress ON _DefaultAddress.BusinessPartner = BusinessPartner  -- association [1..1]
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]
;