need logic for this

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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

Regards

Prabhu

[Former Member]

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

[Former Member]

Hi,

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

Regards

Gaurav

[Former Member]

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

[Former Member]

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