SAP ABAP Table ROIGSS (Internal table for 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	ROIGSS	Table Relationship Diagram
Short Description	Internal table for 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	.INCLUDE	☐				0	0	TD Shipment Stages
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SHNUMBER	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	OIGS
4	TSNUM	☐	TSNUM	TSNUM	NUMC	4	0	Stage of transport number	*
5	TSTYP	☐	TSTYP	TSTYP	CHAR	1	0	Stage category
6	TSRFO	☐	TSRFO	TSRFO	NUMC	4	0	Stage of transport sequence
7	VEH_NR	☐	OIG_VEHNR	OIG_VEHNR	NUMC	3	0	Vehicle Sequence Number in Shipment	*
8	ELUPD	☐	ELUPD	ELUPD	CHAR	1	0	Change Indicator
9	CRE_NAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	CRE_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	CRE_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
12	CHA_NAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	CHA_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	CHA_TIME	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
15	ROUTE	☐	ROUTES	ROUTE	CHAR	6	0	Route for shipment stage	TVRO
16	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
17	LAUFK	☐	LAUFS	LAUFK	CHAR	1	0	Leg indicator for shipment stage
18	ADRNA	☐	ADRNA	ADRNR	CHAR	10	0	Departure point: Address	*
19	KNOTA	☐	KNOTA	KNOTN	CHAR	10	0	Departure Point	TVKN
20	VSTEL	☐	VSTELA	VSTEL	CHAR	4	0	Shipping point at point of departure	TVST
21	LSTEL	☐	LSTELA	LSTEL	CHAR	2	0	Point of departure: Loading point at shipping point	TVLA
22	WERKA	☐	WERKSA	WERKS	CHAR	4	0	Plant at point of departure	T001W
23	LGORTA	☐	LGORTA	LGORT	CHAR	4	0	Departure point: Storage location in plant	T001L
24	KUNNA	☐	KUNNA	KUNNR	CHAR	10	0	Departure point: Customer	KNA1
25	LIFNA	☐	LIFNA	LIFNR	CHAR	10	0	Vendor number of departure point	LFA1
26	ADRNZ	☐	ADRNZ	ADRNR	CHAR	10	0	Destination address	*
27	KNOTZ	☐	KNOTZ	KNOTN	CHAR	10	0	Destination point	TVKN
28	VSTEZ	☐	VSTELZ	VSTEL	CHAR	4	0	Shipping point at destination	TVST
29	LSTEZ	☐	LSTELZ	LSTEL	CHAR	2	0	Destination: Loading point at shipping point	TVLA
30	WERKZ	☐	WERKSZ	WERKS	CHAR	4	0	Plant at destination point	T001W
31	LGORTZ	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	T001L
32	KUNNZ	☐	KUNNZ	KUNNR	CHAR	10	0	Customer number for destination point	KNA1
33	LIFNZ	☐	LIFNZ	LIFNR	CHAR	10	0	Vendor number of destination point	LFA1
34	TDLNR	☐	TDLNRS	LIFNR	CHAR	10	0	Number of forwarding agent in the shipment stage	LFA1
35	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
36	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
37	OIG_GESZTD	☐	OIG_GESZTD	OIG_GESZT	QUAN	13	2	Total time for stage
38	OIG_FAHZTD	☐	OIG_FAHZTD	OIG_GESZT	QUAN	13	2	Total travel time for stage
39	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	*
40	ADRKNZA	☐	ADRKNZA	ADRKNZ	CHAR	1	0	Point of departure: Origin indicator of address
41	KUNABLA	☐	KUNABLA	TEXT25	CHAR	25	0	Point of departure: Customer's unloading point	KNVA
42	ADRKNZZ	☐	ADRKNZZ	ADRKNZ	CHAR	1	0	Destination: Origin indicator of address
43	KUNABLZ	☐	KUNABLZ	TEXT25	CHAR	25	0	Destination: Customer's unloading point	KNVA
44	FRKRL	☐	FRKRL	FRKRL	CHAR	1	0	Shipment costs relevance
45	SKALSM	☐	KALSM_TRAB	KALSM	CHAR	6	0	Pricing procedure in stage of shipment	T683
46	FBSTA	☐	FBSTA	FBSTA	CHAR	1	0	Status of shipment costs calculation
47	ARSTA	☐	ARSTA	ARSTA	CHAR	1	0	Status of shipment costs settlement
48	VEH_IND	☐	OIG_VEHIND	OIG_VEHIND	CHAR	1	0	TD-F: Vehicle stage indicator with first and last node
49	CARR_ROUT	☐	OIG_CRROUT	XFELD	CHAR	1	0	TD-F carrier is copied from route / stage table
50	GESZTD	☐	OIGGESZTDP	TSTRDURAG	DEC	11	0	TD Planned total time for stage (in days)
51	FAHZTD	☐	OIGEFFZTDP	TSTRDURAN	DEC	11	0	TD - planned duration for stage (in hours:minutes)
52	GESZTDA	☐	OIGGESZTDA	TSTRDURAG	DEC	11	0	TD - actual total time for shipment stage (in days)
53	FAHZTDA	☐	OIGEFFZTDA	TSTRDURAN	DEC	11	0	TD - actual duration for shipment stage (in hours:minutes)
54	CONT_DG	☐	ADGE_SCDG	X	CHAR	1	0	Indicator: Section contains dangerous goods
55	TSTYP_TXT	☐	OIG_TYPTXT	CHAR30	CHAR	30	0	Description of stage type
56	DEPFLAG	☐	OIG_STGFLG	CHAR1_X	CHAR	1	0	TD-F flag if stage is used as dep. or destination point
57	DESTFLAG	☐	OIG_STGFLG	CHAR1_X	CHAR	1	0	TD-F flag if stage is used as dep. or destination point
58	FRKRLFLAG	☐	OIG_FRKFLG	CHAR1_X	CHAR	1	0	TD-F flag: if SCD-relevance is set for TSTYP
59	DESCNODEA	☐	BEZEI30	TEXT30	CHAR	30	0	Description
60	DESCNODEZ	☐	BEZEI30	TEXT30	CHAR	30	0	Description
61	UPDATEFLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIGSS	CLIENT	T000	MANDT
2	ROIGSS	KNOTA	TVKN	KNOTE
3	ROIGSS	KNOTZ	TVKN	KNOTE
4	ROIGSS	KUNABLA	KNVA	ABLAD
5	ROIGSS	KUNABLZ	KNVA	ABLAD
6	ROIGSS	KUNNA	KNA1	KUNNR
7	ROIGSS	KUNNZ	KNA1	KUNNR
8	ROIGSS	LGORTA	T001L	LGORT
9	ROIGSS	LGORTZ	T001L	LGORT
10	ROIGSS	LIFNA	LFA1	LIFNR
11	ROIGSS	LIFNZ	LFA1	LIFNR
12	ROIGSS	LSTEL	TVLA	LSTEL
13	ROIGSS	LSTEZ	TVLA	LSTEL	REF	C	CN
14	ROIGSS	ROUTE	TVRO	ROUTE
15	ROIGSS	SHNUMBER	OIGS	SHNUMBER		1	CN
16	ROIGSS	SKALSM	T683	KALSM
17	ROIGSS	TDLNR	LFA1	LIFNR
18	ROIGSS	VSART	T173	VSART		1	CN
19	ROIGSS	VSTEL	TVST	VSTEL
20	ROIGSS	VSTEZ	TVST	VSTEL
21	ROIGSS	WERKA	T001W	WERKS
22	ROIGSS	WERKZ	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in