topic SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Wed, 05 Dec 2007 05:20:01 GMT

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 — Wed, 05 Dec 2007 05:34:00 GMT

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 Member — Wed, 05 Dec 2007 05:39:53 GMT

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