Personal Folder

Dear Farid,
Thanks for your documents. But for the vendor master list, can we have similar format with the same fields as the file attached? The attachment is the vendor master list for TPM. We would like to have similar format including vendor bank account number field for our testing purposes. Thanks for your help.
Best regards,

Internal Audit Dept


Requested field are:
Vendor Account Number
Name 1
Name 2
Name 3
Name 4
Street 4
Street 5
City
PostalCode
Region
Telephone 1
Fax Number
Creation Date
Central Deletion Flag for Master Record
Central posting block
Centrally imposed purchasing block
Bank Account Number
Email

Here the step:
Go to SQVI > Select Basis Mode

Go to data source to create table relationship.



At table LFA1:
Vendor Account Number
Name 1
Name 2
Name 3
Name 4
City
PostalCode
Region
Central Deletion Flag for Master Record
Central posting block
Centrally imposed purchasing block

At table ADRC:
Street 4
Street 5

At table LFB1:
Creation Date
Company Code

At table ADR6:
Email Address

At table LFBK:
Bank Account Number


For email address, I found the table from this article, since at the technical information of the field it point to a structure, not direct point to original table.
http://husnie.wordpress.com/2007/11/08/finding-email-address-customer-and-vendor-master-on-sap/
You need to activated SQL trace and change email on master to find where email address is stored. Here i share the result of tracing using SQL trace of email addess Customer and Vendor master.
For Vendor :
select adr6-addrnumber (email)
from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr