FLOG_RETCTN

Transparent Table Application Table
25 Fields 2 CDS Views

Field Logistics Container Header Table

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsRcvdShipmentContainer view_entity from EXTENSION FL RCVD Shipment Container - Extn
I_FldLogsReturnContainerBasic view from BASIC Basic view for flog_retctn table

Fields (25)

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
cont_status FLOG_CONT_STATUS Container Status
process_start_dat FLOG_PROC_SDAT Processing Start Dat
process_end_dat FLOG_PROC_EDAT Processing End Date
supply_plant FLOG_RESWK_DEF Def. Supplying Plant
fldlogsshipmentid FLOG_SHPT_ID Shipment ID
process_type FLOG_PROCESS_TYPE Process Type
receivingplant FLOG_RCV_PLANT Receiving Plant
fldlogscontaineruuid FLOG_CTN_UUID Container UUID
fldlogscontainerunituuid FLOG_CTNUNIT_ID Container Unit ID
allprocessed FLAG Indicator
del_flag FLOG_DELETE Delete
changedat FLOG_CHANGEDAT Changed On
fldlogsshptvoyageuuid FLOG_SHPTVOYAGE_UUID Voyage UUID
fldlogsshptvoyagenumber FLOG_SHPTVOYAGE_NUMBER Voyage Number
fldlogsvoyagesrcestage FLOG_SRCESTAGE Source Stage
fldlogsvoyagedeststage FLOG_DESTSTAGE Destination Stage
fldlogsrcvdcontainerisreleased XFELD Checkbox
fldlogsctnactualdispatchplant WERKS_D Plant
fldlogsctnactualreceivingplant WERKS_D Plant
dummy_flog_retctn_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 Header Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_RETCTN (
    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]
    CONT_STATUS,                     -- Container Status [FLOG_CONT_STATUS]
    PROCESS_START_DAT,               -- Processing Start Dat [FLOG_PROC_SDAT]
    PROCESS_END_DAT,                 -- Processing End Date [FLOG_PROC_EDAT]
    SUPPLY_PLANT,                    -- Def. Supplying Plant [FLOG_RESWK_DEF]
    FLDLOGSSHIPMENTID,               -- Shipment ID [FLOG_SHPT_ID]
    PROCESS_TYPE,                    -- Process Type [FLOG_PROCESS_TYPE]
    RECEIVINGPLANT,                  -- Receiving Plant [FLOG_RCV_PLANT]
    FLDLOGSCONTAINERUUID,            -- Container UUID [FLOG_CTN_UUID]
    FLDLOGSCONTAINERUNITUUID,        -- Container Unit ID [FLOG_CTNUNIT_ID]
    ALLPROCESSED,                    -- Indicator [FLAG]
    DEL_FLAG,                        -- Delete [FLOG_DELETE]
    CHANGEDAT,                       -- Changed On [FLOG_CHANGEDAT]
    FLDLOGSSHPTVOYAGEUUID,           -- Voyage UUID [FLOG_SHPTVOYAGE_UUID]
    FLDLOGSSHPTVOYAGENUMBER,         -- Voyage Number [FLOG_SHPTVOYAGE_NUMBER]
    FLDLOGSVOYAGESRCESTAGE,          -- Source Stage [FLOG_SRCESTAGE]
    FLDLOGSVOYAGEDESTSTAGE,          -- Destination Stage [FLOG_DESTSTAGE]
    FLDLOGSRCVDCONTAINERISRELEASED,  -- Checkbox [XFELD]
    FLDLOGSCTNACTUALDISPATCHPLANT,   -- Plant [WERKS_D]
    FLDLOGSCTNACTUALRECEIVINGPLANT,  -- Plant [WERKS_D]
    DUMMY_FLOG_RETCTN_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, CONT_ID, DISPATCHDAT, DISPATCH_LOC, CONT_TRIPCNT)
);

Learn More