WBS element is not showing in Milestone Table(MLST)

[former_member629952]

Hi seniors,

For my client requirement I need to trigger a mail at the time of Milestone confirmation, There using two scenarios,

1) Milestone directly under the WBS

2) WBS > Network > Activity > Milestone.

For the email content I need to fetch up the organization structure data like plant and location, so that I can maintain Z table for maintain email id with plant details.

Coming to the point, The WBS element is a only link for MLST and PRPS, WBS element data is not updating in MLST table for scenario 2

What can I do to resolve this issue, Kindly help.

[Prasath · Accepted solution]

Dear Vignesh,

AUFPL – Operation task list number in MLST table is also known as order number which is common for all orders (Including Network order) APLZL – Is an Activity number.

These both are the key link for your requirement.

Now, Pass the Milestone number in MLST - MLST_ZAEHL, Pick the AUFPL and APLZL values,

Pass that into the AFVC – AUFPL , AFVC – APLZL,

Get PROJN, WERKS and BUKRS. WBS ,Plant and company code. Hope this fulfilled your requirement.

Reg

Prasath E

[former_member629952 · Accepted solution]

Dear Prasath,

I am familiar with AFVC table but I cannot able to find the key for it, This helps a lot.

Thanks for your solution. Good day...

[Ken_Melching]

Look in Project Builder and the Milestone will be below its assigned object. Milestones can be assigned to either a WBS or a Network Activity.

To understand things at the table level you need to study object numbers for the different objects. WBS elements start with PR and network activities start with NV.

[former_member629952]

Dear Ken,

Thanks for sharing about object numbers, I learned a new thing.

[TammyPowlas]

Scenario 2, I am guessing, has a network and not a WBS

Then you will have to find the link between the network on the milestone and it's related WBS

See this blog for a start - https://blogs.sap.com/2015/04/03/sap-ps-useful-tables-linkage-to-fetch-data-from-various-tables/ there's a section on MLST table

[former_member629952]

Dear Tammy,

Thanks for information, The blog is really helpful.

[BalasubramanianAP]

Check whether you get PLNNR (network number) from MLST table.

You may have to query CAUFV table/view by passing AUFNR (PLNNR of MLST table) field to get the wbs number (PSPEL field).

[former_member629952]

Dear Bala,

Thank you for sharing this, PLNNR also empty in MLST.

CAUFV table is really helpful.