09-12-2008 10:01 AM
HI ,
Can somebody please explain me why WE partner function is stored as SH in the database table.And how it happens?
Thanks
Saurabh
09-12-2008 10:04 AM
It's the same of doc. 100000023 being stored as 00100000023 in database. One is the output format and the other the input format. Check FM's CONVERSION_EXIT_PARVW_INPUT and CONVERSION_EXIT_PARVW_OUTPUT of domain PARVW.
Regards,
Valter Oliveira.
09-12-2008 10:04 AM
It's the same of doc. 100000023 being stored as 00100000023 in database. One is the output format and the other the input format. Check FM's CONVERSION_EXIT_PARVW_INPUT and CONVERSION_EXIT_PARVW_OUTPUT of domain PARVW.
Regards,
Valter Oliveira.
09-12-2008 10:05 AM
Hi,
SH stands for Ship to party and is only the translation for WE. :O)
Regards
Nicole
09-12-2008 10:05 AM
09-12-2008 10:20 AM
Hi Saurabh,
This is because of internal and external formats.
In table execution what ever u give it converts automatically.
But in select quesy u have to give the value which is being displayed when u execute the table.
eg: If u wnat shipto party then in select query u have to give parvw eq WE. SH is the internal format for WE. If u double click in table output WE will be shown as SH.
Check table VBPA.
There is a conversion exit for this field as u already got a reply which converts external to internal and vice versa.
It is analogous to date/time/currency/Quantity fields.
It stores internaly in one way and displays in other way.
In case of date, time etc it won't store the seperators in data base. but when u output to screen it gets the user settings and displays.
This is also similar to that.
Hope it is clear.
Thanks,
Vinod.
09-12-2008 10:22 AM
Hi,
The ship-to party in the German system key is "WE". In English language it is 'SH'
Sold- to paty AG(German) = SP (sold-to party)
These conversions we maintain in SD partner determination.
Regards,
Chandra
04-13-2009 9:22 AM