I_FldLogsMaintenanceOrder

DDL: I_FLDLOGSMAINTENANCEORDER SQL: IFLMAINTORDER Type: view COMPOSITE Package: ODATA_FLOG_SP_WODOCFLOW
32 Fields 6 Associations

Get Field Logistics Maintenance Orders

I_FldLogsMaintenanceOrder is a Composite CDS View that provides data about "Get Field Logistics Maintenance Orders" in SAP S/4HANA. It has 6 associations to related views. Part of development package ODATA_FLOG_SP_WODOCFLOW.

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant _Plant.Plant = $projection.MaintenancePlanningPlant
[0..1] I_MaterialText _MaterialText _MaterialText.Material = $projection.Material and _MaterialText.Language = $session.system_language
[0..1] I_FldLogsSupplyProcessText _FldLogsSupplyProcessText _FldLogsSupplyProcessText.FldLogsSupplyProcess = $projection.FldLogsSupplyProcess and _FldLogsSupplyProcessText.Language = $session.system_language
[0..1] I_PMUnitOfMeasureVH _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.BaseUnit
[0..1] I_FldLogsDocFlwPurDocs PurDoc PurDoc.PurchaseRequisition = WorkOrder.PurchaseRequisition and PurDoc.PurchaseRequisitionItem = WorkOrder.RefPurchaseRequisitionItem
[0..1] I_Plant _SupplyingPlant _SupplyingPlant.Plant = $projection.FldLogsSupplyingPlant and _SupplyingPlant.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLMAINTORDER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Get Field Logistics Maintenance Orders view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder WorkOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation WorkOrder MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderComponent WorkOrder MaintenanceOrderComponent BOM item
MaintenanceOrderDesc WorkOrder MaintenanceOrderDesc Description
OperationDescription WorkOrder OperationDescription Op. Short Text
ComponentDescription WorkOrder ComponentDescription Item Text
Material WorkOrder Material Vehicle Model
MaintenancePlanningPlant WorkOrder MaintenancePlanningPlant Planning Plant
PlantName _Plant PlantName Plant Name
WorkCenterInternalID WorkOrder WorkCenterInternalID Work Center
MaintenancePlannerGroup WorkOrder MaintenancePlannerGroup Planner Group
MaintenanceOrderType WorkOrder MaintenanceOrderType Order Type
CompanyCode WorkOrder CompanyCode Receiver Company Code
MaintenanceProcessingPhase WorkOrder MaintenanceProcessingPhase Phase
Reservation WorkOrder Reservation Reservation
ReservationItem WorkOrder ReservationItem Reservation Item
RequirementQuantityInBaseUnit WorkOrder RequirementQuantityInBaseUnit
BaseUnit WorkOrder BaseUnit Unit of Measure
ReferenceDocumentendasReferenceDocument
PurchasingDocumentItemCategory PurDoc PurchasingDocumentItemCategory Item Category
PurchaseRequisitionType PurDoc PurchaseRequisitionType Order Type
IsEndOfPurposeBlocked PurDoc IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
DocIsPurchaseReqn WorkOrder DocIsPurchaseReqn
DocIsStockTransportReqn WorkOrder DocIsStockTransportReqn
PurchaseRequisition WorkOrder PurchaseRequisition Requisition
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore Hold On-Shore
FldLogsSupplyProcess FldLogsSupplyProcess Supply Process
FldLogsSupplyingPlant FldLogsSupplyingPlant
_UnitOfMeasure _UnitOfMeasure
FldLogsSupplyProcessText _FldLogsSupplyProcessText FldLogsSupplyProcessText
MaterialName _MaterialText MaterialName Material Description
SupplyingPlantName _SupplyingPlant PlantName Plant Name

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_FldLogsMaintenanceOrder.
-- 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: IFLMAINTORDER

CREATE VIEW I_FldLogsMaintenanceOrder AS
SELECT
  WorkOrder.MaintenanceOrder AS MaintenanceOrder,
  WorkOrder.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  WorkOrder.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  WorkOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  WorkOrder.OperationDescription AS OperationDescription,
  WorkOrder.ComponentDescription AS ComponentDescription,
  WorkOrder.Material AS Material,
  WorkOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _Plant.PlantName AS PlantName,
  WorkOrder.WorkCenterInternalID AS WorkCenterInternalID,
  WorkOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  WorkOrder.MaintenanceOrderType AS MaintenanceOrderType,
  WorkOrder.CompanyCode AS CompanyCode,
  WorkOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  WorkOrder.Reservation AS Reservation,
  WorkOrder.ReservationItem AS ReservationItem,
  WorkOrder.RequirementQuantityInBaseUnit AS RequirementQuantityInBaseUnit,
  WorkOrder.BaseUnit AS BaseUnit,
  case when PurDoc.ReferenceDocument is not initial then PurDoc.ReferenceDocument else WorkOrder.ReferenceDocument end as ReferenceDocument AS ReferenceDocumentendasReferenceDocument,
  PurDoc.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurDoc.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurDoc.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  WorkOrder.DocIsPurchaseReqn AS DocIsPurchaseReqn,
  WorkOrder.DocIsStockTransportReqn AS DocIsStockTransportReqn,
  WorkOrder.PurchaseRequisition AS PurchaseRequisition,
  FldLogsDelivIsHeldOnShore,
  FldLogsSupplyProcess,
  FldLogsSupplyingPlant,
  _FldLogsSupplyProcessText.FldLogsSupplyProcessText AS FldLogsSupplyProcessText,
  _MaterialText.MaterialName AS MaterialName,
  _SupplyingPlant.PlantName AS SupplyingPlantName
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplyProcessText AS _FldLogsSupplyProcessText ON _FldLogsSupplyProcessText.FldLogsSupplyProcess = FldLogsSupplyProcess AND _FldLogsSupplyProcessText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PMUnitOfMeasureVH AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = BaseUnit  -- association [0..1]
LEFT OUTER JOIN I_FldLogsDocFlwPurDocs AS PurDoc ON PurDoc.PurchaseRequisition = WorkOrder.PurchaseRequisition AND PurDoc.PurchaseRequisitionItem = WorkOrder.RefPurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON _SupplyingPlant.Plant = FldLogsSupplyingPlant AND _SupplyingPlant.Language = $session.system_language  -- association [0..1]
;

Learn More