I_NL_SAFTBusinessPartnerCA

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_NL_SAFTBusinessPartnerCA.
-- 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: ISFTNLBPCA

CREATE VIEW I_NL_SAFTBusinessPartnerCA AS
SELECT
  BusinessPartner.BusinessPartner AS BusinessPartner,
  BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast(BusinessPartner.BusinessPartnerName as abap.char(50)) AS BusinessPartnerName,
  coalesce(CustomerToBP.Customer, ' ') AS Customer,
  coalesce(SupplierToBP.Supplier, ' ') AS Supplier,
  coalesce(BusinessPartner._CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber, '') AS PhoneNumber,
  cast( coalesce(BusinessPartner._CurrentDefaultAddress._Address._DefaultFaxNumber.FaxNumber, '') as telfx ) AS FaxNumber,
  coalesce(BusinessPartner._CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress, '') AS EmailAddress,
  coalesce(BusinessPartner._CurrentDefaultAddress._Address._DefaultURLAddress.SearchURLAddress, '') AS SearchURLAddress,
  coalesce(BPCreditLimit.CustomerCreditLimitAmount, 0) AS CustomerCreditLimitAmount,
  BPCreditLimit.CreditSegmentCurrency AS CreditSegmentCurrency,
  coalesce(BusinessPartner._CurrentDefaultAddress._Address.Country, ' ') AS AddressCountry
INNER JOIN I_CustomerToBusinessPartner AS CustomerToBP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SAFTBPMultipleVATNmbr AS BPMultiVAT ON BPMultiVAT.BusinessPartner = BusinessPartner.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN P_NL_SAFTCreditLimit AS BPCreditLimit ON BPCreditLimit.BusinessPartner = BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SupplierToBusinessPartner AS SupplierToBP ON SupplierToBP.BusinessPartnerUUID = BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS CustomerToBP ON CustomerToBP.BusinessPartnerUUID = BusinessPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnertaxnumber AS _BPTaxNumber ON _BPTaxNumber.BusinessPartner = BusinessPartner AND _BPTaxNumber.BPTaxType = 'NL0'  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerBank AS _BPBank ON _BPBank.BusinessPartner = BusinessPartner AND _BPBank.BankIdentification = '0001'  -- association [0..1]
LEFT OUTER JOIN I_BuPaIdentification AS _BPIdentification ON _BPIdentification.BusinessPartner = BusinessPartner AND _BPIdentification.BPIdentificationType = 'BUP002'  -- association [0..*]
;