I_KanbanOutput

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_KanbanOutput.
-- 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: IKANBANOUTPUT

CREATE VIEW I_KanbanOutput AS
SELECT
  KanbanContainer.KanbanContainer AS Kanban,
  Language.Language AS Language,
  KanbanContainer.KanbanControlCycle AS KanbanControlCycle,
  KanbanContainer.KanbanControlCycleItem AS KanbanControlCycleItem,
  KanbanControlCycle.Plant AS Plant,
  KanbanControlCycle.KanbanContainerQuantityInBsUnt AS KanbanQuantity,
  KanbanControlCycle.BaseUnit AS BaseUnit,
  KanbanControlCycle.ProductionSupplyArea AS ProductionSupplyArea,
  _ProductionSupplyAreaText.ProductionSupplyAreaName AS ProductionSupplyAreaName,
  KanbanControlCycle.Product AS Material,
  _ProductText.ProductName AS MaterialName,
  cast(concat(KanbanContainer.KanbanContainer, '1') as pk_barcode_waiting) AS SetKanbanStatusWaitingBarCode,
  cast(concat(KanbanContainer.KanbanContainer, '2') as pk_barcode_empty) AS SetKanbanStatusEmptyBarCode,
  cast(concat(KanbanContainer.KanbanContainer, '3') as pk_barcode_in_process) AS SetKanbanStatusProcessBarCode,
  cast(concat(KanbanContainer.KanbanContainer, '4') as pk_barcode_in_transit) AS SetKanbanStatusTransitBarCode,
  cast(concat(KanbanContainer.KanbanContainer, '5') as pk_barcode_full) AS SetKanbanStatusFullBarCode,
  cast(concat(KanbanContainer.KanbanContainer, '6') as pk_barcode_in_use) AS SetKanbanStatusInUseBarCode,
  KanbanContainer.Supplier AS Supplier,
  KanbanContainer._KanbanControlCycle AS _KanbanControlCycle
FROM I_KanbanContainer AS KanbanContainer
CROSS JOIN I_Language AS Language
INNER JOIN I_KanbanControlCycle AS KanbanControlCycle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductText AS _ProductText ON _ProductText.Language = Language.Language AND _ProductText.Product = KanbanControlCycle.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _ProductionSupplyAreaText ON _ProductionSupplyAreaText.Language = Language.Language AND _ProductionSupplyAreaText.Plant = KanbanContainer.Plant AND _ProductionSupplyAreaText.ProductionSupplyArea = KanbanControlCycle.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Supplier = _SupplierCompanyByPlant.Supplier AND Plant = _SupplierCompanyByPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_KanbanContainer AS _KanbanContainer ON _KanbanContainer.KanbanContainer = KanbanContainer.KanbanContainer  -- association [1..1]
LEFT OUTER JOIN I_KnbnCtrlCycProdMstrDta AS _KnbnCtrlCycProdMstrDta ON KanbanControlCycle = _KnbnCtrlCycProdMstrDta.KanbanControlCycle  -- association [1..1]
LEFT OUTER JOIN E_KanbanControlCycle AS _ControlCycleExtension ON KanbanControlCycle = _ControlCycleExtension.KanbanControlCycle  -- association [0..1]
LEFT OUTER JOIN E_KanbanContainer AS _ContainerExtension ON Kanban = _ContainerExtension.KanbanContainer  -- association [0..1]
;