SAP Query issue

[Former Member]

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

[Former Member]

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!

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[P1389307362]

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

[Former Member]

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

At last made ABAP Report.

Thanks all !