SAP Table TKRSTR

Transport Resource Prices

TKRSTR (Transport Resource Prices) 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 TKRSTR to other SAP tables.

Source: TKRSTR (Transport Resource Prices)

TKRSTR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TRKORR Request/Task TRKORR E070 CHAR 20 0
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Condition type KSCHA T685 CHAR 4 0
KOTABNR Condition table KOTABNR T681 NUMC 3 0
QMANDT Client MANDT CLNT 3 0
QSYSID Name of SAP System SYSYSID CHAR 8 0
KNUMH Condition record number KNUMH CHAR 10 0
VAKEY Variable key 100 bytes VAKEY CHAR 100 0
DATAB Valid-From Date DATAB DATS 8 0
DATBI Valid To Date DATBI DATS 8 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
KVEWE Usage of the condition table KVEWE T681V CHAR 1 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
STFKZ Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
KBETR Rate (condition amount or percentage) where no scale exists KBETR_KOND CURR 11 2
KONWA Rate unit (currency or percentage) KONWA TCURC CUKY 5 0
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN T006 UNIT 3 0
KUMZA Numerator for converting condition units to base units KUMZA DEC 5 0
KUMNE Denominator for converting condition units to base units KUMNE DEC 5 0
LOEVM_KO Deletion Indicator for Condition Item LOEVM_KO CHAR 1 0
X Yes
NULL No
ZAEHK_IND Condition item index DZAEHK_IND NUMC 2 0

TKRSTR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TKRSTR KAPPL TKRSTR KAPPL T681A Conditions: Applications KAPPL
TKRSTR KMEIN TKRSTR MANDT T006 Units of Measurement MANDT
TKRSTR KMEIN TKRSTR KMEIN T006 Units of Measurement MSEHI
TKRSTR KONWA TKRSTR MANDT TCURC Currency Codes MANDT
TKRSTR KONWA TKRSTR KONWA TCURC Currency Codes WAERS
TKRSTR KOTABNR TKRSTR KVEWE T681 Conditions: Structures KVEWE
TKRSTR KOTABNR TKRSTR KOTABNR T681 Conditions: Structures KOTABNR
TKRSTR KSCHL TKRSTR MANDT T685 Conditions: Types MANDT
TKRSTR KSCHL TKRSTR KVEWE T685 Conditions: Types KVEWE
TKRSTR KSCHL TKRSTR KAPPL T685 Conditions: Types KAPPL
TKRSTR KSCHL TKRSTR KSCHL T685 Conditions: Types KSCHL
TKRSTR KVEWE TKRSTR KVEWE T681V Conditions: Usages KVEWE
TKRSTR MANDT TKRSTR MANDT T000 Clients MANDT
TKRSTR TRKORR TKRSTR TRKORR E070 Change & Transport System: Header of Requests/Tasks TRKORR