I_FLDLOGSRETURNITEM

CDS View
18 Fields 14 CDS Views

Field Logistics Return Stock

I_FLDLOGSRETURNITEM is a CDS View in S/4HANA. Field Logistics Return Stock. It contains 18 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_FldLogsProdReturnHistory view from CONSUMPTION Return history of a Product
I_AllReturnStock view union_all COMPOSITE FL - BookStock and ReturnStock
I_FldLogsBatchSrlNmbrItmsEnhcd view union_all COMPOSITE Serial number of batch material
I_FldLogsCtnItmDispatchReady view from COMPOSITE Container Items Ready to Dispatch
I_FldLogsGoodsIssue view from COMPOSITE FL Return Docflow Goods Issue
I_FldLogsRefDocFlow view from COMPOSITE FL Return Docflow Reference Document
I_FldLogsRetEWMHandlingUnit view_entity from COMPOSITE FL EWM Handling Units
I_FldLogsRetEWMHandlingUnit view_entity union_all COMPOSITE FL EWM Handling Units
I_FldLogsRetTotalMaterialStock view_entity from COMPOSITE Total Return Quantity with WBS
I_FldLogsReturnDocFlow view union_all COMPOSITE FL Return Docflow Union
I_FldLogsReturnHandlingUnit view from COMPOSITE Field logistics Return handling units
I_FldLogsReturnHandlingUnit view union_all COMPOSITE Field logistics Return handling units
I_FldLogsTotRetBatchStkEnhcd view from COMPOSITE Total returnable batch serial stock
I_FldLogsTotReturnBatchStock view from COMPOSITE Total returnable batch stock

Fields (18)

KeyField CDS FieldsUsed in Views
KEY FldLogsContainerID FldLogsContainerID 1
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder 2
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber 3
KEY FldLogsRemotePlant FldLogsDispatchPlant,FldLogsRemotePlant 3
KEY Material Material 3
KEY ReferenceDocumentItem ReferenceDocumentItem 2
KEY RemoteStorageLocation RemoteStorageLocation 3
EWMWarehouse EWMWarehouse 1
FldLogsRecommendedAction FldLogsRecommendedAction 1
FldLogsReturnStatus FldLogsReturnStatus 1
FldLogsSupplyProcess FldLogsSupplyProcess 1
IsMarkedForDeletion IsMarkedForDeletion 1
LoadingQtyInOrderUnit LoadingQtyInOrderUnit 1
OutboundDelivery DeliveryDocument 2
RetblQtyBaseUnit RetblQtyBaseUnit 1
RetblQtyInBaseUnit RetblQtyInBaseUnit 1
RetblQtyOrderUnit RetblQtyOrderUnit 1
SupplyingStorageLocation SupplyingStorageLocation 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Field Logistics Return Stock
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FLDLOGSRETURNITEM (
    FLDLOGSCONTAINERID,
    FLDLOGSMAINTENANCEORDER,
    FLDLOGSREFERENCEDOCUMENTNUMBER,
    FLDLOGSREMOTEPLANT,
    MATERIAL,
    REFERENCEDOCUMENTITEM,
    REMOTESTORAGELOCATION,
    EWMWAREHOUSE,
    FLDLOGSRECOMMENDEDACTION,
    FLDLOGSRETURNSTATUS,
    FLDLOGSSUPPLYPROCESS,
    ISMARKEDFORDELETION,
    LOADINGQTYINORDERUNIT,
    OUTBOUNDDELIVERY,
    RETBLQTYBASEUNIT,
    RETBLQTYINBASEUNIT,
    RETBLQTYORDERUNIT,
    SUPPLYINGSTORAGELOCATION,
    PRIMARY KEY (FLDLOGSCONTAINERID, FLDLOGSMAINTENANCEORDER, FLDLOGSREFERENCEDOCUMENTNUMBER, FLDLOGSREMOTEPLANT, MATERIAL, REFERENCEDOCUMENTITEM, REMOTESTORAGELOCATION)
);

Learn More