cancel
Showing results for 
Search instead for 
Did you mean: 

BELNR FROM BKPF Based on RSEG.

arsul_parshuram
Participant
0 Kudos

Dear All,

I need BELNR FROM BKPF Based on RSEG-belnr.

DATA: V_BELNR LIKE BKPF-BELNR,

V_RESWK LIKE EKKO-RESWK.

DATA:B1 LIKE RSEG-BELNR,

B2 LIKE RSEG-GJAHR.

DATA:V_AWKEY LIKE BKPF-AWKEY.

DATA:V_DMBTR LIKE BSEG-DMBTR.

B1 = WA_RSEG-BELNR.

B2 = WA_RSEG-GJAHR.

CONCATENATE B1 B2 INTO V_AWKEY.

IF WA_RSEG-BELNR IS INITIAL.

CLEAR : WA_FINAL-BELNR1,WA_FINAL-BUDAT1.

ENDIF.

SELECT SINGLE BELNR INTO V_BELNR

FROM BKPF

WHERE AWKEY = V_AWKEY

AND GJAHR = WA_RSEG-GJAHR

AND BUKRS = WA_RSEG-BUKRS

and awtyp = 'RMRP'.

IF SY-SUBRC = 0.

WA_FINAL-BELNR1 = V_BELNR.

ENDIF.

My select is working fine but my problem is BKPF-BELNR getting but where Rseg-belnr is blank then it should not get bkpf-belnr.

i don't want print BKPF-BELNR WHERE RSEG-BELNR is Blank.

Please help on this.

Regards,

Parshuram

Accepted Solutions (0)

Answers (1)

Answers (1)

arsul_parshuram
Participant
0 Kudos

My Self solved.