SQVI Material Classification report

[Former Member]

Hi Experts,

I'd like to create an SQVI report in which I could link material number to any of the material classification tables (AUSP,INOB,KSSK,KLAH,CABN,CAWN).

I would really appreciate it if someone could tell me how to join any of these tables to any material master table where material number is used as uniqe identifier.

Thanks.

Nándor

[VigneshV]

This message was moderated.

[Former Member]

Hi,

If you want to pick the material classification directly link it with ausp

MARA-MATNR = AUSP-OBJEK

Regards,

Vishal

[Former Member]

Hi Vishal,

thanks for you reply.

Your mentioned combination is an illegal join unfortunately, I've already tried that before.

[Former Member]

Hi,

I am using that in my many reports and it is working fine.

regards,

Vishal

[JL23]

report is not query.

AUSP-OBJEK is a 50 character field, while

MARA-MATNR is a 18 charcter field.

Because of this you cannot join these 2 field in SQVI.

[Former Member]

Nandor,

When faced with dissimilarly structured text fields in Query, don't attempt a join.

Sometimes, when I face this problem, I just add the table as an object in SQ02. So, in SQ02, create your infoset with all the joins that you want (and can manage without error). Then, on the main SQ02 page, Select Extras>Create>Additional Table. Enter AUSP. It will propose linking criteria. In your case, probably OBJEK = MARA-MATNR. SOMETIMES you will get the results you are seeking, if both fields have the data left justified and no padding. You have to try. As you have noted, Query is pretty fussy about this.

Once you get your infoset created, you can use SQVI to create your query, selecting infoset as a source. Or, you can just create a standard query using SQ01.

Rgds,

DB49

[Former Member]

Hi DB,

thanks for this useful information.

It turns out that OBJEK does not equal to MATNR in all cases as if the material is batch managed, the last set of characters in OBJEK refers to batch setting.

Nandor

[Former Member]

I have exactly the same problem. It seems that we can add a WHERE statement in SQ02 in that case. But all my tests failed.

Any examples of syntax ? WHERE INOB-CUOBJ = AUSP-OBJEK ??

Many thanks

[JL23]

This thread was about SQVI, which is a kind of different to standard queries in SQ01 and infosets in SQ02.

Please do not hijack other peoples threads. this does not add any value, open your own thread after having read the forum rules.

Ask about programming questions in the ABAP forum.

[Former Member]

Many thanks, but as mentionned above, it seems that there are no solution with SQVI. We are obliged to make a WHERE in SQ02. I've found exactly the same questions on many forums, but without any correct answer.

I've to find the right man or woman.

Happy new year !

[JL23]

look at the fields.

INOB-CUOBJ is 18 long, while AUSP-OBJEK is 50 long

you can try this way:

WHERE INOB-CUOBJ = AUSP-OBJEK(18)

[merrill_schilling]

I created a ZVIEW with MARA-MATNR, AUSP-OBJEK and AUSP-ATINN in SE11. There the join MATNR-OBJEK is only a warning.

You can use this new View as a link Table in SQVI MARA-MATNR to ZVIEW-MATNR ZVIEW-OBJEK to AUSP-OBJEK and ZVIEW-ATINN TO AUSP-ATINN.

[Former Member]

Hi

1. Enter T.code : SQVI press enter

2. Enter the name of the file Test u2013click create

3. Enter the file name :test .select table to join

4. Screen will appear u2013go to second ikon enter the table name :AUSP

5. Click the second ikon: enter the table name: MARA

6. Press the green arrow button

7. Select the required characteristics in both the table and SAVE

8. Report is ready for execution

Regards

G.Ganesh Kumar

[Former Member]

Hi Gunash,

thanks for you reply.

The default join that SAP gives me for AUSP & MARA:

MARA-BLANZ=AUSP-ATZHL

MARA-COLOR_ATINN=AUSP-ATINN

doesn't really works as it freezes my SAP completely.