cancel
Showing results for 
Search instead for 
Did you mean: 

Two different field comparision in same Table

Former Member
0 Kudos

Hi All,

can anybody tell me, how to compare two column value in a same table using SQVI or sq01? If we can then how?

Regards,

Sanjeet Kumar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Using SQ01, in SQ02, you have a table VBAP for example, and you can create a ALLIAS table which reference to VBAP table.

In SQ02, you can write a bit of codes to do comparision and output result in extra fields.

Former Member
0 Kudos

Hi Alan

can you provide the code and how will add this code in infoset?

Regards,

Sanjeet Kumar

Former Member
0 Kudos

What field are you comparing?

Former Member
0 Kudos

HI Alan,

for example: take table MAKT where two field i.e. MAKTG and MAKTX. now i want to compare values in both field and want to get duplicate values in this table. using T-code: SQVI .

Regards

Sanjeet Kumar

Former Member
0 Kudos

SQVI not possible. have to use SQ01, SQ02, SQ03.

In SQ02, write some codes in extra section and add a extra field e.g. RESULTS.

Example of code:

If MAKT-MAKTG <> MAKT-MAKTX.

     X_RESULTS = 'False'.

ENDIF.

Former Member
0 Kudos

Hi Alan,

Thanks you very much..

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sanjeet,

If you have to compare two columns in the same table then select those two fields as output and execute with your required inputs.

Please provide any example if this does not suffice your requirement.

Regards

SS

Former Member
0 Kudos

Hi S S,

for example: take table MAKT where two field i.e. MAKTG and MAKTX. now i want to compare values in both field and want to get duplicate values in this table. using T-code: SQVI is this possible ?

Regards,

Sanjeet Kumar