FLOG_SHPTITEM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FldLogsShptItem | view_entity | from | EXTENSION | Field logistics Shipment Item - Extn |
| I_FldLogsShipmentItem | view_entity | from | BASIC | Field Logistics Shipment Item |
Fields (43)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA