on 2007 Sep 03 7:27 AM
HI Experts,
I want to delete data-package in the start rotine based on selections below..
How do i do it???
If PLANT not equal to any of the value below
3000, 4000, 5000 , 6000 , 7000
then delete the data-packege otherwise do nothing or just assign the current value in the datapackage4 to PLANT ( like data-package_plant = data_package_plant)
Thanks in advance
DV
LhELLO dvmc
OOP AT DATA_PACKAGE.
IF DATA_PACKAGE-PLANT EQ '3000' .
DELETE DATA_PACKAGE '.
ENDIF.
ENDLOOP.
or
DELETE DATA_PACKAGE where PLANT EQ '3000'.
Thanks
Tripple k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
if you delete the datapackage for the values you have mentionned, the correponsding records won't be updated in your datatarget:
*start routine in transfer rules
DELETE DATAPAK
WHERE NOT
( PLANT = '3000' AND PLANT = '4000'
AND PLANT = '5000' AND PLANT = '6000'
AND PLANT = '7000' ).
*in update rules, replace DATAPAK by DATA_PACKAGE.
If you want to still update the record but leaving the PLANT empty for your values then you'll have to write a transfer or an update routine:
*in TRules
IF TRAN_STRUCTURE-PLANT = '3000'
OR TRAN_STRUCTURE-PLANT = '4000'
OR TRAN_STRUCTURE-PLANT = '5000'
OR TRAN_STRUCTURE-PLANT = '6000'
OR TRAN_STRUCTURE-PLANT = '7000'.
RESULT = TRAN_STRUCTURE-PLANT.
ELSE.
CLEAR RESULT.
ENDIF.
* in URules replace TRAN_STRUCTURE by COMM_STRUCTURE.
Hope this helps...
Olivier.
Message was edited by:
Olivier Cora
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hai,
start routine used for structure diffinition...if u diffine a structure after that field level it will featch the data...after that if u want to delete the selection creteria u go to end routine and delete the oter packages...
thankz & regards,
prakasu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.