1. Home
  2. Resources
  3. SAP Tables
  4. ROIKTPS - OIL-TPI: External TPS configuration information

SAP Table ROIKTPS

OIL-TPI: External TPS configuration information

ROIKTPS (OIL-TPI: External TPS configuration information) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIKTPS to other SAP tables.

ROIKTPS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TPLST Transportation planning point TPLST CHAR 4 0
FABKL Factory calendar key FABKL TFACD CHAR 2 0
ADRNR Address ADRNR CHAR 10 0
TPSID ID for external transport system TPSID TQCOM CHAR 5 0
VTPARN Partner number of external transportation planning system EDI_VTPARN CHAR 10 0
VTPART Partner type of external transportation planning system EDI_VTPART CHAR 2 0
KSCHL Output type for transportation planning systems NA_KSCHL_T T685 CHAR 4 0
NKETP External no.range for external transporation planning system NKETP CHAR 2 0
TRAEND Controlling for changes to externally planned shipments TRAEND CHAR 2 0
00 No restrictions for changes
01 No change relevant to planning; only the service agent
02 No change relevant to planning allowed
STTRG Overall status of a shipment for which plan. end is set STTRG_TPS CHAR 1 0
0 Planned
1 Planning completed
2 Check-in
3 Loading start
4 Loading end
5 Shipment completion
6 Shipment start
7 Shipment end
TPSSF Status filtering mode for TPS TPSSF CHAR 1 0
NULL No confirmation to TPS
1 Error message to TPS
2 Error and Success message to TPS
TPSTX1 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
TPSTX2 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
TPSTX3 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
STAGEW Weight unit for statistics update STAGEW T006 UNIT 3 0
STAVOL Volume unit for statistics update STAVOL T006 UNIT 3 0
STADIS Distance unit for statistics update STADIS T006 UNIT 3 0
STACUR Currency Unit for Statistical Update STACUR TCURC CUKY 5 0
CLASS Partner class EDIPCLASS CHAR 3 0
MATLVL Status of partner profile EDIPMATLVL CHAR 1 0
TEST Flag for test mode EDIPTEST CHAR 1 0
NULL Blank
X Selection flag
ARCHIV Documents available? EDIPARCHIV CHAR 1 0
NULL No partner profile in archive
X Partner profile exists in archive
USRTYP User Type EDIPUSRTYP CHAR 10 0
USRKEY Permitted users: ID EDIPUSRKEY CHAR 70 0
USRLNG Language of notification EDIPUSRLNG LANG 1 0
TPSCON OIL-TPI: External TPS Control Settings (8-Flag String) OIK_TPSCON CHAR 8 0
SHTYP OIL-TPI: Default Bulk Shipment Type for Inbound Shipments OIK_TDSTYP CHAR 4 0
TPSTSO OIL-TPI: Tank ID Req Mode - Sales Order OIK_TPSTSO CHAR 1 0
NULL Tank ID specification not supported
1 Tank ID specification optional
2 Tank ID specification mandatory
TPSTSD OIL-TPI: Tank ID Req Mode - Delivery OIK_TPSTSD CHAR 1 0
NULL Tank ID specification not supported
1 Tank ID specification optional
2 Tank ID specification mandatory
TPSTDC OIL-TPI: Tank ID Req Mode - Delivery Confirmation OIK_TPSTSC CHAR 1 0
NULL Tank ID specification not supported
1 Tank ID specification optional
2 Tank ID specification mandatory
UOMVOL OIL-TPI: Volume Unit of Measure Used by External TPS OIK_UOMVOL UNIT 3 0
UOMMAS OIL-TPI: Weight Unit of Measure Used by External TPS OIK_UOMMAS UNIT 3 0
UOMLEN OIL-TPI: Length Unit of Measure Used by External TPS OIK_UOMLEN UNIT 3 0
UOMVFR OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS OIK_UOMVFR UNIT 3 0
UOMMFR OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS OIK_UOMMFR UNIT 3 0
UOMTIM OIL-TPI: Time Unit of Measure Used by External TPS OIK_UOMTIM UNIT 3 0
UOMTMP OIL-TPI: Temperature Unit of Measure Used by External TPS OIK_UOMTMP UNIT 3 0
UOMDIS OIL-TPI: Distance Unit of Measure Used by External TPS OIK_UOMDIS UNIT 3 0
DLOCTP OIL-TPI: Default Receiving Location Type OIK_DLOCTP CHAR 2 0
PL Plant
CU Customer
SU Vendor
OC One-time customer
NO Transport.connect.pt
SP Shipping point
CA Carrier
OS One-time vendor
DABTNR OIL-TPI: Default Contact Person Department OIK_DABTNR CHAR 4 0
DPARFN OIL-TPI: Default MRN Partner Role/Relation Type OIK_DPARFN CHAR 4 0
IFWAIT OIL-TPI: Interface Wait Time Between Retries (in Seconds) OIK_IFWAIT NUMC 6 0
IFRTRY OIL-TPI: Number of Transmission Retries Before Termination OIK_IFRTRY NUMC 3 0
KSCHL_O Output type for transportation planning systems NA_KSCHL_T CHAR 4 0
DR_VEH OIL-TPI: Deactivate Driver/Vehicle Assignment OIK_DR_VEH CHAR 1 0
X Yes
NULL No
EXT_NUM OIL-TPI: Use External Number for Document Creation OIK_EXT_NUM CHAR 1 0
X Yes
NULL No
OIK_EQ_A OIL-TPI: Check equal assignm. with loading or sched. date OIK_EQ_A CHAR 1 0
X Yes
NULL No
MAX_STAT OIL-TPI: Max. Default Status OIK_MAX_STAT CHAR 1 0
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
MANETA OIL-TPI: Manual Entry of ETA In SPW OIK_MANETA CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist
DEFTRIP OIL-TPI: Don't default trip sequence in SPW OIK_DEFTRIP CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist
DISPSUM OIL-TPI: Don't show the quantity sum line in SPW OIK_DISPSUM CHAR 1 0
X Entry Exists
NULL Entry Does Not Exist

