P_AR_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 P_AR_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.

CREATE VIEW P_AR_BPRelationshipRole AS
SELECT
  CompanyCode.CompanyCode AS CompanyCode,
  cast( 'D' as fis_gkoar preserving type ) AS OffsettingAccountType,
  cast( CustomerCompany.Customer as fis_gkont preserving type ) AS OffsettingAccount,
  Customer.BPCustomerFullName AS BusinessPartnerFullName,
  cast( Customer.TaxNumberType as j_1atoid preserving type ) AS TaxNumberType,
  Customer.TaxNumber1 AS TaxNumber1,
  Customer.IsOneTimeAccount AS IsOneTimeAccount,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  cast( Customer.CustomerAccountGroup as ktokd preserving type ) AS ReferenceAccountGroup,
  SupplierCompany.AuthorizationGroup AS CoCodeSpcfcAuthorizationGroup
FROM I_CompanyCode AS CompanyCode
INNER JOIN I_CustomerCompany AS CustomerCompany 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_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CompanyCode
;