FLOG_RETCTN_ITM

Transparent Table Application Table
63 Fields 2 CDS Views

Field Logistics Container Items Table

FLOG_RETCTN_ITM is an SAP database table in S/4HANA. Field Logistics Container Items Table. It contains 63 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsReceivedShipmentItem view_entity from EXTENSION FL RCVD Shipment and Ctn item - Extn
I_FldLogsReturnCtnItmsBasic view from BASIC Basic View for FLOG_RETCTN_ITM table

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cont_id FLOG_CONTID Container ID
KEY dispatchdat FLOG_DISPDAT Dispatch Date
KEY dispatch_loc WERKS_D Plant
KEY cont_tripcnt FLOG_TRIPCNT Trip Counter
KEY ref_doc FLOG_DOC Reference Doc Number
ref_doctyp FLOG_DOCTYP Document Type
matnr MATNR Material
load_quantity FLOG_LOADQTY Load Quantity
loadqtyorderunit FLOG_OUNIT Order Unit
loadqtyinbaseunit FLOG_RETQTY Quantity in Base Uni
unit MEINS Base Unit
remote_lgort LGORT_D Location
supply_lgort FLOG_SUPPLY_LGORT Supply SLoc
fldlogssupplyprocess FLOG_SPROC Supply Process
item_type FLOG_ITEM_TYPE Item Type
ret_status FLOG_RETURN_STATUS Return Status
item_status FLOG_ITEM_STATUS Container Item Stats
quk_action FLOG_QK_ACTION Handling Decision
gr MBLNR Material Doc.
obd VBELN_VL Delivery
ret_po EBELN Purchasing Doc.
storage_type FLOG_STORAGE_TYPE Storage Type
batch CHARG_D Batch
valuation_typ BWTAR_D Valuation Type
serialno GERNR Serial Number
receivingplant FLOG_RCV_PLANT Receiving Plant
process_type FLOG_PROCESS_TYPE Process Type
fldlogssubcontractingpo EBELN Purchasing Doc.
fldlogssubcontrgpoiscreated XFELD Checkbox
del_flag FLOG_DELETE Delete
changedat FLOG_CHANGEDAT Changed On
fldlogsretpooutbdeliviscreated XFELD Checkbox
fldlogsshptitemuuid FLOG_SHPTITEM_ID Shipment Item ID
fldlogscontainerunituuid FLOG_CTNUNIT_ID Container Unit ID
fldlogsshptvoyageuuid FLOG_SHPTVOYAGE_UUID Voyage UUID
fldlogsshptvoyagenumber FLOG_SHPTVOYAGE_NUMBER Voyage Number
fldlogsvoyagesrcestage FLOG_SRCESTAGE Source Stage
fldlogsvoyagedeststage FLOG_DESTSTAGE Destination Stage
maintenanceorder AUFNR Order
reservation RSNUM Reservation
reservationitem RSPOS Item no.
fldlogsrefurbishmentorder AUFNR Order
inbounddelivery VBELN_VL Delivery
inbounddeliveryitem POSNR_VL Item
fldlogssuplritemuuid FLOG_SUPLRITEM_UUID Suplr Item UUID
fldlogssuplritemvislinspcode FLOG_SUPLRITEM_VISL_INSP_CODE Visual Inspection
outbounddelivery VBELN_VL Delivery
outbounddeliveryitem POSNR_VL Item
fldlogsshptitmhndlgunitid FLOG_SHPTITEM_HNDLGUNIT_ID Handling Unit ID
fldlogssrcestorlocid LGORT_D Location
fldlogsdeststorlocid LGORT_D Location
warehousetask /SCWM/TANUM Warehouse Task
deliverydocument VBELN_VL Delivery
deliverydocumentitem POSNR_VL Item
referencesddocument VGBEL Reference Doc.
referencesddocumentitem VGPOS Reference Item
purchasingdocumentitem EBELP Item
fldlogsitemactualdispatchplant WERKS_D Plant
fldlogsitmactualreceivingplant WERKS_D Plant
materialdocumentyear MJAHR Mat. Doc. Year
materialdocumentitem MBLPO Mat. Doc.Item
dummy_flog_ctn_itm_incl_eew_ps CFD_DUMMY Dummy

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 Container Items Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_RETCTN_ITM (
    MANDT,                           -- Client [MANDT]
    CONT_ID,                         -- Container ID [FLOG_CONTID]
    DISPATCHDAT,                     -- Dispatch Date [FLOG_DISPDAT]
    DISPATCH_LOC,                    -- Plant [WERKS_D]
    CONT_TRIPCNT,                    -- Trip Counter [FLOG_TRIPCNT]
    REF_DOC,                         -- Reference Doc Number [FLOG_DOC]
    REF_DOCTYP,                      -- Document Type [FLOG_DOCTYP]
    MATNR,                           -- Material [MATNR]
    LOAD_QUANTITY,                   -- Load Quantity [FLOG_LOADQTY]
    LOADQTYORDERUNIT,                -- Order Unit [FLOG_OUNIT]
    LOADQTYINBASEUNIT,               -- Quantity in Base Uni [FLOG_RETQTY]
    UNIT,                            -- Base Unit [MEINS]
    REMOTE_LGORT,                    -- Location [LGORT_D]
    SUPPLY_LGORT,                    -- Supply SLoc [FLOG_SUPPLY_LGORT]
    FLDLOGSSUPPLYPROCESS,            -- Supply Process [FLOG_SPROC]
    ITEM_TYPE,                       -- Item Type [FLOG_ITEM_TYPE]
    RET_STATUS,                      -- Return Status [FLOG_RETURN_STATUS]
    ITEM_STATUS,                     -- Container Item Stats [FLOG_ITEM_STATUS]
    QUK_ACTION,                      -- Handling Decision [FLOG_QK_ACTION]
    GR,                              -- Material Doc. [MBLNR]
    OBD,                             -- Delivery [VBELN_VL]
    RET_PO,                          -- Purchasing Doc. [EBELN]
    STORAGE_TYPE,                    -- Storage Type [FLOG_STORAGE_TYPE]
    BATCH,                           -- Batch [CHARG_D]
    VALUATION_TYP,                   -- Valuation Type [BWTAR_D]
    SERIALNO,                        -- Serial Number [GERNR]
    RECEIVINGPLANT,                  -- Receiving Plant [FLOG_RCV_PLANT]
    PROCESS_TYPE,                    -- Process Type [FLOG_PROCESS_TYPE]
    FLDLOGSSUBCONTRACTINGPO,         -- Purchasing Doc. [EBELN]
    FLDLOGSSUBCONTRGPOISCREATED,     -- Checkbox [XFELD]
    DEL_FLAG,                        -- Delete [FLOG_DELETE]
    CHANGEDAT,                       -- Changed On [FLOG_CHANGEDAT]
    FLDLOGSRETPOOUTBDELIVISCREATED,  -- Checkbox [XFELD]
    FLDLOGSSHPTITEMUUID,             -- Shipment Item ID [FLOG_SHPTITEM_ID]
    FLDLOGSCONTAINERUNITUUID,        -- Container Unit ID [FLOG_CTNUNIT_ID]
    FLDLOGSSHPTVOYAGEUUID,           -- Voyage UUID [FLOG_SHPTVOYAGE_UUID]
    FLDLOGSSHPTVOYAGENUMBER,         -- Voyage Number [FLOG_SHPTVOYAGE_NUMBER]
    FLDLOGSVOYAGESRCESTAGE,          -- Source Stage [FLOG_SRCESTAGE]
    FLDLOGSVOYAGEDESTSTAGE,          -- Destination Stage [FLOG_DESTSTAGE]
    MAINTENANCEORDER,                -- Order [AUFNR]
    RESERVATION,                     -- Reservation [RSNUM]
    RESERVATIONITEM,                 -- Item no. [RSPOS]
    FLDLOGSREFURBISHMENTORDER,       -- Order [AUFNR]
    INBOUNDDELIVERY,                 -- Delivery [VBELN_VL]
    INBOUNDDELIVERYITEM,             -- Item [POSNR_VL]
    FLDLOGSSUPLRITEMUUID,            -- Suplr Item UUID [FLOG_SUPLRITEM_UUID]
    FLDLOGSSUPLRITEMVISLINSPCODE,    -- Visual Inspection [FLOG_SUPLRITEM_VISL_INSP_CODE]
    OUTBOUNDDELIVERY,                -- Delivery [VBELN_VL]
    OUTBOUNDDELIVERYITEM,            -- Item [POSNR_VL]
    FLDLOGSSHPTITMHNDLGUNITID,       -- Handling Unit ID [FLOG_SHPTITEM_HNDLGUNIT_ID]
    FLDLOGSSRCESTORLOCID,            -- Location [LGORT_D]
    FLDLOGSDESTSTORLOCID,            -- Location [LGORT_D]
    WAREHOUSETASK,                   -- Warehouse Task [/SCWM/TANUM]
    DELIVERYDOCUMENT,                -- Delivery [VBELN_VL]
    DELIVERYDOCUMENTITEM,            -- Item [POSNR_VL]
    REFERENCESDDOCUMENT,             -- Reference Doc. [VGBEL]
    REFERENCESDDOCUMENTITEM,         -- Reference Item [VGPOS]
    PURCHASINGDOCUMENTITEM,          -- Item [EBELP]
    FLDLOGSITEMACTUALDISPATCHPLANT,  -- Plant [WERKS_D]
    FLDLOGSITMACTUALRECEIVINGPLANT,  -- Plant [WERKS_D]
    MATERIALDOCUMENTYEAR,            -- Mat. Doc. Year [MJAHR]
    MATERIALDOCUMENTITEM,            -- Mat. Doc.Item [MBLPO]
    DUMMY_FLOG_CTN_ITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CONT_ID, DISPATCHDAT, DISPATCH_LOC, CONT_TRIPCNT, REF_DOC)
);

Learn More