在S/4HANA里,我们如何根据一个销售订单的行项目,查看对应的生产订单状态?
双击行项目:
![webp](https://i-blog.csdnimg.cn/blog_migrate/ecbdacd3db650b50d776560aaf27df4c.webp?x-image-process=image/format,png)
点击Schedule line:
![webp](https://i-blog.csdnimg.cn/blog_migrate/0b59b54a102546dd94a189b0aeba82e8.webp?x-image-process=image/format,png)
这里就能看到生产订单的ID和状态了。
![webp](https://i-blog.csdnimg.cn/blog_migrate/01f4330d717af8605629baab89045c35.webp?x-image-process=image/format,png)
其中订单的状态存储在表vsaufk里,注意订单和状态可以是1对多的关系。
状态的ID和描述信息存储在表tj02t里,所以有了下面的代码:
METHOD get_prod_order_status. DATA: lt_status TYPE TABLE OF j_status, lt_text TYPE TABLE OF tj02t, lv_id LIKE iv_prod_order_id, ls_result LIKE LINE OF rt_status_in_s4_format. lv_id = iv_prod_order_id. CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT' EXPORTING input = lv_id IMPORTING output = lv_id. SELECT stat INTO TABLE lt_status FROM vsaufk WHERE inact = space AND aufnr = lv_id. CHECK sy-subrc = 0. SELECT * INTO TABLE lt_text FROM tj02t FOR ALL ENTRIES IN lt_status WHERE istat = lt_status-table_line AND spras = 'EN'. LOOP AT lt_text ASSIGNING FIELD-SYMBOL(<text>). CLEAR: ls_result. ls_result-status_id = <text>-istat. ls_result-status_code = <text>-txt04. ls_result-status_text = <text>-txt30. APPEND ls_result TO rt_status_in_s4_format. ENDLOOP. ENDMETHOD.
测试一下,成功拿到所有状态,和事务码CO03里看到的一样。
![webp](https://i-blog.csdnimg.cn/blog_migrate/d557c2b05d580208a88a0d3d80f60671.webp?x-image-process=image/format,png)
要获取更多Jerry的原创文章,请关注公众号"汪子熙":
![webp](https://i-blog.csdnimg.cn/blog_migrate/74558bb18967c3bd534a6a96ff665331.webp?x-image-process=image/format,png)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24475491/viewspace-2375014/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24475491/viewspace-2375014/