topic Re: Table Linkages in Application Development and Automation Discussions

Table Linkages

Former Member — Sat, 04 Oct 2008 18:15:57 GMT

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

Re: Table Linkages

Former Member — Sun, 05 Oct 2008 03:48:25 GMT

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

Re: Table Linkages

Former Member — Sun, 05 Oct 2008 10:36:13 GMT

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

Re: Table Linkages

Former Member — Sun, 05 Oct 2008 17:34:00 GMT

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

Re: Table Linkages

Former Member — Mon, 06 Oct 2008 04:48:15 GMT

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.