I_CO_BPRelationshipRole

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_CO_BPRelationshipRole.
-- 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_CompanyCode : fis_bukrs

CREATE VIEW I_CO_BPRelationshipRole AS
SELECT
  cast( CustomerCompany.CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast( 'D' as gkoar preserving type ) AS OffsettingAccountType,
  cast( BusinessPartner.Customer as gkont preserving type ) AS OffsettingAccount,
  cast( Customer.CustomerAccountGroup as ktokd preserving type ) AS ReferenceAccountGroup,
  CustomerCompany.AuthorizationGroup AS CoCodeSpcfcAuthorizationGroup,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  Customer.TaxNumberType AS TaxNumberType,
  Supplier.AddressID AS AddressID
FROM I_CompanyCode AS CompanyCode
INNER JOIN I_CustomerCompany AS CustomerCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerToBusinessPartner AS BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierCompany AS SupplierCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierToBusinessPartner AS BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CompanyCode
;