Skip to Content
author's profile photo Former Member
0
Former Member

link betwen VBap and vbfa

Posted on Dec 14, 2006 at 12:49 PM 363 Views

Hi all,

please let me know how can I link these 2 tables VBAP AND vbfa so that I should get field value RFMNG and MEINS right now I am doing like this

select rfmng meins from vbfa into table i_vbfa

where vbelv = i_vbap-vbeln and

posnv = i_vbap-posnr and

vbtyp_n = 'J"

Even then I have data in i_vbeln I am not getting data from vbfa what could be the problem? is there any thing wrong with posnv = i_vbap-posnr? Please clarify this?

Thanks&Regards

Mahesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2006 at 12:53 PM
    0

    Hi Mahesh,

    The field vbfa-vbelv has the subsequent docuemnt number...

    Replace you code like below

    If you want the RFMNG & MEINS of Delivary Document

    select rfmng meins from vbfa into table i_vbfa

    where vbeln = i_vbap-vbeln and

    posnv = i_vbap-posnr and

    vbtyp_n = 'J" (Here the J represents Delivary Document)

    Regards,

    Satya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2006 at 12:58 PM
    0

    Hi Mahesh,

    Change the VBTYP_N from J to C to get the required results.

    J - Delivery

    C - Order

    select rfmng meins from vbfa into table i_vbfa

    where vbelv = i_vbap-vbeln and

    posnv = i_vbap-posnr and

    <b>vbtyp_n = 'C'.</b>

    Note: Plz mark all helpful answers.

    Thanks,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2006 at 01:00 PM
    0

    Do you have a value in i_vbap-posnr. If so, then it should return a value.

    Regards,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Jan 09, 2007 at 04:33 PM

      Hi Mahesh,

      Were you able find any solution to this problem. I have kind of a similar problem as am trying to calculate the Pick Quantity for an Outbound Delivery.

      Please let me know if you found something.

      Regards,

      Rohit.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.