Hi, I'm struggling with something that would seem to be easy, but apparently it's not. Or I'm missing something obvious.
I'm using Studio, so I can chose between Transaction, Query and Direct, but I can't manage with either of them.
The task:- there's a list of vendors in an excel file (let's say there's one company code to make it easier)
- I need to fetch open items as of today (I can add =today() formula column if needed) for each of these vendors in the same excel file, anywhere. Just to get the list in the same file. Let's say I need vendor - document number - amount
Easy? Maybe, but not for me.
Transaction:
well, this won't let me copy anything, so I think I can't use it.
Query:
Table BSIK could be handful. But in terms of input, I can only see an option to chose between fixed value, user input (not an option- must be read from excel) or a
single cell. I don't know any way to pick a
list of vendor accounts in Query as selection criteria.
Direct:
I can use a
BAPI_AP_ACC_GETOPENITEMS, which allows me to pick a list of vendor accounts. But it requires a loop (otherwise it fetches only first doc), which then requires to post H/D values in a column, which I can't do - I don't know how many line items there are for each vendor, so I don't know how many D's are required. Sometimes it's 1, sometimes it's 10 000.
Any help would be appreciated.
regards,
Radek P.------------------------------
Radoslaw Poziomek | BSC Continuous Improvement Specialist
Owens Illinois
------------------------------