cancel
Showing results for 
Search instead for 
Did you mean: 

Reg: ZOR orders

Former Member
0 Kudos
1,702

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183879
Active Contributor
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Cheers

Prashant

Former Member
0 Kudos

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

Former Member
0 Kudos

hi,

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

regards

sriram.

Former Member
0 Kudos

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

Former Member
0 Kudos

Actually, the problem is ZOR type orders are there in VBAK table. but i need to pick up the data from vbrk table. Is there any way to link these two tables?

Former Member
0 Kudos

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