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

Reg: ZOR orders

Hi All,

How to get ZOR orders from VBRK table?

Actually in my selection screen, i got

kunrg

vkorg

fkdat

vbeln

fkart

fktyp

fields(from VBRK) to choose...

Based on this criteria i have to select the billing documents (ZOR orders) and update the pricing using VF02 transaction...

Please reply asap...

Regards,

Swathi

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jul 10, 2007 at 07:26 AM

    If your order type is ZOR, then in VBAK table , give the selection criteria as

    VBAK-AUART = ZOR

    Once you get the output, give the VBAK-VBELN in the place of VBFA-VBELV and get the output,

    This will give you all the documents created with reference to your document.

    Then based on the sales document category, you can sort only teh billing documents, and further data on the billing documents can be extracted from VBRK, VBRP tables.

    Reward point if it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 12:33 PM

    You can also create a querry for the same by tr. co. sq01, sq02, and sq03.

    Cheers

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 07:07 AM

    Hi Swathi,

    I think you have everything that is needed for getting the data.

    Enter the selection criteria and execute.Pickup billing document

    Regards,

    Amrish Purohit

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Swathi,

      Simply take all the ZOR type orders from VBAK table as per your desired selection criteria say for ex for one month.

      Take all this documents and input to VBFA table along with subsequent document category as M (Invoice) and you will get the invoice list 😊

      Reward points if useful

      Regards,

      Amrish Purohit

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 08:07 AM

    Hi Swathi,

    Firstly let me know whether you are having Order Related Billing Documents or Delivery Related Billing Documents.

    If Order Related Billing Documents, then go to VBFA table,

    Input ZOR sales order no in VBELV field and execute to get Delivery number in VBELN field.

    Then input your delivery number in VBELV field and execute to get Invoice number in VBELN field.

    If your Order is delivery related staight away go to VBFA Table, input ZOR sales order in VBELV field and execute it to get Invoice number in VBELN field.

    Hope this will help you out !

    Regards,

    Syed Nasir

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 07:20 AM

    hi,

    check vbfa table ,document flow, u could get some clue.

    regards

    sriram.

    Add a comment
    10|10000 characters needed characters exceeded

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.