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_NL_SAFTBusinessPartner.
-- 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: CNLSAFTBP
-- Parameters: P_StartDate : dats, P_EndDate : dats
CREATE VIEW C_NL_SAFTBusinessPartner AS
SELECT
BusinessPartner.BusinessPartner AS BusinessPartner,
BusinessPartner.CompanyCode AS CompanyCode,
BusinessPartner.FiscalYear AS FiscalYear,
BusinessPartner.Ledger AS Ledger,
BusinessPartner.Customer AS Customer,
BusinessPartner.Supplier AS Supplier,
BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
cast( case when BusinessPartner.Customer is not initial and BusinessPartner.Customer is not null then concat_with_space( coalesce(BPContactCustomer.FirstName, coalesce(BPOtherContact.FirstName, ' ' )), coalesce(BPContactCustomer.LastName, coalesce(BPOtherContact.LastName, ' ' )), 1) when BusinessPartner.Supplier is not initial and BusinessPartner.Supplier is not null then concat_with_space( coalesce(BPContactSupplier.FirstName, coalesce(BPOtherContact.FirstName, ' ' )), coalesce(BPContactSupplier.LastName, coalesce(BPOtherContact.LastName, ' ' )), 1) else ' ' end as abap.char( 50 ) ) as ContactOriginName AS char50asContactOriginName,
BPAddress.PhoneNumber AS PhoneNumber,
BPAddress.FaxNumber AS FaxNumber,
BPAddress.EmailAddress AS EmailAddress,
cast( BPAddress.SearchURLAddress as ad_uri2 ) AS SearchURLAddress,
BPAddress.StreetName AS StreetName,
BPAddress.HouseNumber AS HouseNumber,
BPAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
BPAddress.CareOfName AS CareOfName,
BPAddress.CityName AS CityName,
BPAddress.PostalCode AS PostalCode,
BPAddress.Region AS Region,
BPAddress.Country AS Country,
coalesce(BPIdentification.BPIdentificationNumber, ' ') AS BPIdentificationNumber,
BPAddress.Country AS VATRegistrationCountry,
case when BPMultiVAT.NumberOfLines is not null and BPMultiVAT.NumberOfLines > 1 then coalesce(BPTaxNumber.BPTaxNumber, ' ') when BPMultiVAT.NumberOfLines > 1 and BPTaxNumber.BPTaxNumber is not initial and BPTaxNumber.BPTaxNumber is not null then BPTaxNumber.BPTaxNumber else coalesce(BPVATByCountry.BPTaxNumber, ' ') end as BPTaxNumber AS BPTaxNumberendasBPTaxNumber,
BPCreditLimit.CreditSegmentCurrency AS CreditSegmentCurrency,
BusinessPartner._CompanyCode AS _CompanyCode,
BusinessPartner._Ledger AS _Ledger,
BusinessPartner._FiscalYear AS _FiscalYear
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN P_BPCurrentAddress AS BPAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SAFTBPVATByCountry AS BPVATByCountry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerContact AS BPContactCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerContact AS BPContactSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NL_SAFTBusinessPartnerCntct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Businesspartnertaxnumber AS BPTaxNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SAFTBPMultipleVATNmbr AS BPMultiVAT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NL_SAFTCreditLimit AS BPCreditLimit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BuPaIdentification AS BPIdentification ON /* join condition not captured in parsed metadata */
;