C_CollectiveProcessingDocument

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_CollectiveProcessingDocument.
-- 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: CCOLPROCDOC

CREATE VIEW C_CollectiveProcessingDocument AS
SELECT
  CollectiveProcessing,
  SDDocument,
  SortSequence,
  _DeliveryDocument.SDDocumentCategory AS SDDocumentCategory,
  cast (_DeliveryDocument._OverallSDProcessStatus._Text[1: Language=$session.system_language].OverallSDProcessStatusDesc as gbstk_name) AS OverallSDProcessStatusDesc,
  cast( case _DeliveryDocument.OverallSDProcessStatus when '' then 0 when 'A' then 2 when 'B' then 2 when 'C' then 3 else 1 end as abap.int1 ) as OvrlSDProcessStatusCriticality AS int1asOvrlSDProcessStatusCriticality,
  _DeliveryDocument.ShipToParty AS ShipToParty,
  _DeliveryDocument._Partner[1:PartnerFunction='WE']._DfltAddrRprstn.AddresseeFullName AS ShipToPartyName,
  _DeliveryDocument.Supplier AS Supplier,
  _DeliveryDocument._Supplier.SupplierName AS SupplierName,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  cast ( _DeliveryDocument._DeliveryDocumentType._Text[1: Language=$session.system_language].DeliveryDocumentTypeName as le_lfart_name) AS DeliveryTypeName,
  _DeliveryDocument.ShippingPoint AS ShippingPoint
FROM I_CollectiveProcessingDocument
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON SDDocument = _DeliveryDocument.DeliveryDocument  -- association [0..1]
;