FLOG_SHPTITEM

Transparent Table Application Table

Field Logistics: Shipment Item

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsShptItem view_entity from EXTENSION Field logistics Shipment Item - Extn
I_FldLogsShipmentItem view_entity from BASIC Field Logistics Shipment Item

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fldlogsshptitemuuid flog_shptitem_id Shipment Item ID
fldlogsreferencedoccategory flog_refdoc_type Ref. Document Type
fldlogsreferencedocumentnumber flog_doc Reference Doc Number
fldlogsshptitmwrkorditmid flog_shptitem_woitem_id Work Order Item ID
fldlogsshptitmprojdmnditmid flog_shptitem_projdmnditm_id Demand Item ID
fldlogsshptitmstoitmid flog_shptitem_stoitm_id STO Item ID
fldlogsshptitmoutbdelivitmid flog_shptitem_obditm_id OBD Item ID
fldlogsshptitmhndlgunitid flog_shptitem_hndlgunit_id Handling Unit ID
fldlogscontainerunituuid flog_ctnunit_id Container Unit ID
fldlogsshipmentid flog_shpt_id Shipment ID
fldlogsshptitmstscode flog_shptitem_sts_code Status Code
fldlogsdeststorlocid lgort_d Location
fldlogsdestplnt werks_d Plant
fldlogssrcestorlocid lgort_d Location
fldlogssrceplnt werks_d Plant
fldlogsshptitmchangeddatetime flog_changedat Changed On
fldlogsdelivduedate eindt Delivery Date
fldlogsgrossvolume volum Volume
fldlogsgrossvolumeunit voleh Volume Unit
productgrossweight brgew Gross Weight
productweightunit /sapapo/gewei Unit
quantityinbaseunit menge_d Quantity
orderquantityunit vrkme Sales Unit
fldlogsshptitmodoitemid flog_shptitem_odoitm_id Outbound Deliv.Order
deliverydocument vbeln_vl Delivery
deliverydocumentitem posnr_vl Item
grossweight brgew_vekp Total Weight
weightunit gewei Unit of Weight
grossvolume btvol_vekp Total Volume
volumeunit voleh Volume Unit
packagingmaterial vhilm Packaging Materials
fldlogsshptitmisassgdtovoy flog_voyage_assignment_ind VoyAsgnInd
fldlogsvoyagesrcestage flog_srcestage Source Stage
fldlogsvoyagedeststage flog_deststage Destination Stage
fldlogsvoyageassignmentstatus flog_voyage_assgmt_status Voy Assgmt Status
fldlogsshptitemcurrentplant werks_d Plant
fldlogsshptitemcurshipgpoint flog_deststage Destination Stage
fldlogsshptitemactualweight brgew Gross Weight
fldlogsshptitemactlweightunit meins Base Unit
handlingunitquantity vemng Packed Quantity
handlingunitquantityunit vemeh UoM of HU item
fldlogsshptlocationid flog_shpt_locid Location Id.

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SHPTITEM (
    MANDT,                           -- Client [mandt]
    FLDLOGSSHPTITEMUUID,             -- Shipment Item ID [flog_shptitem_id]
    FLDLOGSREFERENCEDOCCATEGORY,     -- Ref. Document Type [flog_refdoc_type]
    FLDLOGSREFERENCEDOCUMENTNUMBER,  -- Reference Doc Number [flog_doc]
    FLDLOGSSHPTITMWRKORDITMID,       -- Work Order Item ID [flog_shptitem_woitem_id]
    FLDLOGSSHPTITMPROJDMNDITMID,     -- Demand Item ID [flog_shptitem_projdmnditm_id]
    FLDLOGSSHPTITMSTOITMID,          -- STO Item ID [flog_shptitem_stoitm_id]
    FLDLOGSSHPTITMOUTBDELIVITMID,    -- OBD Item ID [flog_shptitem_obditm_id]
    FLDLOGSSHPTITMHNDLGUNITID,       -- Handling Unit ID [flog_shptitem_hndlgunit_id]
    FLDLOGSCONTAINERUNITUUID,        -- Container Unit ID [flog_ctnunit_id]
    FLDLOGSSHIPMENTID,               -- Shipment ID [flog_shpt_id]
    FLDLOGSSHPTITMSTSCODE,           -- Status Code [flog_shptitem_sts_code]
    FLDLOGSDESTSTORLOCID,            -- Location [lgort_d]
    FLDLOGSDESTPLNT,                 -- Plant [werks_d]
    FLDLOGSSRCESTORLOCID,            -- Location [lgort_d]
    FLDLOGSSRCEPLNT,                 -- Plant [werks_d]
    FLDLOGSSHPTITMCHANGEDDATETIME,   -- Changed On [flog_changedat]
    FLDLOGSDELIVDUEDATE,             -- Delivery Date [eindt]
    FLDLOGSGROSSVOLUME,              -- Volume [volum]
    FLDLOGSGROSSVOLUMEUNIT,          -- Volume Unit [voleh]
    PRODUCTGROSSWEIGHT,              -- Gross Weight [brgew]
    PRODUCTWEIGHTUNIT,               -- Unit [/sapapo/gewei]
    QUANTITYINBASEUNIT,              -- Quantity [menge_d]
    ORDERQUANTITYUNIT,               -- Sales Unit [vrkme]
    FLDLOGSSHPTITMODOITEMID,         -- Outbound Deliv.Order [flog_shptitem_odoitm_id]
    DELIVERYDOCUMENT,                -- Delivery [vbeln_vl]
    DELIVERYDOCUMENTITEM,            -- Item [posnr_vl]
    GROSSWEIGHT,                     -- Total Weight [brgew_vekp]
    WEIGHTUNIT,                      -- Unit of Weight [gewei]
    GROSSVOLUME,                     -- Total Volume [btvol_vekp]
    VOLUMEUNIT,                      -- Volume Unit [voleh]
    PACKAGINGMATERIAL,               -- Packaging Materials [vhilm]
    FLDLOGSSHPTITMISASSGDTOVOY,      -- VoyAsgnInd [flog_voyage_assignment_ind]
    FLDLOGSVOYAGESRCESTAGE,          -- Source Stage [flog_srcestage]
    FLDLOGSVOYAGEDESTSTAGE,          -- Destination Stage [flog_deststage]
    FLDLOGSVOYAGEASSIGNMENTSTATUS,   -- Voy Assgmt Status [flog_voyage_assgmt_status]
    FLDLOGSSHPTITEMCURRENTPLANT,     -- Plant [werks_d]
    FLDLOGSSHPTITEMCURSHIPGPOINT,    -- Destination Stage [flog_deststage]
    FLDLOGSSHPTITEMACTUALWEIGHT,     -- Gross Weight [brgew]
    FLDLOGSSHPTITEMACTLWEIGHTUNIT,   -- Base Unit [meins]
    HANDLINGUNITQUANTITY,            -- Packed Quantity [vemng]
    HANDLINGUNITQUANTITYUNIT,        -- UoM of HU item [vemeh]
    FLDLOGSSHPTLOCATIONID,           -- Location Id. [flog_shpt_locid]
    PRIMARY KEY (MANDT, FLDLOGSSHPTITEMUUID)
);