Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

any fm to get belnr?

shahid
Product and Topic Expert
Product and Topic Expert
0 Kudos
435

hello alll

is there any functional module which gives me the BELNR(of bseg) by passing the vbeln.

yeah ...we can do tht by passing bseg table ,,,,but its taking loads of time to give me the output as its not a primary key or secondary key.....

when i m using this condition in the prog i cannot use inner join as its a cluster table . if i m writing a condition it is effecting my prog performance

regards

Message was edited by:

shahid mohammed syed

9 REPLIES 9

former_member189629
Active Contributor
0 Kudos
169

Shahid,

pass your VBELN to BSEG table. U'll get the BELNR.

former_member187452
Contributor
0 Kudos
169

hi shahid,

In bseg u can directly pass vbeln to get belnr, u can do so in your select statement.

Regards,

Bharat.

shahid
Product and Topic Expert
Product and Topic Expert
0 Kudos
169

yeah ...we can do tht ,,,,but its taking loads of time to give me the output as its not a primary key or secondary key.....

when i m using this condition in the prog i cannot use inner join as its a cluster table . if i m writing a condition it is effecting my prog performance

Former Member
0 Kudos
169

select BELNR from BSEG

into table IT

where

VBELN = your VBELN number..

both fields are available in BSEG table...

reward points please....

Former Member
0 Kudos
169

use READ_BSEG

pass VBELN value to XBLNR field.

rewar if useful.

Amit Singla

shahid
Product and Topic Expert
Product and Topic Expert
0 Kudos
169

in tht fm , there is no xblnr field..and in bseg there is no xblnr field

0 Kudos
169

Sorry, You have to input the VBELN into READ_BSEG XBELNR field

Former Member
0 Kudos
169

hi,

You have to pass the INVOICE NUMBER in AWKEY field of table BKPF.

Hope this helps.

Regards,

Pritha

0 Kudos
169

Read from BKPF with AWTYP = 'VBRK' and AWKEY = invoice number. (the whole key of the index BKPF-4).

Regards