Usage of tables EKKN,ESLL,ESLH,ESKL and FMIOI in Service PO's

[Former Member]

Hi Gurus,

We have a multi-line service PO. Each overview line has multiple service lines. Please provide a brief explanation of the role the following tables play in defining the PO structure and contents.

The tables are :

EKKN : Account Assignment in Purchasing Document

ESLL : Lines of Service Package

ESLH : Service Package Header Data

ESKL : Account Assignment Specification(Service Line)

FMIOI : Commitment Documents Fund Management.

What i need to know as to how these tables can be used to define the structure of a <b>SERVICE PO</b>.

Kindly note that this requirement is wrt SERVICE PO only.

Please reply to this asap.

[former_member195696]

Hello,

If you happen to enter the ESLL-PACKNO into the

ESKL-PACKNO field , you will not be able to see any entries. You should actually enter the SUB_PACKNO of the PACKNO(taken from EKPO table) entered in the ESLL table.

That is, account is assigned for the service line and not for its

header which holds it. Lines in ESLL which have a SUB_PACKNO are actually headers which hold the service lines( which do not have a SUB_PACKNO)

Hope the above information would have useful.

Thanks,

Vivek

[Former Member]

The link is as follows:

EKKN is the account assignment at the item level. So any account assignment maintained at the item level is stored here against the PO and item.

EKPO has a package number. This package number is the link between EKKO/EKPO and ESLL/ESLH.

There will be a record in ESLH with the same package number as in EKPO. This is just the header line.

Then in ESLH, search for all package numbers where this package number is the PARENT. Here you will get all the service items.

These package numbers will have the service details in ESLL.

ESKL will have the account assignment details against these package numbers.

FMIOI - you can check with the PO number as reference... I cannot see since I do not have funds management activated in my system.

Hope this helps,

Lakshman

[Former Member]

Hello,

we check the link, but the ESKL table doesn't have the information about account assingment. Do you know about this??

thanks,

José Aldemar.

The link is as follows:

EKKN is the account assignment at the item level. So any account assignment maintained at the item level is stored here against the PO and item.

EKPO has a package number. This package number is the link between EKKO/EKPO and ESLL/ESLH.

There will be a record in ESLH with the same package number as in EKPO. This is just the header line.

Then in ESLH, search for all package numbers where this package number is the PARENT. Here you will get all the service items.

These package numbers will have the service details in ESLL.

ESKL will have the account assignment details against these package numbers.

FMIOI - you can check with the PO number as reference... I cannot see since I do not have funds management activated in my system.

[Former Member]

Hi there,

additional to your question I have another,

ESLL : Lines of Service Package

and there are other table named ESKN: Account Assingment

ok, the problem is that I need get the relation between the tables. Both tables have the fields PACKNO but they don't match.

In few words I need to get the account assingment for each Line of Service.

thanks,

José Aldemar Cortés.