SAP table TVSU (Material Substitution: Reasons)

SAP table TVSU has 2 primary key fields being MANDT,SUGRD.

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
SUGRD Reason for material substitution CHAR 4 0 SUGRD
SUDRU Original entry will be printed CHAR 1 0 SUDRU
SUDIA Display a warning before material is substituted CHAR 1 0 SUDIA
SUVFP Substitution dependent on the availability check CHAR 1 0 SUVFP
SUBAR Substitution strategy CHAR 1 0 SUBAR
Automatic
A Substitute products are displayed for selection
B General material determination with selection, without ATP
SUERG Outcome of substitution CHAR 1 0 SUERG
Item will be replaced
A Substitution products are displayed as subitems
B As in A but only when creating the item in Sales
SUTYP Substitution category CHAR 1 0 SUTYP
A Equipment is substituted by service product (Service)