Automate

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!

Hello community,

I'd need to extract from SAP a list of materials that have a larger Net weight than Gross weight value on Basic Data. Obviously this fault causes issues, and listing the materials would be first step towards solving them.

I'm trying to do this with a WS Query. I cannot extract all SAP materials and compare in Excel, amount of materials would exceed Excel's maximum row amount, so I'd need to limit the query result. Gross weight is MARA-BRGEW, Net weight is MARA-NTGEW.

Is it possible to create the query so that it'll compare Net weight and Gross weight and extract only where one is greater than the other? I tried to achieve this but found only a way to compare the values to fixed/user given values.

Is it possible to make WS compare the two values on the fly and extract just the ones where NTGEW>BRGEW? What should I select as WS Query Criterias?

Thank you for your comments!