Which data base tables contain SCM customer code

[Former Member]

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]

Hi Reddy,

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

Corresponding field for it is ' <b>BUKRS</b> '.

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

relate with your <b>KNA1- ADRNR</b> 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