sap推薦樣例word版(參考版)
2024-09-01 16:37本頁(yè)面
【正文】 and so on.)Incorrect:SELECT FROM AUFK WHERE KDAUF = VBAPVBELNAND KDPOS = VBAPPOSNRCorrect:SELECT FROM AFPO WHERE KDAUF = VBAPVBELNAND KDPOS = VBAPPOSNRSELECT FROM AUFK WHERE AUFNR = AFPOAUFNR.Note:The tables AFKO and CAUFV can be selected analogously to the AUFK access using order number AUFNR.3. Access to reservations and dependent requirement (table: RESB, MDRS ATP _RESB)a) Search for reservation for PPS orders (field RESBAUFNR):Incorrect:SELECT FROM resb WHERE AUFNR = ...Correct:SELECT rsnum FROM afko WHERE aufnr = resbaufnrSELECT ..... FROM resb WHERE rsnum = afkorsnum Note:The same access path applies to MDRS and ATP_RESB.b) Search for reservation for Planned orders (field RESBPLNUM):Incorrect:SELECT FROM resb WHERE PLNUM = ... Correct:SELECT rsnum FROM plaf WHERE plnum = resbplnumSELECT ..... FROM resb WHERE rsnum = plafrsnumNote:The same access path applies to MDRS and ATP_RESB.Source code corrections。 CAUFVRSNUM):Incorrect:SELECT FROM afko WHERE rsnum = ... Correct:SELECT aufnr FROM resb WHERE rsnum = afkorsnumSELECT ..... FROM afko WHERE aufnr = resbaufnrNote:The same access path applies to CAUFV and AUFK.Search for sales orders (tables VBAPVBELN, VBAPPOSNR。X39。AND vbeln = i_lipsvbeln orSELECT aubel FROM vbrp WHERE vbeln = ... a) Search for shipping unit item with deliveryIncorrect: SELECT FROM vepo WHERE vbtyp = 39。In table VBFA only the preceeding document is used to search for the subsequent document (for example, delivery for order). Searching the other way makes no sense with this table since the preceding documents (for example, order for delivery) are stored directly in the document tables. Thus reading in table VBFA is a oneway street.Correct: SELECT vgbel FROM lips WHERE vbeln = ...。 M39。 AND vbelv = ...SELECT FROM vbrp WHERE vbeln = vbfavbelnAND posnr = vbfaposnn a) Search for invoices with order number (preceding document, field VBRPAUBEL):Incorrect: SELECT FROM vbrp WHERE aubel = ...Correct: SELECT FROM vbfa WHERE vbtyp_n = 39。 Correct: SELECT FROM vrkpa WHERE kunde = ...SELECT FROM vbrk WHERE vbeln = vrkpavbeln a) Search for invoice items with material number (field VBRPMATNR):Incorrect: SELECT FROM vbrp WHERE matnr = ... SELECT FROM lips WHERE vbeln = vbfavbelnAND posnr = vbfaposnn a) Other search helps for deliveries offer matchcode tables and views M_VMVLx, x. = A, B, C, ... M。Correct: SELECT FROM vbfa WHERE VBELV = ... and VBTYP_N = 39。 Correct: SELECT FROM vlkpa WHERE kunde = ...SELECT FROM likp WHERE vbeln = v
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1