C_SlsDocNonStdPartner

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 C_SlsDocNonStdPartner.
-- 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 C_SlsDocNonStdPartner AS
SELECT
  SDDocument,
  SDDocumentItem,
  cast(PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  _PartnerFunction._Text[1:Language = $session.system_language ].PartnerFunctionName AS PartnerFunctionName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  Customer,
  Supplier,
  _AdditionalPartners.Partner AS BusinessPartner,
  _AdditionalPartners.FullName AS BusinessPartnerFullName,
  Personnel,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  ContactPerson,
  PartnerIsOneTimeAccount,
  VATRegistration,
  cast( ' ' as ad_line_s ) AS FormattedPostalAddressDesc
FROM I_SDDocumentCompletePartners
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SDDocument = _SalesDocument.SalesDocument  -- association [1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SDDocument = _SalesDocumentItem.SalesDocument AND SDDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN I_SalesDocumentPartner AS _AdditionalPartners ON SDDocument = _AdditionalPartners.SalesDocument AND PartnerFunction = _AdditionalPartners.PartnerFunction  -- association [1]
;