cancel
Showing results for 
Search instead for 
Did you mean: 

Pull Vendor Data

Former Member
0 Kudos

I have a request to pull Vendor information from a table(s) that will list the VN/OA/PI partner with the address associated with each. Please advise if you are aware of any method to gather this data.

Thanks - points will be rewarded.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Brian,

The three or four tables I would use in a query are the following:

LFA1

LFB1

LFM1

WYT3

WYT3 is the table that provides the partner function relationship.

You may be able to get away with using only one of the three LF tables depending on your selection and report output requirements.

Hope this helps.

Answers (0)