Table Linkages

[Former Member]

Hi Friends,

We have created the batch characterestics as Accepted and rejected.While receiving from vendor, the batch will be created and their characterestics will be maintained.Now I have to create a report of goods received having only rejected material. For this I need table linkages of Batch Number(MSEG-CHARG), Batch characterestics description(RCTAT-ATNAM) and Batch characterestics Value(CAWN-ATWRT). Please help. Full points will be awarded.....

Edited by: k prasanna on Oct 5, 2008 4:18 AM

[Former Member]

why can't you use the BAPI BAPI_OBJCL_GETDETAIL to get the information about the characteristic values.

or else you can get the information from AUSP table using the batch

[Former Member]

Dear Vijay,

Congrats for on top and thanx for reply.we are not fluent in BAPI.I am an MM consultant.I have to give table linkages for these fields. Our business requirements are while goods reciept with MIGO, system will create the batch no. In that batch we have got characterestics value as accepted and rejected. Now i have to fetch only rejected materials. That is why I have to link batchno with Characterestics description and characterestics value.So please convey how to link these fields.

Regards.

Edited by: k prasanna on Oct 6, 2008 5:18 AM

[Former Member]

Hello

1. goto MCH1 with matnr and charg

2. check field CUOBJ_BM

3. if this field not initial, then goto AUSP with OBJEK = MCH1-CUOBJ_BM - characteristic values.

4. goto CABN with ATINN = AUSP-ATINN - characteristics description.

[Former Member]

dear Friend ,

Please concatenate materail and batch no into one variable

concatenate itab-matnr itab-charg into itab-objek.

select single cuobj

from inob

into itab-objek1

where objek = itab-objek.

select single atwrt

from ausp

into itab-customer

where objek = itab-objek1.

u refer this code for u r requirment ,i hope its useful for u

Regards ,

Nikhil Narkhede