FLOG_SHPTCTN_D

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.

-- Draft table for entity R_FLDLOGSSHIPMENTCONTAINERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SHPTCTN_D (
    MANDT,                           -- Client [MANDT]
    FLDLOGSCONTAINERUUID,            -- Container UUID [FLOG_CTN_UUID]
    FLDLOGSCONTAINERID,              -- Container ID [FLOG_CONTID]
    EQUIPMENT,                       -- Equipment [EQUNR]
    EQUIPMENTTYPE,                   -- Equipment Type [/SCMB/DE_EQUI_CODE]
    EQUIPMENTGROUP,                  -- Equipment Group [/SCMB/DE_EQUI_TYPE]
    FLDLOGSCONTAINERTEXT,            -- Container Desc. [FLOG_CTN_NAME]
    FLDLOGSCONTAINERCATEGORY,        -- Container Category [FLOG_CTN_CAT]
    FLDLOGSCONTAINERSTATUS,          -- Container Status [FLOG_CTN_STATUS]
    FLDLOGSSHPTCTNSTSCRITICALITY,    -- abap.int1
    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]
    EXTERNALRESOURCEID,              -- Internal Resrce [/SAPAPO/RESUID]
    FLDLOGSCONTAINEROWNER,           -- Owner [FLOG_CTN_OWNER]
    FLDLOGSCTNOWNERBUSINESSPARTNER,  -- Busn. Partner [BU_PARTNER]
    FLDLOGSCTNISRENTED,              -- Rental Flag [FLOG_CTN_RENT]
    FLDLOGSCTNISSUPPLIEROWNED,       -- Supplier Owned [FLOG_CTN_SUPLR]
    FLDLOGSCTNISTHIRDPARTYOWNED,     -- Third Party Flag [FLOG_CTN_TPTY]
    FIELDLOGISTICSCTNISOWNED,        -- Ctn classification [FLOG_CTN_OWND]
    FLDLOGSCTNCHANGEDATETIME,        -- Changed On [FLOG_CHANGEDAT]
    FLDLOGSCTNLASTCHANGEDATETIME,    -- Changed On [ABP_LASTCHANGE_TSTMPL]
    FLDLOGSCERTENDDATE,              -- abap.dats
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [BU_XPCPT]
    SUPLRCOISBUSPRPSCMPLTD,          -- Purpose Completed [CVP_XBLCK]
    EQUIPMENTCATEGORY,               -- EquipCategory [EQTYP]
    FLDLOGSISCREATEEQUIPMENT,        -- TRUE [BOOLE_D]
    FLDLOGSISDELETEEQUIPMENT,        -- TRUE [BOOLE_D]
    FLDLOGSCTNMAXIMUMHEIGHT,         -- Maximum Height [FLOG_CTN_MAX_EXT_HEIGHT]
    FLDLOGSCONTAINEREXTERNALID,      -- External ID [FLOG_CTN_EXTID]
    FLDLOGSCTNFOOTPRINTHASERROR,     -- Truth Value [ABAP_BOOLEAN]
    FLDLOGSCTNTAREVOLUMEHASERROR,    -- Truth Value [ABAP_BOOLEAN]
    FLDLOGSCTNCUBICCAPHASERROR,      -- Truth Value [ABAP_BOOLEAN]
    FLDLOGSCTNHASINTNMBRRNGECRTED,   -- Truth Value [ABAP_BOOLEAN]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_SHPTCTN_PS,                -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLDLOGSCONTAINERUUID)
);