FLOG_RETURN

Transparent Table Application Table
52 Fields 6 CDS Views

Field logistic: Return Table

FLOG_RETURN is an SAP database table in S/4HANA. Field logistic: Return Table. It contains 52 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_FieldLogisticsReturns view_entity from EXTENSION Field logistics Returns - Extension
I_FldLogsFlogReturnBasic view from BASIC Field Logistics Return Table
I_TotCalcReturnStock view from BASIC Aggregated Ret Stock on Mat and Plant
I_TotReturnDispatchReady view from BASIC FL: Ready to Dispatch line count
I_TotReturnRequested view from BASIC Field Logistics:Return lines Count
I_TotReturnScheduled view from BASIC Field Logistics: Return Scheduled Count

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY plant werks_d Plant
KEY ref_doc flog_doc Reference Doc Number
KEY ref_docitem flog_docitem Document Item
KEY work_order aufnr Order
KEY remote_lgort lgort_d Location
ref_doctyp flog_doctyp Document Type
ret_status flog_return_status Return Status
ret_quantity flog_retqty Quantity in Base Uni
unit meins Base Unit
retqtyinorderunit flog_retoqty Order Qty.
retqtyorderunit flog_ounit Order Unit
load_quantity flog_loadqty Load Quantity
dispatchdat flog_dispdat Dispatch Date
supply_lgort flog_supply_lgort Supply SLoc
shipdate flog_shipdat Shipping Date
shiptime flog_shiptims Shipping Time
rec_action flog_rt_action Recommended Action
fldlogssupplyprocess flog_sproc Supply Process
item_type flog_item_type Item Type
ref_wrk_order aufnr Order
ref_po ebeln Purchasing Doc.
cont_id flog_contid Container ID
fldlogscontaineruuid flog_ctn_uuid Container UUID
fldlogscontainerunituuid flog_ctnunit_id Container Unit ID
ret_stock_typ flog_insmk Return Stock Type
batch charg_d Batch
valuation_typ bwtar_d Valuation Type
serialno gernr Serial Number
createdat flog_createdat Created On
changedat flog_changedat Changed On
del_flag flog_delete Delete
fldlogssuplritemuuid flog_suplritem_uuid Suplr Item UUID
fldlogsshptitemuuid flog_shptitem_id Shipment Item ID
fldlogsretoutbdeliviscreated xfeld Checkbox
fieldlogisticsstoragebin flog_lgpla Storage Bin
fieldlogisticstransferplant werks_d Plant
fldlogsrefurbishmentorder aufnr Order
reservation rsnum Reservation
reservationitem rspos Item no.
purchaseorderitem ebelp Item
outbounddelivery vbeln_vl Delivery
outbounddeliveryitem posnr_vl Item
inbounddelivery vbeln_vl Delivery
inbounddeliveryitem posnr_vl Item
materialdocument mblnr Material Doc.
materialdocumentitem mblpo Mat. Doc.Item
stocktransportorderitem ebelp Item
fldlogsvoyagedeststage flog_deststage Destination Stage
orderoperation vornr Activity
billofmaterialitemnumber aposn BOM item

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 logistic: Return Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_RETURN (
    MANDT,                         -- Client [mandt]
    MATNR,                         -- Material [matnr]
    PLANT,                         -- Plant [werks_d]
    REF_DOC,                       -- Reference Doc Number [flog_doc]
    REF_DOCITEM,                   -- Document Item [flog_docitem]
    WORK_ORDER,                    -- Order [aufnr]
    REMOTE_LGORT,                  -- Location [lgort_d]
    REF_DOCTYP,                    -- Document Type [flog_doctyp]
    RET_STATUS,                    -- Return Status [flog_return_status]
    RET_QUANTITY,                  -- Quantity in Base Uni [flog_retqty]
    UNIT,                          -- Base Unit [meins]
    RETQTYINORDERUNIT,             -- Order Qty. [flog_retoqty]
    RETQTYORDERUNIT,               -- Order Unit [flog_ounit]
    LOAD_QUANTITY,                 -- Load Quantity [flog_loadqty]
    DISPATCHDAT,                   -- Dispatch Date [flog_dispdat]
    SUPPLY_LGORT,                  -- Supply SLoc [flog_supply_lgort]
    SHIPDATE,                      -- Shipping Date [flog_shipdat]
    SHIPTIME,                      -- Shipping Time [flog_shiptims]
    REC_ACTION,                    -- Recommended Action [flog_rt_action]
    FLDLOGSSUPPLYPROCESS,          -- Supply Process [flog_sproc]
    ITEM_TYPE,                     -- Item Type [flog_item_type]
    REF_WRK_ORDER,                 -- Order [aufnr]
    REF_PO,                        -- Purchasing Doc. [ebeln]
    CONT_ID,                       -- Container ID [flog_contid]
    FLDLOGSCONTAINERUUID,          -- Container UUID [flog_ctn_uuid]
    FLDLOGSCONTAINERUNITUUID,      -- Container Unit ID [flog_ctnunit_id]
    RET_STOCK_TYP,                 -- Return Stock Type [flog_insmk]
    BATCH,                         -- Batch [charg_d]
    VALUATION_TYP,                 -- Valuation Type [bwtar_d]
    SERIALNO,                      -- Serial Number [gernr]
    CREATEDAT,                     -- Created On [flog_createdat]
    CHANGEDAT,                     -- Changed On [flog_changedat]
    DEL_FLAG,                      -- Delete [flog_delete]
    FLDLOGSSUPLRITEMUUID,          -- Suplr Item UUID [flog_suplritem_uuid]
    FLDLOGSSHPTITEMUUID,           -- Shipment Item ID [flog_shptitem_id]
    FLDLOGSRETOUTBDELIVISCREATED,  -- Checkbox [xfeld]
    FIELDLOGISTICSSTORAGEBIN,      -- Storage Bin [flog_lgpla]
    FIELDLOGISTICSTRANSFERPLANT,   -- Plant [werks_d]
    FLDLOGSREFURBISHMENTORDER,     -- Order [aufnr]
    RESERVATION,                   -- Reservation [rsnum]
    RESERVATIONITEM,               -- Item no. [rspos]
    PURCHASEORDERITEM,             -- Item [ebelp]
    OUTBOUNDDELIVERY,              -- Delivery [vbeln_vl]
    OUTBOUNDDELIVERYITEM,          -- Item [posnr_vl]
    INBOUNDDELIVERY,               -- Delivery [vbeln_vl]
    INBOUNDDELIVERYITEM,           -- Item [posnr_vl]
    MATERIALDOCUMENT,              -- Material Doc. [mblnr]
    MATERIALDOCUMENTITEM,          -- Mat. Doc.Item [mblpo]
    STOCKTRANSPORTORDERITEM,       -- Item [ebelp]
    FLDLOGSVOYAGEDESTSTAGE,        -- Destination Stage [flog_deststage]
    ORDEROPERATION,                -- Activity [vornr]
    BILLOFMATERIALITEMNUMBER,      -- BOM item [aposn]
    PRIMARY KEY (MANDT, MATNR, PLANT, REF_DOC, REF_DOCITEM, WORK_ORDER, REMOTE_LGORT)
);

Learn More