SAP专业培训教材SD_MM_interface

1、SAP Impleme ntati onDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nal Desig n Form.docAuthorCreated on5/31/2021 7:10:00 AMReviewerWindows 用户Versio nv1Created by:<Wen dy><2002-3-15><Purpose>Approved by:<Name><Date>vComme nt>Reviewed by:<Name><Date>v

2、Major Chan ges>Reviewed by:<Name><Date>vMajor Chan ges>Reviewed by:<Name><Date><Major Chan ges>Reviewed by:<Name><Date><Major Chan ges>Reviewed by:<Name><Date><Major Chan ges>Reviewed by:<Name><Date><Major Chan ge

3、s>Reviewed by:<Name><Date><Major Chang es>Reviewed by:<Name><Date><Major Chang es>SAP Impleme ntati onDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nal Desig n Form.docAuthorCreated on5/31/2021 7:10:00 AMReviewerWindows 用户Versio nv11. In terface Tech ni

4、cal Desig nProject:Function Area:SD MMPriority (H/M/L):Designed by:Signed-Off by:Signed-Off Date:1.1 In terface Defin iti onInterface Title:Interface between SAP and DCS Inventory management systemDepartment:Comments:Define a job iNt 'Job execute frequency: Daily on 23:50 using report: ZSDMMR1.2

5、 Developme nt In formati onProgram Name:ZSDMMR (main program), ZSDR007, ZMMR008Program Description:1.3 Design Field Mapping:Field NameField DescriptionSAP Table FieldRemarksCustomized table: zsdmmt.Technical Flow Diagram:Main Logic Flow:Main program ZSDMMR REPORT ZSDMMR . tables : ZSDMMT.*Author: Wa

6、ngnaDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nalDesig n Fo rm.docReviewerWindows 用户Versio nv1*Date: 2002/03/11* This report is to call 2 in terface (SD&MM) program * select billi ng docume nt created on sy-datum. en d-of-selecti on.*Make caculati on sort i_bill by vtweg mat nr. loop

7、at i_bill.case i_bill-vtweg. whe n c_road.Tot10_qty = Tot10_qty + i_bill-fklmg. Tot10_amt = Tot10_amt + i_bill-kzwi5. whe n c_water.Tot20_qty = Tot20_qty + i_bill-fklmg. Tot20_amt = Tot20_amt + i_bill-kzwi5.whe n c_rail.Tot30_qty = Tot30_qty + i_bill-fklmg. Tot30_amt = Tot30_amt + i_bill-kzwi5.ENDCA

8、SE.-if i_bill-mat nr = c_c3. c3_qty = c3_qty + i_bill-fklmg.elseif i_bill-mat nr = c_c4. c4_qty = c4_qty + i_bill-fklmg.en dif .W_MEINS = l_BILL-MEINS. W_WAERK = l_BILL-WAERK. en dloop.* GET C3 & C4 MOVING PRICE.SELECT SINGLE VERPR INTO C3_PRICE FROM MBEWWHERE BWKEY EQ 'BPNB' AND MATNR E

9、Q C_C3.SELECT SINGLE VERPR INTO C4_PRICE FROM MBEWWHERE BWKEY EQ 'BPNB' AND MATNR EQ C_C4. Execute Freque nee: dailydata: w_date like sy-datum,w_time like ZSDMMT-ytime.w_date = sy-datum. w_time = sy-uzeit.export w_date to memory id 'DATE'. EXPORT W_TIME TO MEMORY ID 'TIME'.SU

10、BMIT ZSDR004 AND RETURN. SUBMIT ZMMR005 AND RETURN.Porgram: zsdr004REPORT ZSDR004 .*Author: Wen dy.Wa ng *Date: 2002/02/22*This report is to caculte average price and qty data: beg in of i_bill occurs 0,* erdat like vbrp-erdat, "bill create dateVTWEG like vbrp-VTWEG_AUFT, "Distribution Cha

11、 nnel mat nr like vbrp-mat nr, "material number kzwi5 like vbrp-kzwi5, "Total amount Waerk like vbrk-waerk, "curre ncy key fklmg like vbrp-fklmg, "Billed qua ntity mei ns like vbrp-me ins, " unit vbe In like vbrp-vbe In, "Billi ng nu mber pos nr like vbrp-posnr, "B

12、illing item number end of i_bill.DATA: W_WAERK LIKE VBRK-WAERK,-W_MEINS LIKE l_BILL-MEINS. Total qty & amount for differe nt distributi on cha nnel data: Tot10_qty like vbrp-fklmg,"road total qua ntityFor each distribution channel and update Customized table:zsdmmt*The reprot is scheduled a

13、s a job to execute dailyTables: vbak, "Sales order headvbap, "sales order items vbrk, "Billi ng head vbrp, "Billi ng item mbew, "Material Valuati on zsdmmt. "Customized table con sta nts: c_c3 like mbew-mat nr value '3000000001', c_c4 like mbew-mat nr value '

14、;3000000011'. con sta nts:c_road like vbak-VTWEGvalue '10',c_water like vbak-VTWEGvalue '20',c_rail like vbak-VTWEG value '30'.data: w_date like sy-datum,w_time like ZSDMMT-ytime.SAP Impleme ntati onDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nal Desig n Form.doc

15、AuthorCreated on5/31/2021 7:10:00 AMReviewerWindows 用户Versio nv1* for material C3&C4 billed quantity and moving price data: c3_qty like vbrp-fklmg, "billed qtyc4_qty like vbrp-fklmg, c3_price like mbew-verpr, "mov ing price c4_price like mbew-verpr.INITIALIZATION.IMPORT W_DATE FROM MEM

16、ORY ID 'DATE'. IMPORT W_TIME FROM MEMORY ID 'TIME'.start-of-selectio n.* Select sales order billed on sy-datum.selectavtweg_AUFT amat nr akzwi5 bwaerk afklmg ame ins avbe In apos nr into (i_bill-vtweg, i_bill-mat nr, i_bill-kzWI5, i_bill-waerk, i_bill-fklmg, i_bill-mei ns, i_bill-vbe

17、 In, i_bill-pos nr) fROM vbrp as a inn er jo in vbrk as b on avbe In = bvbe In where aerdat eq w_date and auepos = '000000' "mea ns upper leverl mat and avkorg_auft = 'BPNB'. appe nd i_bill. en dselect.SAP Impleme ntati onDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nal

18、Desig n Form.docAuthorCreated on5/31/2021 7:10:00 AMReviewerWindows 用户Versio nv1SAP Impleme ntati onDocume ntProject Docume ntFile Name400_ABAP_Fu nctio nal Desig n Form.docAuthorCreated on5/31/2021 7:10:00 AMReviewerWindows 用户Versio nv1ZSDMMT-SDRDQTY = TOT10_QTY.ZSDMMT-SDWTQTY = TOT20_QTY.ZSDMMT-SD

19、RLQTY = TOT30_QTY.ZSDMMT-SDGRQTY = ZSDmMt-MMC3QTY_REV + ZSDMMT-MMC4QTY_REV.ZSDMMT-SDLVQTY = ZSDMMT-MMC3QTY_NH02 + ZSDMMT-MMC4QTY_NH03 + ZSDMMT-MMC4QTY_NH02.ZSDMMT-SDMEINS = W_MEINS.MODIFY ZSDMMT.1.4 Data Dictio nary Modificatio nsOverview of New/Change Data Dictionary Objects:Object TypeStatusNameDetails of Data Dictionary ModificationsFieldNameDescriptionKeyData ElementDomainTypeLengthCheck Table1.5 Test Con ditionNo.Test ConditionEx