I_FldLogsKitMatlDocumentItem

DDL: I_FLDLOGSKITMATLDOCUMENTITEM Type: view_entity COMPOSITE
19 Fields 1 Data Sources 1 Associations

Kit Material Document Item

I_FldLogsKitMatlDocumentItem is a Composite CDS View that provides data about "Kit Material Document Item" in SAP S/4HANA. It reads from 1 data source (I_FieldLogisticsKitItem) and exposes 19 fields with key fields FieldLogisticsKitItemUUID, FieldLogisticsKitHeaderUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FieldLogisticsKitItem kititem from

Associations (1)

CardinalityTargetAliasCondition
[1] I_FldLogsMatlDocumentRecord _MaterialDocument kititem.FldLogsKitItmRefDocument1 = _MaterialDocument.MaterialDocument and kititem.FldLogsKitItmRefDocument2 = _MaterialDocument.MaterialDocumentItem and kititem.FldLogsKitItmRefDocument3 = _MaterialDocument.MaterialDocumentYear

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Kit Material Document Item view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FieldLogisticsKitItemUUID FieldLogisticsKitItemUUID Kit Item ID
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID kit header id
QuantityInBaseUnit _MaterialDocument GoodsReceiptQtyInOrderUnit
MaterialBaseUnit _MaterialDocument MaterialBaseUnit Valuation Unit
PurchaseOrder _MaterialDocument PurchaseOrder Purchasing Document
PurchaseOrderItem _MaterialDocument PurchaseOrderItem Purchasing Document Item
GoodsMovementType _MaterialDocument GoodsMovementType Movement Type
MaterialDocument _MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem _MaterialDocument MaterialDocumentItem Material Document Item
MaterialDocumentYear _MaterialDocument MaterialDocumentYear Material Document Year
ReversedMaterialDocument _MaterialDocument ReversedMaterialDocument Reversed Mat Doc
ReversedMaterialDocumentItem _MaterialDocument ReversedMaterialDocumentItem Reversed Doc Item
ReversedMaterialDocumentYear _MaterialDocument ReversedMaterialDocumentYear Reversed Doc Year
Material _MaterialDocument Material Vehicle Model
LastChangeDateTime LastChangeDateTime Timestamp
ParentObjectUUID ParentObjectUUID UUID Parent GO
FldLogsKitIsTwoStpGRCmpltd FldLogsKitIsTwoStpGRCmpltd TRUE
OrderQuantityUnit _MaterialDocument OrderQuantityUnit Sales Unit
FldLogsKitDispatchOnHold FldLogsKitDispatchOnHold Dispatch On hold

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_FldLogsKitMatlDocumentItem.
-- 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_FldLogsKitMatlDocumentItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  _MaterialDocument.GoodsReceiptQtyInOrderUnit AS QuantityInBaseUnit,
  _MaterialDocument.MaterialBaseUnit AS MaterialBaseUnit,
  _MaterialDocument.PurchaseOrder AS PurchaseOrder,
  _MaterialDocument.PurchaseOrderItem AS PurchaseOrderItem,
  _MaterialDocument.GoodsMovementType AS GoodsMovementType,
  _MaterialDocument.MaterialDocument AS MaterialDocument,
  _MaterialDocument.MaterialDocumentItem AS MaterialDocumentItem,
  _MaterialDocument.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocument.ReversedMaterialDocument AS ReversedMaterialDocument,
  _MaterialDocument.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem,
  _MaterialDocument.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  _MaterialDocument.Material AS Material,
  LastChangeDateTime,
  ParentObjectUUID,
  FldLogsKitIsTwoStpGRCmpltd,
  _MaterialDocument.OrderQuantityUnit AS OrderQuantityUnit,
  FldLogsKitDispatchOnHold
FROM I_FieldLogisticsKitItem AS kititem
LEFT OUTER JOIN I_FldLogsMatlDocumentRecord AS _MaterialDocument ON kititem.FldLogsKitItmRefDocument1 = _MaterialDocument.MaterialDocument AND kititem.FldLogsKitItmRefDocument2 = _MaterialDocument.MaterialDocumentItem AND kititem.FldLogsKitItmRefDocument3 = _MaterialDocument.MaterialDocumentYear  -- association [1]
;

Learn More