Reg WBS data fetching

[Former Member]

iam unable to fetch the WBS data for MEXICO orders with the follwing query

*.select all date activities found for the WBS

SELECT afvc_{projn afvc}aufpl afvc_{aplzl afvu}usr00

INTO TABLE gt_sid_hod

FROM afvc INNER JOIN afvu ON

( afvc_{aufpl = afvu}aufpl AND

afvc_{aplzl = afvu}aplzl )

FOR ALL entries IN lt_vbup_vbap

WHERE afvc~projn EQ lt_vbup_vbap-pspnr

AND afvu~usr00 IN ('SID', 'HOD',

'RRD', 'ITD', 'SDD', 'DDQ', 'DID' ).

Can you please advise..there is any constaraints..

But the sale orders are aviable with Project and its activites

Thanks

Ram

[Kanagaraja_L]

Have you checked the Values available/Not in the DB Table level.

Kanagaraja L

[Former Member]

Hi ,

Thanks for answering

WBS element is not avilable in the AFVC table for the mexico orders,but it will update the WBS for the ohter organization.

please let me how the WBS can updated in the AFVC table.

Thanks & Regards

Ram

[Kanagaraja_L]

WBS updated in AFVC Table if you are looking for PROJN you need to do the conversion

CONVERSION_EXIT_ABPSP_INPUT Conversion External > Internal WBS Element Number

CONVERSION_EXIT_ABPSP_OUTPUT Conversion Internal > External WBS Element Number

and also check the Std WBS element PSPNR in the Table level.

Kanagaraja L

[Former Member]

Thank for answering,

But we are unable to see the WBS element in the AFVC even after used the conversion routine.

Please help me how AFVC updated with WBS element.

Thanks&Reagrds