Automate

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Hello Moazzam,

With BAPIs that I have used in scripts, the loop construct will initially show but I had no need for the loop function.  The yellow loop construct can be deleted using a right-click on the loop itself, the fields for the table will remain, so you will have the 2 IT_Header tables listed with their fields, but without the loop.  When you map to the Excel template all the fields will map to columns.  Then populate each column for each of the 2 sets of IT_Header fields as needed.  For each work order you would populate one row in the Excel template.

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Hi John,

I'm not sure I follow. Would you be able to attach a sample script to help me understand?

Thanks,

Moazzam

Hello Moazzam,

With BAPIs that I have used in scripts, the loop construct will initially show but I had no need for the loop function.  The yellow loop construct can be deleted using a right-click on the loop itself, the fields for the table will remain, so you will have the 2 IT_Header tables listed with their fields, but without the loop.  When you map to the Excel template all the fields will map to columns.  Then populate each column for each of the 2 sets of IT_Header fields as needed.  For each work order you would populate one row in the Excel template.

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Unfortunately I cannot send a sample script, I am dead in the water with Studio as I allowed my PC to be upgraded to Win11 for some testing and our current version of Studio doesn't work with Win11.

On the Expert View tab, you can right-click somewhere on the loop construct (pointed out) and you will get a popup menu with a Delete option.  The yellow loop that surrounds that header table will be deleted, but table IT_HEADER_JVA and it's fields will remain.  You are only deleting the fact that the table is part of a loop - it will no longer be "in a loop".

When you map the fields, all the fields for both header tables will get mapped to columns in the Excel template.  So, for example, in the Excel template for field Order Number, you will see it in two columns - one will be for IT_HEADER, and one will be for IT_HEADER_JVA.  Just populate both with the same order number.

Hi John,

I'm not sure I follow. Would you be able to attach a sample script to help me understand?

Thanks,

Moazzam

Hello Moazzam,

With BAPIs that I have used in scripts, the loop construct will initially show but I had no need for the loop function.  The yellow loop construct can be deleted using a right-click on the loop itself, the fields for the table will remain, so you will have the 2 IT_Header tables listed with their fields, but without the loop.  When you map to the Excel template all the fields will map to columns.  Then populate each column for each of the 2 sets of IT_Header fields as needed.  For each work order you would populate one row in the Excel template.

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Definitely look at the SAP Note that is referenced in the message.  If you run a google search for: sap note 2295840 - there are some links to threads where a similar message is issued for other function modules.  One mentions a system setting that has to do with blacklisting incompatible calls.

At his point I would try a transaction recording.

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).  

Good point, John.

That note refers to other notes

• 2298711 - Maintain RFC Blacklist in customer installations
• 2480080 - RFC Blacklist Update 1610 FPS3 and 1709
• 2295840 - Outbound / Inbound calls from external to RFC FM are blocked when the FM is blacklisted and the UCON-Check is active
• 2465870 - CAD Services: MFLE changes for BOM related modules

from https://me.sap.com/notes/2295840 - RZ11 ucon/rfc/check_blacklist could be set to 0, but that's something Basis would need to investigate and approve.  There look to be other options, including running reports, to allow using the Function Module from outside of SAP.

Best Regards,

Sigrid

Definitely look at the SAP Note that is referenced in the message.  If you run a google search for: sap note 2295840 - there are some links to threads where a similar message is issued for other function modules.  One mentions a system setting that has to do with blacklisting incompatible calls.

At his point I would try a transaction recording.

Hi all,

We have a requirement to mass update Joint Venture fields in thousands of PM orders. An end user can do that manually by using t-code IW32 to (change PM order) and Go To -> Assignments -> Joint Venture (first screenshot).