topic Re: Batch wise characteristic values in Application Development and Automation Discussions

Batch wise characteristic values

Former Member — Tue, 07 Apr 2009 13:46:03 GMT

Hi experts

In which transparent table get the batch wise characteristic values

Regards

manoj

Re: Batch wise characteristic values

Former Member — Tue, 07 Apr 2009 13:52:33 GMT

Hello

AUSP with OBJEK = MCH1-CUOBJ_BM

Re: Batch wise characteristic values

Former Member — Thu, 09 Apr 2009 10:14:12 GMT

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

Re: Batch wise characteristic values

Former Member — Thu, 09 Apr 2009 11:14:54 GMT

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

Re: Batch wise characteristic values

dhirendra_pandit — Fri, 12 Jun 2009 06:19:17 GMT

Hi this is the right table.

CAWN-Characteristic values

AUSP-Characteristic Values

Regards

Dhirendra pandit

Re: Batch wise characteristic values

Former Member — Fri, 12 Jun 2009 10:24:10 GMT

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 a_{atinn = b}atinn

INTO TABLE t_ausp

FOR ALL ENTRIES IN t_mch1

WHERE objek = t_mch1-objek.

Hope this solves your issue