I_NO_SAFTCustomerMasterData

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_NO_SAFTCustomerMasterData.
-- 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.
-- Parameters: P_FromPostingDate : budat, P_ToPostingDate : budat, P_Ledger : fins_ledger, P_FiscalYear : gjahr

CREATE VIEW I_NO_SAFTCustomerMasterData AS
SELECT
  CustomerCompany.CompanyCode AS CompanyCode,
  CustomerCompany.Customer AS Customer,
  cast('' as fis_belnr) AS AccountingDocument,
  cast('' as fis_docln) AS LedgerGLLineItem,
  cast(ltrim(Customer.Customer,'0') as saftn_no_customer_id) AS NO_SAFTCustomerID,
  BP.BusinessPartner AS BusinessPartner,
  BP.BusinessPartnerUUID AS BusinessPartnerUUID,
  CustomerCompany.ReconciliationAccount AS GLAccount,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.TaxNumber2 AS TaxNumber2,
  Customer.BusinessPartnerName1 AS BusinessPartnerName1,
  Customer.BusinessPartnerName2 AS BusinessPartnerName2,
  Customer.VATRegistration AS VATRegistration,
  cast('' as md_customer_name) AS CustomerName,
  Address.Country AS Country,
  Address.Region AS Region,
  Address.CityName AS CityName,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode,
  Address.POBox AS POBox,
  Address.POBoxPostalCode AS POBoxPostalCode,
  cast('' as bankn) AS BankAccount,
  cast('' as bankk) AS BankNumber,
  RegionText.RegionName AS RegionName,
  CustomerCompany._CompanyCode AS _CompanyCode,
  CustomerCompany._Customer AS P_FromPostingDate,
  P_ToPostingDate: $parameters.P_ToPostingDate AS P_ToPostingDate,
  P_Ledger: $parameters.P_Ledger AS P_Ledger,
  case when OneTimeBP.TaxID1 is not initial then concat(concat(ltrim(JournalItem.Customer,'0'), '/'), OneTimeBP.TaxID1) when OneTimeBP.TaxID2 is not initial then concat(concat(ltrim(JournalItem.Customer,'0'), '/'), OneTimeBP.TaxID2) else concat(ltrim(JournalItem.Customer,'0'), '/NA') end as NO_SAFTCustomerID AS Customer0NAendasNO_SAFTCustomerID,
  CustomerCompany._Customer AS _Customer
FROM I_SAFTCustomerBalance
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerCompany AS CustomerCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerToBusinessPartner AS CustToBP ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS BP ON /* join condition not captured in parsed metadata */
INNER JOIN I_BPCurrentDefaultAddress AS BPAddress ON /* join condition not captured in parsed metadata */
INNER JOIN I_Address_2 AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN I_NO_SAFTCustomersInPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItemOneTimeData AS OneTimeBP ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItemRawData
;