1、VBFA(销售凭证流) 这张表记录销售订单对应的交货单(子层凭证类别VBTYP_N = ‘J’),以及底层过账发货生成的物料 凭证(子层凭证类别VBTYP_N = ‘R’)、冲销交货单生成的物料凭证(子层类别VBTYP_N = ‘H’),还有等等。 2、VBUK(销售凭证 : 抬头状态和管理数据) 这张表既记录了销售订单的表头交货状态...
vbfa~vbelv=vbap-vbelnANDvbfa~posnv=vbap-posnrANDvbfa~vbtyp_v='C'ANDvbfa~vbtyp_n='J' 另外,根据SO查找PO时,可以根据EKKN-VBELN= VBAP-VBELNANDEKKN-VBELP=VBAP-POSNR到SO与PO中间表EKKN里去找,但查找条件为非主键也非索引,所以找起来时很慢,可以通过VBFA单据流表进行查找,因为VBFA在vbeln、pos...
SELECT vbeln FROM vbfa INTO TABLE gt_vbfa 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 vbel...
1.For the combination of VBAP_VBELN and VBAP-POSNR, where VBAP-PSTVY = ZD2D, Please check if VBFA-VBTYP_N = blank, then display the output. 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...
inner join sapsr3.vbfa 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 vu on vu.vbeln = va2.VBELN and vu.posnr = va2.POSNN and vu.WBSTA = 'C' --交货单已...
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' ...
DATA: zvbtyp LIKE vbfa-vbtyp_n, zvbeln LIKE vbfa-vbeln. CASE SCREEN-GROUP3. WHEN '900'. IF VBAK-VBTYP NE 'A'. SCREEN-ACTIVE = 0. ENDIF. ENDCASE. CASE SCREEN-NAME. WHEN 'VBAK-VBELN'. SCREEN-ACTIVE = 0. ENDCASE. IF vbap-pstyv = 'IRLA'. ...
DATA:BEGIN OFvbfa_tabOCCURS0, vbelvTYPEvbfa-vbelv, posnvTYPEvbfa-posnv, vbelnTYPEvbfa-vbeln, posnnTYPEvbfa-posnn, vbtyp_nTYPEvbfa-vbtyp_n, vbtyp_vTYPEvbfa-vbtyp_v, """$"$\SE:(4) Function Module FDM_COLL_INVOICES_READ, End, Enhancement ZFSCM_FILL_PONUMB, Struct. VBFA_TAB, ...
yes, the vbfa-vbtyp_n = J, so may i know the delivery quantity is vbfa-rfmng? also, may i know if the 3 tables field values are the same? i will close the thread if i got the confirmation. points already rewarded. thanksAnswers...
VBFA-VBTYP_N (subsequent document type) = 'M' (Invoice) Result is in: VBFA-VBELN (subsequent documnent) Regards jack You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in. Comment Comments (0) ...