Sort Key in Vendor Master

[Former Member]

Hi all,

we're working on a SAP 4.6C release and we've experience a problem reltaed to the "Sort key" field in the vendor master. In particular we fill in the sort key of the vendor and after invoice posting the sort key is set again to blank. No record of the change is shown in the log related to the modification that sets the field to blank again while all the entries related to the changes from blank to filled are shown.

The sort key field in all the reconciliation accounts related to vendor is set to blank.

Is there a way for which the system sets automatically this field to blank? May be this caused by the discrepancy between the sort key in the vendor master and in its related reconciliation account?

Thanks for the help

Davide

[Former Member · Accepted solution]

The sort key in the vendor recon account ( GL ) has no bearing on the vendor master. Any change to the sort key to the vendor master must be visible in the log via Environment> Account chanes> All.

Unusual that the trace is not available.

[JozsefSzikszai]

hi Davide,

I would set the sort key to blank both vendor master and reconciliation account master. If it does not help, you have to create a substitution, where the field si set to blank.

hope this helps

ec

[Former Member]

Ec,

actually is the opposite we want the sort key in the vendor master to be always filled in while the system seems to change it, on random basis, setting it to blank.

Do you know on what this may depend?

Thanks

Davide

[JozsefSzikszai]

it cannot be random... there should be a logic behind. What I would check is:

sort key of vendor

sort key of reconciliation account

substitutions (probably the field is changed somewhere during posting)

[JozsefSzikszai]

one more thing:

if you post to a vendor, in the corresponding BSEG line of the posting:

ZUONR ==> this should be filled acc. to vendor master sort key

HZUON ==> this should be filled acc. to G/L master sort key

Pls. check in your system!

[lavanyavasanth_99]

The Sort Key of Vendor is available in the table: LFB1 (Known as Vendor Master (Company Code)).
The field is: ZUAWA

LFB1-ZUAWA