FLOG_SHPTCTN

Transparent Table Application Table
55 Fields 2 CDS Views

Field Logistics: Shipment Container

FLOG_SHPTCTN is an SAP database table in S/4HANA. Field Logistics: Shipment Container. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsShptContainer view_entity from EXTENSION Field logistics Shipment Container - Extension
I_FldLogsShipmentContainer view_entity from BASIC Field logistics shipment container

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fldlogscontaineruuid FLOG_CTN_UUID Container UUID
fldlogscontainerid FLOG_CONTID Container ID
fldlogscontainertext FLOG_CTN_NAME Container Desc.
equipment EQUNR Equipment
equipmenttype /SCMB/DE_EQUI_CODE Equipment Type
equipmentgroup /SCMB/DE_EQUI_TYPE Equipment Group
fldlogscontainercategory FLOG_CTN_CAT Container Category
fldlogscontainerstatus FLOG_CTN_STATUS Container Status
fldlogscontainersafeloadqty FLOG_CTN_SAFE_LOAD Safe Load
fldlogscontainersafeloadunit FLOG_CTN_SAFE_LOAD_UOM Safe Load Unit
plant WERKS_D Plant
storagelocation LGORT_D Location
fldlogsctncurrentlocation WERKS_D Plant
fldlogsctncurrentstorageloc LGORT_D Location
fldlogsctnrentalstartdate FLOG_CTN_RENTAL_DTE Rental Date
fldlogsctnrentalexpirydate FLOG_CTN_RNTL_EXP_DTE Expiry Date
material MATNR Material
fldlogsctncubiccapacity /SCMB/CAPA_VOLUME Cubic Capacity
fldlogsctncubiccapacityunit /SCMB/CAPA_VOLUME_UOM Cub. Capa. UoM
fldlogsctninteriorlength /SCMB/INTERNAL_LENGTH Interior Length
fldlogsctninteriorwidth /SCMB/INTERNAL_WIDTH Interior Width
fldlogsctninteriorheight /SCMB/INTERNAL_HEIGHT Interior Height
fldlogsctninteriordimnunit /SCMB/INTERNAL_LWH_UOM Int. Dim. UoM
fldlogsctnmaximumlength FLOG_CTN_MAX_EXT_LENGTH Max. Length
fldlogsctnmaximumwidth FLOG_CTN_MAX_EXT_WIDTH Max. Width
fldlogsctnmaximumdimnunit /SCMB/MAX_EXT_UOM Unit of Meas.
fldlogscontainerfootprintqty FLOG_CTN_FOOTPRINT Footprint
fldlogscontainerfootprintunit FLOG_CTN_FOOTPRINT_UOM Footprint Unit
fldlogsctnmaxgrossweight /SCMB/MAX_GROSS_WEIGHT Max. Gross Weight
fldlogsctnmaxgrossweightunit /SCMB/MAX_GROSS_WEIGHT_UOM Gross Weight UoM
fldlogscontainertareweight /SCMB/TARE_WEIGHT Tare Weight
fldlogscontainertareweightunit /SCMB/TARE_WEIGHT_UOM Tare Weight UoM
fldlogscontainertarevolume /SCMB/TARE_VOLUME Tare Volume
fldlogscontainertarevolumeunit /SCMB/TARE_VOLUME_UOM Tare Volume UoM
fldlogsctnistemperaturectrld /SCMB/TEMP_CONTROLLED Temp.Ctrld.
fldlogsctnminctrltemperature /SCMB/TEMP_CONTROL_MIN Min. Temp.
fldlogsctnmaxctrltemperature /SCMB/TEMP_CONTROL_MAX Max. Temp.
fldlogsctntemperatureunit /SCMB/TEMP_UOM Temp. UoM
fldlogscontainerventilation FLOG_CTN_VENTILATION Cont. Ventilation
fldlogscontainerowner FLOG_CTN_OWNER Owner
externalresourceid /SAPAPO/RESUID Internal Resrce
fldlogsctnchangedatetime FLOG_CHANGEDAT Changed On
fldlogsctnisrented FLOG_CTN_RENT Rental Flag
fldlogsctnisthirdpartyowned FLOG_CTN_TPTY Third Party Flag
fldlogsctnissupplierowned FLOG_CTN_SUPLR Supplier Owned
fldlogsctnownerbusinesspartner BU_PARTNER Busn. Partner
fieldlogisticsctnisowned FLOG_CTN_OWND Ctn classification
fldlogsctnlastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
fldlogsisdeleteequipment BOOLE_D TRUE
fldlogsctnmaximumheight FLOG_CTN_MAX_EXT_HEIGHT Maximum Height
equipmentcategory EQTYP EquipCategory
fldlogsiscreateequipment BOOLE_D TRUE
fldlogscontainerexternalid FLOG_CTN_EXTID External ID
dummy_shptctn_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: 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]
    DUMMY_SHPTCTN_PS,                -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLDLOGSCONTAINERUUID)
);

Learn More