Service Entry Sheet table

[Former Member]

Hi all,

Any anybody tell me which table i can get the short text, quantity, gross price, currency, cost center, net value for Service Entry Sheet?

I tried in ESLL table with packeage number but all the above fields are cuming 0.00 in this table

Regards

Sushmita

[Former Member · Accepted solution]

Try table ML_ESLL.

Enjoy SAP,

Parag Mahajan

[Former Member · Accepted solution]

Hey Parag,

Thanks a lot transaction ML_ESLL is giving all the details except cost centre. I'll manage to get the cost center.

You need to enter service entry sheet in purchasing doc. field

~Regards

[Former Member]

Hello,

Please check the below tables of service entry sheet:

ESKN Account Assignment in Service Package

ESLH Service Package Header Data

ESLL Lines of Service Package

ESLP Service Item

ESLT Service Item Short Texts

ESSR Service Entry Sheet Header Data

ESST Service Item Short Texts

Parameters like quantity, gross price, currency, cost center, net value might be obtained by searching in the above tables. But probably for "short text", you have to use function module READ_TEXT.

Hope the above inputs are sufficient.

Regards

Mahesh

[kunal_ingale]

hi

check ESSR Service Entry Sheet Header Data

regards

kunal

[Former Member]

Hi..

You need to do one more step to get the values.

After passing the Packno to Essr table, from that get the 'sub_packno' field.

Now again, you pass the 'sub_packno' field vlaue in Packno to get your values.

example:

IF it_essr[] IS NOT INITIAL.
    SELECT packno
           sub_packno
      FROM esll
      INTO TABLE it_esll
      FOR ALL ENTRIES IN it_essr
      WHERE packno = it_essr-packno.
  ENDIF.

  IF it_esll[] IS NOT INITIAL.
    SELECT packno
           extrow
           sub_packno
           menge
           tbtwr
           userf2_num
      FROM esll
      INTO TABLE it_esll1
      FOR ALL ENTRIES IN it_esll
      WHERE packno = it_esll-sub_packno.
  ENDIF.

thanks,

Padma

[Former Member]

Hi Padma,

Its not very clear, could you elaborate it?

Edited by: aakansha kumar on Dec 3, 2009 9:53 AM