topic Re: SAP Query issue in Application Development and Automation Discussions

SAP Query issue

Former Member — Thu, 29 Aug 2013 12:38:57 GMT

Hi ,

I have created a query using MSEG & AUFK. I can get data only if the query gets AUFNR using which I connected these tables.

But now I want query to show data which doesn't have AUFNR e.g. data with mov type 201 and posting date from MSEG.

How I can achieve this, please suggest.

Regards

plm

Re: SAP Query issue

Former Member — Thu, 29 Aug 2013 13:07:38 GMT

AUFK always has an aufnr. It doesn't seem logical to include AUFK if you want non-aufnr records.

However, you could always MSEG outer join to AUFK.

Neal

PS: This would be far better done in an ABAP report!

Re: SAP Query issue

Former Member — Thu, 29 Aug 2013 14:44:30 GMT

Hi PLM,

As suggested by Neal, it does not make much sense to include AUFK records if its key fields are to be ignored. Please provide your business need.

As SQVI says (& you also know),

BR.

Re: SAP Query issue

Former Member — Fri, 30 Aug 2013 10:35:30 GMT

thanks Neal & Ankit ,

Actually I want to make material consumption report in which movement type 261 & 201 is used to issue materials from stores. Using MSEG & AUFK my first requirement is 261 is fulfilled but not able to get the data for 201 in the same report.

please suggest a solution ...

regards

PLM

Re: SAP Query issue

Former Member — Fri, 30 Aug 2013 11:34:07 GMT

For sure, you shouldn't be using SAP Query!

Re: SAP Query issue

P1389307362 — Mon, 02 Sep 2013 12:38:21 GMT

Hi,

The best way is to create a ABAP program. Because reading from BSEG will cause the program to getting slow because it may have huge amount of records than other talbe.

Regards,

Prasad

Re: SAP Query issue

Former Member — Sat, 28 Sep 2013 10:18:20 GMT

Tired all trial and error ..but couldn't succeed .

At last made ABAP Report.

Thanks all !