*WHEN_REF_DATA = MASTER_DATA Statement taking more time in execution

157 Views

Hi gurus,

Im working on script logic where i had to use *WHEN_REF_DATA = MASTER_DATA Statement.

Here my Prblem is with out *WHEN_REF_DATA = MASTER_DATA Statement logic execution taking 30 to 40 sec, with is it is taking 30 to 40 min.

why i have to use is. My planned quantity is Zero for some Products and I have inventory for those products. when i write script logic without this statement it is not considering empty product.

Planned Qty Inventory to Produce Product 20 here any data is populating Product1 10 20 here is Ok Product2 10 here is Ok Product3 100 here is Ok

is there anyway without BADI/*WHEN_REF*

*XDIM_MEMBERSET MACHINE_GROUP = PAIRING

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

//*XDIM_MEMBERSET PLANT = 1003

*XDIM_MEMBERSET PRODUCT = P_NONE

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET GRID=G_NONE

*WHEN_REF_DATA = MASTER_DATA

*WHEN PLANT

*IS 1003

*WHEN ACCOUNT

*IS TO_PAIRING

*REC(EXPRESSION = %VALUE% >= 0 ? (%VALUE% - ([ACCOUNT].[SFG],[PLANT].[1003],[MACHINE_GROUP].[NONE_MC_GROUP])):0,ACCOUNT = LONG)

*ENDWHEN

*WHEN ACCOUNT

*IS LONG

*WHEN PLANT

*IS 1003

*REC(EXPRESSION = %VALUE% < 0 ? (%VALUE% - ([ACCOUNT].[TO_PAIRING],[PLANT].[1004],[MACHINE_GROUP].[PAIRING])):0,ACCOUNT = LONG1)

*REC(EXPRESSION = %VALUE% >= 0 ? (%VALUE%):0,ACCOUNT = SEAMING_TRANS,MACHINE_GROUP=SEAMING,PLANT=1003)

*ENDWHEN

Please Suggest me...

Thank you in advance

PJR