I_BatchHistory

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_BatchHistory.
-- 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: IBATCHISTORY

CREATE VIEW I_BatchHistory AS
SELECT
  cast(xzuga as s4lobm_xzuga preserving type) AS IsGoodsIssueDocument,
  werks AS Plant,
  matnr AS Material,
  charg AS Batch,
  cast(aufnr as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(aufps as manufacturingorderitem preserving type) AS ManufacturingOrderItem,
  ebeln AS PurchaseOrder,
  cast(ebelp as s4lobm_ebelp preserving type) AS PurchaseOrderItem,
  kdauf AS SalesOrder,
  cast(kdpos as s4lobm_kdpos preserving type) AS SalesOrderItem,
  mjahr AS MaterialDocumentYear,
  mblnr AS MaterialDocument,
  zeile AS MaterialDocumentItem,
  xstbw AS IsReversalMovementType,
  budat AS PostingDate,
  menge AS QuantityInBaseUnit,
  meins AS MaterialBaseUnit,
  ummat AS IssgOrRcvgMaterial,
  lifnr AS Supplier,
  licha AS BatchBySupplier,
  kunnr AS Customer,
  vbeln AS DeliveryDocument,
  cast(posnr as s4lobm_posnr preserving type) AS DeliveryDocumentItem,
  kzbew AS GoodsMovementRefDocType,
  _Plant._ValuationArea.CompanyCode AS CompanyCode
FROM chvw
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [1..1]
LEFT OUTER JOIN I_Material AS _IssgOrRcvgMaterial ON IssgOrRcvgMaterial = _IssgOrRcvgMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND companycode = _SupplierCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON Customer = _CustomerCompany.Customer AND companycode = _CustomerCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [0..1]
;