Hi Sharath, I managed to found the solution. Will share it below:
First Need to get the data for the VS_TREATMENT Characteristic. For this we need to do the following Selections:
1) SELECT SINGLE CLINT INTO KSSK-CLINT FROM KSSK
WHERE OBJEK = MATNR
AND MAFID = 'O'
AND KLART = '001'
2) SELECT SINGLE KLART INTO (KLAH-KLART) FROM KLAH
WHERE CLINT = KSSK-CLINT
3) SELECT IMERK FROM KSML
WHERE CLINT = KSSK-CLINT
4) SELECT ATINN ATNAM FROM CABN
WHERE ATINN = KSML-IMERK
With all the ATINN obtained from CABN + Material Number, retrieve records from AUSP.
5) SELECT OBJEK ATINN ATZHL ATWRT FROM AUSP
WHERE OBJEK = MATNR (18 DIGIT WITH LEADING ZEROS)
AND ATINN = CABN-ATINN.
Now here is the trick:
For all records from AUSP table from the previuos search, concatenate ATINN + ATWRT. This will be the key for further selections,
lv_val LIKE ausp-objek,
lv_atwtb LIKE cawnt-atwb,
lv_atinn TYPE atinn,
lv_objek TYPE objnum,
lv_atwrt TYPE atwrt,
lv_atzhl TYPE atzhl,
----CABN
SELECT SINGLE atinn INTO lv_atinn
FROM cabn WHERE atnam = 'VS_ACTIVETYPE'.
----AUSP
SELECT SINGLE atwrt INTO lv_atwrt
FROM ausp WHERE atinn = lv_atinn AND objek = lv_val. "<-----------
----CAWN
SELECT SINGLE atzhl INTO lv_atzhl
FROM cawn WHERE atinn = lv_atinn AND atwrt = lv_atwrt.
----CAWNT
SELECT SINGLE atwtb INTO lv_atwtb
FROM cawnt WHERE atinn = lv_atinn AND atzhl = lv_atzhl
AND spras = sy-langu.
Here is how I managed to pull this "sub characteristic". The key was to concatenate Internal Characteristic + Value to get a New Key and search for it.
Regards,
Ernesto.
Bluesky
