topic Re: Reg WBS data fetching in Application Development and Automation Discussions

Reg WBS data fetching

Former Member — Tue, 04 Aug 2009 08:27:05 GMT

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 — Tue, 04 Aug 2009 11:29:25 GMT

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

Kanagaraja L

Former Member — Tue, 04 Aug 2009 12:43:54 GMT

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 — Tue, 04 Aug 2009 15:40:16 GMT

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 — Wed, 05 Aug 2009 07:06:56 GMT

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