Automate

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Luzpur -

If you can create a new Query script, then you should be able to set any of the properties, including the padding. So I'm not sure what is going on. You should open up a support ticket. Can anyone else who's also a developer change this or is it just affecting you?

Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 03-22-2021 09:19
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Jennifer,
Is there an template in the Library to Query EAN?

Thank you.

------------------------------
Luzpura Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------

Original Message:
Sent: 03-22-2021 13:46
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi Luzpur -

If you can create a new Query script, then you should be able to set any of the properties, including the padding. So I'm not sure what is going on. You should open up a support ticket. Can anyone else who's also a developer change this or is it just affecting you?

Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-22-2021 09:19
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Luzpur -

I've attached an example.  Please open a Support ticket to get your padding issue addressed. 

Thank you,

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 03-29-2021 14:22
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,
Is there an template in the Library to Query EAN?

Thank you.

------------------------------
Luzpura Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 13:46
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi Luzpur -

If you can create a new Query script, then you should be able to set any of the properties, including the padding. So I'm not sure what is going on. You should open up a support ticket. Can anyone else who's also a developer change this or is it just affecting you?

Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-22-2021 09:19
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Luzpur
Since you have Foundation, you'll need someone who has access to Settings -> Preferences -> Foundation tab, where you can check a box to allow developers to manage padding.  IMHO, it should always be checked.

Best Regards,
Sigrid

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

Original Message:
Sent: 03-22-2021 09:19
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Hi Sigrid,
Thank you for the reply. My setting in Foundation IMHO has been updated but I still cannot change Criteria to Padding.


------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------

Original Message:
Sent: 03-25-2021 11:47
From: s kok
Subject: Query EAN/UPC in MARA

Hi Luzpur
Since you have Foundation, you'll need someone who has access to Settings -> Preferences -> Foundation tab, where you can check a box to allow developers to manage padding.  IMHO, it should always be checked.

Best Regards,
Sigrid

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

Original Message:
Sent: 03-22-2021 09:19
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi Jennifer,

Thank you for the response.

That field is grayed out in my script. Is it related to SAP role?

Thanks

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780

Original Message:
Sent: 03-22-2021 08:31
From: Jennifer Hwang
Subject: Query EAN/UPC in MARA

Hi @Luzpura Parrell -

For me, I needed to take off the padding in the EAN field and I did not need to provide the leading zeroes as inputs. So you may need to try a few different ways on your system.


Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 03-21-2021 18:23
From: Jan van Asseldonk
Subject: Query EAN/UPC in MARA

Hi Luzpur,

check your input and check the table entry.
Field length in the table is 18, the length of your input is 11.
For some tables you have enter the full length of the field, so with leading zeros or leading or preceding spaces.


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

Original Message:
Sent: 03-19-2021 14:14
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------
​

Original Message:
Sent: 3/19/2021 2:15:00 PM
From: Luzpura Parrell
Subject: Query EAN/UPC in MARA

Hi,
I created a Query with Table MARA.
Criteria are EAN/UPC and Material Type.

Output are Material Number, Material Type and EAN/UPC.

When I tested (with an existing EAN already in SAP) just to test and to get Data Preview, I received "No data are available". In SAP, MARA  found one record with material number.
Is there a specific format to follow?
Any input is highly appreciated.

Thank you,

------------------------------
Luzpur Parrell
Sr Data Analyst
PACTIV EVERGREEN
570730780
------------------------------