topic Re: Function module for changing the service line item quantity, rate, cost centre and G/L account in Application Development and Automation Discussions

Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Tue, 11 Nov 2014 10:42:31 GMT

Hi,

I am developing a UI5 application which is supposed to replace the current me53n for approving purchase requisition.

There one requirement is to change the quantity, rate, cost centre and G/L account if needed for a particular sub-line in a service line.

I received tables ESLL, ESKL which stores the service line data except cost centre and G/L account.

I am not understanding how to relate individual sub-line within a service line with a particular cost centre as cost centre data is not maintainined in those tables.

How can I relate individual sub-line within a service line with a particular cost centre through any table?

Is there any function module for changing service items sub-lines?

Awaiting,

Regards,

Subhabaha Pal

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Tue, 11 Nov 2014 11:03:03 GMT

Hi Subhabaha Pal,

You can use function module BAPI_PR_CHANGE to Changing an item with account assignment with regard to quantity, delivery date, and G/L account .

Go to tcode : BAPI -> Alphabetical Tab -> PurchaseRequisition -> Change1 -> Documentation for details view of what are mandatory parameters you have to pass in this Bapi function Module.

Hope it will useful.

Thanks and Regards,

Sagar Pambhar

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Wed, 12 Nov 2014 05:19:06 GMT

Hi Sagar,

Thanks a lot. I have gone through the function module BAPI_PR_CHANGE. It has option for entering new service lines, however, old service line format and new service line format is somewhat different.

Furthermore in order to get the format of the table (relevant data) for BAPI_PR_CHANGE, I need to run BAPI_PR_GETDETAILS as I have done for BAPI_REQUISITION_GETDETAILS AND BAPI_REQUISITION_CHANGE.

But strangely here I find that in BAPI_PR_GETDETAILS, no data is coming in the service line item table though I have service line-items in the PR.

Can you please help?

Regards,

Subhabaha Pal

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Wed, 12 Nov 2014 12:59:50 GMT

Hi Subhabaha Pal,

Use Bapi BAPI_REQUISITION_GETDETAIL .

You will get all the necessary Service level details as well as Item Level Details inside this Bapi.

In below snapshot, there is only 1 line item is there inside that 2 services are attached. So you can get the details in highlighted Internal Table.

You have to do mapping manually to pass the values in BAPI_PR_CHNAGE.

Hope it will helpful.

Regards,

Sagar Pambhar

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Fri, 14 Nov 2014 10:57:06 GMT

Thanks a lot Sagar for your kind response.

Yes I have seen that service lines are coming through the FM BAPI_REQUISITION_GETDETAIL.

For updating BAPI_PR_CHANGE, can you please tell me which table I need to update for modified service line-items as there are 2 tables - SERVICELINE and SERVICELINEX.

Servicelinex table format is somewhat different. So if similar type of application you have done for service line update, it will be of great help to me if you can send me a test format for updating the tables in the BAPI_PR_CHANGE function module.

Thanks a lot Sagar once again.

Awaiting,

Subhabaha Pal

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Fri, 14 Nov 2014 11:19:40 GMT

Hi Subhabaha Pal,

Changing an item with account assignment with regard to quantity, delivery date, and G/L account

Parameter: NUMBER

0010012707

Parameter: PRITEM

PREQ_ITEM = 00010

QUANTITY = 59,000

DELIV_DATE = 20050301

Parameter: PRITEMX

PREQ_ITEM = 00010

PREQ_ITEMX = X

QUANTITY = X

DELIV_DATE = X

Parameter: PRACCOUNT

PREQ_ITEM = 00010

SERIAL_NO = 01

GL_ACCOUNT = 0000410000

Parameter: PRACCOUNTX

PREQ_ITEM = 00010

SERIAL_NO = 01

PREQ_ITEMX = X

SERIAL_NOX = X

GL_ACCOUNT = X

Same for the SERVICELINE - Pass the new value of required parameter which you want to change and in SERVICELINEX - pass the value 'X' of above fields where you have changed the value from old to new.

Let me know if this is helpful for you.

Regards,

Sagar

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Mon, 17 Nov 2014 11:30:36 GMT

Thanks a lot Sagar.

I shall check and let you know.

Thanks once again for your great help Sagar.

Regards,

Subhabaha Pal

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Mon, 17 Nov 2014 11:36:12 GMT

Hi Subhabaha Pal,

Your Most Welcome dear. Let me know if you have any queries now or in future.

Regards,

Sagar.

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Mon, 17 Nov 2014 11:39:00 GMT

Yes Sure. I shall let you know. I am new in SCN. If any post I make and want to bring your attention to that post, how can I do that?

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Mon, 17 Nov 2014 12:05:50 GMT

Hi Subhabaha Pal,

You can Tag me while posting any new discussion in SDN. So i will get notification and i will try to find solutions for that .

Thanks and Regards,

Sagar Pambhar.

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Mon, 17 Nov 2014 12:13:27 GMT

Thanks Sagar. I shall surely do the needful.

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Thu, 11 Dec 2014 12:38:57 GMT

Hi Sagar,

I have tried to use your solution but could not find it working. The details has been mentioned in my below post.

http://scn.sap.com/thread/3667414

It will be of great help if you please help...

Regards,

Subhabaha Pal

Re: Function module for changing the service line item quantity, rate, cost centre and G/L account

Former Member — Tue, 21 Apr 2015 05:56:51 GMT

Hi Sagar,

Is it possible to delete a service line item using BAPI_PR_CHANGE?

I can add a new service line for example from 1 service line to 2 service line but i cant delete, from 2 services line to 1.

Below is my example code but unfortunately its not deleting the service line.

ls_servicesline-doc_item = '00010'.

ls_servicesline-outline = '0000000001'.

ls_servicesline-srv_line = '0000000020'.

ls_servicesline-del_ind = 'X'.

APPEND ls_servicesline TO lt_servicesline.

ls_serviceslinex-doc_item = '00010'.

ls_serviceslinex-outline = '0000000001'.

ls_serviceslinex-srv_line = '0000000020'.

ls_serviceslinex-del_ind = 'X'.

APPEND ls_serviceslinex TO lt_servicesline.

did i miss something??

I badly needed this to work and your help will be greatly appreciated.

Kind Regards,

Deck