SAP ABAP Table ROIKPEXORD (OIL-TPI: Status of orders within external TPS (update))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

Table Category	INTTAB	Structure
Structure	ROIKPEXORD	Table Relationship Diagram
Short Description	OIL-TPI: Status of orders within external TPS (update)

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	Status of Orders Within Transportation Planning
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
4	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
5	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
6	STATE	☐	OIK_STATE	OIK_STATE	NUMC	2	0	Status of a document in transport planning
7	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
8	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
9	DTCON	☐	VTDTCON	VTDTCON	NUMC	2	0	Transition requirements for status sequence of deliveries
10	LOCCL1	☐	EDI_VTTRMT	EDI_VTTRMT	CHAR	2	0	Location category of generalized location
11	LOCID1	☐	EDI_VTLCID	CHAR10	CHAR	10	0	General location number
12	SUBID1	☐	EDI_VTLSID	CHAR35	CHAR	35	0	Location addition for general location
13	ADRNR1	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
14	LOCCL2	☐	EDI_VTTRMT	EDI_VTTRMT	CHAR	2	0	Location category of generalized location
15	LOCID2	☐	EDI_VTLCID	CHAR10	CHAR	10	0	General location number
16	SUBID2	☐	EDI_VTLSID	CHAR35	CHAR	35	0	Location addition for general location
17	ADRNR2	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
18	DPTBG	☐	DPTBGS	DATUM	DATS	8	0	Stage: Planned date for start of shipment
19	UPTBG	☐	UPTBGS	UZEIT	TIMS	6	0	Stage: Planned shipment start time
20	TZONBG	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
21	DPTEN	☐	DPTENS	DATUM	DATS	8	0	Stage: Planned date for end of shipment
22	UPTEN	☐	UPTENS	UZEIT	TIMS	6	0	Stage: Planned shipemnt end time
23	TZONEN	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
24	UPD_FLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIKPEXORD	MANDT	T000	MANDT
2	ROIKPEXORD	POSNR	VBUP	POSNR
3	ROIKPEXORD	TPLST	TTDS	TPLST
4	ROIKPEXORD	VBELN	VBUK	VBELN

History

Last changed by/on	SAP	20110901
SAP Release Created in