SAP ABAP Table ROIKTPS (OIL-TPI: External TPS configuration information)

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	ROIKTPS	Table Relationship Diagram
Short Description	OIL-TPI: External TPS configuration information

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	Organizational Unit: Transportation Scheduling Point
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	*
4	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
5	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
6	TPSID	☐	TPSID	COMMN	CHAR	5	0	ID for external transport system	TQCOM
7	VTPARN	☐	EDI_VTPARN	EDI_PARNUM	CHAR	10	0	Partner number of external transportation planning system	*
8	VTPART	☐	EDI_VTPART	EDI_RCVPRT	CHAR	2	0	Partner type of external transportation planning system	*
9	KSCHL	☐	NA_KSCHL_T	KSCHL	CHAR	4	0	Output type for transportation planning systems	T685
10	NKETP	☐	NKETP	NUMKR	CHAR	2	0	External no.range for external transporation planning system
11	TRAEND	☐	TRAEND	TRAEND	CHAR	2	0	Controlling for changes to externally planned shipments
12	STTRG	☐	STTRG_TPS	STTRG	CHAR	1	0	Overall status of a shipment for which plan. end is set
13	TPSSF	☐	TPSSF	TPSSF	CHAR	1	0	Status filtering mode for TPS
14	TPSTX1	☐	VTPS_LFTX	TDID	CHAR	4	0	Delivery header text ID for transferral to ext. trans.pl.sys	*
15	TPSTX2	☐	VTPS_LFTX	TDID	CHAR	4	0	Delivery header text ID for transferral to ext. trans.pl.sys	*
16	TPSTX3	☐	VTPS_LFTX	TDID	CHAR	4	0	Delivery header text ID for transferral to ext. trans.pl.sys	*
17	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
18	STAGEW	☐	STAGEW	MEINS	UNIT	3	0	Weight unit for statistics update	T006
19	STAVOL	☐	STAVOL	MEINS	UNIT	3	0	Volume unit for statistics update	T006
20	STADIS	☐	STADIS	MEINS	UNIT	3	0	Distance unit for statistics update	T006
21	STACUR	☐	STACUR	WAERS	CUKY	5	0	Currency Unit for Statistical Update	TCURC
22	.INCLUDE	☐				0	0	OIL-TPI: Configuration relevant fields from EDPP1
23	CLASS	☐	EDIPCLASS	CHAR3	CHAR	3	0	Partner class
24	MATLVL	☐	EDIPMATLVL	EDIPMATLVL	CHAR	1	0	Status of partner profile	*
25	TEST	☐	EDIPTEST	EDI_FLAG	CHAR	1	0	Flag for test mode
26	ARCHIV	☐	EDIPARCHIV	EDIPARCHIV	CHAR	1	0	Documents available?
27	USRTYP	☐	EDIPUSRTYP	CHAR10	CHAR	10	0	User Type
28	USRKEY	☐	EDIPUSRKEY	TEXT70	CHAR	70	0	Permitted users: ID
29	USRLNG	☐	EDIPUSRLNG	SPRAS	LANG	1	0	Language of notification	*
30	.INCLUDE	☐				0	0	OIL-TPI: Common Configuration Data for External TPS
31	TPSCON	☐	OIK_TPSCON	OIK_TPSCON	CHAR	8	0	OIL-TPI: External TPS Control Settings (8-Flag String)
32	SHTYP	☐	OIK_TDSTYP	OIG_TDSTYP	CHAR	4	0	OIL-TPI: Default Bulk Shipment Type for Inbound Shipments	*
33	TPSTSO	☐	OIK_TPSTSO	OIK_TPSTS	CHAR	1	0	OIL-TPI: Tank ID Req Mode - Sales Order
34	TPSTSD	☐	OIK_TPSTSD	OIK_TPSTS	CHAR	1	0	OIL-TPI: Tank ID Req Mode - Delivery
35	TPSTDC	☐	OIK_TPSTSC	OIK_TPSTS	CHAR	1	0	OIL-TPI: Tank ID Req Mode - Delivery Confirmation
36	.INCLUDE	☐				0	0	OIL-TPI: Units of Measure Set for External TPS
37	UOMVOL	☐	OIK_UOMVOL	MEINS	UNIT	3	0	OIL-TPI: Volume Unit of Measure Used by External TPS	*
38	UOMMAS	☐	OIK_UOMMAS	MEINS	UNIT	3	0	OIL-TPI: Weight Unit of Measure Used by External TPS	*
39	UOMLEN	☐	OIK_UOMLEN	MEINS	UNIT	3	0	OIL-TPI: Length Unit of Measure Used by External TPS	*
40	UOMVFR	☐	OIK_UOMVFR	MEINS	UNIT	3	0	OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS	*
41	UOMMFR	☐	OIK_UOMMFR	MEINS	UNIT	3	0	OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS	*
42	UOMTIM	☐	OIK_UOMTIM	MEINS	UNIT	3	0	OIL-TPI: Time Unit of Measure Used by External TPS	*
43	UOMTMP	☐	OIK_UOMTMP	MEINS	UNIT	3	0	OIL-TPI: Temperature Unit of Measure Used by External TPS	*
44	UOMDIS	☐	OIK_UOMDIS	MEINS	UNIT	3	0	OIL-TPI: Distance Unit of Measure Used by External TPS	*
45	DLOCTP	☐	OIK_DLOCTP	EDI_VTTRMT	CHAR	2	0	OIL-TPI: Default Receiving Location Type
46	DABTNR	☐	OIK_DABTNR	ABTNR	CHAR	4	0	OIL-TPI: Default Contact Person Department	*
47	DPARFN	☐	OIK_DPARFN	OIF_PARFN	CHAR	4	0	OIL-TPI: Default MRN Partner Role/Relation Type	*
48	IFWAIT	☐	OIK_IFWAIT	NUM06	NUMC	6	0	OIL-TPI: Interface Wait Time Between Retries (in Seconds)
49	IFRTRY	☐	OIK_IFRTRY	NUM03	NUMC	3	0	OIL-TPI: Number of Transmission Retries Before Termination
50	KSCHL_O	☐	NA_KSCHL_T	KSCHL	CHAR	4	0	Output type for transportation planning systems	*
51	DR_VEH	☐	OIK_DR_VEH	X	CHAR	1	0	OIL-TPI: Deactivate Driver/Vehicle Assignment
52	EXT_NUM	☐	OIK_EXT_NUM	XFELD	CHAR	1	0	OIL-TPI: Use External Number for Document Creation
53	OIK_EQ_A	☐	OIK_EQ_A	X	CHAR	1	0	OIL-TPI: Check equal assignm. with loading or sched. date
54	MAX_STAT	☐	OIK_MAX_STAT	OIG_SSTSF	CHAR	1	0	OIL-TPI: Max. Default Status
55	MANETA	☐	OIK_MANETA	XCHAR	CHAR	1	0	OIL-TPI: Manual Entry of ETA In SPW
56	DEFTRIP	☐	OIK_DEFTRIP	XCHAR	CHAR	1	0	OIL-TPI: Don't default trip sequence in SPW
57	DISPSUM	☐	OIK_DISPSUM	XCHAR	CHAR	1	0	OIL-TPI: Don't show the quantity sum line in SPW

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIKTPS	BUKRS	T001	BUKRS	REF	1	CN
2	ROIKTPS	FABKL	TFACD	IDENT	REF	C	CN
3	ROIKTPS	KSCHL	T685	KSCHL	REF	C	CN
4	ROIKTPS	MANDT	T000	MANDT	KEY	1	CN
5	ROIKTPS	STACUR	TCURC	WAERS
6	ROIKTPS	STADIS	T006	MSEHI
7	ROIKTPS	STAGEW	T006	MSEHI
8	ROIKTPS	STAVOL	T006	MSEHI
9	ROIKTPS	TPSID	TQCOM	COMMN	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in