C_BatchTP

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_BatchTP.
-- 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: CBATCHTP

CREATE VIEW C_BatchTP AS
SELECT
  Batch,
  Material,
  Plant,
  BatchForEdit,
  MaterialForEdit,
  PlantForEdit,
  MatlBatchIsInRstrcdUseStock,
  BatchRestrictionStatus,
  BatchRestrictionStsCriticality,
  cast(BatchIsMarkedForDeletion as s4bop_batch_marked_for_delet preserving type) AS BatchIsMarkedForDeletion
FROM I_BatchTP
LEFT OUTER JOIN C_BatchTP AS _SubordinateBatch ON Batch = _SubordinateBatch.Batch AND Material = _SubordinateBatch.Material AND Plant = '' AND _SubordinateBatch.IsSubordinateBatch = 'X'  -- association [0..*]
LEFT OUTER JOIN C_BatchObjPgInspectionLot AS _BatchObjPgInspectionLot ON Batch = _BatchObjPgInspectionLot.Batch AND Material = _BatchObjPgInspectionLot.Material AND Plant = _BatchObjPgInspectionLot.Plant  -- association [0..*]
LEFT OUTER JOIN C_BatchObjPgInspectionLot AS _BatchObjPgInspLotCrossPlant ON Batch = _BatchObjPgInspLotCrossPlant.Batch AND Material = _BatchObjPgInspLotCrossPlant.Material  -- association [0..*]
LEFT OUTER JOIN C_BatchObjPageBatchHistory AS _BatchObjPageBatchHistory ON Batch = _BatchObjPageBatchHistory.Batch AND Material = _BatchObjPageBatchHistory.Material AND Plant = _BatchObjPageBatchHistory.Plant  -- association [0..*]
LEFT OUTER JOIN C_BatchObjPageBatchHistory AS _BatchObjPgBatHistCrossPlant ON Batch = _BatchObjPgBatHistCrossPlant.Batch AND Material = _BatchObjPgBatHistCrossPlant.Material  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_BatchManagedMaterialVH AS _BatchManagedMaterialVH ON MaterialForEdit = _BatchManagedMaterialVH.Material  -- association [0..1]
LEFT OUTER JOIN I_BatchPlant AS _BatchPlant ON Material = _BatchPlant.Material AND Batch = _BatchPlant.Batch AND Plant = ''  -- association [0..*]
LEFT OUTER JOIN C_ChFiExBatchClfn AS _ChFiExBatchClfn ON Plant = _ChFiExBatchClfn.Plant AND Material = _ChFiExBatchClfn.Material AND Batch = _ChFiExBatchClfn.Batch  -- association [0..1]
;