cancel
Showing results for 
Search instead for 
Did you mean: 

AFRU-RUECK and MSEG-MBLNR

Former Member
0 Kudos

Hi everybody;

How can I go from AFRU table to MSEG table? (BLPP doesnt work in production order, it works for only REM)

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

Hi Emre,

AFRU-WABLNR = MSEG-MBLNR

If AFRU-WABLNR is empty:

AFWI-RUECK = AFRU-RUECK

AFWI-RMZHL = AFRU-RMZHL

AFWI-MBLNR = MSEG-MBLNR

...

Regards, Andreas

Former Member
0 Kudos

Hi Andreas;

I check your suggestion.Thank you very much.

But unfortunately AFRU-WABLNR and also there are also no record according to the following join.

AFWI-RUECK = AFRU-RUECK

AFWI-RMZHL = AFRU-RMZHL

AFWI-MBLNR = MSEG-MBLNR

martinmanriqu
Explorer
0 Kudos

Thank you very much.

Former Member
0 Kudos

Thanks.

Former Member
0 Kudos

Link is as below

AFRU-AUFPL = CAUFV-AUFPL

from here you will get the order number - AUFNR

CAUFV-AUFNR = MSEG-AFUNR

I hope you got the link.

Former Member
0 Kudos

Hi Rajesha;

Unfortunately this is not working.

Former Member
0 Kudos

it is working for me...where exactly you are getting the error?

Former Member
0 Kudos

Hi;

In table AFWI we dont have any records. I think this table is related with tcode MF47 we dont use this screen.

We use MFBF and COGI screen.

Former Member
0 Kudos

Hi;

AFRU is the detail table. CAUFV is the view for header. These tables have (n-1) relation.

CAUFV-MSEG has (1-N) relation.,

So for one record in AFRU you can have n record in MSEG.

I want to have a relation between

Between AFRU-RUECK-AFRU-RMZHL ; and MSEG-MBLNR.

in (1-1) relation.

Former Member
0 Kudos

Hi Emre,

I'm a bit confused. By your initial question I thought you are working with production orders. But now you say that you use MFBF and COGI only.

For production and process orders there is no other 1:1 relation between AFRU and MSEG than given above in my previous response:

AFRU-WABLNR = MSEG-MBLNR.

If there's more than one document per confirmation, also table AFWI is used, but for production/process orders only (not for REM).

Hope it is clear now.

Best Regards,

Andreas

Edited by: Andreas Seibel on Oct 9, 2008 8:54 AM