P_RU_CustomerSupplierDataComp

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 P_RU_CustomerSupplierDataComp.
-- 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: PRUCUSTSUPLRDC

CREATE VIEW P_RU_CustomerSupplierDataComp AS
SELECT
  CustomerCompany.CompanyCode AS CompanyCode,
  cast( Customer.Customer as char10 preserving type ) AS Partner,
  cast( ltrim(Customer.Customer,'0') as char10 preserving type ) AS PartnerShort,
  'C' AS PartnerType,
  Customer.CustomerName AS PartnerName,
  Customer.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
  Customer.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
  Customer.RU_PartnerPersonINN AS RU_PartnerPersonINN,
  Customer.LastName AS LastName,
  Customer.FirstName AS FirstName,
  Customer.MiddleName AS MiddleName,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  Customer.BPIsOrganization AS BPIsOrganization,
  Customer.IsNaturalPerson AS IsNaturalPerson,
  '' AS CustomerCountry
FROM I_RU_CustomerData AS Customer
INNER JOIN I_CustomerCompany AS CustomerCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierCompany AS SupplierCompany ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_RU_SupplierData
;