SAP ABAP Table E3OILST (TD Shipment stages)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIG (Package) TD Transport and Distribution

Basic Data

Table Category	INTTAB	Structure
Structure	E3OILST	Table Relationship Diagram
Short Description	TD Shipment stages

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TSNUM	☐	TSNUM	TSNUM	NUMC	4	0	Stage of transport number	*
2	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
3	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
4	VEH_NR	☐	OIG_VEHNR	OIG_VEHNR	NUMC	3	0	Vehicle Sequence Number in Shipment	*
5	ELUPD	☐	ELUPD	ELUPD	CHAR	1	0	Change Indicator
6	ROUTE	☐	ROUTES	ROUTE	CHAR	6	0	Route for shipment stage	*
7	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	*
8	LAUFK	☐	LAUFS	LAUFK	CHAR	1	0	Leg indicator for shipment stage
9	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
10	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	*
11	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	*
12	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	*
13	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	*
14	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	*
15	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	*
16	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	*
17	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
18	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	*
19	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	*
20	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	*
21	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	*
22	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	*
23	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	*
24	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	*
25	TDLNR	☐	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	*
26	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
27	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
28	OIG_GESZTD	☐	OIG_GESZTD	OIG_GESZT	QUAN	13	2	Total time for stage
29	OIG_FAHZTD	☐	OIG_FAHZTD	OIG_GESZT	QUAN	13	2	Total travel time for stage
30	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
31	ADRKNZA	☐	ADRKNZA	ADRKNZ	CHAR	1	0	Point of departure: Origin indicator of address
32	KUNABLA	☐	KUNABLA	TEXT25	CHAR	25	0	Point of departure: Customer's unloading point
33	ADRKNZZ	☐	ADRKNZZ	ADRKNZ	CHAR	1	0	Destination: Origin indicator of address
34	KUNABLZ	☐	KUNABLZ	TEXT25	CHAR	25	0	Destination: Customer's unloading point
35	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
36	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	*
37	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
38	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
39	VEH_IND	☐	OIG_VEHIND	OIG_VEHIND	CHAR	1	0	TD-F: Vehicle stage indicator with first and last node
40	CARR_ROUT	☐	OIG_CRROUT	XFELD	CHAR	1	0	TD-F carrier is copied from route / stage table
41	TSTYP_TXT	☐	OIG_TYPTXT	CHAR30	CHAR	30	0	Description of stage type
42	DEPFLAG	☐	OIG_STGFLG	CHAR1_X	CHAR	1	0	TD-F flag if stage is used as dep. or destination point
43	DESTFLAG	☐	OIG_STGFLG	CHAR1_X	CHAR	1	0	TD-F flag if stage is used as dep. or destination point
44	FRKRLFLAG	☐	OIG_FRKFLG	CHAR1_X	CHAR	1	0	TD-F flag: if SCD-relevance is set for TSTYP
45	DESCNODEA	☐	BEZEI30	TEXT30	CHAR	30	0	Description
46	DESCNODEZ	☐	BEZEI30	TEXT30	CHAR	30	0	Description
47	UPDATEFLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

History

Last changed by/on	SAP	20110901
SAP Release Created in