I_CollectiveProcessing

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 I_CollectiveProcessing.
-- 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: ISDCOLPROC

CREATE VIEW I_CollectiveProcessing AS
SELECT
  sammg AS CollectiveProcessing,
  smart AS CollectiveProcessingType,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  uzeit AS CreationTime,
  vbnum AS NumberOfCreatedDocuments,
  ernum AS NumberOfErrors,
  brgew AS HeaderGrossWeight,
  gewei AS HeaderWeightUnit,
  volum AS HeaderVolume,
  voleh AS HeaderVolumeUnit,
  vstel AS ShippingPoint,
  vtext AS ShippingPointName,
  maxzt AS MaximumLaborCapacity,
  programm AS ABAPProgramName,
  selset AS ABAPProgramVariantName,
  batch AS HasBeenProcessedInBackground,
  anzlp AS NumberOfCreatedDocumentItems,
  anzgp AS NumberOfProcessedDocumentItems,
  anzgi AS NumberOfProcessedDueIndexes,
  kwpro AS PickingWaveProfile,
  kaptp AS ShiftDefinition,
  lgnum AS Warehouse,
  collectiverun_uuid AS CollectiveProcessingRunUUID
FROM vbsk
LEFT OUTER JOIN I_CollectiveProcessingDocument AS _CollectiveProcessingDocument ON CollectiveProcessing = _CollectiveProcessingDocument.CollectiveProcessing  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderWeightUnit ON HeaderWeightUnit = _HeaderWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderVolumeUnit ON HeaderVolumeUnit = _HeaderVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
;