C_PartnerFuncBySalesDocTypeVH

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_PartnerFuncBySalesDocTypeVH.
-- 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_PartnerFuncBySalesDocTypeVH AS
SELECT
  SalesDocumentType.SalesDocumentType AS SalesDocumentType,
  PartFuncByPartDetnProced.PartnerDeterminationProcedure AS PartnerDeterminationProcedure,
  PartFuncByPartDetnProced.PartnerFunction AS PartnerFunction,
  _PartnerFunction._Text[1: Language=$session.system_language].PartnerFunctionName AS PartnerFunctionName,
  PartFuncByPartDetnProced._PartnerDeterminationProcedure AS _PartnerDeterminationProcedure
FROM I_SalesDocumentType AS SalesDocumentType
INNER JOIN I_PartFuncByPartDetnProced AS PartFuncByPartDetnProced ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PartnerFunctionUnconverted AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_AdvncdRetsMgmtSttgAtClient AS _ThirdPartySupplier ON PartnerFunction = _ThirdPartySupplier.ThirdPtySuplrPartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_AdvncdRetsMgmtSttgAtClient AS _ThirdPartyReturnTo ON PartnerFunction = _ThirdPartyReturnTo.ThirdPtyRetToPartnerFunction  -- association [0..1]
;