FLOG_SHPTVOYAGE
Field Logistics: Shipment Voyage
FLOG_SHPTVOYAGE is an SAP database table in S/4HANA. Field Logistics: Shipment Voyage. It contains 14 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FieldLogisticsShipmentVoyage | view_entity | from | EXTENSION | Field Logistics ShipmentVoy - Extension |
| I_FldLogsShipmentVoyage | view_entity | from | BASIC | Field Logistics Shipment Voyage |
| I_NmbrOfArrivedFldLogsShptVoy | view_entity | from | BASIC | Fld Logistics Ship Voy Count Arrived |
| I_NmbrOfInTrnstFldLogsShptVoy | view_entity | from | BASIC | Fld Logistics Ship Voy Count InTransit |
| I_NmbrOfNotStrtdFldLogsShptVoy | view_entity | from | COMPOSITE | Fld Logistics Ship Voy Count NotStarted |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | fldlogsshptvoyageuuid | FLOG_SHPTVOYAGE_UUID | Voyage UUID | |||
| fldlogsshptvoyagenumber | FLOG_SHPTVOYAGE_NUMBER | Voyage Number | ||||
| fldlogsshptvoyagetypecode | FLOG_SHPTVOYAGE_TYPE_CODE | Voyage Type Code | ||||
| fldlogsshptvoyagevehiclenumber | FLOG_SHPTVOYAGE_VEH_NUMBER | Voyage Veh number | ||||
| fldlogsshptvoyagevehiclename | FLOG_SHPTVOYAGE_VEH_NAME | Voyage Veh Name | ||||
| fldlogsshptvoyagestatuscode | FLOG_SHPTVOYAGE_STS_CODE | Voyage Status Code | ||||
| fldlogsvoyagechangedatetime | FLOG_CHANGEDAT | Changed On | ||||
| fldlogsshptvoyisexternallymngd | FLOG_SHPTVOYAGE_EXT_MANAGED | Externally Managed | ||||
| fldlogsvoylastchangedatetime | ABP_LASTCHANGE_TSTMPL | Changed On | ||||
| country | LAND1_GP | Country/Region Key | ||||
| fldlogsvoyagecarrierid | LIFNR | Supplier | ||||
| fldlogsvoyisctnnotallowed | FLOG_SHPTVOY_CTN_NOT_ALLOWED | Container Not Allwd | ||||
| dummy_flog_shptvoy_incl_eew_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 Voyage
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SHPTVOYAGE (
MANDT, -- Client [MANDT]
FLDLOGSSHPTVOYAGEUUID, -- Voyage UUID [FLOG_SHPTVOYAGE_UUID]
FLDLOGSSHPTVOYAGENUMBER, -- Voyage Number [FLOG_SHPTVOYAGE_NUMBER]
FLDLOGSSHPTVOYAGETYPECODE, -- Voyage Type Code [FLOG_SHPTVOYAGE_TYPE_CODE]
FLDLOGSSHPTVOYAGEVEHICLENUMBER, -- Voyage Veh number [FLOG_SHPTVOYAGE_VEH_NUMBER]
FLDLOGSSHPTVOYAGEVEHICLENAME, -- Voyage Veh Name [FLOG_SHPTVOYAGE_VEH_NAME]
FLDLOGSSHPTVOYAGESTATUSCODE, -- Voyage Status Code [FLOG_SHPTVOYAGE_STS_CODE]
FLDLOGSVOYAGECHANGEDATETIME, -- Changed On [FLOG_CHANGEDAT]
FLDLOGSSHPTVOYISEXTERNALLYMNGD, -- Externally Managed [FLOG_SHPTVOYAGE_EXT_MANAGED]
FLDLOGSVOYLASTCHANGEDATETIME, -- Changed On [ABP_LASTCHANGE_TSTMPL]
COUNTRY, -- Country/Region Key [LAND1_GP]
FLDLOGSVOYAGECARRIERID, -- Supplier [LIFNR]
FLDLOGSVOYISCTNNOTALLOWED, -- Container Not Allwd [FLOG_SHPTVOY_CTN_NOT_ALLOWED]
DUMMY_FLOG_SHPTVOY_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, FLDLOGSSHPTVOYAGEUUID)
);
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