SAP ABAP Table V_OI0BW_OIGSV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OI0BW_OIGSV	Table Relationship Diagram
Short Description	Generated Table for View

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SHNUMBER	☑	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number
3	VEH_NR	☑	OIG_VEHNR	OIG_VEHNR	NUMC	3	0	Vehicle Sequence Number in Shipment
4	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
5	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
6	VEH_MODE	☐	OIG_VMOT	OIG_VMOT	CHAR	1	0	TD vehicle mode of transport
7	FKART	☐	FKART_T	FKART_T	CHAR	4	0	Shipment cost type
8	FRKRL_VEH	☐	OIG_FRKRLV	FRKRL	CHAR	1	0	TD - shipment cost relevance for vehicles
9	SCLDTYPE	☐	OIG_STYPE	OIG_STYPE	CHAR	1	0	TD-F -Shipment costing based on loaded or disch. quantitites
10	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
11	CRE_NAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	CRE_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	CRE_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
14	CHA_NAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	CHA_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	CHA_TIME	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
17	OIG_SSTSF	☐	OIG_SSTSF	OIG_SSTSF	CHAR	1	0	TD Shipment Status (Functional)
18	LOAD_STDTA	☐	OIG_LDSTDA	DATUM	DATS	8	0	Date for start of loading
19	LOAD_STTMA	☐	OIG_LDSTTA	UZEIT	TIMS	6	0	Actual time for start of loading
20	LOAD_EDDTA	☐	OIG_LDEDDA	DATUM	DATS	8	0	Actual date for end of loading
21	LOAD_EDTMA	☐	OIG_LDEDTA	UZEIT	TIMS	6	0	Actual time for end of loading
22	DEL_STDTA	☐	OIG_DESTDA	DATUM	DATS	8	0	Actual date for start of delivery confirmation
23	DEL_STTMA	☐	OIG_DESTTA	UZEIT	TIMS	6	0	Actual time for start of delivery confirmation
24	DEL_EDDTA	☐	OIG_DEEDDA	DATUM	DATS	8	0	Actual date for end of delivery confirm
25	DEL_EDTMA	☐	OIG_DEEDTA	UZEIT	TIMS	6	0	Actual time for end of delivery confirmation
26	FBGST	☐	FBGST	FBGST	CHAR	1	0	Overall status of calculation of shipment costs for shipment
27	ARGST	☐	ARGST	ARGST	CHAR	1	0	Total status of shipment costs settlement for shipment
28	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
29	COMP_GROUP	☐	OIG_VEHCUSTGRP	OIG_VCG	CHAR	8	0	TD Vehicle Customer group	TOIGBV
30	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	TOIGV
31	VEH_ID	☐	OIG_VEHID	OIG_LICNMR	CHAR	18	0	TD vehicle identifier
32	CARRIER	☐	OIG_LIFNR	LIFNR	CHAR	10	0	TD carrier (vendor account number)	LFA1
33	VEH_NRTUS	☐	OIG_NMRTU	OIG_NMRTU	NUMC	2	0	Number of transport units on vehicle (TD)
34	EQUIP_NR_V	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
35	ROUTE	☐	OIG_ROUTEV	ROUTE	CHAR	6	0	TD-F vehicle route	TVRO
36	LDDATE	☐	OIG_LDDATE	DATUM	DATS	8	0	Loading Date
37	LDTIME	☐	OIG_LDTIME	TIME	TIMS	6	0	Loading time
38	SHIFT	☐	OIG_SHIFT	OIG_SHIFT	CHAR	1	0	TD driver shift	TOIGH
39	TRIP	☐	OIG_TRIP	OIG_TRIP	NUMC	5	0	Trip Number
40	RTDATE	☐	OIG_RTDATE	DATUM	DATS	8	0	Date of return
41	RTTIME	☐	OIG_RTTIME	TIME	TIMS	6	0	Time of return
42	DDCDAT	☐	OIG_DDCDAT	DATUM	DATS	8	0	Document date in delivery confirmation
43	PSTDAT	☐	OIG_PSTDAT	DATUM	DATS	8	0	Posting date in delivery confirmation
44	FBGST_V	☐	OIG_VFBGST	FBGST	CHAR	1	0	Overall status of shipment costing vehicle level
45	ARGST_V	☐	OIG_VARGST	ARGST	CHAR	1	0	Overall status of shipment cost settlement vehicle level

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OI0BW_OIGSV	CARRIER	LFA1	LIFNR
2	V_OI0BW_OIGSV	CLIENT	T000	MANDT
3	V_OI0BW_OIGSV	COMP_GROUP	TOIGBV	GROUPNAME
4	V_OI0BW_OIGSV	EQUIP_NR_V	EQUI	EQUNR
5	V_OI0BW_OIGSV	ROUTE	TVRO	ROUTE
6	V_OI0BW_OIGSV	SHIFT	TOIGH	SHIFT
7	V_OI0BW_OIGSV	SHTYPE	TOIGS	SHTYP
8	V_OI0BW_OIGSV	TPLST	TTDS	TPLST
9	V_OI0BW_OIGSV	VEHICLE	OIGV	VEHICLE	KEY	1	CN
10	V_OI0BW_OIGSV	VEH_TYPE	TOIGV	VEH_TYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in