Unpack the PACKNO of Service Entry Sheet (SES)

Share on Facebook4Share on LinkedIn8Tweet about this on TwitterShare on Google+0
Please Share!!

[adToAppearHere]

You have the SES number and you need to get the details of services.

T-Code: ML81N

1

Tables in question:

ESSR is the Service Entry Sheet Header Data. SES number and the PO number are available in this table.
ESLH is the Service Package Header Data. Please pay attention to the word Package Header Data. PACKNO is the primary key of this table.
ESLL is the Lines of Service Package. This is package item.

Link between these tables are established using PACKNO.

2

ESSR-PACKNO –> ESLH-FPACKNO (Parent package number). Check with functional consultant if field FPACKNO is to be used or HPACKNO is to be used for your system.
ESLH-PACKNO –> ESLL-PACKNO

The final data in ESLL would have one extra line for the Package Header identification. You need to remove this line in your logic to get SES item details.

Option 1. If ESLL-PACKNO = ESLL-FPACKNO .. Ignore this line.
Option 2. Other way round is to delete the ESLL entry which has ESLL-PACKAGE = ABAP_TRUE (X).
Option 3. Or delete ESLL entry which has SUB_PACKNO NOT EQUAL to blank.

Please consult your functional/business before implementing option 2 and option 3. There might be some customization in your system or multiple sub packages which needs to be handled intelligently. Option i is the safest bet..

In one of our project, we used option 1.

4

If you do not want to hit two database tables ESLH and ESLL, then directly fetch the data from standard database view ML_ESLL (Service Lines with Package Header Data), using ML_ESLL-PACKNO = ESSR-PACKNO.

3

Image source: via Free Stock Photos foter.com

Share on Facebook4Share on LinkedIn8Tweet about this on TwitterShare on Google+0
Please Share!!

About the Author

SAP Yard
SAP Yard
SAPYard is one stop page for all Technical Folks in SAP. You would find un-conventional explanations, tutorials, and tricks. Please like our Facebook Page and also join our LinkedIn Group.

4 Comments on "Unpack the PACKNO of Service Entry Sheet (SES)"

  1. Hi,
    in the last line

    ML_ESLL (Service Lines with Package Header Data), using ML_ESLL-FPACKNO(instead of ML_ESLL-PACKNO) = ESSR-PACKNO.

    • Hi Vim – Thank you for leaving your comment. Yes, FPACKNO is linked to PACKNO. Treat FPACKNO as parent and then you can filter it out. Please look at the data in the screenshot, it would be more clear.

      Please let us know for further question.

      Regards,
      Team SAPYard.

  2. Hi, just wanted to mention, I enjoyed this post.

    It was practical. Keep on posting!

Leave a comment

Your email address will not be published.


*