I_FldLogsPrdcssrDocRemote

DDL: I_FLDLOGSPRDCSSRDOCREMOTE SQL: IFLPREDOC_R Type: view COMPOSITE
28 Fields 1 Data Sources

Field Logistics Predecessor documents

I_FldLogsPrdcssrDocRemote is a Composite CDS View that provides data about "Field Logistics Predecessor documents" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentItem) and exposes 28 fields with key fields PurchasingDocument, PurchasingDocumentItem, DeliveryDocumentendasOutboundDelivery.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentItem STO from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFLPREDOC_R view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Field Logistics Predecessor documents view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY DeliveryDocumentendasOutboundDelivery
PurchaseRequisitionItem I_PurchasingDocumentItem PurchaseRequisitionItem Requisn. item
DeliveryDocumentendasDeliveryDocument
MaterialDocument _IBD MaterialDocument Material Doc.
MaterialDocumentItem _IBD MaterialDocumentItem Material Document Item
MaterialDocumentYear _IBD MaterialDocumentYear Material Document Year
RefPurchaseRequisitionItem
EWMOutboundDeliveryOrder _EWM_OUTBDELIV EWMOutboundDeliveryOrder Document Number
FldLogsPickingWrhsTask _EWM_WarehouseTask WarehouseTask Warehouse Task
PurchaseOrder _IBD PurchaseOrder Purchasing Document
PurchaseOrderItem _IBD PurchaseOrderItem Purchasing Document Item
StockTransportOrder I_PurchasingDocumentItem PurchasingDocument Purchasing Document
SupplyingPlant
InboundDeliveryUUID _EWM_InbDeliveryItem InboundDeliveryUUID Document ID
InboundDeliveryItemUUID _EWM_InbDeliveryItem InboundDeliveryItemUUID Item ID
WarehouseTask _WarehouseTask WarehouseTask Warehouse Task
PurchasingDocumentSubtype _PurchasingDocument PurchasingDocumentSubtype Control
MaintenanceOrder _SupplierItem MaintenanceOrder Order
OrderCategory _SupplierItem OrderCategory Order Category
Project _SupplierItem Project WBS Element
ProjectDemand _SupplierItem ProjectDemand Demand ID
ProjectDescription
ProjectDemandName
EWMInboundDelivery
EWMInboundDeliveryItem _EWM_InbDel EWMInboundDeliveryItem Item Number
_Order _Order

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_FldLogsPrdcssrDocRemote.
-- 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: IFLPREDOC_R

CREATE VIEW I_FldLogsPrdcssrDocRemote AS
SELECT
  STO.PurchasingDocument AS PurchasingDocument,
  STO.PurchasingDocumentItem AS PurchasingDocumentItem,
  case when _SupplierItem.DeliveryDocument is not null then _SupplierItem.DeliveryDocument else _DeliveryDocumentItem.DeliveryDocument end as OutboundDelivery AS DeliveryDocumentendasOutboundDelivery,
  STO.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  case when _SupplierItem.DeliveryDocument is not null then _SupplierItem.DeliveryDocument else _IBD.DeliveryDocument end as DeliveryDocument AS DeliveryDocumentendasDeliveryDocument,
  _IBD.MaterialDocument AS MaterialDocument,
  _IBD.MaterialDocumentItem AS MaterialDocumentItem,
  _IBD.MaterialDocumentYear AS MaterialDocumentYear,
  _IBD._PurchaseOrderItem.PurchaseRequisitionItem AS RefPurchaseRequisitionItem,
  _EWM_OUTBDELIV.EWMOutboundDeliveryOrder AS EWMOutboundDeliveryOrder,
  _EWM_WarehouseTask.WarehouseTask AS FldLogsPickingWrhsTask,
  _IBD.PurchaseOrder AS PurchaseOrder,
  _IBD.PurchaseOrderItem AS PurchaseOrderItem,
  STO.PurchasingDocument AS StockTransportOrder,
  STO._PurchasingDocument.SupplyingPlant AS SupplyingPlant,
  _EWM_InbDeliveryItem.InboundDeliveryUUID AS InboundDeliveryUUID,
  _EWM_InbDeliveryItem.InboundDeliveryItemUUID AS InboundDeliveryItemUUID,
  _WarehouseTask.WarehouseTask AS WarehouseTask,
  _PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _SupplierItem.MaintenanceOrder AS MaintenanceOrder,
  _SupplierItem.OrderCategory AS OrderCategory,
  _SupplierItem.Project AS Project,
  _SupplierItem.ProjectDemand AS ProjectDemand,
  _SupplierItem._PPMTask.TaskName AS ProjectDescription,
  _SupplierItem._ProjectDemand.ProjectDemandName AS ProjectDemandName,
  ltrim(_EWM_InbDel.EWMInboundDelivery, '0') AS EWMInboundDelivery,
  _EWM_InbDel.EWMInboundDeliveryItem AS EWMInboundDeliveryItem
FROM I_PurchasingDocumentItem AS STO
;

Learn More