we have a function module in sap which if we pass order number will return the status. We created a sysnonym for this and are able to run it by itself.
TABLE FILE Z_SD_SALES_ORDER_STATUS
WHERE VBELN EQ '&VBELN';
But how do we pass a bunch of values into this function module and get the status without looping one by one.??
For example if we have a Hold file with just order numbers and we want to get status for all those?
I tried joining and it did not work? Any ideas?
App Studio Version 8202
SQL Server 2008/2012
Yeah, I don't think you're the only one that would like to join a table into SAP. All we ended up doing is looping the hold file into 1 long WHERE statement. We only were using it for a 10-100 "orders" so it wasn't that big of an issue.
Here's the code in case you were thinking of doing something similar:
-SET &NUMLINES = &LINES; -READ HOLD NOCLOSE &CUSTOMER.A7. -SET &IFCUST = '''' || &CUSTOMER || ''''; -TOPLOOP -READ HOLD NOCLOSE &CUSTOMER.A7. -SET &NUMLINES = &NUMLINES - 1; -IF &NUMLINES LT 1 THEN GOTO ENDLOOP; -SET &IFCUST = &IFCUST || ' OR ' | '''' || &CUSTOMER || ''''; -GOTO TOPLOOP; -ENDLOOP -CLOSE HOLD
Prod: WebFOCUS 7.6.4 - Self Service - Windows Server2003 - Apache Tomcat 5.5
Dev: WebFOCUS 7.6.4 - Self Service - Windows XP SP2 - Apache Tomcat 5.5
|Powered by Social Strata|