on 07-10-2007 8:04 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can also create a querry for the same by tr. co. sq01, sq02, and sq03.
Cheers
Prashant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
check vbfa table ,document flow, u could get some clue.
regards
sriram.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.