Table for material PO items

[dpolovitola]

Hello SAP Community,

I'm currently working on a business intelligence dashboard featuring POs. I need to show all the PO items for each PO, I'm doing this by linking the EKPO and ESLL tables using the PACKNO attribute.

This is working perfectly fine! Except for material POs. The item information shows up perfectly for service POs, but there is no PACKNO value assigned to any of the material POs.

Any clue about what might be causing this issue? Do I need to use another table for material POs? 

Any help is greatly appreciated!

[abhishek_singh26 · Accepted solution]

I've recently worked on a similar scenario while building a business intelligence dashboard, and wanted to share the approach that worked well for me. The challenge was to correctly retrieve all PO line items, including service lines from ESLL, and material lines directly from EKPO .

When linking EKPO with ESLL via the PACKNO field, service POs worked perfectly, but material POs had blank PACKNO values, causing them to be excluded from the results.

This is expected behavior in SAP:

Service POs (EKPO-PSTYP = 9) use PACKNO to manage hierarchical service line details stored in ESLL.

Material POs do not use PACKNO and their item details are fully stored in EKPO.

To handle both cases in a unified way, I differentiated the logic using the item category field PSTYP

[dpolovitola · Accepted solution]

Hello Abhishek, thank you so much for your answer! Your solution works perfectly!