Skip to Content
Former Member
Nov 21, 2012 at 07:43 AM

Substitution Issue~ Field to be substituted is not available for selection



We have a situation where we want to force WHT tax base amount -QSSHB to 0 if a Doc type is RE. We are creating a substitution for this with prerequisite as Doc type = RE. However, in substituable fileds BSEG-QSSHB is not an option.

I checked in table gb01 and this field has a cross X in exclude and this explains why it does not appear in substituable list in GGB1. I removed it via editing the table because no other means is possible. Yet when I make a substitution it does not work.

My questions are:

1) Is it a good idea to edit the table GB01?

2) Even if editing is done, why is substitution not working? Does substitution not work if an additional field is added in the list in GGB1 via editing of GB01 i.e. removing X?

3) We have tried inserting an exit for forcing this QSHHB to 0 in the substitution. However, the technical team says that this field is a structure initially in fb01 and no values can be stored or forced for a structure. Is there no way to force an 0 in a structure?

4) Is there any other way to enforce that WHT tax base is 0 when document with type RE is saved?

Help would be greatly appreciated.