FLOG_SHPTCTN

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: Shipment Container
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SHPTCTN (
    MANDT,                           -- Client [mandt]
    FLDLOGSCONTAINERUUID,            -- Container UUID [flog_ctn_uuid]
    FLDLOGSCONTAINERID,              -- Container ID [flog_contid]
    FLDLOGSCONTAINERTEXT,            -- Container Desc. [flog_ctn_name]
    EQUIPMENT,                       -- Equipment [equnr]
    EQUIPMENTTYPE,                   -- Equipment Type [/scmb/de_equi_code]
    EQUIPMENTGROUP,                  -- Equipment Group [/scmb/de_equi_type]
    FLDLOGSCONTAINERCATEGORY,        -- Container Category [flog_ctn_cat]
    FLDLOGSCONTAINERSTATUS,          -- Container Status [flog_ctn_status]
    FLDLOGSCONTAINERSAFELOADQTY,     -- Safe Load [flog_ctn_safe_load]
    FLDLOGSCONTAINERSAFELOADUNIT,    -- Safe Load Unit [flog_ctn_safe_load_uom]
    PLANT,                           -- Plant [werks_d]
    STORAGELOCATION,                 -- Location [lgort_d]
    FLDLOGSCTNCURRENTLOCATION,       -- Plant [werks_d]
    FLDLOGSCTNCURRENTSTORAGELOC,     -- Location [lgort_d]
    FLDLOGSCTNRENTALSTARTDATE,       -- Rental Date [flog_ctn_rental_dte]
    FLDLOGSCTNRENTALEXPIRYDATE,      -- Expiry Date [flog_ctn_rntl_exp_dte]
    MATERIAL,                        -- Material [matnr]
    FLDLOGSCTNCUBICCAPACITY,         -- Cubic Capacity [/scmb/capa_volume]
    FLDLOGSCTNCUBICCAPACITYUNIT,     -- Cub. Capa. UoM [/scmb/capa_volume_uom]
    FLDLOGSCTNINTERIORLENGTH,        -- Interior Length [/scmb/internal_length]
    FLDLOGSCTNINTERIORWIDTH,         -- Interior Width [/scmb/internal_width]
    FLDLOGSCTNINTERIORHEIGHT,        -- Interior Height [/scmb/internal_height]
    FLDLOGSCTNINTERIORDIMNUNIT,      -- Int. Dim. UoM [/scmb/internal_lwh_uom]
    FLDLOGSCTNMAXIMUMLENGTH,         -- Max. Length [flog_ctn_max_ext_length]
    FLDLOGSCTNMAXIMUMWIDTH,          -- Max. Width [flog_ctn_max_ext_width]
    FLDLOGSCTNMAXIMUMDIMNUNIT,       -- Unit of Meas. [/scmb/max_ext_uom]
    FLDLOGSCONTAINERFOOTPRINTQTY,    -- Footprint [flog_ctn_footprint]
    FLDLOGSCONTAINERFOOTPRINTUNIT,   -- Footprint Unit [flog_ctn_footprint_uom]
    FLDLOGSCTNMAXGROSSWEIGHT,        -- Max. Gross Weight [/scmb/max_gross_weight]
    FLDLOGSCTNMAXGROSSWEIGHTUNIT,    -- Gross Weight UoM [/scmb/max_gross_weight_uom]
    FLDLOGSCONTAINERTAREWEIGHT,      -- Tare Weight [/scmb/tare_weight]
    FLDLOGSCONTAINERTAREWEIGHTUNIT,  -- Tare Weight UoM [/scmb/tare_weight_uom]
    FLDLOGSCONTAINERTAREVOLUME,      -- Tare Volume [/scmb/tare_volume]
    FLDLOGSCONTAINERTAREVOLUMEUNIT,  -- Tare Volume UoM [/scmb/tare_volume_uom]
    FLDLOGSCTNISTEMPERATURECTRLD,    -- Temp.Ctrld. [/scmb/temp_controlled]
    FLDLOGSCTNMINCTRLTEMPERATURE,    -- Min. Temp. [/scmb/temp_control_min]
    FLDLOGSCTNMAXCTRLTEMPERATURE,    -- Max. Temp. [/scmb/temp_control_max]
    FLDLOGSCTNTEMPERATUREUNIT,       -- Temp. UoM [/scmb/temp_uom]
    FLDLOGSCONTAINERVENTILATION,     -- Cont. Ventilation [flog_ctn_ventilation]
    FLDLOGSCONTAINEROWNER,           -- Owner [flog_ctn_owner]
    EXTERNALRESOURCEID,              -- Internal Resrce [/sapapo/resuid]
    FLDLOGSCTNCHANGEDATETIME,        -- Changed On [flog_changedat]
    FLDLOGSCTNISRENTED,              -- Rental Flag [flog_ctn_rent]
    FLDLOGSCTNISTHIRDPARTYOWNED,     -- Third Party Flag [flog_ctn_tpty]
    FLDLOGSCTNISSUPPLIEROWNED,       -- Supplier Owned [flog_ctn_suplr]
    FLDLOGSCTNOWNERBUSINESSPARTNER,  -- Busn. Partner [bu_partner]
    FIELDLOGISTICSCTNISOWNED,        -- Ctn classification [flog_ctn_ownd]
    FLDLOGSCTNLASTCHANGEDATETIME,    -- Changed On [abp_lastchange_tstmpl]
    FLDLOGSISDELETEEQUIPMENT,        -- TRUE [boole_d]
    FLDLOGSCTNMAXIMUMHEIGHT,         -- Maximum Height [flog_ctn_max_ext_height]
    EQUIPMENTCATEGORY,               -- EquipCategory [eqtyp]
    FLDLOGSISCREATEEQUIPMENT,        -- TRUE [boole_d]
    FLDLOGSCONTAINEREXTERNALID,      -- External ID [flog_ctn_extid]
    PRIMARY KEY (MANDT, FLDLOGSCONTAINERUUID)
);