SAP ABAP Table OIKPEXORD (Status of Orders Within Transportation Planning)

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	TRANSP	Transparent table
Transparent table	OIKPEXORD	Table Relationship Diagram
Short Description	Status of Orders Within Transportation Planning

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in