topic How we can update fields in PRPS table in Application Development and Automation Discussions

How we can update fields in PRPS table

Former Member — Wed, 07 Nov 2007 08:52:13 GMT

I have a requirement like, need to update one field in PRPS table. Actually this table append with some Z - fields. I have to update one of the Z field for WBS level 1 value also sub levels i.e. level2 and level3 of respective WBS element.

please help me int this. Thanks in advance.

Re: How we can update fields in PRPS table

Former Member — Wed, 07 Nov 2007 09:02:56 GMT

good

check this code

Report ZUPDATE_PRPS.

tables: prps.

parameter: p_wbs like prps-pspnr,

p_value like prps-fakkz default 'X'.

data: wa_fakkz type prps-fakkz.

************************************************************************

*START-OF_SELECTION

start-of-selection.

call function 'CONVERSION_EXIT_ABPSP_INPUT'

exporting

input = p_wbs

importing

output = p_wbs

exceptions

not_found = 1

others = 2.

select single fakkz

into wa_fakkz

from prps

where pspnr eq p_wbs.

if sy-subrc eq 0.

update prps set fakkz = p_value where PSPNR eq p_wbs.

if p_value is initial.

message i999(za) with 'Billing element field has been unchecked'.

else.

message i999(za) with 'Billing element field has been checked'.

endif.

else.

message i999(za) with 'WBS element not found'.

endif.

reward point if helpful.

thanks

mrutyun^

Re: How we can update fields in PRPS table

Former Member — Wed, 07 Nov 2007 09:04:16 GMT

Check transactions CJ11, CJ12 and CJ13..

Check if one of the below exits are useful esp ones in bold

<b>CNEX0004 PS: Customer specific fields standard WBS element

CNEX0007 PS customer specific fields WBS element</b>

CNEX0012 Derive external network number from WBS number

CNEX0033 WBS: Predefine Search and Replace String

IWO10010 Maint. order: Cust. enhancement for determining WBS ele

MBCF0006 Customer function for WBS element

PCSD0008 WBS BOM: Customer-specific explosion for creating

PCSD0009 Order/WBS BOM, determine URL page

PCSD0010 Order/WBS BOM, determine explosion date

Regards

Arun

Message was edited by:

Arun Nair