SELECT STATEMENT

[Former Member]

HI GURUS,

IM UNABLE TO WRITE A SELECT STATEMENT PLZ HELP ME IN THIS.

Get BKPF-AWKEY where BKPF-BELNR = VBRK-VBELN + prefix “00”.

HERE

VBRK -VBELN = BILLING DOCUMENT NUMBER

BKPF-BELNR = ACCOUNTING DOC NUMBER

BKPF-AWKEY = OBJECT KEY.

SO IS IT POSSIBLE TO WRITE THE SELECT STATEMENT FOR THIS (Get BKPF-AWKEY where BKPF-BELNR = VBRK-VBELN ).

AND IN THE SAME WAY..

IS IT POSSIBLE TO WRITE SELECT STATEMENT FOR

Get KNA1- STCEG where VBRK-KUNRG = KNA1-KUNNR.

PLEASE HELP ME .ITS VERY URGENT.

IF IT IS POSSIBLE PLEASE SAY ME HOW TO WRITE FOR THESE BOTH STATEMENTS.

ANSWERS WILL BE FULLY REWARDED.

THANKS & REGARDS

SIRISH.

[Former Member]

Try Concatenating them into a variable and check with that variable.

concatenate '00' vbrk-vbeln into v_vbeln.

check like:

Where BKPF-BELNR = v_vbeln.

[former_member624107]

Hi..

first get VBRK-VBELN

declare v_veblen.

concatenate '00' VBRK-VBELN into v_vbeln.

and select AWKEY from bkpf into v_awkey

where BELNR = v_vbeln.

same way...

concatenate '00' VBRK-KUNRG into v_KUNRG.

select STCEG from kna1 into v_STCEG

where kunnr = v_KUNRG