Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP ERP Query

Former Member

‎2013 Aug 05 3:40 PM

0 Likes
486

Dear all,

I have created  an Infoset-Query based on the following tables in my Join.

MARA ___Matrialdata table

EINA _____Purchasing info record

EINE______Purchaseing organization data

I want that no matter what kind of Materialtyp is selected, the appropriate generic Artikel be used to read information in the Purchasing Info Record (general data).

Has any one gotten a clue on how to go about this?

Thanks in advance

Dear all,

I have created  an Infoset-Query based on the following tables in my Join.

MARA ___Matrialdata table

EINA _____Purchasing info record

EINE______Purchaseing organization data

I want that no matter what kind of Materialtyp is selected, the appropriate generic Artikel be used to read information in the Purchasing Info Record (general data).

Has any one gotten a clue on how to go about this?

Thanks in advance

Reply
2 REPLIES 2
Read only

FredericGirod
Active Contributor

‎2013 Aug 06 6:42 AM

0 Likes
448

Please clarify

regards

Fred

Read only

Former Member
In response to FredericGirod

‎2013 Aug 07 7:07 PM

0 Likes
448

Hi Fred thanks for the interest.

in the Materialdata table (MARA) You have two fields related to the mateial:

1.  MARA-MATNR and

2.  MARA-SATNR

However in the PUrchase information data Table you can only read Item with MARA-SATNR.

Thant means Readind data Items in the EINA Table is not possible with MARA-MATNR.

How can I go about this.

I want in my requery to funktion such that, no matter if the User uses the SATNR or the MATNR he/she should have a result.

Thanks a lot.