‎2009 Apr 07 2:46 PM
Hi experts
In which transparent table get the batch wise characteristic values
Regards
manoj
‎2009 Apr 07 2:52 PM
‎2009 Apr 09 11:14 AM
To check batch characteristics ; go to table INOB - give OBTAB as MCH1 ; OBJEK - combination of MATNR and batch ( 18 char+batch) and get the CUOBJ value.
Using this CUOBJ , go to table AUSP ; OBJEK of AUSP = CUOBJ ; give appropriate class type and ATINN and ATWRT holds the characteristic value.
Regards,
Deepthi
‎2009 Apr 09 12:14 PM
Use the following code as per ur requiremeny-----
DATA : MATERIALBATCH(30) VALUE ' #'.
DATA : CBJKEY LIKE INOB-OBJEK
MOVE ' #' TO MATERIALBATCH.
OVERLAY MATERIALBATCH WITH ITAB-MATNR.
REPLACE '#' WITH ITAB-BATCH2 INTO MATERIALBATCH.
SELECT SINGLE CUOBJ FROM INOB INTO CBJKEY WHERE OBJEK = MATERIALBATCH .
SELECT SINGLE ATFLV FROM AUSP INTO WA_ITAB-THICK WHERE OBJEK = CBJKEY AND ATINN = '0000000080' .
Edited by: mujib tirandaz on Apr 9, 2009 1:16 PM
‎2009 Jun 12 7:19 AM
Hi this is the right table.
CAWN-Characteristic values
AUSP-Characteristic Values
Regards
Dhirendra pandit
‎2009 Jun 12 11:24 AM
hi,
sample code for your reference :-
SELECT matnr
charg
zustd
cuobj_bm
FROM mch1
INTO TABLE t_mch1
WHERE matnr = itab-matnr
AND charg = itab--charg.
LOOP AT T_MCH1 INTO WA_MCH1.
MOVE WA_MCH1-CUOBJ_BM TO WA_MCH1-OBJEK.
MODIFY T_MCH1 FROM WA_MCH1 INDEX SY-TABIX.
ENDLOOP.
SELECT a~objek
a~atinn
a~atzhl
a~mafid
a~klart
a~adzhl
a~atwrt
a~atflv
b~atnam
FROM ausp AS a INNER JOIN cabn AS b
ON aatinn = batinn
INTO TABLE t_ausp
FOR ALL ENTRIES IN t_mch1
WHERE objek = t_mch1-objek.
Hope this solves your issue