Skip to Content
0

Third party order having item category as TAN and schedule line as CS?

Nov 12, 2016 at 07:28 PM

101

avatar image
Former Member

Hello Experts,

I have a Third party scenario where a sales order is create with a material that can be used in both ways i.e. Third party material as well as MTS/MTO material.

Now in the sales order we have changed the schedule line category to CS but forgot to change item category to TAS from TAN.

As per third party process, this sales order has created a purchase requisition followed by purchase order and invoice receipt.

Now when we check the sales order we found that item category is TAN due to which we cannot bill the sales order directly.

We have nearly 200+ sales order having same problem and we don't want to roll back the PO, in order to open the sales order so that item category can be changes to TAS.

The most suitable option that we thought is to develop a Z-program that update the item category in VBAP table so that order can be billed.

I have tried to change one sales order through above mentioned way but unfortunately it doesn't work giving error as "The item is not relevant for billing".

Seems like there are some more updations in the table is required other then item category change.

Request you to please let me know if any suitable option to close this sales orders

Thanks,

Shashwat

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

G Lakshmipathi
Nov 14, 2016 at 10:08 AM
1

Though your ABAP team should be able to develop a coding to achieve the desired result, it would be ideal to raise an OSS message with SAP who can guide you the right away. If at all, as you said, you were unable to make changes with some customized coding, your ABAP team should relook into their coding and see as to why system is not allowing to make change. As a functional consultant, you should be knowing why those errors are popping up and you need to tell the ABAP team to overwrite those validations.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 14, 2016 at 10:05 AM
0

Hi,

Can you try to update item category by using this BAPI:

bapi_saleorder_change

Regards,

Shiva.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 14, 2016 at 12:24 PM
0

Hi Shashwat,

I believe that this a PRD issue right? If it is then your most suitable option is highly not recommend, As per SAP table level changes is not at all to be done due to hell number reason.

The recommended solution will be to reverse all the Invoice receipt and Accounting document followed by reversing the PO and changing the sales order item category to TAN or sales order ca be short close also if client permit.

Ideally till now I m really surprised how come you had not reverse the Invoice recent for 200 + transaction, trust me you need to rectified it ASAP.

Thanks.

Sumeet Sah

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 01, 2017 at 07:19 AM
0

Hello Experts,

Thanks alot for your advise and it really help me to think further. We have figure out each and every possibility to go on with roll back process but unfortunately business will take a long time in this process and cause much delay. So we have created a Z-program which update VBAP (item category) and VBUP tables. In VBUP it will update field (order related billing) from BLANK to A by checking that if the corresponding PO has done with MIRO, then only VBUP is updated and sales order is open for billing. In this way we have completed all the sales order and closed this path so that in future this won't happen. Additionally we have updated VBAP item category field from TAN to TAS for proper synchronization.

Thanks again and we can close this Thread.

Best Regards,

Shashwat Sharma

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 01, 2017 at 07:20 AM
0

Hello Experts,

Thanks alot for your advise and it really help me to think further. We have figure out each and every possibility to go on with roll back process but unfortunately business will take a long time in this process and cause much delay. So we have created a Z-program which update VBAP (item category) and VBUP tables. In VBUP it will update field (order related billing) from BLANK to A by checking that if the corresponding PO has done with MIRO, then only VBUP is updated and sales order is open for billing. In this way we have completed all the sales order and closed this path so that in future this won't happen. Additionally we have updated VBAP item category field from TAN to TAS for proper synchronization.

Thanks again and we can close this Thread.

Best Regards,

Shashwat Sharma

Share
10 |10000 characters needed characters left characters exceeded