ABAP
fgqlmd
这个作者很懒,什么都没留下…
展开
-
2021-03-06
客户期初余额CDSdefine view ZCDS_CSTM_BGN_BLNwith parameters pm_bukrs : bukrs,pm_kunnr : kunnr,pm_gsber : gsber,pm_enddat: datsas select from bseg as Aleft outer join bkpf as B on A.belnr = B.belnr andA.gjahr = B.gjahr andA.bukrs = B.bukrs {key A.bukrs,原创 2021-03-06 11:17:52 · 76 阅读 · 1 评论 -
2021-03-06
获取物料批次的含税单价select amatnr,acharg,division( b~BRTWR ,b~menge,2 ) as taxpricefrom matdoc as ainner join ekko as c on a~ebeln = c~ebelninner join ekpo as b on a~ebeln = b~ebeln and a~ebelp = b~ebelpwhere a~matnr like ‘%101010003’ and a~charg = ‘3005054293原创 2021-03-06 11:14:32 · 31 阅读 · 0 评论