【SAP】ABAP开发——交货已完成、冻结、删除标识

最新推荐文章于 2024-07-22 11:02:31 发布

Mona_1220

最新推荐文章于 2024-07-22 11:02:31 发布

阅读量2.3k

点赞数 1

本文链接：https://blog.csdn.net/Mona_1220/article/details/102697827

版权

SELECT ekko~ebeln
         ekpo~ebelp
         ekpo~matnr
         ekpo~werks
         ekko~ekgrp
         ekko~ekorg
         ekko~lifnr
         ekpo~netpr
         ekpo~peinh
         ekpo~menge
         ekko~bedat
         ekpo~webre
         ekko~waers
         ekpo~pstyp
    INTO TABLE gt_po
    FROM ekko
    JOIN ekpo ON ekko~ebeln = ekpo~ebeln
    WHERE ekpo~matnr IN s_matnr
     AND  ekpo~werks IN s_werks
     AND  ekko~ekgrp IN s_ekgrp
     AND  ekko~ekorg IN s_ekorg
     AND  ekko~bedat IN s_bedat
     AND  ekko~lifnr IN s_lifnr
     AND  ekko~ebeln in s_ebeln
     AND ekpo~netpr <> '0'
     AND ekpo~retpo <> 'X'
     AND ekpo~loekz <> 'S'    " S：冻结
     AND ekpo~loekz <> 'L'    " L: 已删除
     AND ekpo~elikz <> 'X'.   " 交货已完成：  "X": 是    ""：否