原因: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...
vbep-edatu = itab-d_date. select a1belnr a1posnr vbep~etenr into corresponding fields of table itab from a1 inner join vbap on a1belnr = vbapvbeln inner join vbep on a1posnr = vbepposnr where a1~werks = p_werks AND vbap~vstel = p_vstel AND vbep~edatu = p_edatu AND (...
SAP Managed Tags: SD (Sales and Distribution) 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 ...
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, --订货量(基本单...
*&MTS销售订单在VL01N创建出库交货时,控制实际发货日期不能晚于订单交货日期,否则报错不允许交货过账;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...
'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. ...
I am getting system dump due to "DYNPRO_FIELD_CONVERSION". This is happening as negative sign is appearing in cumulative quantity field in VBAP and VBEP tables. "Information on where terminated The termination occurred in the ABAP program "SAPMV45A" in "VBEP-EDATU_AUSGEBEN". The main progr...
xvbep-edatu = li_slines-req_date. xvbep-prgrs = '1'. APPEND xvbep. CLEAR xvbep. PERFORM FCODE_BVFP. Reply All forum topics Previous Topic Next Topic 2 REPLIES Former Member 2007 Dec 11 10:08 PM 0 Kudos 123 SAP Managed Tags: ABAP Extensibility Can tell me the Trans...
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...