Automate

Hi All,

I am trying to extract the PO text fields for multiple languages via Query.

The data is stored in Structures. 

Any suggestions on the best method to extract the data ??

------------------------------
Vag Vignesh Shenoy |
------------------------------

Hello -

Have you considered using Query with table STXL?  You would need to include the TDOBJECT, which for a PO would either be EKKO or EKPO, depending on whether it is header or line item.  

Thank you!

------------------------------
JENNIFER HWANG | SE
Winshuttle North America
------------------------------

Hi Jennifer,

The thing is that PO may or may not be created. The business needs an extract with reference to the Material Numbers.
Also i tried to create a Transaction script to upload the same PO text on the Material. but the field does not get captured because it is a structure. Any idea how to capture the data like these ??

------------------------------
Vag Vignesh Shenoy |
------------------------------

Original Message:
Sent: 03-11-2020 11:23
From: JENNIFER HWANG
Subject: Extract PO Text via Query

Hello -

Have you considered using Query with table STXL?  You would need to include the TDOBJECT, which for a PO would either be EKKO or EKPO, depending on whether it is header or line item.

Thank you!

------------------------------
JENNIFER HWANG | SE
Winshuttle North America
------------------------------

Hi -

Creating material master long text is easy, you just can't enter it in the main big long text box in the MM02 PO text view.  In recording your MM02, you need to either go into basic text editor and enter in the long text as 72-character lines, or you can use Winshuttle-specific long text functionality within the mapper as long as you are using Studio 11 or Studio 12.  https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-connect/12/Record-long-text.htm

For the extract you could possibly do this in 2 steps.  The first step would be to identify any POs that the material(s) is in by using an EKPO extract.  Once you have the list of POs and the PO line item numbers, then you could use an ME23N recording and using the same Winshuttle-specific long text functionality, but map those long text fields to be download for the line items that you've identified in step 1. Or the Step 2 could be using an STXL extract, but you would need to provide EKPO as TDOBJECT, and you would also need to provide the names, which would require you to concatenate the PO number and the item number as a separate input field.  You could use name using an in operator to point to a list of your po/item fields. 

Thank you!

------------------------------
JENNIFER HWANG | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 03-12-2020 05:12
From: Vag Vignesh Shenoy
Subject: Extract PO Text via Query

Hi Jennifer,

The thing is that PO may or may not be created. The business needs an extract with reference to the Material Numbers.
Also i tried to create a Transaction script to upload the same PO text on the Material. but the field does not get captured because it is a structure. Any idea how to capture the data like these ??

------------------------------
Vag Vignesh Shenoy |
------------------------------


Original Message:
Sent: 03-11-2020 11:23
From: JENNIFER HWANG
Subject: Extract PO Text via Query

Hello -

Have you considered using Query with table STXL?  You would need to include the TDOBJECT, which for a PO would either be EKKO or EKPO, depending on whether it is header or line item.

Thank you!

------------------------------
JENNIFER HWANG | SE
Winshuttle North America