C_PurchasingWorkReDistDocument

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_PurchasingWorkReDistDocument.
-- 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: CWRKLOADREDIST

CREATE VIEW C_PurchasingWorkReDistDocument AS
SELECT
  P_WrkDistrDoc.PurchasingDocument AS PurchasingDocument,
  P_WrkDistrDoc.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_WrkDistrDoc.PurchasingDocumentType AS PurchasingDocumentType,
  P_WrkDistrDoc.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  cast ('' as abap.char( 40 )) AS Status,
  P_WrkDistrDoc.PurchasingGroup AS PurchasingGroup,
  P_WrkDistrDoc.PurchasingGroupName AS PurchasingGroupName,
  P_WrkDistrDoc.PurchasingOrganization AS PurchasingOrganization,
  P_WrkDistrDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  P_WrkDistrDoc.PurchasingOrganizationName AS PurchasingOrganizationName,
  P_WrkDistrDoc.CreationDate AS CreationDate,
  P_WrkDistrDoc.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName
FROM P_WrkDistrDoc
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_PurchasingDocTypeValueHelp AS _PurchasingDocTypeValueHelp ON _PurchasingDocTypeValueHelp.PurchasingDocumentType = PurchasingDocumentType AND _PurchasingDocTypeValueHelp.PurchasingDocumentCategory = PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurgWorkReDistDocCategoryVH AS _PurgWorkReDistDocCategoryVH ON _PurgWorkReDistDocCategoryVH.PurchasingDocumentCategory = PurchasingDocumentCategory  -- association [0..1]
;