SAP table TKRSTR (Transport Resource Prices)

SAP table TKRSTR has 8 primary key fields being MANDT,TRKORR,KAPPL,KSCHL,KOTABNR,QMANDT,QSYSID,KNUMH.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TRKORR Request/Task CHAR 20 0 E070 TRKORR
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHA
KOTABNR Number of the Condition Table CHAR 3 0 T681 KOTABNR
QMANDT Client CLNT 3 0 MANDT
QSYSID Name of SAP System CHAR 8 0 SYSYSID
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
VAKEY Variable key 255 Character CHAR 255 0 VAKEY_LONG
DATAB Valid-From Date DATS 8 0 DATAB
DATBI Valid To Date DATS 8 0 DATBI
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
STFKZ Scale Type CHAR 1 0 STFKZ
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 CHAR 1 0 KRECH
A Percentage
B Fixed Amount
C Quantity
D Gross Weight
E Net Weight
F Volume
G Formula
H Percentage (in Hundreds)
I Percentage (Travel Costs)
J Per Mille
K Per Mille (in Thousands)
L Points
M Quantity - Monthly Price
N Quantity - Year 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)
V Quantity Adjustment
W Percentage (with 6 Decimal Places)
KBETR Condition amount or percentage where no scale exists CURR 11 2 KBETR_KOND
KONWA Condition Unit (Currency or Percentage) CUKY 5 0 TCURC KONWA
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 T006 KMEIN
KUMZA Numerator for converting condition units to base units DEC 5 0 KUMZA
KUMNE Denominator for converting condition units to base units DEC 5 0 KUMNE
LOEVM_KO Deletion Indicator for Condition Record CHAR 1 0 LOEVM_KO
ZAEHK_IND Condition item index NUMC 3 0 DZAEHK_IND

TKRSTR foreign key relationships

Table Field Check Table Check Field
0 TKRSTR KAPPL T681A Conditions: Applications KAPPL
1 TKRSTR KMEIN T006 Units of Measurement MANDT
0 TKRSTR KONWA TCURC Currency Codes MANDT
0 TKRSTR KONWA TCURC Currency Codes WAERS
1 TKRSTR KOTABNR T681 Conditions: Structures KOTABNR
0 TKRSTR KSCHL T685 Conditions: Types KAPPL
0 TKRSTR KSCHL T685 Conditions: Types KSCHL
1 TKRSTR KVEWE T681V Conditions: Usages KVEWE
0 TKRSTR TRKORR E070 Transport system: Headers of requests/tasks TRKORR