MM(TABLE-FLOWS)
Posts
SAP MM Tables Link and Flow MM flow is processing between business organisation and Vendor: 1...Purchase Requisition --- T.code ---ME51 2...Source List -----T.code-----ME41 3...Request for Quation (RFQ)---T.code--ME21N (To Vendor) 4...Purchase Order ---- T.code ----ME21N (To Vendor) 5...Goods Receipt-------T.code....MIGO (Tables: MKPF, MSEG) 6...Invoice Verification----T.code...MIRO (Tables: BKPF , BSEG) 7...Vendor Payment----T.code...FB60 (FI - Account Payable)
FOR ALL ENTRIES ( JOIN TABLE) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -* *& Report ZREPOR_FOR_ALL *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT ZREPOR_FOR_ALL . TABLES : MARA . SELECT - OPTIONS : S_MATNR FOR MARA - MATNR . DATA : BEGIN OF IMARA OCCURS 0 , MATNR TYPE MARA - MATNR , MBRSH TYPE MARA - MBRSH , MTART TYPE MARA - MTART , END OF IMARA . DATA : BEGIN OF IMARC OCCURS 0 , MATNR TYPE MARC - MATNR , WERKS TYPE MARC - WERKS , END OF IMARC . DATA : BEGIN OF FINAL OCCURS 0 , MATNR TYPE MARA - MATNR , MBRSH TYPE MARA - MBRSH , MTART TYPE MARA - MTART , WERKS TYPE MARC - WERKS , END OF FINAL . SELECT MATNR MBR
UPLOAD FLAT FILE TO SAP USING BDC(CALL TRANSACTION METHODS) report ZMATREIAL no standard page heading line-size 255 . parameters : p_file type rlgrap - filename . data : messtab like bdcmsgcoll occurs 0 with header line . data : bdcdata type bdcdata occurs 0 with header line . data : begin of itab occurs 0 , matnr ( 18 ) , mbrsh ( 1 ) , mtart ( 4 ) , maktx ( 40 ) , meins ( 3 ) , end of itab . data : index ( 5 ) , text ( 50 ) . at selection-screen on value-request for p_file . CALL FUNCTION 'F4_FILENAME' EXPORTING PROGRAM_NAME = SYST - CPROG DYNPRO_NUMBER = SYST - DYNNR * FIELD_NAME = ' ' IMPORTING FILE_NAME = p_file . start - of - selection . data : p_file1 type string . p_file1 = p_file . CALL FUNC
UPLOAD XLS FILE TO SAP USING BDC(CALL TRANSACTION METHODS) report ZNEEDTR no standard page heading line-size 255 . TYPE - POOLS : truxs . PARAMETERS : P_FILE TYPE RLGRAP - FILENAME DEFAULT 'C:\Users\User86\Desktop\JK.xlsx' . DATA : BDCDATA LIKE BDCDATA OCCURS 0 WITH HEADER LINE . * messages of call transaction DATA : MESSTAB LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE . *include bdcrecx1. DATA : BEGIN OF IT OCCURS 0 , MATNR ( 18 ) , MBRSH ( 1 ) , MTART ( 4 ) , MAKTX ( 40 ) , MEINS ( 3 ) , END OF IT . DATA : INDEX ( 5 ) , TEXT ( 50 ) . AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE . CALL FUNCTION 'F4_FILENAME' EXPORTING PROGRAM_NAME = SYST - CPROG DYNPRO_NUMBER = SYST - DYNNR * FIELD_NAME = ' ' IMPORTING FILE_NAME = P_FILE