C_BPAdditionalCustomer

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_BPAdditionalCustomer.
-- 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: CBPADDCUST

CREATE VIEW C_BPAdditionalCustomer AS
SELECT
  BPAdditionalCustomer.BusinessPartner AS BusinessPartner,
  BPAdditionalCustomer.Customer AS Customer,
  BPAdditionalCustomer.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BPAdditionalCustomer.CustomerForEdit AS CustomerForEdit,
  BPAdditionalCustomer.BPAssignmentReasonID AS BPAssignmentReasonID,
  BPAdditionalCustomer.CustomerAccountGroup AS CustomerAccountGroup,
  BPAdditionalCustomer.AlternativePayerAccount AS AlternativePayerAccount,
  BPAdditionalCustomer.DataMediumExchangeIndicator AS DataMediumExchangeIndicator,
  BPAdditionalCustomer.Supplier AS Supplier,
  BPAdditionalCustomer.CustomerClassification AS CustomerClassification,
  BPAdditionalCustomer.VATLiability AS VATLiability,
  BPAdditionalCustomer.PostingIsBlocked AS PostingIsBlocked,
  BPAdditionalCustomer.DeliveryIsBlocked AS DeliveryIsBlocked,
  BPAdditionalCustomer.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BPAdditionalCustomer.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BPAdditionalCustomer.AuthorizationGroup AS AuthorizationGroup,
  BPAdditionalCustomer.AddressNumber AS AddressNumber,
  BPAdditionalCustomer.StreetName AS StreetName,
  BPAdditionalCustomer.HouseNumber AS HouseNumber,
  BPAdditionalCustomer.PostalCode AS PostalCode,
  BPAdditionalCustomer.CityName AS CityName,
  BPAdditionalCustomer.Country AS Country,
  BPAdditionalCustomer.Region AS Region,
  BPAdditionalCustomer.POBoxPostalCode AS POBoxPostalCode,
  BPAdditionalCustomer.POBox AS POBox,
  BPAdditionalCustomer.CorrespondenceLanguage AS CorrespondenceLanguage,
  BPAdditionalCustomer.PrfrdCommMediumType AS PrfrdCommMediumType,
  BPAdditionalCustomer.DeliveryDateTypeRule AS DeliveryDateTypeRule,
  BPAdditionalCustomer.DeletionIndicator AS DeletionIndicator
FROM I_BPAdditionalCustomerTP AS BPAdditionalCustomer
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAddlCustCompanyCode AS _BPAddlCustCompanyCode ON BusinessPartner = _BPAddlCustCompanyCode.BusinessPartner AND Customer = _BPAddlCustCompanyCode.Customer  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustSalesArea AS _BPAddlCustSalesArea ON BusinessPartner = _BPAddlCustSalesArea.BusinessPartner AND Customer = _BPAddlCustSalesArea.Customer  -- association [1..*]
LEFT OUTER JOIN I_Supplier_VH AS _SupplierValueHelp ON Supplier = _SupplierValueHelp.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer_VH AS _AlternativePayerValueHelp ON AlternativePayerAccount = _AlternativePayerValueHelp.Customer  -- association [0..1]
LEFT OUTER JOIN C_BPAddressValueHelp AS _BPAddressValueHelp ON BusinessPartner = _BPAddressValueHelp.BusinessPartner AND AddressNumber = _BPAddressValueHelp.AddressNumber  -- association [0..1]
LEFT OUTER JOIN C_BPAddlCustTelNmbr AS _BPAddlCustTelNmbr ON BusinessPartner = _BPAddlCustTelNmbr.BusinessPartner AND Customer = _BPAddlCustTelNmbr.Customer  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustMblPhNumber AS _BPAddlCustMblPhNumber ON BusinessPartner = _BPAddlCustMblPhNumber.BusinessPartner AND Customer = _BPAddlCustMblPhNumber.Customer  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustFaxNumber AS _BPAddlCustFaxNumber ON BusinessPartner = _BPAddlCustFaxNumber.BusinessPartner AND Customer = _BPAddlCustFaxNumber.Customer  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustWebsiteURL AS _BPAddlCustWebsiteURL ON BusinessPartner = _BPAddlCustWebsiteURL.BusinessPartner AND Customer = _BPAddlCustWebsiteURL.Customer  -- association [1..*]
LEFT OUTER JOIN C_BPAddlCustEmailAddress AS _BPAddlCustEmailAddress ON BusinessPartner = _BPAddlCustEmailAddress.BusinessPartner AND Customer = _BPAddlCustEmailAddress.Customer  -- association [1..*]
LEFT OUTER JOIN I_BillingBlockReasonText AS _BillingBlockReasonText ON BillingIsBlockedForCustomer = _BillingBlockReasonText.BillingBlockReason  -- association [0..*]
LEFT OUTER JOIN I_DeliveryBlockReasonText AS _DeliveryBlockReasonText ON DeliveryIsBlocked = _DeliveryBlockReasonText.DeliveryBlockReason  -- association [0..*]
LEFT OUTER JOIN I_BusPartAuthorizationGroupTxt AS _AuthorizationGroupText ON AuthorizationGroup = _AuthorizationGroupText.AuthorizationGroup AND _AuthorizationGroupText.AuthorizationObject = 'CUST'  -- association [1..*]
LEFT OUTER JOIN I_DeliveryDateTypeRuleText AS _DeliveryDateTypeRuleText ON DeliveryDateTypeRule = _DeliveryDateTypeRuleText.DeliveryDateTypeRule  -- association [0..*]
LEFT OUTER JOIN C_CommMethTextVhTemp AS _CommMethText ON PrfrdCommMediumType = _CommMethText.CommunicationMediumType  -- association [0..*]
LEFT OUTER JOIN C_BPLanguageTextValueHelp AS _LanguageText ON CorrespondenceLanguage = _LanguageText.LanguageCode  -- association [0..*]
;