Skip to Content
-1

Need some coding help in SAP BI

Nov 10, 2016 at 10:13 AM

126

avatar image

Hi Gurus,

I got a requirement in my project.

I'm having two tables AUFM, AUFK, AFRU, CRHD, CRTX.

1ST:

Table -> AUFM:

WERKS (plant)

MATNR (matnr)

AUFNR (order)

want to get order type from table -> AUFK

Common fields in both the tables (AUFNR,WERKS)

if plant and order are same in both the tables then we need to extract AUART (Order type ) from the table AUFK.

2ND :

Table: AFUR

Fields:

WERKS (plant)

BUDAT (posting date)

AUFNR (order)

ARBID( Object ID)

Want to get work center form table CRHD.

Common fields in both the tables (ARBID)

If ARBID(Object ID) is same in both tables we need to extract Work center(ARBPL) from CHRD.

This is the requirement and for this i'm planning to go with generic extarctor (function module). Can some one please help me on this coding part.

Is there any other option apart from function module for this requirement?

Kind Regards.

N

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raman Korrapati Nov 10, 2016 at 04:31 PM
-1

please report your issue at ABAP forum or seek abap expert help.

Share
10 |10000 characters needed characters left characters exceeded
umayaraj B Jan 07, 2017 at 07:18 AM
0

Hi Nag,

Use select with inner join ,it's full fill your requirement .

Thanks,

Raja


Share
10 |10000 characters needed characters left characters exceeded