SAP table T790G (Warranty Type)
SAP table T790G has 2 primary key fields being MANDT,GAART.
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
GAART
Warranty type
CHAR
1
0
GAART
GATYP
Warranty category
CHAR
1
0
GATYP
Possible values
I
Warrantee (vendor/manufacturer)
O
Guarantor (customer)
NUMKR
Number Range
CHAR
2
0
NUMKR
NUMKE
Number Range of External Number Assignment
CHAR
2
0
NUMKE
STSMA
Status Profile
CHAR
8
0
TJ20
J_STSMA
PARGR
Partner Determination Procedure
CHAR
4
0
TVPG
PARGR
KVEWE
Usage of the condition table
CHAR
1
0
T681V
KVEWE
KAPPL
Application
CHAR
2
0
T681A
KAPPL
KALSM
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
CHAR
6
0
T683
KALSM_D
POPUPM
Display Dialog Box
CHAR
1
0
POPUP
POPUPA
Display Dialog Box
CHAR
1
0
POPUP
POPUPF
Display Dialog Box
CHAR
1
0
POPUP
T790G foreign key relationships
Table
Field
Check Table
Check Field
0 T790G
KALSM
T683
Pricing procedures
KAPPL
0 T790G
KALSM
T683
Pricing procedures
KALSM
1 T790G
KAPPL
T681A
Conditions: Applications
KAPPL
0 T790G
KVEWE
T681V
Conditions: Usages
KVEWE
1 T790G
PARGR
TVPG
Partner Function Groups
PARGR
0 T790G
STSMA
TJ20
Status profiles
MANDT
0 T790G
STSMA
TJ20
Status profiles
STSMA