Skip to Content
Former Member
Jan 27, 2011 at 06:09 PM

Need for SQL to fetch the details of Business Partner table (OCRD)



I am trying to write a sql that would help me to get all vendors and their Tax ID information. Here is what I wrote...

select CardName, LicTradNum, Address, City, State1, Country, ZipCode, Phone1, Fax, CntctPrsn, Box1099, CreateDate, UpdateDate, * from OCRD where CardType = 'S'

In the SAP B1 client I am able to see valid values for fields '1099 Form' and '1099 Box'. When I execute above SQL, I only get a reference to the actual values. I am thinking there is a cross reference to other table to pull this informaiton. Can you help me to get the details for 1099.

Thanks a lot in advance for your help.