逻辑脚本在WHEN/ENDWHEN条件下不起作用

2020-08-27 18:23发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,瓦迪姆,

我对您帮助我的逻辑脚本有一个小问题。 这与我使用的YTD计算逻辑脚本相同。

我们将数据加载到审计跟踪INPUT_PERIP中,然后转换为YTD并存储在INPUT_YTDIP中。

要求-

我需要输入一些帐号。 来自BAS(STATACCTS),它是人数值。 这些不应转换为YTD,而应与逻辑转换YTD金额(INPUT_YTDIP)时保存在同一AUDIT TRAIL中。

下面是我修改的代码,

该脚本正确执行了YTD计算。

我已经添加了一段新代码(//将FTE帐户写入审核跟踪INPUT_YTDIP,而没有进行YTD转换),以将FTE帐户写入AUDIT TRAIL-INPUT_YTD。

但是代码跳过了这一位,直接进入//Scope区域清除//清除数据

您能帮我解决这里可能不正确的地方吗?

如果需要更多信息,请告诉我

 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP//确定从BWIP加载的数据的范围
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(NETINC)




 * SELECT(%Y%,[YEAR],TIME,[ID] =%TIME_SET%)
 * SELECT(%M01%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 1 AND [CALC] = N)//从时间中选择月份和年份
 * SELECT(%M02%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 2 AND [CALC] = N)
 * SELECT(%M03%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 3 AND [CALC] = N)
 * SELECT(%M04%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 4 AND [CALC] = N)
 * SELECT(%M05%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 5 AND [CALC] = N)
 * SELECT(%M06%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 6 AND [CALC] = N)
 * SELECT(%M07%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 7 AND [CALC] = N)
 * SELECT(%M08%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 8 AND [CALC] = N)
 * SELECT(%M09%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 9 AND [CALC] = N)
 * SELECT(%M10%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 10 AND [CALC] = N)
 * SELECT(%M11%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 11 AND [CALC] = N)
 * SELECT(%M12%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 12 AND [CALC] = N)


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%,%M12  %
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M12%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M11%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M10%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M09%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M08%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M07%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M06%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M05%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M04%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M03%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M02%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M01%,AUDITTRAIL = INPUT_YTDIP)
 *结束


//将FTE帐户写入审核记录INPUT_YTDIP,而无需进行YTD转换
 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(STATACCTS)


 *当帐户
 * IS" S0152"," S0153"," S0201"," S0202"," S0203"," S0204"
 * REC(EXPRESSION =%VALUE%,AUDITTRAIL = INPUT_YTDIP)
 *结束


//要清除的范围区域
 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(NETINC),BAS(STATACCTS)
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%,%M12  %


//清除数据
 *到时
 *是*
 * REC(EXPRESSION = 0)
 *结束


 

如果您需要更多信息,请告诉我。

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


嗨,瓦迪姆,

我对您帮助我的逻辑脚本有一个小问题。 这与我使用的YTD计算逻辑脚本相同。

我们将数据加载到审计跟踪INPUT_PERIP中,然后转换为YTD并存储在INPUT_YTDIP中。

要求-

我需要输入一些帐号。 来自BAS(STATACCTS),它是人数值。 这些不应转换为YTD,而应与逻辑转换YTD金额(INPUT_YTDIP)时保存在同一AUDIT TRAIL中。

下面是我修改的代码,

该脚本正确执行了YTD计算。

我已经添加了一段新代码(//将FTE帐户写入审核跟踪INPUT_YTDIP,而没有进行YTD转换),以将FTE帐户写入AUDIT TRAIL-INPUT_YTD。

但是代码跳过了这一位,直接进入//Scope区域清除//清除数据

您能帮我解决这里可能不正确的地方吗?

如果需要更多信息,请告诉我

 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP//确定从BWIP加载的数据的范围
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(NETINC)




 * SELECT(%Y%,[YEAR],TIME,[ID] =%TIME_SET%)
 * SELECT(%M01%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 1 AND [CALC] = N)//从时间中选择月份和年份
 * SELECT(%M02%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 2 AND [CALC] = N)
 * SELECT(%M03%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 3 AND [CALC] = N)
 * SELECT(%M04%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 4 AND [CALC] = N)
 * SELECT(%M05%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 5 AND [CALC] = N)
 * SELECT(%M06%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 6 AND [CALC] = N)
 * SELECT(%M07%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 7 AND [CALC] = N)
 * SELECT(%M08%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 8 AND [CALC] = N)
 * SELECT(%M09%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 9 AND [CALC] = N)
 * SELECT(%M10%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 10 AND [CALC] = N)
 * SELECT(%M11%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 11 AND [CALC] = N)
 * SELECT(%M12%,[ID],TIME,[YEAR] =%Y%AND [MONTHNUM] = 12 AND [CALC] = N)


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%,%M12  %
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M12%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M11%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M10%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M09%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M08%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M07%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M06%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M05%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M04%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M03%,AUDITTRAIL = INPUT_YTDIP)
 *结束
 * XDIM_MEMBERSET TIME =%M01%,%M02%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M02%,AUDITTRAIL = INPUT_YTDIP)
 *结束


 * XDIM_MEMBERSET TIME =%M01%
 *到时
 *是*
  * REC(EXPRESSION =%VALUE%,TIME =%M01%,AUDITTRAIL = INPUT_YTDIP)
 *结束


//将FTE帐户写入审核记录INPUT_YTDIP,而无需进行YTD转换
 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(STATACCTS)


 *当帐户
 * IS" S0152"," S0153"," S0201"," S0202"," S0203"," S0204"
 * REC(EXPRESSION =%VALUE%,AUDITTRAIL = INPUT_YTDIP)
 *结束


//要清除的范围区域
 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(NETINC),BAS(STATACCTS)
 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%,%M07%,%M08%,%M09%,%M10%,%M11%,%M12  %


//清除数据
 *到时
 *是*
 * REC(EXPRESSION = 0)
 *结束


 

如果您需要更多信息,请告诉我。

付费偷看设置
发送
2条回答
代楠1984
1楼 · 2020-08-27 19:01.采纳回答

代码没有任何问题:

//将FTE帐户写入审核跟踪INPUT_YTDIP,而无需进行YTD转换
 * XDIM_MEMBERSET AUDITTRAIL = INPUT_PERIP
 * XDIM_MEMBERSET FLOW = F_NONE
 * XDIM_MEMBERSET CATEGORY = FORECAST_IP
 * XDIM_MEMBERSET RPTCURRENCY = LC
 * XDIM_MEMBERSET INTERCO = I_3RD
 * XDIM_MEMBERSET帐户= BAS(STATACCTS)
 *当帐户
 * IS" S0152"," S0153"," S0201"," S0202"," S0203"," S0204"
 * REC(EXPRESSION =%VALUE%,AUDITTRAIL = INPUT_YTDIP)
 * ENDWHEN 

但是必须限制时间!

 * XDIM_MEMBERSET TIME =%M01%,%M02%,%M03%,%M04%,%M05%,%M06%  ,%M07%,%M08%,%M09%,%M10%,%M11%,%M12%

 *
 * IS * 

可用于所有stataccount帐户!

野沐沐
2楼-- · 2020-08-27 18:46

嗨,Vadim,

一如既往地非常感谢您的宝贵帮助:)

一周热门 更多>