I_BatchVH

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_BatchVH.
-- 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: IBATCHVH

CREATE VIEW I_BatchVH AS
SELECT
  Material,
  Batch,
  BatchIsMarkedForDeletion,
  MatlBatchIsInRstrcdUseStock,
  Supplier,
  BatchBySupplier,
  CountryOfOrigin,
  RegionOfOrigin,
  MatlBatchAvailabilityDate,
  ShelfLifeExpirationDate,
  ManufactureDate,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedDate3,
  FreeDefinedDate4,
  FreeDefinedDate5,
  FreeDefinedDate6,
  DefinitionOfBatchLevel,
  CreationDateTime,
  LastChangeDateTime,
  ClfnObjectInternalID,
  BatchExtWhseMgmtInternalId,
  I_BatchPlant._Plant AS _Plant,
  I_BatchPlant._Material AS _Material,
  I_BatchCrossPlant._Supplier AS _Supplier,
  I_BatchCrossPlant._CountryOfOrigin AS _CountryOfOrigin,
  I_BatchCrossPlant._RegionOfOrigin AS _RegionOfOrigin
FROM I_BatchCrossPlant
INNER JOIN I_BatchConfiguration ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BatchCrossPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClfnObjectClassForKeyDate ON ClfnObjectInternalID = _ClfnObjectClassForKeyDate.ClfnObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _ClfnObjectCharcValForKeyDate ON ClfnObjectInternalID = _ClfnObjectCharcValForKeyDate.ClfnObjectInternalID  -- association [0..*]
-- UNION ALL with additional select branch(es): I_BatchPlant
;