topic Re: need logic for this in Application Development and Automation Discussions

need logic for this

Former Member — Wed, 02 May 2007 09:48:51 GMT

To get Account document number (BKPF-BELNR), input existing material document number(MKPF-MBLNR) appended with material document year(MSEG-MJAHR) into reference key ( BKPF-AWKEY).

regards,GA

Re: need logic for this

Former Member — Wed, 02 May 2007 09:51:06 GMT

concatnate itab-mblnr itab-mjahr into itab-awkey.

Regards

Prabhu

Re: need logic for this

Former Member — Wed, 02 May 2007 09:52:22 GMT

Use concatenate ... if you want all the fields to be displayed into a single field....

I think if I am not mistaken to understand you question..

Regards,

Jayant

Re: need logic for this

Former Member — Wed, 02 May 2007 09:55:26 GMT

Hi,

With the help of Reference Document Number (MSEG-XBLNR) u can get Account document number (BKPF-BELNR).

Regards

Gaurav

Re: need logic for this

Former Member — Wed, 02 May 2007 09:57:08 GMT

data : v_awkey like bkpf-awkey.

select mblnr mjahr into corresponding fields of table itab from mseg where....

loop at itab.

concatenate itab-mblnr itab-mjahr into v_awkey.

select single belnr into itab-belnr from bkpf where awkey = v_awkey.

modify itab.

clear v_awkey.

endloop.

regards

shiba dutta

Re: need logic for this

Former Member — Wed, 02 May 2007 10:17:13 GMT


Data:wa_belnr like BKPF-BELNR.
        
SELECT  mseg~mjahr  INTO    CORRESPONDING   FIELDS OF  TABLE int_outtab

  concatenate mkpf-mblnr mseg-mjahr
where bkpf-awkey = ' '  "specify any value from awkey in that space

Regards,

Pavan