SAP ABAP Table ISI_BOR_DATA (Shipment Stucture for Internet)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-SWP (Application Component) Supplier Workplace
     ⤷ ISIA (Package) Internet Supplier Integration: Application layer

Basic Data

Table Category	INTTAB	Structure
Structure	ISI_BOR_DATA	Table Relationship Diagram
Short Description	Shipment Stucture for Internet

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	TRACKABLE	☐	IST_TRACKABLE	IST_TRACKABLE	CHAR	1	0	Trackability
2	TRACKABLE_BEZ	☐	SIGNI	TEXT20	CHAR	20	0	Container ID
3	TZONE_NODE	☐	C1	CHAR1	CHAR	1	0	Select time frame in units of day
4	TZONE_LOCAL	☐	C1	CHAR1	CHAR	1	0	Select time frame in units of day
5	TRACKABLE_UP	☐	C1	CHAR1	CHAR	1	0	Select time frame in units of day
6	.INCLUDE	☐				0	0	Shipment Header
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	TKNUM	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	SHTYP	☐	SHTYP	SHTYP	CHAR	4	0	Shipment type	TVTK
11	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
14	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
18	STERM	☐	STERM	STERM	CHAR	1	0	Leg determination
19	ABFER	☐	ABFER	ABFER	CHAR	1	0	Shipment completion type
20	ABWST	☐	ABWST	ABWST	CHAR	1	0	Processing control
21	BFART	☐	BFART	BFART	CHAR	1	0	Service level
22	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
23	VSAVL	☐	VSAVL	VERSART	CHAR	2	0	Shipping type of preliminary leg	T173
24	VSANL	☐	VSANL	VERSART	CHAR	2	0	Shipping type of subsequent leg	T173
25	LAUFK	☐	LAUFK	LAUFK	CHAR	1	0	Leg Indicator
26	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
27	ROUTE	☐	ROUTR	ROUTE	CHAR	6	0	Shipment route	TVRO
28	SIGNI	☐	SIGNI	TEXT20	CHAR	20	0	Container ID
29	EXTI1	☐	EXTI1	TEXT20	CHAR	20	0	External identification 1
30	EXTI2	☐	EXTI2	TEXT20	CHAR	20	0	External identification 2
31	TPBEZ	☐	TPBEZ	TEXT20	CHAR	20	0	Description of Shipment
32	STDIS	☐	STDIS	STTRA	CHAR	1	0	Status of transportation planning
33	DTDIS	☐	DTDIS	DATUM	DATS	8	0	Date of end of planning
34	UZDIS	☐	UZDIS	UZEIT	TIMS	6	0	Scheduling end time
35	STREG	☐	STREG	STTRA	CHAR	1	0	Status of check-in
36	DPREG	☐	DPREG	DATUM	DATS	8	0	Planned date of check-in
37	UPREG	☐	UPREG	UZEIT	TIMS	6	0	Planned check-in time
38	DAREG	☐	DAREG	DATUM	DATS	8	0	Actual date of check-in
39	UAREG	☐	UAREG	UZEIT	TIMS	6	0	Current time of check-in
40	STLBG	☐	STLBG	STTRA	CHAR	1	0	Status for start of loading
41	DPLBG	☐	DPLBG	DATUM	DATS	8	0	Planned date for start of loading
42	UPLBG	☐	UPLBG	UZEIT	TIMS	6	0	Planned loading start time
43	DALBG	☐	DALBG	DATUM	DATS	8	0	Current date for start of loading
44	UALBG	☐	UALBG	UZEIT	TIMS	6	0	Actual loading start time
45	STLAD	☐	STLAD	STTRA	CHAR	1	0	Status for end of loading
46	DPLEN	☐	DPLEND	DATUM	DATS	8	0	Planned date for end of loading
47	UPLEN	☐	UPLEND	UZEIT	TIMS	6	0	Planned loading end time
48	DALEN	☐	DALEND	DATUM	DATS	8	0	Actual date for end of loading
49	UALEN	☐	UALEND	UZEIT	TIMS	6	0	Actual loading end time
50	STABF	☐	STABF	STTRA	CHAR	1	0	Status of shipment completion
51	DPABF	☐	DPABF	DATUM	DATS	8	0	Planned date for shipment completion
52	UPABF	☐	UPABF	UZEIT	TIMS	6	0	Planned time for processing
53	DTABF	☐	DTABF	DATUM	DATS	8	0	Current date of shipment completion
54	UZABF	☐	UZABF	UZEIT	TIMS	6	0	Time of transportation processing
55	STTBG	☐	STTBG	STTRA	CHAR	1	0	Status for start of shipment
56	DPTBG	☐	DPTBG	DATUM	DATS	8	0	Planned date for start of shipment
57	UPTBG	☐	UPTBG	UZEIT	TIMS	6	0	Planned transport start time
58	DATBG	☐	DATBG	DATUM	DATS	8	0	Current date for start of shipment
59	UATBG	☐	UATBG	UZEIT	TIMS	6	0	Actual transport start time
60	STTEN	☐	STTEN	STTRA	CHAR	1	0	Status for end of shipment
61	DPTEN	☐	DPTEN	DATUM	DATS	8	0	Planned date for end of shipment
62	UPTEN	☐	UPTEN	UZEIT	TIMS	6	0	Planned transport end time
63	DATEN	☐	DATEND	DATUM	DATS	8	0	Actual Date for End of Shipment
64	UATEN	☐	UATEND	UZEIT	TIMS	6	0	Actual shipment end time
65	STTRG	☐	STTRG	STTRG	CHAR	1	0	Overall transportation status
66	TDLNR	☐	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	LFA1
67	TERNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
68	PKSTK	☐	PKSTK_VTTK	XFELD	CHAR	1	0	Shipment Contains Handling Units
69	DTMEG	☐	DTMEG	MEINS	UNIT	3	0	Unit of Weight for Transportation Planning	*
70	DTMEV	☐	DTMEV	MEINS	UNIT	3	0	Volume Unit for Transportation Planning	*
71	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
72	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
73	FAHZT	☐	FAHZT	FAHZT	QUAN	5	2	Travelling time only between two locations
74	GESZT	☐	GESZT	FAHZT	QUAN	5	2	Total travelling time between two locations incl. breaks
75	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
76	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
77	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
78	FBGST	☐	FBGST	FBGST	CHAR	1	0	Overall status of calculation of shipment costs for shipment
79	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
80	ARGST	☐	ARGST	ARGST	CHAR	1	0	Total status of shipment costs settlement for shipment
81	STERM_DONE	☐	STERM_DONE	STERM_DONE	CHAR	1	0	Leg determination complete
82	VSE_FRK	☐	VSE_FRK	VSE_FRK	CHAR	1	0	Handling Unit Data are Referred in Shipment Cost Document
83	KKALSM	☐	KALSM_KOPF	KALSM	CHAR	6	0	Pricing procedure in shipment header	T683
84	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
85	FRKRL	☐	KFRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
86	GESZTD	☐	KP_GESZTDP	TSTRDURAG	DEC	11	0	Planned total time of transportation (in days)
87	FAHZTD	☐	KP_EFFZTDP	TSTRDURAN	DEC	11	0	Planned duration of transportation (in hours:minutes)
88	GESZTDA	☐	KP_GESZTDA	TSTRDURAG	DEC	11	0	Actual total time of shipment (in days)
89	FAHZTDA	☐	KP_EFFZTDA	TSTRDURAN	DEC	11	0	Actual time needed for transporation (in hours:minutes)
90	ROCPY_DONE	☐	ROCPY_DONE	ROCPY_DONE	CHAR	1	0	Route copied from delivery
91	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
92	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
93	TSEGTP	☐	TSEGTPLVTT	TSEGTEMPLA	CHAR	10	0	Time segment event group shipment header	*
94	ADD01	☐	VTTK_ADD01	VTTK_ADD01	CHAR	10	0	Suppl. 1	VTADD01
95	ADD02	☐	VTTK_ADD02	VTTK_ADD02	CHAR	10	0	Suppl. 2	VTADD02
96	ADD03	☐	VTTK_ADD03	VTTK_ADD03	CHAR	10	0	Suppl. 3	VTADD03
97	ADD04	☐	VTTK_ADD04	VTTK_ADD04	CHAR	10	0	Suppl. 4	VTADD04
98	TEXT1	☐	VTTK_TEXT1	TEXT40	CHAR	40	0	Addit.text 1
99	TEXT2	☐	VTTK_TEXT2	TEXT40	CHAR	40	0	Addit.text 2
100	TEXT3	☐	VTTK_TEXT3	TEXT40	CHAR	40	0	Addit.text 3
101	TEXT4	☐	VTTK_TEXT4	TEXT40	CHAR	40	0	Addit.text 4
102	PROLI	☐	ADGE_PROLI	ADGD_PROLI	CHAR	3	0	Dangerous Goods Management Profile in SD Documents	TDGC5
103	DGTLOCK	☐	ADGE_TLOCK	X	CHAR	1	0	Block Indicator for Dangerous Goods
104	DGMDDAT	☐	ADGE_MDDAT	DATUM	DATS	8	0	Selection date dangerous goods master data
105	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
106	WARZTD	☐	KP_WARZTDP	TSTRDURAN	DEC	11	0	Planned waiting time of shipment (in hours:minutes)
107	WARZTDA	☐	KP_WARZTDA	TSTRDURAN	DEC	11	0	Current waiting time of shipment (in hours:minutes)
108	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	*
109	TNDRST	☐	TNDRST	TNDRST	CHAR	2	0	Tender Status
110	TNDRRC	☐	TNDRRC	TNDRRC	CHAR	2	0	Acceptance Condition/Rejection Reason
111	TNDR_TEXT	☐	TNDR_TEXT	TEXT80	CHAR	80	0	Tendering Text
112	TNDRDAT	☐	TNDRDAT	DATUM	DATS	8	0	Date of tender status
113	TNDRZET	☐	TNDRZET	UZEIT	TIMS	6	0	Time of tender status
114	TNDR_MAXP	☐	TNDR_MAXP	WERT15	CURR	15	2	Maximum Price for Shipment
115	TNDR_MAXC	☐	TNDR_MAXC	WAERS	CUKY	5	0	Currency of Maximum Price	TCURC
116	TNDR_ACTP	☐	TNDR_ACTP	WERT15	CURR	15	2	Actual Shipment Costs for Shipment
117	TNDR_ACTC	☐	TNDR_ACTC	WAERS	CUKY	5	0	Currency of Actual Shipment Costs	TCURC
118	TNDR_CARR	☐	TNDR_CARR	TEXT10	CHAR	10	0	Forwarding Agent Who Accepted the Shipment
119	TNDR_CRNM	☐	TNDR_CRNM	NAME	CHAR	35	0	Name of Carrier Who Accepted the Shipment
120	TNDR_TRKID	☐	TNDR_TRKID	TEXT35	CHAR	35	0	Forwarding Agent Tracking ID
121	TNDR_EXPD	☐	TNDR_EXPD	DATUM	DATS	8	0	Date on Which Offer Expires
122	TNDR_EXPT	☐	TNDR_EXPT	UZEIT	TIMS	6	0	Time at Which Quotation Expires
123	TNDR_ERPD	☐	TNDR_ERPD	DATUM	DATS	8	0	Earliest Pickup Date
124	TNDR_ERPT	☐	TNDR_ERPT	UZEIT	TIMS	6	0	Earliest Pickup Time
125	TNDR_LTPD	☐	TNDR_LTPD	DATUM	DATS	8	0	Latest Pickup Date
126	TNDR_LTPT	☐	TNDR_LTPT	UZEIT	TIMS	6	0	Latest Pickup Time
127	TNDR_ERDD	☐	TNDR_ERDD	DATUM	DATS	8	0	Earliest Delivery Date
128	TNDR_ERDT	☐	TNDR_ERDT	UZEIT	TIMS	6	0	Earliest Delivery Time
129	TNDR_LTDD	☐	TNDR_LTDD	DATUM	DATS	8	0	Latest Delivery Date
130	TNDR_LTDT	☐	TNDR_LTDT	UZEIT	TIMS	6	0	Latest Delivery Time
131	TNDR_LDLG	☐	TNDR_LDLG	MENG13	QUAN	13	3	Length of Loading Platform
132	TNDR_LDLU	☐	TNDR_LDLU	MEINS	UNIT	3	0	Unit of Measure for Load Length	*
133	KZHULFR	☐	KZHULFR	KZHULFR	CHAR	1	0	Indicator: HUs Relevant for Delivery Item Generation
134	ALLOWED_TWGT	☐	ALLOWED_TWGT	MENG12_0	QUAN	8	0	Allowed total weight of shipment
135	VLSTK	☐	VLSTK	VLSTK	CHAR	1	0	Distribution Status (Decentralized Warehouse Processing)
136	VERURSYS	☐	TRA_VERURSYS	LOGSYS	CHAR	10	0	Shipment Distribution: Original System	*
137	CM_IDENT	☐	CMIDENTIFIER	CHAR12	CHAR	12	0	Identification Number for Continuous Moves
138	CM_SEQUENCE	☐	CMSEQUENCE	SEQUENCE1	NUMC	4	0	Sequence of Transports in Connecting Traffice
139	EXT_FREIGHT_ORD	☐	EXT_FREIGHT_ORDER	EXT_FREIGHT_ORDER	CHAR	20	0	External Freight Order ID
140	EXT_TM_SYS	☐	SLD_BSKEY	SLD_BSKEY	CHAR	60	0	Key Name of Business System
141	.INCLU--AP	☐				0	0	Extension of Shipment Header (Transportation Planning)
142	.INCLUDE	☐				0	0	Include Transportation Planning Staff and Vehicles
143	/BEV1/RPFAR1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
144	/BEV1/RPFAR2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
145	/BEV1/RPMOWA	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	*
146	/BEV1/RPANHAE	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	*
147	/BEV1/RPFLGNR	☐	/DSD/RP_SEQUENCENR	/DSD/RP_SEQUENCENR	NUMC	5	0	Loading Sequence Number in the Tour
148	.INCLU--AP	☐				0	0	Append to VTTK for VSO
149	.INCLUDE	☐				0	0	Include for Append to VTTK for VSO
150	/VSO/R_STATUS	☐	/VSO/M_VSO_STATUS	/VSO/M_VSO_STATUS	CHAR	1	0	Status of Vehicle Space Optimization
151	VTTP_TAB	☐	VTTPVB_TAB		TTYP	0	0
152	VTTS_TAB	☐	VTTSVB_TAB		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISI_BOR_DATA	/BEV1/RPFAR1	KNA1	KUNNR
2	ISI_BOR_DATA	/BEV1/RPFAR2	KNA1	KUNNR
3	ISI_BOR_DATA	ADD01	VTADD01	ADD_INFO
4	ISI_BOR_DATA	ADD02	VTADD02	ADD_INFO
5	ISI_BOR_DATA	ADD03	VTADD03	ADD_INFO
6	ISI_BOR_DATA	ADD04	VTADD04	ADD_INFO
7	ISI_BOR_DATA	KKALSM	T683	KALSM
8	ISI_BOR_DATA	MANDT	T000	MANDT
9	ISI_BOR_DATA	PROLI	TDGC5	PROLI
10	ISI_BOR_DATA	ROUTE	TVRO	ROUTE
11	ISI_BOR_DATA	SDABW	TVSAK	SDABW
12	ISI_BOR_DATA	SHTYP	TVTK	SHTYP
13	ISI_BOR_DATA	TDLNR	LFA1	LIFNR	REF	1	CN
14	ISI_BOR_DATA	TNDR_ACTC	TCURC	WAERS	REF	1	CN
15	ISI_BOR_DATA	TNDR_MAXC	TCURC	WAERS	REF	1	CN
16	ISI_BOR_DATA	TPLST	TTDS	TPLST
17	ISI_BOR_DATA	VSANL	T173	VSART
18	ISI_BOR_DATA	VSART	T173	VSART
19	ISI_BOR_DATA	VSAVL	T173	VSART
20	ISI_BOR_DATA	VSBED	TVSB	VSBED

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2