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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TPLST Transportation planning point CHAR 4 0 * TPLST
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
ADRNR Address CHAR 10 0 * ADRNR
TPSID ID for External Transport System CHAR 5 0 TQCOM TPSID
VTPARN Partner number of external transportation planning system CHAR 10 0 * EDI_VTPARN
VTPART Partner type of external transportation planning system CHAR 2 0 * EDI_VTPART
KSCHL Output type for transportation planning systems CHAR 4 0 T685 NA_KSCHL_T
NKETP External no.range for external transporation planning system CHAR 2 0 NKETP
TRAEND Controlling for changes to externally planned shipments CHAR 2 0 TRAEND
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 CHAR 1 0 STTRG_TPS
TPSSF Status filtering mode for TPS CHAR 1 0 TPSSF
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 CHAR 4 0 * VTPS_LFTX
TPSTX2 Delivery header text ID for transferral to ext. trans.pl.sys CHAR 4 0 * VTPS_LFTX
TPSTX3 Delivery header text ID for transferral to ext. trans.pl.sys CHAR 4 0 * VTPS_LFTX
BUKRS Company Code CHAR 4 0 T001 BUKRS
STAGEW Weight unit for statistics update UNIT 3 0 T006 STAGEW
STAVOL Volume unit for statistics update UNIT 3 0 T006 STAVOL
STADIS Distance unit for statistics update UNIT 3 0 T006 STADIS
STACUR Currency Unit for Statistical Update CUKY 5 0 TCURC STACUR
CLASS Partner class CHAR 3 0 EDIPCLASS
MATLVL Status of partner profile CHAR 1 0 * EDIPMATLVL
TEST Flag for test mode CHAR 1 0 EDIPTEST
ARCHIV Documents exist? CHAR 1 0 EDIPARCHIV
No partner profile in archive
X Partner profile exists in archive
USRTYP User Type CHAR 10 0 EDIPUSRTYP
USRKEY Permitted users: ID CHAR 70 0 EDIPUSRKEY
USRLNG Language of notification LANG 1 0 * EDIPUSRLNG
TPSCON OIL-TPI: External TPS Control Settings (8-Flag String) CHAR 8 0 OIK_TPSCON
SHTYP OIL-TPI: Default Bulk Shipment Type for Inbound Shipments CHAR 4 0 * OIK_TDSTYP
TPSTSO OIL-TPI: Tank ID Req Mode - Sales Order CHAR 1 0 OIK_TPSTSO
TPSTSD OIL-TPI: Tank ID Req Mode - Delivery CHAR 1 0 OIK_TPSTSD
TPSTDC OIL-TPI: Tank ID Req Mode - Delivery Confirmation CHAR 1 0 OIK_TPSTSC
UOMVOL OIL-TPI: Volume Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMVOL
UOMMAS OIL-TPI: Weight Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMMAS
UOMLEN OIL-TPI: Length Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMLEN
UOMVFR OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS UNIT 3 0 * OIK_UOMVFR
UOMMFR OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS UNIT 3 0 * OIK_UOMMFR
UOMTIM OIL-TPI: Time Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMTIM
UOMTMP OIL-TPI: Temperature Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMTMP
UOMDIS OIL-TPI: Distance Unit of Measure Used by External TPS UNIT 3 0 * OIK_UOMDIS
DLOCTP OIL-TPI: Default Receiving Location Type CHAR 2 0 OIK_DLOCTP
DABTNR OIL-TPI: Default Contact Person Department CHAR 4 0 * OIK_DABTNR
DPARFN OIL-TPI: Default MRN Partner Role/Relation Type CHAR 4 0 * OIK_DPARFN
IFWAIT OIL-TPI: Interface Wait Time Between Retries (in Seconds) NUMC 6 0 OIK_IFWAIT
IFRTRY OIL-TPI: Number of Transmission Retries Before Termination NUMC 3 0 OIK_IFRTRY
KSCHL_O Output type for transportation planning systems CHAR 4 0 * NA_KSCHL_T
DR_VEH OIL-TPI: Deactivate Driver/Vehicle Assignment CHAR 1 0 OIK_DR_VEH
EXT_NUM OIL-TPI: Use External Number for Document Creation CHAR 1 0 OIK_EXT_NUM
OIK_EQ_A OIL-TPI: Check equal assignm. with loading or sched. date CHAR 1 0 OIK_EQ_A
MAX_STAT OIL-TPI: Max. Default Status CHAR 1 0 OIK_MAX_STAT
MANETA OIL-TPI: Manual Entry of ETA In SPW CHAR 1 0 OIK_MANETA
DEFTRIP OIL-TPI: Don't default trip sequence in SPW CHAR 1 0 OIK_DEFTRIP
DISPSUM OIL-TPI: Don't show the quantity sum line in SPW CHAR 1 0 OIK_DISPSUM

ROIKTPS foreign key relationships

Table Field Check Table Check Field
0 ROIKTPS BUKRS T001 Company Codes BUKRS
1 ROIKTPS KSCHL T685 Conditions: Types KAPPL
1 ROIKTPS KSCHL T685 Conditions: Types KSCHL
0 ROIKTPS STACUR TCURC Currency Codes MANDT
0 ROIKTPS STACUR TCURC Currency Codes WAERS
1 ROIKTPS STADIS T006 Units of Measurement MANDT
1 ROIKTPS STADIS T006 Units of Measurement MSEHI
0 ROIKTPS STAGEW T006 Units of Measurement MANDT
0 ROIKTPS STAGEW T006 Units of Measurement MSEHI
1 ROIKTPS STAVOL T006 Units of Measurement MANDT
1 ROIKTPS STAVOL T006 Units of Measurement MSEHI