1、VBFA(销售凭证流) 这张表记录销售订单对应的交货单(子层凭证类别VBTYP_N = ‘J’),以及底层过账发货生成的物料 凭证(子层凭证类别VBTYP_N = ‘R’)、冲销交货单生成的物料凭证(子层类别VBTYP_N = ‘H’),还有等等。 2、VBUK(销售凭证 : 抬头状态和管理数据) 这张表既记录了销售订单的表头交货状态...
1、VBFA(销售凭证流) 这张表记录销售订单对应的交货单(子层凭证类别VBTYP_N = ‘J’),以及底层过账发货生成的物料 凭证(子层凭证类别VBTYP_N = ‘R’)、冲销交货单生成的物料凭证(子层类别VBTYP_N = ‘H’),还有等等。 2、VBUK(销售凭证 : 抬头状态和管理数据) 这张表既记录了销售订单的表头交货状态...
WHERE vbtyp_n = 'J' .第二步: 用FOR ALL ENTRIES IN 前要先判断是否为空 IF gt_vbfa IS NOT INITIAL .SELECT matnr lfimg vrkme FROM lips INTO gt_lips FOR ALL ENTRIES IN gt_vbfa WHERE vbeln = gt_vbfa-vbeln AND vbelv = gt_vbfa-vbelv AND posnv = gt...
vbuk. "销售凭证 : 抬头状态和管理数据 包括销售和采购 vbup. "销售凭证 : 项目状态 vl01N里面的状态 包括销售和采购 ttsgt. "运输冻结原因的描述 VBPA. "销售凭证 : 合作伙伴 vbfa. "包括了销售凭证的所有数据流,从订单下达,交货,开发票 tables: likp. "SD凭证: 交货抬头数据 lips. "SD凭证: 交货项目...
2.If VBFA-VBTYP_N = M , then check for VBUP-GBSTA not equal to C. If either of the above conditions are fulfilled, the lines should be shown in the report. My question is , can we use a single query to give two different outputs for the above two cases. I was thinkin of usin...
I_VBTYP_N:Document category of subsequent document I_FKTYP:Billing category I_BYPASSING_BUFFER:是否用buffer I_REFRESH_BUFFER:删除buffer? Tables: E_VBFA:凭证流的表 说明:可以通过by passing buffer来优化性能 LIKP_READ:Delivery Header Data 参数: Import: I_VBELN:Delivery LINE_EXIST:if 'x' check...
inner join sapsr3.vbfa@sap va2 ON va2.VBELV = vp2.vbeln AND va2.POSNV = vp2.posnr and ( va2.VBTYP_N = 'T' or va2.VBTYP_N = 'J' ) inner join sapsr3.vbup@sap vu on vu.vbeln = va2.VBELN and vu.posnr = va2.POSNN and vu.WBSTA = 'C' ...
instead of check if a specific invoice is cancelled, you could simply count the number of invoice and invoice cancellations directly in VBFA. You can get that info by the field VBTYP_N in table VBFA, as it specify the kind of billing type. Example 'M' is an invoice, 'N' is a cance...
7, 选用一些替代表/替代字段(VBFA, SHP_IDX_) 曾做过一些类似于“未拣配交货单”、“未发货过账交货单”的报表,刚开始用的是LIKP、VBUK等表,速度并不理想。后来调试了标准程序VL06O,发现其用的表是SHP_IDX_PICK、SHP_IDX_GDSI等。原来系统在创建交货单的时候,也会更新这些临时表。当拣配完成,该条目就从...
vbtyp_nTYPEvbfa-vbtyp_n, vbtyp_vTYPEvbfa-vbtyp_v, """$"$\SE:(4) Function Module FDM_COLL_INVOICES_READ, End, Enhancement ZFSCM_FILL_PONUMB, Struct. VBFA_TAB, End S END OFvbfa_tab. DATA:BEGIN OFvbkd_tabOCCURS0, vbelnTYPEvbkd-vbeln, posnrTYPEvbkd-posnr, bstkdTYPEvbkd-bstkd,...