尝试增加条件也仍然提示错误:and VBEP.EDATU<>'00000000' and VBEP.EDATU is not null 原因:SAP数据库中的某些字段查看数据库时是看不到有空格,取出来时却有空格, 解决方法:对日期栏位加上TRIM去除空格。 and trim(VBEP.EDATU)!='00000000' and VBEP.EDATU is not null...
EDATU | VBEP-EDATU | | 交货工厂 | WERKS | VBAP-WERKS | | 存储地点 | LGORT | VBAP-LGORT | | 退货批次 | CHARG | VBAP-CHARG | | 价格类型1 | KSCHL | KONV-KSCHL | | 交易指导价 | NETPR | VBAP-NETPR | | 客户折扣% | KBETR3 | PRCD_ELEMENTS-KBETR | | 拒绝原因 | AB...
kv.klabc,--ABC等级 ltrim(vp.vbeln,'0') vbeln,--订单 ltrim(vp.posnr,'0') posnr,--行 ltrim(vp.matnr,'0') matnr,--物料 mt.MAKTX,--物料描述 ve.EDATU,--交期 vp.KWMENG,--订货量(订货单位) vp.VRKME,--订货单位 vp.UMVKZ * vp.KWMENG / vp.UMVKN KLMENG, --订货量(基本单...
否则报错不允许交货过账;IF(sy-tcode='VL01N'ORsy-tcode='VL02N').DATA:lv_auartTYPEvbak-auart." 订单类型DATA:lv_edatuTYPEvbep-edatu.DATA:lv_wadatTYPElikp-wadat_ist.CLEAR:lv_auart,lv_edatu,lv_wadat.LOOPATxlips." 取订单行计划行日期 xlips-vgbelSELECTSINGLEauartFROMvbakINTOlv_auartW...
Please give me table/field name where I can find delivery date requested by customer. What is the difference between delivery date requested by customer, VBAK-VDATU (system generated req deliv date) and VBEP-EDATU (schedule line date). Thanks Lisa.Know...
on a1belnr = vbapvbeln inner join vbep on vbapvbeln = vbepvbeln and vbapposnr = vbepposnr where a1~werks = p_werks AND vbap~vstel = p_vstel AND vbep~edatu = p_edatu AND (vbep~mbdat <= p_edatu OR vbep~tddat <= p_edatu ). regards, Anji Reply ...
'EDATU', vbep-edatu, 'MBDAT', vbep-mbdat. ENDSELECT. SELECT SINGLE * FROM vbep WHERE vbeln = vbap-vbeln AND posnr = vbap-posnr. CHECK sy-subrc = 0. CLEAR lt_schdl. lt_schdl-itm_number = lt_schdlx-itm_number = vbep-posnr. ...
VBAK-VDATU = VBEP-EDATU. endif. With this system will always take schedule line date (Calculated by lead time) as requested delivery date and user can't change it manually in VA01. You can modify logic as per your requirement. See if this helps y...
During Sales order change (VA02), If I change the material group 2 (from additional data 1) vbap-mvgr2 field value from blank to '06', the delivery date of the sales order item needs to be redermined (i.e. vbep-edatu). However, the change of field VBAP-MVGR2 doesn't trigger...
Even it did not update in my user exit when I update from VBEP-WADAT. So, I did back calculation (considering route lead time) and updated Delivery date field VBEP-EDATU. It is simple. I have given the sample code as below. if lines( xvbap[] ) = 1 and VBEP-ETENR = '0001' an...