I_FldLogsDocFlwGIForWrkOrd

DDL: I_FLDLOGSDOCFLWGIFORWRKORD SQL: IFLDFGIWO Type: view COMPOSITE
12 Fields 1 Data Sources

Field Logistics Doc Flow GI WorkOrder

I_FldLogsDocFlwGIForWrkOrd is a Composite CDS View that provides data about "Field Logistics Doc Flow GI WorkOrder" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 12 fields with key fields MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord MatDoc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLDFGIWO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
EndUserText.label Field Logistics Doc Flow GI WorkOrder view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
MaintenanceOrder WO MaintenanceOrder Order
MaintenanceOrderComponent WO MaintenanceOrderComponent BOM item
MaintenanceOrderOperation WO MaintenanceOrderOperation Suboperation
MaintenanceProcessingPhase WO MaintenanceProcessingPhase Phase
PurchaseRequisition WO ReferenceDocument Reference Document
PurchaseRequisitionItem WO RefPurchaseRequisitionItem
PurchasingDocumentItemCategory WO PurchasingDocumentItemCategory Item Category
PurchaseRequisitionType WO PurchaseRequisitionType Order Type
GoodsMovementType GoodsMovementType Movement Type

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_FldLogsDocFlwGIForWrkOrd.
-- 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: IFLDFGIWO

CREATE VIEW I_FldLogsDocFlwGIForWrkOrd AS
SELECT
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  WO.MaintenanceOrder AS MaintenanceOrder,
  WO.MaintenanceOrderComponent AS MaintenanceOrderComponent,
  WO.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  WO.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  WO.ReferenceDocument AS PurchaseRequisition,
  WO.RefPurchaseRequisitionItem AS PurchaseRequisitionItem,
  WO.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  WO.PurchaseRequisitionType AS PurchaseRequisitionType,
  GoodsMovementType
FROM I_MaterialDocumentRecord AS MatDoc
;

Learn More