点击此处---> 群内免费提供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) *结束
如果您需要更多信息,请告诉我。
代码没有任何问题:
但是必须限制时间!
也
可用于所有stataccount帐户!
嗨,Vadim,
一如既往地非常感谢您的宝贵帮助:)
一周热门 更多>