R_FldLogsKitMaintOrderItem

DDL: R_FLDLOGSKITMAINTORDERITEM Type: view_entity COMPOSITE Package: FLOG_SHIPMENT_PACKCTN
24 Fields 1 Data Sources 1 Associations

Kit Maintenance Order Item W/O PO

R_FldLogsKitMaintOrderItem is a Composite CDS View that provides data about "Kit Maintenance Order Item W/O PO" in SAP S/4HANA. It reads from 1 data source (I_FldLogsKitMaintOrderItem) and exposes 24 fields with key fields FieldLogisticsKitItemUUID, FieldLogisticsKitHeaderUUID. It has 1 association to related views. Part of development package FLOG_SHIPMENT_PACKCTN.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsKitMaintOrderItem I_FldLogsKitMaintOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsPlantBasic _RemotePlant $projection.FldLogsSrcePlnt = _RemotePlant.Plant

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Kit Maintenance Order Item W/O PO view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (24)

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
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
MaintenanceOrder MaintenanceOrder Order
LastChangeDateTime LastChangeDateTime Timestamp
SupplyingPlantendasFldLogsSrcePlnt
IsEndOfPurposeBlocked _PurchaseRequisition IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_MaintenanceOrderComponent _MaintenanceOrderComponent
_PurchaseRequisitionItem _PurchaseRequisitionItem
_RemotePlant _RemotePlant

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 R_FldLogsKitMaintOrderItem.
-- 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 R_FldLogsKitMaintOrderItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  FldLogsKitItmRefDocument2,
  FldLogsKitItmRefDocument3,
  FldLogsReferenceDocumentNumber,
  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,
  MaintenanceOrder,
  LastChangeDateTime,
  case when _PurchaseRequisitionItem.SupplyingPlant is initial then _PurchaseRequisitionItem.Plant else _PurchaseRequisitionItem.SupplyingPlant end as FldLogsSrcePlnt AS SupplyingPlantendasFldLogsSrcePlnt,
  _PurchaseRequisition.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM I_FldLogsKitMaintOrderItem
LEFT OUTER JOIN I_FldLogsPlantBasic AS _RemotePlant ON FldLogsSrcePlnt = _RemotePlant.Plant  -- association [0..1]
;

Learn More