ROIKTPS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIKTPS BUKRS ROIKTPS BUKRS T001 Company Codes BUKRS
ROIKTPS BUKRS ROIKTPS MANDT T001 Company Codes MANDT
ROIKTPS FABKL ROIKTPS FABKL TFACD Factory calendar definition IDENT
ROIKTPS KSCHL ROIKTPS KSCHL T685 Conditions: Types KSCHL
ROIKTPS KSCHL ROIKTPS MANDT T685 Conditions: Types MANDT
ROIKTPS KSCHL 'B' T685 Conditions: Types KVEWE
ROIKTPS KSCHL 'V2' T685 Conditions: Types KAPPL
ROIKTPS MANDT ROIKTPS MANDT T000 Clients MANDT
ROIKTPS STACUR ROIKTPS MANDT TCURC Currency Codes MANDT
ROIKTPS STACUR ROIKTPS STACUR TCURC Currency Codes WAERS
ROIKTPS STADIS ROIKTPS MANDT T006 Units of Measurement MANDT
ROIKTPS STADIS ROIKTPS STADIS T006 Units of Measurement MSEHI
ROIKTPS STAGEW ROIKTPS MANDT T006 Units of Measurement MANDT
ROIKTPS STAGEW ROIKTPS STAGEW T006 Units of Measurement MSEHI
ROIKTPS STAVOL ROIKTPS MANDT T006 Units of Measurement MANDT
ROIKTPS STAVOL ROIKTPS STAVOL T006 Units of Measurement MSEHI
ROIKTPS TPSID ROIKTPS TPSID TQCOM Assignment of Communication No. to Logical Queue ID (APPQ) COMMN