EKBE-VGABE=“1”AND EKBE-BWART=105、106、101、102、122、123 ; 汇总EKBE-MENGE EKBE-SHKZG=“H”为减“S”为加 正品编码 替代品编码 EKPO-MATNR最后一位修改为0 EKPO-MATNR最后一位修改为1,如无1则改为2,如无2则为空; 例:EKPO-MATNR=2010010390,则为2010010391或2010010392如果1 没有价格则取2的价...
2)根据读取出的EKKO读取EKPO和EKBE SELECT * FROM EKPO WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND "REPOS" = 'X' AND "LOEKZ" = ' ' SELECT * FROM EKBE WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND ( "VGABE" = '1' OR "VGABE" = '2' ) 3)循环读取EKKO的...
EBELNLIKE EKBE-EBELN,"采购订单号 BUZEILIKE EKBE-BUZEI,"行项目 VGABELIKE EKBE-VGABE,"业务\事件类 BELNRLIKE EKBE-BELNR,"凭证号 MENGE1LIKE EKBE-MENGE,"数量 BWARTLIKE EKBE-BWART,"移动类型 BUDATLIKE EKBE-BUDAT,"过账日期 HSWAELIKE EKBE-HSWAE,"货币 MATNRLIKE EKPO-MATNR,"物料号 ENDOF GT_E...
SELECT * FROM EKBE INTO CORRESPONDING FIELDS OF TABLE LT_EKBE FOR ALL ENTRIES IN LT_EKPO_F WHERE EBELN = LT_EKPO_F-EBELN AND EBELP = LT_EKPO_F-EBELP AND VGABE IN ('1','2','P').这里注意一个标示 VGABE 1 收货 2 发票收据 3 后续借/贷 4 预付款 5 支付 6 库存转移...
Select EKBE-SHKZG EKBE-MENGE EKBE-VGABE from EKBE INTO CORRESPONDING FIELDS OF TABLE WA_EKBE From LFAL inner join EKKO on LFAL~LIFNR = EKKO~LIFNR Inner join EKET on EKKO ~EBELN = EKET ~EBELN Inner join EKBE on EKET~EBELN = EKBE~EBELN AND EKET~EBELP = EKBE~EBELP Where...
1.T-code: ME23N,输入PO号码,转到“Purchase Order History"界面,可以查看Invoice的相关信息。 2.T-code: MIR5, 输入相对应条件,可以查看到MIRO界面的相关信息,即Invoice及其对应的text(一般会输入reference PO)。 3.T-code: SE16N,输入Table EKBE(History per Purchasing Document), 选择Field EBELN, VGABE,...
SELECT * FROM EKBE WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND ( "VGABE" = '1' OR "VGABE" = '2' ) 3)循环读取EKKO的内表,来计算EKBE的交货和发货的的数量和金额,来生成需要开票的金额。 2)MIRO的操作保存时用到的函数 ...
4,422 SAP Managed Tags: ABAP Development Hi all, I was wondering if anyone knew under what conditions a PO Item's VGABE Flag would change from 1(GR) to 8(Delivery Stock transfer) in table EKBE? Any help would be greatly appreciated. Many Thanks, Philip JohannesenReply...
SELECT * FROM EKBE WHERE "MANDT" = '800' AND "EBELN" = '4500000005' AND ( "VGABE" = '1' OR "VGABE" = '2' ) 3)循环读取EKKO的内表,来计算EKBE的交货和发货的的数量和金额,来生成需要开票的金额。 2)MIRO的操作保存时用到的函数 ...
vgabe TYPE ekbe-vgabe, gjahr TYPE ekbe-gjahr, belnr TYPE ekbe-belnr, buzei TYPE ekbe-buzei, dmbtr TYPE ekbe-dmbtr,"收货凭证金额 shkzg TYPE ekbe-shkzg,"S金额为正,H金额是负 werks TYPE ekbe-werks,"地点 END OF ty_ekbe. TYPES : BEGIN OF ty_ekbe_sum, ebeln TYPE ekbe-...