I_FldLogsManageKitItemDetail

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_FldLogsManageKitItemDetail.
-- 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.

CREATE VIEW I_FldLogsManageKitItemDetail AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  FldLogsKitItmRefDocument3,
  FldLogsKitItmRefDocument4,
  FldLogsReferenceDocCategory,
  FldLogsKitItmRefDocument1UUID,
  FldLogsKitItmRefDocument2UUID,
  ParentObjectUUID,
  LastChangeDateTime,
  FldLogsSrceStorLocID,
  FldLogsManageKitItemStorLoc,
  cast(concat(concat(concat(concat(ltrim(FldLogsKitItmRefDocument1, '0'), '/'), FldLogsKitItmRefDocument2), '/'), FldLogsKitItmRefDocument3 ) as abap.char( 40 ) ) as FldLogsReferenceDocumentNumber AS char40asFldLogsReferenceDocumentNumber,
  FldLogsManageKitItemStatus,
  FldLogsShptLocationID,
  FldLogsManageKitItemQty,
  OrderQuantityUnit,
  _MaintenanceOrderComponent.FldLogsDelivIsHeldOnShore AS FldLogsDelivIsHeldOnShore,
  _MaintenanceOrderComponent.MatlCompRequirementDate AS RequirementDate,
  case when coalesce(_KitPurchaseOrderItem.PurchaseOrder,'') = '' then _MaintenanceOrderComponent.RequirementQuantityInBaseUnit else _KitPurchaseOrderItem.OrderQuantity end as Quantity AS OrderQuantityendasQuantity,
  _MaintenanceOrderComponent.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  _MaintenanceOrderComponent.BaseUnit AS BaseUnit,
  _MaintenanceOrderComponent.ProjectNetwork AS MaintenanceOrder,
  case when coalesce(_KitPurchaseOrderItem.PurchaseOrder,'') = '' then coalesce(_MaintenanceOrderComponent.Material, '') else cast(coalesce(_KitPurchaseOrderItem.Material, '') as matn1 ) end as Material AS Materialasmatn1endasMaterial,
  case when coalesce(_KitPurchaseOrderItem.PurchaseOrder,'') = '' then _MaintenanceOrderComponent.BOMItemDescription else _KitPurchaseOrderItem.ItemDescription end as ComponentDescription AS ItemDescriptionendasComponentDescription,
  _MaintenanceOrderComponent.Reservation AS Reservation,
  _MaintenanceOrderComponent.ReservationItem AS ReservationItem,
  _MaintenanceOrderComponent.Plant AS Plant,
  _MaintenanceOrderComponent.BOMItemCategory AS BOMItemCategory,
  _MaintenanceOrderComponent.MaterialCompIsSpecialStock AS InventorySpecialStockType,
  _MaintenanceOrderComponent.OpenQuantity AS OpenQuantity,
  _MaintenanceOrderComponent.ReceivedQuantity AS ReceivedQuantity,
  _MaintenanceOrderComponent.GoodsRecipientName AS GoodsRecipientName,
  _MaintenanceOrderComponent.UnloadingPointName AS UnloadingPointName,
  _KitPurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  _KitPurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  _KitPurchaseOrderItem.OrderQuantity AS OrderQuantity,
  _KitPurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _BaseKitItem.FieldLogisticsKitItemUUID AS FldLogsMngKitItmRefDoc1UUID,
  _BaseKitItem.FieldLogisticsKitHeaderUUID AS FldLogsMngKitItmRefDoc2UUID,
  InventoryValuationType,
  _MaintenanceOrderComponent.WBSElementInternalID AS WBSElementInternalID
FROM I_FldLogsManageKitItem
LEFT OUTER JOIN I_FldLogsPrjMatlCompBasicData AS _MaintenanceOrderComponent ON FldLogsKitItmRefDocument1 = _MaintenanceOrderComponent.ProjectNetwork AND FldLogsKitItmRefDocument2 = _MaintenanceOrderComponent.NetworkActivity AND FldLogsKitItmRefDocument3 = _MaintenanceOrderComponent.BillOfMaterialItemNumber  -- association [1]
LEFT OUTER JOIN I_FldLogsReservationItemDetail AS _ReservationItem ON reservation = _ReservationItem.Reservation AND reservationitem = _ReservationItem.ReservationItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemBasic AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_FldLogsMaterialPlantDetails AS _ProductPlant ON Material = _ProductPlant.Material AND plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_FieldLogisticsStorageBin AS _StorageBin ON Material = _StorageBin.Material AND plant = _StorageBin.Plant AND FldLogsManageKitItemStorLoc = _StorageBin.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_FldLogsValuationType AS _ValuationType ON Material = _ValuationType.Material AND plant = _ValuationType.Plant  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1]
LEFT OUTER JOIN I_FldLogsMngKitPurOrdItm AS _KitPurchaseOrderItem ON FieldLogisticsKitItemUUID = _KitPurchaseOrderItem.ParentObjectUUID  -- association [0..*]
LEFT OUTER JOIN I_FieldLogisticsKitItem AS _BaseKitItem ON FldLogsKitItmRefDocument1 = _BaseKitItem.FldLogsKitItmRefDocument1 AND FldLogsKitItmRefDocument2 = _BaseKitItem.FldLogsKitItmRefDocument2 AND FldLogsKitItmRefDocument3 = _BaseKitItem.FldLogsKitItmRefDocument3 AND _BaseKitItem.FldLogsReferenceDocCategory = 'PM'  -- association [0..*]
LEFT OUTER JOIN I_FldLogsPlantBasic AS _RemotePlant ON plant = _RemotePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsManageKitItemStsTxt AS _KitItemStatusText ON FldLogsManageKitItemStatus = _KitItemStatusText.FldLogsManageKitItemStatus AND _KitItemStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BomItemCategoryText AS _ItemCategoryText ON bomitemcategory = _ItemCategoryText.BillOfMaterialItemCategory AND _ItemCategoryText.Language = $session.system_language  -- association [0..1]
;