FLOG_SHPTITEM

Transparent Table Application Table
44 Fields 2 CDS Views

Field Logistics: Shipment Item

FLOG_SHPTITEM is an SAP database table in S/4HANA. Field Logistics: Shipment Item. It contains 44 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 (44)

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.
dummy_shptitem_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 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]
    DUMMY_SHPTITEM_PS,               -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, FLDLOGSSHPTITEMUUID)
);

Learn More