j3rflvmobvedh 新俄罗斯报表配置字段

时间:2024-03-29 10:08:18

取凭证和计算各字段值位置,通过BADI J_3RMOBVEDH实现,在实施类CL_J_3RMOBVEDH_BADI的方法IF_J_3RMOBVEDH_BADI~CALCULATE_TURNOVERS中

 

j3rflvmobvedh 新俄罗斯报表配置字段

 

j3rflvmobvedh 新俄罗斯报表配置字段

可以看到销售出货数量通过 TURNTYP 判断的

                      (

                        case

                            when docs.TURNTYP = 'TS' then docs.MENGE

                            else 0

                        end

                      ) as Issue_To_Sales_Stock,

docs来自这里

from

                      :mm_with_fi_documents as docs

 

TURNTYP 取的是J_3RM_TURN_TYPE这张表

left join j_3rm_turn_type as groups on(     groups.MANDT = mandant

                                                and docPosition.BWART = groups.BWART

                                                and ( docPosition.SHKZG = groups.SHKZG or groups.SHKZG = '' )

                                              )

找到J_3RM_TURN_TYPE有个视图V_J_3RM_TURNTYP,SM30维护一下即可

j3rflvmobvedh 新俄罗斯报表配置字段

j3rflvmobvedh 新俄罗斯报表配置字段