Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

sales doc

Former Member

‎2011 Jan 07 6:25 AM

0 Likes
352

Hi all,

in my billing doc report i need sale order no . i am picking AUBEL field from VBRP table . but in my VBAP table i am having VBELN field no starts with 4 seris. but in AUBEL i am having 3 series no.

My req is i need VBAP-VBELN in billing document report for this i am using (VBRP,VBRK).

regards,

saiteja

Hi all,

in my billing doc report i need sale order no . i am picking AUBEL field from VBRP table . but in my VBAP table i am having VBELN field no starts with 4 seris. but in AUBEL i am having 3 series no.

My req is i need VBAP-VBELN in billing document report for this i am using (VBRP,VBRK).

regards,

saiteja

Reply
1 REPLY 1
Read only

Former Member

‎2011 Jan 07 6:39 AM

0 Likes
316

Hi Saiteja,

Actually VBRP-AUBEL should give you the correct sales order number. Alternatively, you can fetch it from VBFA (Sales document flow table) by giving invoice number in VBELN field and VBTYP_V as 'C'. It will give sales order number in VBELV field.

Thanks

Radhika