topic Re: Which data base tables contain SCM customer code in Application Development and Automation Discussions

Which data base tables contain SCM customer code

Former Member — Tue, 25 Sep 2007 05:36:27 GMT

Friends,

I am writing an user exit for VA01/VA02/VA3/VA32.

I am getting the customer number from VBAK-KUNNR when I execute any of the above transactions.

According to functional sepecification, we can find SCM code in the data base table ADRC.

(we can fetch the data from ADRC table where ADRC-ADDRNR = KNA1-ADRNR; ( KNA1-KUNNR = VBAK-KUNNR))

I could not find SCM customer code in the table ADRC.

Please let me know the Data table and field to find the SCM customer code in SAP.

Former Member — Tue, 25 Sep 2007 06:02:37 GMT

Hi Reddy,

>> As in SCM the company codes exist in the table ' T001 '.

Corresponding field for it is ' BUKRS '.

>> U can use ' ADRNR ' as a key field in ' T001 ' table and

relate with your KNA1- ADRNR using Joins for user exits.

Feel Free to ask any questions regarding this...

Hope it Helps...

Regards,

Dhayanandh.S

Message was edited by:

DHAYANANDH SIVASANKARAN