Automate

Hello,

We have a script for ME12 that deletes old Pricing Conditions and adds new ones. The script is working fine, except that when it needs to choose the validity date range - it is choosing the second date range on the list, rather than the most recent date range. Does anyone know how to fix this?

Thanks!

------------------------------
Maxwell Streit | Data Maintenance Manager
The Coleman Company Inc | 0000000000
------------------------------

Hi Maxwell

If it's always choose the 2nd condition, then that's how it's recorded.

I'm not 100% what you're trying to accomplish, because you state you create a new condition record each time, but then you state you also need to select from a list of condition effectivity dates.

If you're creating a new condition each time, then you can use this template:  https://community.winshuttle.com/sap-module-templates/viewdocument/change-purchasing-info-record?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

If you need to find a specific condition effectivity date to update, it would require GUI scripting, and you'd have to use the effectivity date do to the find.

You'll have to use the pop-up to "identify disabled fields" as the date is read only, and then click a start date - you'll see a red box around it for a moment.

You then use an Indexed IF to position based on the effectivity start date - make sure you disable the download field of the start date, as well

A quick example is attached.

My test data 
in SAP

in the script template
I threw in a bad start date so that you could see the message

HTH,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Hi Sigrid,

Thank you for your reply. We are doing a mass update to delete the FRC1 and ZOC1 conditions, and replace them with ZOC1 and ZOC3. 

We just need the script to choose the current effectivity date (x date to 12/31/9999). Is there a way to do this without GUI scripting?

Best,

Maxwell

------------------------------
Maxwell Streit | Data Maintenance Manager
The Coleman Company Inc | 0000000000
------------------------------

Original Message:
Sent: 11-22-2021 14:26
From: Sigrid Kok
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Maxwell

If it's always choose the 2nd condition, then that's how it's recorded.

I'm not 100% what you're trying to accomplish, because you state you create a new condition record each time, but then you state you also need to select from a list of condition effectivity dates.

If you're creating a new condition each time, then you can use this template:  https://community.winshuttle.com/sap-module-templates/viewdocument/change-purchasing-info-record?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

If you need to find a specific condition effectivity date to update, it would require GUI scripting, and you'd have to use the effectivity date do to the find.

You'll have to use the pop-up to "identify disabled fields" as the date is read only, and then click a start date - you'll see a red box around it for a moment.

You then use an Indexed IF to position based on the effectivity start date - make sure you disable the download field of the start date, as well

A quick example is attached.

My test data
in SAP

in the script template
I threw in a bad start date so that you could see the message

HTH,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Hi Maxwell

With transactions that have sections like this that don't provide a way to find a specific row, you have two choices:

1. use a BAPI, but there isn't a remote-enabled BAPI that I'm aware of to do this for ME12
2. use GUI scripting

Those are the only options I'm aware of.   If anyone else has a better suggestion, please post here.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 11-23-2021 13:37
From: Maxwell Streit
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Sigrid,

Thank you for your reply. We are doing a mass update to delete the FRC1 and ZOC1 conditions, and replace them with ZOC1 and ZOC3.

We just need the script to choose the current effectivity date (x date to 12/31/9999). Is there a way to do this without GUI scripting?

Best,

Maxwell

------------------------------
Maxwell Streit | Data Maintenance Manager
The Coleman Company Inc | 0000000000
------------------------------


Original Message:
Sent: 11-22-2021 14:26
From: Sigrid Kok
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Maxwell

If it's always choose the 2nd condition, then that's how it's recorded.

I'm not 100% what you're trying to accomplish, because you state you create a new condition record each time, but then you state you also need to select from a list of condition effectivity dates.

If you're creating a new condition each time, then you can use this template:  https://community.winshuttle.com/sap-module-templates/viewdocument/change-purchasing-info-record?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

If you need to find a specific condition effectivity date to update, it would require GUI scripting, and you'd have to use the effectivity date do to the find.

You'll have to use the pop-up to "identify disabled fields" as the date is read only, and then click a start date - you'll see a red box around it for a moment.

You then use an Indexed IF to position based on the effectivity start date - make sure you disable the download field of the start date, as well

A quick example is attached.

My test data
in SAP

in the script template
I threw in a bad start date so that you could see the message

HTH,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA

Hi Maxwell,

the effective date ranges are in table A018. Search on Supplier, Materialnumber and Purch.Org.
Maybe you can first query this table to find out which row must be selected and then use the rownumber to select the right row in your transaction script.
It will be a bit complicated but I think it can be done.

Regards,

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Original Message:
Sent: 11-23-2021 13:46
From: Sigrid Kok
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Maxwell

With transactions that have sections like this that don't provide a way to find a specific row, you have two choices:

1. use a BAPI, but there isn't a remote-enabled BAPI that I'm aware of to do this for ME12
2. use GUI scripting

Those are the only options I'm aware of.   If anyone else has a better suggestion, please post here.

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------


Original Message:
Sent: 11-23-2021 13:37
From: Maxwell Streit
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Sigrid,

Thank you for your reply. We are doing a mass update to delete the FRC1 and ZOC1 conditions, and replace them with ZOC1 and ZOC3.

We just need the script to choose the current effectivity date (x date to 12/31/9999). Is there a way to do this without GUI scripting?

Best,

Maxwell

------------------------------
Maxwell Streit | Data Maintenance Manager
The Coleman Company Inc | 0000000000


Original Message:
Sent: 11-22-2021 14:26
From: Sigrid Kok
Subject: Troubleshooting ME12 Script - Adjusting Pricing Conditions in PIR

Hi Maxwell

If it's always choose the 2nd condition, then that's how it's recorded.

I'm not 100% what you're trying to accomplish, because you state you create a new condition record each time, but then you state you also need to select from a list of condition effectivity dates.

If you're creating a new condition each time, then you can use this template:  https://community.winshuttle.com/sap-module-templates/viewdocument/change-purchasing-info-record?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

If you need to find a specific condition effectivity date to update, it would require GUI scripting, and you'd have to use the effectivity date do to the find.

You'll have to use the pop-up to "identify disabled fields" as the date is read only, and then click a start date - you'll see a red box around it for a moment.

You then use an Indexed IF to position based on the effectivity start date - make sure you disable the download field of the start date, as well

A quick example is attached.

My test data
in SAP

in the script template
I threw in a bad start date so that you could see the message

HTH,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA