cancel
Showing results for 
Search instead for 
Did you mean: 

Two different field comparision in same Table

Former Member
0 Kudos
1,133

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

View Entire Topic
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..