I_FldLogsMngKitDroppedItm

DDL: I_FLDLOGSMNGKITDROPPEDITM Type: view_entity COMPOSITE
49 Fields 1 Data Sources 1 Associations

Manage Kit Dropped Items

I_FldLogsMngKitDroppedItm is a Composite CDS View that provides data about "Manage Kit Dropped Items" in SAP S/4HANA. It reads from 1 data source (I_FldLogsManageKitItemDetail) and exposes 49 fields with key fields FieldLogisticsKitItemUUID, FieldLogisticsKitHeaderUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsManageKitItemDetail I_FldLogsManageKitItemDetail from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsRstrcdItmIntegration _RstrcdItmIntegration $projection.FldLogsDrvdRefDocNumber = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr and _RstrcdItmIntegration.FldLogsRstrcdItmRefDocType = 'RKIT'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manage Kit Dropped Items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY FieldLogisticsKitItemUUID FieldLogisticsKitItemUUID Kit Item ID
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID kit header id
FldLogsKitItmRefDocument1 FldLogsKitItmRefDocument1 Reference Doc Number
FldLogsKitItmRefDocument2 FldLogsKitItmRefDocument2 Reference Doc Number
FldLogsKitItmRefDocument3 FldLogsKitItmRefDocument3 Reference Doc Number
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
FldLogsDrvdRefDocNumber FldLogsDrvdRefDocNumber
FldLogsSrceStorLocID FldLogsSrceStorLocID Location
FldLogsManageKitItemStorLoc FldLogsManageKitItemStorLoc Location
FldLogsManageKitItemStatus FldLogsManageKitItemStatus Kit Item Status
FldLogsShptLocationID FldLogsShptLocationID Location Id.
FldLogsManageKitItemQty FldLogsManageKitItemQty Item Qty
OrderQuantityUnit OrderQuantityUnit Sales Unit
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
FldLogsKitPlannedDeliveryDate _PurchaseRequisitionItem DeliveryDate Delivery Date
MaterialNameendasItemDescription
Material Material Vehicle Model
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore Hold On-Shore
RequirementDate RequirementDate Requirement Date
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
OpenQuantity OpenQuantity PBE Entry Open Qty
ReceivedQuantity ReceivedQuantity Quantity Received
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
RecipientLocationCode _ReservationItem RecipientLocationCode Recipient Loc.
MaintenanceOrder MaintenanceOrder Order
LastChangeDateTime LastChangeDateTime Timestamp
BOMItemCategory BOMItemCategory Item Category
GoodsMovementType GoodsMovementType Movement Type
InventorySpecialStockType InventorySpecialStockType Special Stock Type
Plant Plant Valuation Area
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
MaterialBaseUnit MaterialBaseUnit Valuation Unit
InventoryValuationType InventoryValuationType Valuation Type
DangerousGoodsIndProfile _Product DangerousGoodsIndProfile DGIndProfile
ValuationCategory _ValuationType ValuationCategory Valuation Cat.
SerialNumberProfile _ProductPlant SerialNumberProfile SerialNoProfile
IsBatchManagementRequired _Product IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
SupplyingPlantendasFldLogsSrcePlnt
IsEndOfPurposeBlocked _PurchaseRequisitionItem IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
FldLogsItemIsRestricted
_MaintenanceOrderComponent _MaintenanceOrderComponent
_PurchaseRequisitionItem _PurchaseRequisitionItem
_KitItemStatusText _KitItemStatusText
_ItemCategoryText _ItemCategoryText

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_FldLogsMngKitDroppedItm.
-- 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_FldLogsMngKitDroppedItm AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  FldLogsKitItmRefDocument3,
  FldLogsReferenceDocumentNumber,
  FldLogsDrvdRefDocNumber,
  FldLogsSrceStorLocID,
  FldLogsManageKitItemStorLoc,
  FldLogsManageKitItemStatus,
  FldLogsShptLocationID,
  FldLogsManageKitItemQty,
  OrderQuantityUnit,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  _PurchaseRequisitionItem.DeliveryDate AS FldLogsKitPlannedDeliveryDate,
  case when Material is initial then ComponentDescription else _MaterialText.MaterialName end as ItemDescription AS MaterialNameendasItemDescription,
  Material,
  Reservation,
  ReservationItem,
  FldLogsDelivIsHeldOnShore,
  RequirementDate,
  Quantity,
  BaseUnit,
  OpenQuantity,
  ReceivedQuantity,
  GoodsRecipientName,
  UnloadingPointName,
  _ReservationItem.RecipientLocationCode AS RecipientLocationCode,
  MaintenanceOrder,
  LastChangeDateTime,
  BOMItemCategory,
  GoodsMovementType,
  InventorySpecialStockType,
  Plant,
  FldLogsSupplyProcess,
  MaterialBaseUnit,
  InventoryValuationType,
  _Product.DangerousGoodsIndProfile AS DangerousGoodsIndProfile,
  _ValuationType.ValuationCategory AS ValuationCategory,
  _ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  _Product.IsBatchManagementRequired AS IsBatchManagementRequired,
  case when FldLogsSupplyProcess = 'SP15' or FldLogsSupplyProcess = 'SERV' then _RemotePlant.SupplyingPlant when _PurchaseRequisitionItem.SupplyingPlant is initial then _PurchaseRequisitionItem.Plant else _PurchaseRequisitionItem.SupplyingPlant end as FldLogsSrcePlnt AS SupplyingPlantendasFldLogsSrcePlnt,
  _PurchaseRequisitionItem.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  coalesce(_RstrcdItmIntegration.FldLogsItemIsRestricted, '') AS FldLogsItemIsRestricted
FROM I_FldLogsManageKitItemDetail
LEFT OUTER JOIN I_FldLogsRstrcdItmIntegration AS _RstrcdItmIntegration ON FldLogsDrvdRefDocNumber = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr AND _RstrcdItmIntegration.FldLogsRstrcdItmRefDocType = 'RKIT'  -- association [0..1]
;

Learn More