I_RU_CustomerData

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_RU_CustomerData.
-- 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: IRUCUSTOMERDATA

CREATE VIEW I_RU_CustomerData AS
SELECT
  P_RU_CustomerData.Customer AS Customer,
  P_RU_CustomerData.BusinessPartner AS BusinessPartner,
  P_RU_CustomerData.IsNaturalPerson AS IsNaturalPerson,
  cast( P_RU_CustomerData.BPIsOrganization as firu_is_bp_org ) AS BPIsOrganization,
  cast( coalesce(PersonData.PersonName, OrgData.OrganizationName) as firu_partner_name ) AS CustomerName,
  cast( coalesce(PersonData.FirstName, '') as firu_partner_pers_first_name ) AS FirstName,
  cast( coalesce(PersonData.LastName, '') as firu_partner_pers_last_name ) AS LastName,
  cast( coalesce(PersonData.MiddleName, '') as firu_partner_pers_middle_name ) AS MiddleName,
  P_RU_CustomerData.BusinessPartnerCategory AS BusinessPartnerCategory,
  P_RU_CustomerData.PersonNumber AS PersonNumber,
  P_RU_CustomerData.AddressID AS AddressID,
  P_RU_CustomerData.Country AS Country,
  P_RU_CustomerData.IsOneTimeAccount AS IsOneTimeAccount,
  P_RU_CustomerData.AuthorizationGroup AS AuthorizationGroup,
  P_RU_CustomerData._CustomerCompany AS _CustomerCompany
FROM P_RU_CustomerData
;