Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

upload customer master

Former Member
0 Likes
1,126

hi,

could someone please explain how to upload customer master

using call transaction method

what is the transaction

and what are the tables and what is the procedure

regards,

siri.

6 REPLIES 6
Read only

Former Member
0 Likes
1,010

transaction - XD01 or FD01

&----


*& Report *

*& *

&----


*&

*& This program is to transfer data from flat file to transaction 'FD01'

&----


REPORT zgopi_report

NO STANDARD PAGE HEADING

LINE-SIZE 255

MESSAGE-ID ZRASH.

************************************************************************

  • Internal Table Declarations *

************************************************************************

*--Internal Table for Data Uploading.

DATA : BEGIN OF IT_FFCUST OCCURS 0,

KUNNR(10),

BUKRS(4),

KTOKD(4),

ANRED(15),

NAME1(35),

SORTL(10),

STRAS(35),

ORT01(35),

PSTLZ(10),

LAND1(3),

SPRAS(2),

AKONT(10),

END OF IT_FFCUST.

*--Internal Table to Store Error Records.

DATA : BEGIN OF IT_ERRCUST OCCURS 0,

KUNNR(10),

EMSG(255),

END OF IT_ERRCUST.

*--Internal Table to Store Successful Records.

DATA : BEGIN OF IT_SUCCUST OCCURS 0,

KUNNR(10),

SMSG(255),

END OF IT_SUCCUST.

*--Internal Table for Storing the BDC data.

DATA : IT_CUSTBDC LIKE BDCDATA OCCURS 0 WITH HEADER LINE.

*--Internal Table for storing the messages.

DATA : IT_CUSTMSG LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.

DATA : V_FLAG1(1) VALUE ' ',

"Flag used for opening session.

V_TLINES LIKE SY-TABIX,

"For storing total records processed.

V_ELINES LIKE SY-TABIX,

"For storing the no of error records.

V_SLINES LIKE SY-TABIX.

"For storing the no of success records.

************************************************************************

  • Selection screen *

************************************************************************

SELECTION-SCREEN BEGIN OF BLOCK B1.

PARAMETERS : V_FNAME LIKE RLGRAP-FILENAME,

V_SESNAM LIKE RLGRAP-FILENAME.

SELECTION-SCREEN END OF BLOCK B1.

************************************************************************

  • Start-of-selection *

************************************************************************

START-OF-SELECTION.

*-- Form to upload flatfile data into the internal table.

PERFORM FORM_UPLOADFF.

************************************************************************

  • TOP-OF-PAGE *

************************************************************************

TOP-OF-PAGE.

WRITE:/ 'Details of the error and success records for the transaction'

.

ULINE.

SKIP.

************************************************************************

  • End of Selection *

************************************************************************

END-OF-SELECTION.

*-- Form to Generate a BDC from the Uploaded Internal table

PERFORM FORM_BDCGENERATE.

*--To write the totals and the session name.

PERFORM FORM_WRITEOP.

&----


*& Form form_uploadff

&----


  • Form to upload flatfile data into the internal table.

----


FORM FORM_UPLOADFF .

*--Variable to change the type of the parameter file name.

DATA : LV_FILE TYPE STRING.

LV_FILE = V_FNAME.

*--Function to upload the flat file to the internal table.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = LV_FILE

  • FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = 'X'

  • HEADER_LENGTH = 0

  • READ_BY_LINE = 'X'

  • DAT_MODE = ' '

  • IMPORTING

  • FILELENGTH =

  • HEADER =

TABLES

DATA_TAB = IT_FFCUST

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17

.

IF SY-SUBRC = 0.

*--Deleting the headings from the internal table.

DELETE IT_FFCUST INDEX 1.

*--Getting the total number of records uploaded.

DESCRIBE TABLE IT_FFCUST LINES V_TLINES.

ENDIF.

ENDFORM. " form_uploadff

&----


*& Form Form_bdcgenerate

&----


  • Form to Generate a BDC from the Uploaded Internal table

----


FORM FORM_BDCGENERATE .

*--Generating the BDC table for the fields of the internal table.

LOOP AT IT_FFCUST.

PERFORM POPULATEBDC USING :

'X' 'SAPMF02D' '0105',

' ' 'BDC_OKCODE' '/00' ,

' ' 'RF02D-KUNNR' IT_FFCUST-KUNNR,

' ' 'RF02D-BUKRS' IT_FFCUST-BUKRS,

' ' 'RF02D-KTOKD' IT_FFCUST-KTOKD,

'X' 'SAPMF02D' '0110' ,

' ' 'BDC_OKCODE' '/00',

' ' 'KNA1-ANRED' IT_FFCUST-ANRED,

' ' 'KNA1-NAME1' IT_FFCUST-NAME1,

' ' 'KNA1-SORTL' IT_FFCUST-SORTL,

' ' 'KNA1-STRAS' IT_FFCUST-STRAS,

' ' 'KNA1-ORT01' IT_FFCUST-ORT01,

' ' 'KNA1-PSTLZ' IT_FFCUST-PSTLZ,

' ' 'KNA1-LAND1' IT_FFCUST-LAND1,

' ' 'KNA1-SPRAS' IT_FFCUST-SPRAS,

'X' 'SAPMFO2D' '0120',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0125',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0130',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0340',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0360',

' ' 'BDC_OKCODE' '=ENTR',

'X' 'SAPMF02D' '0210',

' ' 'KNB1-AKONT' IT_FFCUST-AKONT,

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0215',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0220',

' ' 'BDC_OKCODE' '/00',

'X' 'SAPMF02D' '0230',

' ' 'BDC_OKCODE' '=UPDA'.

*--Calling the transaction 'fd01'.

<b> CALL TRANSACTION 'FD01' USING IT_CUSTBDC MODE 'N' UPDATE 'S'

MESSAGES INTO IT_CUSTMSG.</b>

IF SY-SUBRC <> 0.

*--Populating the error records internal table.

IT_ERRCUST-KUNNR = IT_FFCUST-KUNNR.

APPEND IT_ERRCUST.

CLEAR IT_ERRCUST.

*--Opening a session if there is an error record.

IF V_FLAG1 = ' '.

PERFORM FORM_OPENSESSION.

V_FLAG1 = 'X'.

ENDIF.

*--Inserting the error records into already open session.

IF V_FLAG1 = 'X'.

PERFORM FORM_INSERT.

ENDIF.

*--Populating the Success records internal table.

ELSE.

IT_SUCCUST-KUNNR = IT_FFCUST-KUNNR.

APPEND IT_SUCCUST.

CLEAR IT_SUCCUST.

ENDIF.

*--Displaying the messages.

IF NOT IT_CUSTMSG[] IS INITIAL.

PERFORM FORM_FORMATMSG.

ENDIF.

*--Clearing the message and bdc tables.

CLEAR : IT_CUSTBDC[],IT_CUSTMSG[].

ENDLOOP.

*--Getting the total no of error records.

DESCRIBE TABLE IT_ERRCUST LINES V_ELINES.

*--Getting the total no of successful records.

DESCRIBE TABLE IT_SUCCUST LINES V_SLINES.

*--Closing the session only if it is open.

IF V_FLAG1 = 'X'.

PERFORM FORM_CLOSESESS.

ENDIF.

ENDFORM. " Form_bdcgenerate

&----


*& Form populatebdc

&----


  • FOrm to Populate the BDC table.

----


FORM POPULATEBDC USING VALUE(P_0178)

VALUE(P_0179)

VALUE(P_0180).

IF P_0178 = 'X'.

IT_CUSTBDC-PROGRAM = P_0179.

IT_CUSTBDC-DYNPRO = P_0180.

IT_CUSTBDC-DYNBEGIN = 'X'.

ELSE.

IT_CUSTBDC-FNAM = P_0179.

IT_CUSTBDC-FVAL = P_0180.

ENDIF.

APPEND IT_CUSTBDC.

CLEAR IT_CUSTBDC.

ENDFORM. " populatebdc

&----


*& Form FORM_OPENSESSION

&----


  • Form to Open a session.

----


FORM FORM_OPENSESSION .

*--Variable to convert the given session name into reqd type.

DATA : LV_SESNAM(12).

LV_SESNAM = V_SESNAM.

*--Opening a session.

CALL FUNCTION 'BDC_OPEN_GROUP'

EXPORTING

CLIENT = SY-MANDT

GROUP = LV_SESNAM

HOLDDATE = '20040805'

KEEP = 'X'

USER = SY-UNAME

PROG = SY-CPROG

  • IMPORTING

  • QID =

EXCEPTIONS

CLIENT_INVALID = 1

DESTINATION_INVALID = 2

GROUP_INVALID = 3

GROUP_IS_LOCKED = 4

HOLDDATE_INVALID = 5

INTERNAL_ERROR = 6

QUEUE_ERROR = 7

RUNNING = 8

SYSTEM_LOCK_ERROR = 9

USER_INVALID = 10

OTHERS = 11

.

IF SY-SUBRC <> 0.

WRITE 😕 'Session not open'.

ENDIF.

ENDFORM. " FORM_OPENSESSION

&----


*& Form FORM_INSERT

&----


  • fORM TO INSERT ERROR RECOED INTO A SESSION.

----


FORM FORM_INSERT .

*--Inserting the record into session.

CALL FUNCTION 'BDC_INSERT'

EXPORTING

TCODE = 'FD01'

  • POST_LOCAL = NOVBLOCAL

  • PRINTING = NOPRINT

  • SIMUBATCH = ' '

  • CTUPARAMS = ' '

TABLES

DYNPROTAB = IT_CUSTBDC

EXCEPTIONS

INTERNAL_ERROR = 1

NOT_OPEN = 2

QUEUE_ERROR = 3

TCODE_INVALID = 4

PRINTING_INVALID = 5

POSTING_INVALID = 6

OTHERS = 7

.

IF SY-SUBRC <> 0.

WRITE 😕 'Unable to insert the record'.

ENDIF.

ENDFORM. " FORM_INSERT

&----


*& Form FORM_CLOSESESS

&----


  • Form to Close the Open Session.

----


FORM FORM_CLOSESESS .

CALL FUNCTION 'BDC_CLOSE_GROUP'

EXCEPTIONS

NOT_OPEN = 1

QUEUE_ERROR = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

ENDIF.

ENDFORM. " FORM_CLOSESESS

&----


*& Form FORM_FORMATMSG

&----


  • Form to format messages.

----


FORM FORM_FORMATMSG .

*--Var to store the formatted msg.

DATA : LV_MSG(255).

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = SY-MSGID

LANG = SY-LANGU

NO = SY-MSGNO

V1 = SY-MSGV1

V2 = SY-MSGV2

V3 = SY-MSGV3

V4 = SY-MSGV4

IMPORTING

MSG = LV_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC = 0.

WRITE 😕 LV_MSG.

ENDIF.

ULINE.

ENDFORM. " FORM_FORMATMSG

&----


*& Form form_writeop

&----


  • To write the totals and the session name.

----


FORM FORM_WRITEOP .

WRITE 😕 'Total Records Uploaded :',V_TLINES,

/ 'No of Error Records :',V_ELINES,

/ 'No of Success Records :',V_SLINES,

/ 'Name of the Session :',V_SESNAM.

ULINE.

ENDFORM. " form_writeop

Read only

Former Member
0 Likes
1,010

XK01 is the transaction.

the tables that get updated will be KNA1 and KN* tables.

Regards,

Ravi

Read only

Former Member
0 Likes
1,010

Hi,

1) XK01 is the transaction code

Upload Program for Xk01 ..

REPORT Y730_BDC5 .

DATA : BEGIN OF IT_DUMMY OCCURS 0,
       DUMMY(100) TYPE C,
       END OF IT_DUMMY.
DATA : BEGIN OF IT_XK01 OCCURS 0,
       LIFNR(10) TYPE C,
       BUKRS(4)  TYPE C,
       EKORG(4)  TYPE C,
       KTOKK(4)  TYPE C,
       NAME1(30) TYPE C,
       SORTL(10) TYPE C,
       LAND1(3)  TYPE C,
       SPRAS(2)  TYPE C,
       AKONT(6)  TYPE C,
       FDGRV(2)  TYPE C,
       WAERS(3)  TYPE C,
       END OF IT_XK01,
       BEGIN OF IT_BANK OCCURS 0,
       BANKS(3)  TYPE C,
       BANKL(10) TYPE C,
       BANKN(10) TYPE C,
       KOINH(30) TYPE C,
       LIFNR(10) TYPE C,
       END OF IT_BANK.
DATA : IT_BDCDATA LIKE BDCDATA OCCURS 0 WITH HEADER LINE,
       IT_BDCMSGCOLL LIKE BDCMSGCOLL OCCURS 0 WITH HEADER LINE.

CALL FUNCTION 'WS_UPLOAD'
 EXPORTING
   FILENAME                      = 'C:VENDOR.TXT'
   FILETYPE                      = 'ASC'
 TABLES
   DATA_TAB                      = IT_DUMMY.

LOOP AT IT_DUMMY.
  IF IT_DUMMY-DUMMY+0(2) = '11'.
    IT_XK01-LIFNR = IT_DUMMY-DUMMY+2(10).
    IT_XK01-BUKRS = IT_DUMMY-DUMMY+12(4).
    IT_XK01-EKORG = IT_DUMMY-DUMMY+16(4).
    IT_XK01-KTOKK = IT_DUMMY-DUMMY+20(4).
    IT_XK01-NAME1 = IT_DUMMY-DUMMY+24(30).
    IT_XK01-SORTL = IT_DUMMY-DUMMY+54(10).
    IT_XK01-LAND1 = IT_DUMMY-DUMMY+64(3).
    IT_XK01-SPRAS = IT_DUMMY-DUMMY+67(2).
    IT_XK01-AKONT = IT_DUMMY-DUMMY+69(6).
    IT_XK01-FDGRV = IT_DUMMY-DUMMY+75(2).
    IT_XK01-WAERS = IT_DUMMY-DUMMY+77(3).
    APPEND IT_XK01.
  ELSE.
    IT_BANK-BANKS = IT_DUMMY-DUMMY+2(3).
    IT_BANK-BANKL = IT_DUMMY-DUMMY+5(10).
    IT_BANK-BANKN = IT_DUMMY-DUMMY+15(10).
    IT_BANK-KOINH = IT_DUMMY-DUMMY+25(30).
    IT_BANK-LIFNR = IT_DUMMY-DUMMY+55(10).
    APPEND IT_BANK.
  ENDIF.
ENDLOOP.

LOOP AT IT_XK01.
REFRESH IT_BDCDATA.
perform bdc_dynpro      using 'SAPMF02K' '0100'.
perform bdc_field       using 'BDC_CURSOR'
                              'RF02K-REF_LIFNR'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_field       using 'RF02K-LIFNR'
                              IT_XK01-LIFNR.
perform bdc_field       using 'RF02K-BUKRS'
                              IT_XK01-BUKRS.
perform bdc_field       using 'RF02K-EKORG'
                              IT_XK01-EKORG.
perform bdc_field       using 'RF02K-KTOKK'
                              IT_XK01-KTOKK.
perform bdc_dynpro      using 'SAPMF02K' '0110'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFA1-TELX1'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_field       using 'LFA1-NAME1'
                              IT_XK01-NAME1.
perform bdc_field       using 'LFA1-SORTL'
                              IT_XK01-SORTL.
perform bdc_field       using 'LFA1-LAND1'
                              IT_XK01-LAND1.
perform bdc_field       using 'LFA1-SPRAS'
                              IT_XK01-SPRAS.
perform bdc_dynpro      using 'SAPMF02K' '0120'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFA1-KUNNR'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_dynpro      using 'SAPMF02K' '0130'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFBK-KOINH(02)'.
perform bdc_field       using 'BDC_OKCODE'
                              '=ENTR'.
DATA : FNAM(20) TYPE C,
       IDX      TYPE C.
  MOVE 1 TO IDX.
LOOP AT IT_BANK WHERE LIFNR = IT_XK01-LIFNR.
  CONCATENATE 'LFBK-BANKS(' IDX ')' INTO FNAM.
  perform bdc_field       using FNAM
                                IT_BANK-BANKS.

  CONCATENATE 'LFBK-BANKL(' IDX ')' INTO FNAM.
  perform bdc_field       using FNAM
                                IT_BANK-BANKL.

  CONCATENATE 'LFBK-BANKN(' IDX ')' INTO FNAM.
  perform bdc_field       using FNAM
                                IT_BANK-BANKN.

  CONCATENATE 'LFBK-KOINH(' IDX ')' INTO FNAM.
  perform bdc_field       using FNAM
                                IT_BANK-KOINH.
  IDX = IDX + 1.
ENDLOOP.

perform bdc_dynpro      using 'SAPMF02K' '0130'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFBK-BANKS(01)'.
perform bdc_field       using 'BDC_OKCODE'
                              '=ENTR'.
perform bdc_dynpro      using 'SAPMF02K' '0210'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFB1-FDGRV'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_field       using 'LFB1-AKONT'
                              IT_XK01-AKONT.
perform bdc_field       using 'LFB1-FDGRV'
                              IT_XK01-FDGRV.
perform bdc_dynpro      using 'SAPMF02K' '0215'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFB1-ZTERM'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_dynpro      using 'SAPMF02K' '0220'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFB5-MAHNA'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_dynpro      using 'SAPMF02K' '0310'.
perform bdc_field       using 'BDC_CURSOR'
                              'LFM1-WAERS'.
perform bdc_field       using 'BDC_OKCODE'
                              '/00'.
perform bdc_field       using 'LFM1-WAERS'
                              IT_XK01-WAERS.
perform bdc_dynpro      using 'SAPMF02K' '0320'.
perform bdc_field       using 'BDC_CURSOR'
                              'WYT3-PARVW(01)'.
perform bdc_field       using 'BDC_OKCODE'
                              '=ENTR'.
perform bdc_dynpro      using 'SAPLSPO1' '0300'.
perform bdc_field       using 'BDC_OKCODE'
                              '=YES'.
CALL TRANSACTION 'XK01' USING IT_BDCDATA
                        MODE  'A'
                       UPDATE 'S'
                     MESSAGES INTO IT_BDCMSGCOLL.
ENDLOOP.

FORM BDC_DYNPRO USING PROG SCR.
  CLEAR IT_BDCDATA.
  IT_BDCDATA-PROGRAM = PROG.
  IT_BDCDATA-DYNPRO  = SCR.
  IT_BDCDATA-DYNBEGIN = 'X'.
  APPEND IT_BDCDATA.
ENDFORM.

FORM BDC_FIELD USING FNAM FVAL.
  CLEAR IT_BDCDATA.
  IT_BDCDATA-FNAM = FNAM.
  IT_BDCDATA-FVAL  = FVAL.
  APPEND IT_BDCDATA.
ENDFORM.

Regards

Sudheer

Read only

Former Member
0 Likes
1,010

check below code....it is used to upload customer data....

it is used for vendor upload...modify according to ur requirement...

REPORT ZFC_VENDOR_CREATE LINE-SIZE 100

NO STANDARD PAGE HEADING

MESSAGE-ID ZZ.

************************************************************************

************************************************************************

  • TABLES

************************************************************************

TABLES : SSCRFIELDS. " Fields on selection screens

************************************************************************

  • CONSTANTS

************************************************************************

DATA : C_SPLIT TYPE C VALUE '#'. " Used for Has Separator in GUI_UPLAOD

************************************************************************

  • TYPES

************************************************************************

  • Int'table to hold Vendor Master Data

TYPES : BEGIN OF TY_VENDOR_MASTER,

FLAG TYPE C, " Update Flag

LIFNR TYPE LIFNR, " Vendor Number

BUKRS TYPE BUKRS, " Company Code

KTOKK TYPE KTOKK, " Account Group

ANRED TYPE ANRED, " Title

NAME1 TYPE NAME1_GP, " Name1

NAME2 TYPE NAME2_GP, " Name2

SORTL TYPE SORTL, " Search Term 1

SORT2 TYPE AD_SORT2UL, " Search Term 2

STRAS TYPE STRAS_GP, " Street

PSTLZ TYPE PSTLZ, " Postal Code

ORT01 TYPE ORT01_GP, " City

REGIO TYPE REGIO, " Region

LAND1 TYPE LAND1_GP, " Country

SPRAS TYPE SPRAS, " Language

VBUND TYPE RASSC, " Trading Partner

BANKS TYPE BANKS, " Country

BANKL TYPE BANKK, " Bank Key

BANKN TYPE BANKN, " Bank Account

BKONT TYPE BKONT, " Bank Control Key

BANKA TYPE BANKA, " Name of Bank

AKONT TYPE AKONT, " Reconciliation Account

FDGRV TYPE FDGRV, " Cash Management Group

ZTERM TYPE DZTERM, " Payment Terms

REPRF TYPE REPRF, " Check Double Invoice

ZWELS TYPE DZWELS, " Payment Methods

XPORE TYPE XPORE, " Pay all items separately

END OF TY_VENDOR_MASTER,

  • Int'table to hold Vendor Extend Data

BEGIN OF TY_VENDOR_EXTEND,

FLAG TYPE C, " Update Flag

LIFNR TYPE LIFNR, " Vendor Number

BUKRS TYPE BUKRS, " Company Code

KTOKK TYPE KTOKK, " Account Group

REF_LIFNR TYPE LIFNR, " Reference Vendor Number

REF_BUKRS TYPE BUKRS, " Reference Company Code

AKONT TYPE AKONT, " Reconciliation Account

FDGRV TYPE FDGRV, " Cash Management Group

ZTERM TYPE DZTERM, " Payment Terms

REPRF TYPE REPRF, " Check Double Invoice

ZWELS TYPE DZWELS, " Payment Methods

XPORE TYPE XPORE, " Pay all items separately

END OF TY_VENDOR_EXTEND,

  • Int'table to hold Error Records Data

BEGIN OF TY_ERROR,

MSG(200) TYPE C, " To hold Message

LIFNR TYPE LIFNR, " Vendor Number

BUKRS TYPE BUKRS, " Company Code

END OF TY_ERROR.

************************************************************************

  • DATA (Simple Fields)

************************************************************************

DATA : W_COUNT TYPE I, " Variable to hold count of Records

W_SUCC_REC TYPE I, " No. of Success Records

W_SUCC_REC1 TYPE I, " No. of Updated Records

W_ERR_REC TYPE I, " No. of Error Records

w_noupdate_rec type i. " No. of Records not Changed

************************************************************************

  • INTERNAL TABLES

************************************************************************

  • Int'table to hold uploaded data from File

DATA : IT_VENDOR_MASTER TYPE STANDARD TABLE OF TY_VENDOR_MASTER,

WA_IT_VENDOR_MASTER TYPE TY_VENDOR_MASTER,

IT_VENDOR_EXTEND TYPE STANDARD TABLE OF TY_VENDOR_EXTEND,

WA_IT_VENDOR_EXTEND TYPE TY_VENDOR_EXTEND,

WA_IT_BDCDATA TYPE BDCDATA,

IT_BDCDATA TYPE STANDARD TABLE OF BDCDATA,

WA_IT_MESSTAB TYPE BDCMSGCOLL,

IT_MESSTAB TYPE STANDARD TABLE OF BDCMSGCOLL,

IT_ERROR TYPE STANDARD TABLE OF TY_ERROR,

WA_IT_ERROR TYPE TY_ERROR,

it_error_fk01 type standard table of ty_error,

wa_it_error_fk01 type ty_error,

it_error_fk02 type standard table of ty_error,

wa_it_error_fk02 type ty_error,

it_succ_rec1 type standard table of ty_error,

wa_it_succ_rec1 type ty_error,

it_noupdate type standard table of ty_error,

wa_it_noupdate type ty_error.

************************************************************************

  • FLAGS

************************************************************************

DATA : FL_FLAG1 TYPE C, " Flag to check error upload file

FL_FLAG2 TYPE C, " Flag to hold value

FL_FLAG3 TYPE C, " Flag to hold value

FL_FLAG4 TYPE C. " Flag to hold value

************************************************************************

  • SELECTION-SCREEN

************************************************************************

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-001,

POSITION POS_LOW.

PARAMETERS : P_FILE(128) DEFAULT 'C:\UPLOAD.TXT' OBLIGATORY.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-002,

POSITION POS_LOW.

PARAMETERS : P_VENMAS RADIOBUTTON GROUP R1 DEFAULT 'X'.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-003,

POSITION POS_LOW.

PARAMETERS : P_VENEXT RADIOBUTTON GROUP R1.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN SKIP 2.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-004,

POSITION POS_LOW.

PARAMETERS : P_MODE(1) DEFAULT 'N'.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-005,

POSITION POS_LOW.

PARAMETERS : P_GROUP(12) DEFAULT 'ZFC_VENDOR_C' OBLIGATORY.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN : BEGIN OF LINE,

COMMENT 1(30) TEXT-016,

POSITION POS_LOW.

PARAMETERS : P_GROUP1(12) DEFAULT 'ZFC_VENDOR_U' OBLIGATORY.

SELECTION-SCREEN : END OF LINE.

SELECTION-SCREEN END OF BLOCK B1.

************************************************************************

  • AT SELECTION-SCREEN ON

************************************************************************

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.

  • Form to get file path for upload of data

PERFORM GET_FILE_PATH.

AT SELECTION-SCREEN ON BLOCK B1.

  • Form to Validate data specified on Selection Screen

CHECK SSCRFIELDS-UCOMM EQ 'ONLI'.

PERFORM VALIDATE_DATA.

************************************************************************

  • START - OF - SELECTION

************************************************************************

START-OF-SELECTION.

IF P_VENMAS = 'X'.

  • Form to upload data from Presentation Server for Vendor Master

PERFORM UPLOAD_DATA TABLES IT_VENDOR_MASTER.

IF FL_FLAG1 NE 'X'.

SORT IT_VENDOR_MASTER BY LIFNR BUKRS KTOKK.

DELETE IT_VENDOR_MASTER WHERE LIFNR = ' '

AND BUKRS = ' '

AND KTOKK = ' '.

  • Form to process data for Vendor Master

PERFORM INSERT_VENDOR_MASTER_DATA.

ENDIF.

ELSEIF P_VENEXT = 'X'.

  • Form to upload data from Presentation Server for Vendor Extend

PERFORM UPLOAD_DATA TABLES IT_VENDOR_EXTEND.

IF FL_FLAG1 NE 'X'.

SORT IT_VENDOR_EXTEND BY LIFNR BUKRS KTOKK.

DELETE IT_VENDOR_EXTEND WHERE LIFNR = ' '

AND BUKRS = ' '

AND KTOKK = ' '.

  • Form to process data for Vendor Master

PERFORM CHK_AND_INS_VENDOR_EXTEND_DATA.

ENDIF.

ENDIF.

************************************************************************

  • END - OF - SELECTION

************************************************************************

END-OF-SELECTION.

IF FL_FLAG1 NE 'X'.

FORMAT COLOR 7.

WRITE:/2 TEXT-O01. " Total Number of records read :

FORMAT COLOR OFF.

WRITE:40 W_COUNT.

FORMAT COLOR 7.

WRITE:/2 TEXT-O02. " Total Number of Success records :

FORMAT COLOR OFF.

WRITE:40 W_SUCC_REC.

FORMAT COLOR 7.

WRITE:/2 TEXT-O07. " Total Number of Updated records :

FORMAT COLOR OFF.

WRITE:40 W_SUCC_REC1.

FORMAT COLOR 7.

WRITE:/2 TEXT-O08. " Total Number of Unchanged records :

FORMAT COLOR OFF.

WRITE:40 W_noupdate_REC.

FORMAT COLOR 7.

WRITE:/2 TEXT-O03. " Total Number of Error records :

FORMAT COLOR OFF.

WRITE:40 W_ERR_REC.

if not it_succ_rec1 is initial.

skip 1.

perform display_changed_report.

endif.

if not it_noupdate is initial.

skip 1.

perform display_nochange_report.

endif.

IF NOT IT_ERROR IS INITIAL.

SKIP 3.

  • Form to display error data

PERFORM DISPLAY_ERROR_REPORT.

ENDIF.

IF FL_FLAG2 = 'X'.

SKIP 2.

FORMAT COLOR 4.

WRITE:/2 TEXT-O04. " BDC Session Name for Creation (FK01) :

FORMAT COLOR OFF.

WRITE:40 P_GROUP.

perform display_error_report_fk01.

ENDIF.

IF FL_FLAG3 = 'X'.

SKIP 2.

FORMAT COLOR 4.

WRITE:/2 TEXT-O09. " BDC Session Name for Updation (FK02) :

FORMAT COLOR OFF.

WRITE:40 P_GROUP1.

perform display_error_report_fk02.

ENDIF.

ENDIF.

&----


*& Form GET_FILE_PATH

&----


  • This form is used to get the specified path for uploading of data from

  • flat file with the help of F4 function key

----


FORM GET_FILE_PATH .

CALL FUNCTION 'F4_FILENAME'

EXPORTING

PROGRAM_NAME = SYST-CPROG

DYNPRO_NUMBER = SYST-DYNNR

FIELD_NAME = ' '

IMPORTING

FILE_NAME = P_FILE.

ENDFORM. " GET_FILE_PATH

&----


*& Form VALIDATE_DATA

&----


  • This form is used to validate the data given by user on the Selection

  • Screen and the appropriate message is been displayed when an wrong

  • entry is inputted

----


FORM VALIDATE_DATA .

IF SY-BATCH EQ 'X'.

CLEAR SSCRFIELDS-UCOMM.

MESSAGE E001(ZZ) WITH TEXT-011.

" Excel file not to be used in Batch Mode

ENDIF.

IF P_MODE NE 'A' AND P_MODE NE 'N' AND P_MODE NE 'E'.

MESSAGE E001(ZZ) WITH TEXT-012.

" Session Mode should be either A or N or E

ENDIF.

ENDFORM. " VALIDATE_DATA

&----


*& Form UPLOAD_DATA

&----


  • This form is used to upload data from Presentation Server for either

  • Vendor Master or Vendor Extend

----


FORM UPLOAD_DATA TABLES P_IT_VENDOR.

DATA : L_FILENAME TYPE STRING,

L_FILETYPE TYPE CHAR10 VALUE 'ASC',

L_HEADER_LENGTH TYPE I VALUE 0,

L_READ_BY_LINE TYPE CHAR01 VALUE 'X'.

MOVE P_FILE TO L_FILENAME.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = L_FILENAME

FILETYPE = L_FILETYPE

HEADER_LENGTH = L_HEADER_LENGTH

READ_BY_LINE = L_READ_BY_LINE

HAS_FIELD_SEPARATOR = C_SPLIT

TABLES

DATA_TAB = P_IT_VENDOR

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17.

IF SY-SUBRC <> 0.

  • MESSAGE I001(ZZ) WITH TEXT-006 L_FILENAME.

MESSAGE ID SY-MSGID TYPE 'I' NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

FL_FLAG1 = 'X'.

ELSEIF P_IT_VENDOR[] IS INITIAL.

MESSAGE I001(ZZ) WITH TEXT-014. " Uploaded File contains no data

FL_FLAG1 = 'X'.

ENDIF.

ENDFORM. " UPLOAD_DATA

&----


*& Form INSERT_VENDOR_MASTER_DATA

&----


  • This form is used to process BDC data for Vendor Master

&----


FORM INSERT_VENDOR_MASTER_DATA .

DATA : L_LIFNR TYPE LIFNR.

CLEAR : L_LIFNR.

sort it_vendor_master by flag.

LOOP AT IT_VENDOR_MASTER INTO WA_IT_VENDOR_MASTER.

W_COUNT = W_COUNT + 1.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_IT_VENDOR_MASTER-LIFNR

IMPORTING

OUTPUT = WA_IT_VENDOR_MASTER-LIFNR.

if wa_it_vendor_master-flag = 'A'.

SELECT SINGLE LIFNR

FROM LFB1

INTO L_LIFNR

WHERE LIFNR = WA_IT_VENDOR_MASTER-LIFNR

AND BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

IF SY-SUBRC EQ 0.

WA_IT_ERROR-LIFNR = WA_IT_VENDOR_MASTER-LIFNR.

WA_IT_ERROR-BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

WA_IT_ERROR-MSG = TEXT-015.

APPEND WA_IT_ERROR TO IT_ERROR.

W_ERR_REC = W_ERR_REC + 1.

CLEAR : WA_IT_ERROR, L_LIFNR.

ELSE.

REFRESH IT_BDCDATA.

CLEAR IT_BDCDATA.

PERFORM POPULATE_BDC_DATA_VEN_MASTER.

PERFORM CALL_TRANSACTION.

ENDIF.

CLEAR : WA_IT_VENDOR_MASTER.

elseif wa_it_vendor_master-flag = 'C'.

IF FL_FLAG2 = 'X' and fl_flag4 ne 'X'.

PERFORM CLOSE_BDC_SESSION.

fl_flag4 = 'X'.

ENDIF.

REFRESH IT_BDCDATA.

CLEAR IT_BDCDATA.

PERFORM POPULATE_BDC_DATA_VEN_MASTER.

PERFORM CALL_TRANSACTION_FK02.

CLEAR : WA_IT_VENDOR_MASTER.

elseif wa_it_vendor_master-flag = 'N'.

WA_IT_noupdate-LIFNR = WA_IT_VENDOR_MASTER-LIFNR.

WA_IT_noupdate-BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

WA_IT_noupdate-MSG = TEXT-018.

APPEND WA_IT_noupdate TO IT_noupdate.

W_noupdate_REC = W_noupdate_REC + 1.

CLEAR : WA_IT_noupdate, WA_IT_VENDOR_MASTER.

endif.

ENDLOOP.

IF FL_FLAG3 = 'X'.

PERFORM CLOSE_BDC_SESSION.

ENDIF.

ENDFORM. " INSERT_VENDOR_MASTER_DATA

&----


*& Form POPULATE_BDC_DATA_VEN_MASTER

&----


  • This form is used to populate BDC data of Vendor Master

----


FORM POPULATE_BDC_DATA_VEN_MASTER .

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_IT_VENDOR_MASTER-ZTERM

IMPORTING

OUTPUT = WA_IT_VENDOR_MASTER-ZTERM.

IF WA_IT_VENDOR_MASTER-REPRF = 'Y'.

WA_IT_VENDOR_MASTER-REPRF = 'X'.

ENDIF.

IF WA_IT_VENDOR_MASTER-XPORE = 'Y'.

WA_IT_VENDOR_MASTER-XPORE = 'X'.

ENDIF.

if wa_it_vendor_master-flag = 'A'.

PERFORM :BDC_DYNPRO USING 'SAPMF02K' '0105',

BDC_FIELD USING 'RF02K-LIFNR' WA_IT_VENDOR_MASTER-LIFNR,

BDC_FIELD USING 'RF02K-BUKRS' WA_IT_VENDOR_MASTER-BUKRS,

BDC_FIELD USING 'RF02K-KTOKK' WA_IT_VENDOR_MASTER-KTOKK,

BDC_FIELD USING 'BDC_OKCODE' '/00'.

elseif wa_it_vendor_master-flag = 'C'.

PERFORM :BDC_DYNPRO USING 'SAPMF02K' '0106',

BDC_FIELD USING 'RF02K-LIFNR' WA_IT_VENDOR_MASTER-LIFNR,

BDC_FIELD USING 'RF02K-BUKRS' WA_IT_VENDOR_MASTER-BUKRS,

BDC_FIELD USING 'BDC_OKCODE' '=MALL',

BDC_DYNPRO USING 'SAPMF02K' '0106',

BDC_FIELD USING 'RF02K-D0110' 'X',

BDC_FIELD USING 'RF02K-D0120' 'X',

BDC_FIELD USING 'RF02K-D0130' 'X',

BDC_FIELD USING 'RF02K-D0210' 'X',

BDC_FIELD USING 'RF02K-D0215' 'X',

BDC_FIELD USING 'RF02K-D0220' 'X',

BDC_FIELD USING 'BDC_OKCODE' '/00'.

endif.

perform :BDC_DYNPRO USING 'SAPMF02K' '0110',

BDC_FIELD USING 'LFA1-ANRED' WA_IT_VENDOR_MASTER-ANRED,

BDC_FIELD USING 'LFA1-NAME1' WA_IT_VENDOR_MASTER-NAME1,

BDC_FIELD USING 'LFA1-NAME2' WA_IT_VENDOR_MASTER-NAME2,

BDC_FIELD USING 'LFA1-SORTL' WA_IT_VENDOR_MASTER-SORTL,

BDC_FIELD USING 'LFA1-STRAS' WA_IT_VENDOR_MASTER-STRAS,

BDC_FIELD USING 'LFA1-ORT01' WA_IT_VENDOR_MASTER-ORT01,

BDC_FIELD USING 'LFA1-PSTLZ' WA_IT_VENDOR_MASTER-PSTLZ,

BDC_FIELD USING 'LFA1-LAND1' WA_IT_VENDOR_MASTER-LAND1,

BDC_FIELD USING 'LFA1-REGIO' WA_IT_VENDOR_MASTER-REGIO,

BDC_FIELD USING 'LFA1-SPRAS' WA_IT_VENDOR_MASTER-SPRAS,

BDC_FIELD USING 'BDC_OKCODE' '/00',

BDC_DYNPRO USING 'SAPMF02K' '0120',

BDC_FIELD USING 'LFA1-VBUND' WA_IT_VENDOR_MASTER-VBUND,

BDC_FIELD USING 'BDC_OKCODE' '/00',

BDC_DYNPRO USING 'SAPMF02K' '0130',

BDC_FIELD USING 'LFBK-BANKS(01)' WA_IT_VENDOR_MASTER-BANKS,

BDC_FIELD USING 'LFBK-BANKL(01)' WA_IT_VENDOR_MASTER-BANKL,

BDC_FIELD USING 'LFBK-BANKN(01)' WA_IT_VENDOR_MASTER-BANKN,

BDC_FIELD USING 'BDC_OKCODE' '=BANK',

BDC_DYNPRO USING 'SAPLBANK' '0100',

BDC_FIELD USING 'BNKA-BANKA' WA_IT_VENDOR_MASTER-BANKA,

BDC_FIELD USING 'BDC_OKCODE' '=ENTR',

BDC_DYNPRO USING 'SAPMF02K' '0130',

BDC_FIELD USING 'BDC_OKCODE' '=ENTR',

BDC_DYNPRO USING 'SAPMF02K' '0210',

BDC_FIELD USING 'LFB1-AKONT' WA_IT_VENDOR_MASTER-AKONT,

BDC_FIELD USING 'LFB1-FDGRV' WA_IT_VENDOR_MASTER-FDGRV,

BDC_FIELD USING 'BDC_OKCODE' '=/00',

BDC_DYNPRO USING 'SAPMF02K' '0215',

BDC_FIELD USING 'LFB1-ZTERM' WA_IT_VENDOR_MASTER-ZTERM,

BDC_FIELD USING 'LFB1-REPRF' WA_IT_VENDOR_MASTER-REPRF,

BDC_FIELD USING 'LFB1-ZWELS' WA_IT_VENDOR_MASTER-ZWELS,

BDC_FIELD USING 'LFB1-XPORE' WA_IT_VENDOR_MASTER-XPORE,

BDC_FIELD USING 'BDC_OKCODE' '=UPDA'.

ENDFORM. " POPULATE_BDC_DATA_VEN_MASTER

&----


*& Form BDC_DYNPRO

&----


  • This form is used to move data to BDCDATA int'table

----


FORM BDC_DYNPRO USING PROGRAM TYPE BDC_PROG

DYNPRO TYPE BDC_DYNR.

CLEAR WA_IT_BDCDATA.

WA_IT_BDCDATA-PROGRAM = PROGRAM.

WA_IT_BDCDATA-DYNPRO = DYNPRO.

WA_IT_BDCDATA-DYNBEGIN = 'X'.

APPEND WA_IT_BDCDATA TO IT_BDCDATA.

ENDFORM. " BDC_DYNPRO

&----


*& Form BDC_FIELD

&----


  • This form is used to move data to BDCDATA int'table

----


FORM BDC_FIELD USING FNAM TYPE ANY

FVAL TYPE ANY.

CLEAR WA_IT_BDCDATA.

WA_IT_BDCDATA-FNAM = FNAM.

WA_IT_BDCDATA-FVAL = FVAL.

APPEND WA_IT_BDCDATA TO IT_BDCDATA.

ENDFORM. " BDC_FIELD

&----


*& Form CALL_TRANSACTION

&----


  • This form is used to Call FK01 for processing of data either for

  • Vendor Master or Vendor Extend. The error records are inserted to

  • Session which can be processed using SM35

----


FORM CALL_TRANSACTION .

DATA : L_OPTION TYPE CTU_PARAMS,

L_SUBRC TYPE SYSUBRC.

REFRESH IT_MESSTAB.

CLEAR IT_MESSTAB.

L_OPTION-DEFSIZE = 'X'.

L_OPTION-DISMODE = P_MODE.

L_OPTION-UPDMODE = 'S'.

CALL TRANSACTION 'FK01'

USING IT_BDCDATA

MESSAGES INTO IT_MESSTAB

OPTIONS FROM L_OPTION.

L_SUBRC = SY-SUBRC.

IF L_SUBRC = 0.

W_SUCC_REC = W_SUCC_REC + 1.

ELSE.

IF FL_FLAG2 NE 'X'.

PERFORM OPEN_BDC_SESSION.

FL_FLAG2 = 'X'.

ENDIF.

PERFORM BDC_INSERT.

W_ERR_REC = W_ERR_REC + 1.

PERFORM ERROR_RECORD_DATA.

ENDIF.

ENDFORM. " CALL_TRANSACTION

&----


*& Form OPEN_BDC_SESSION

&----


  • Form used to open session for Error out Records

----


FORM OPEN_BDC_SESSION .

DATA : L_USERID TYPE APQ_MAPN, " Variable to hold user-id

L_GROUP TYPE APQ_GRPN. " Variable to hold value

MOVE P_GROUP TO L_GROUP.

MOVE SY-UNAME TO L_USERID.

CALL FUNCTION 'BDC_OPEN_GROUP'

EXPORTING

CLIENT = SY-MANDT

GROUP = L_GROUP

KEEP = SPACE

USER = L_USERID

EXCEPTIONS

CLIENT_INVALID = 1

DESTINATION_INVALID = 2

GROUP_INVALID = 3

GROUP_IS_LOCKED = 4

HOLDDATE_INVALID = 5

INTERNAL_ERROR = 6

QUEUE_ERROR = 7

RUNNING = 8

SYSTEM_LOCK_ERROR = 9

USER_INVALID = 10

OTHERS = 11.

IF SY-SUBRC <> 0.

WRITE:/ TEXT-008. " Unable to open BDC Session

ENDIF.

ENDFORM. " OPEN_BDC_SESSION

&----


*& Form BDC_INSERT

&----


  • This form is used to insert error records to a Session method

----


FORM BDC_INSERT .

CALL FUNCTION 'BDC_INSERT'

EXPORTING

TCODE = 'FK01'

TABLES

DYNPROTAB = IT_BDCDATA

EXCEPTIONS

INTERNAL_ERROR = 1

NOT_OPEN = 2

QUEUE_ERROR = 3

TCODE_INVALID = 4

PRINTING_INVALID = 5

POSTING_INVALID = 6

OTHERS = 7.

IF SY-SUBRC <> 0.

WRITE:/ TEXT-009. " Unable to Insert Data to BDC Session

ENDIF.

ENDFORM. " BDC_INSERT

&----


*& Form ERROR_RECORD_DATA

&----


  • This form is used to process the messages for the error records which

  • will be displayed on the output report

----


FORM ERROR_RECORD_DATA .

DATA : L_LINES TYPE I,

L_MSG(200) TYPE C.

DESCRIBE TABLE IT_MESSTAB LINES L_LINES.

READ TABLE IT_MESSTAB INTO WA_IT_MESSTAB INDEX L_LINES.

IF SY-SUBRC = 0.

CLEAR L_MSG.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = WA_IT_MESSTAB-MSGID

LANG = SY-LANGU

NO = WA_IT_MESSTAB-MSGNR

V1 = WA_IT_MESSTAB-MSGV1

V2 = WA_IT_MESSTAB-MSGV2

V3 = WA_IT_MESSTAB-MSGV3

V4 = WA_IT_MESSTAB-MSGV4

IMPORTING

MSG = L_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC = 0.

WA_IT_ERROR_fk01-MSG = L_MSG.

ENDIF.

IF P_VENMAS = 'X'.

WA_IT_ERROR_fk01-LIFNR = WA_IT_VENDOR_MASTER-LIFNR.

WA_IT_ERROR_fk01-BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

ELSEIF P_VENEXT = 'X'.

WA_IT_ERROR_fk01-LIFNR = WA_IT_VENDOR_EXTEND-LIFNR.

WA_IT_ERROR_fk01-BUKRS = WA_IT_VENDOR_EXTEND-BUKRS.

ENDIF.

APPEND WA_IT_ERROR_fk01 TO IT_ERROR_fk01.

CLEAR WA_IT_ERROR_fk01.

ENDIF.

ENDFORM. " ERROR_RECORD_DATA

&----


*& Form CLOSE_BDC_SESSION

&----


  • Form used to close session of the Error Records

----


FORM CLOSE_BDC_SESSION .

CALL FUNCTION 'BDC_CLOSE_GROUP'

EXCEPTIONS

NOT_OPEN = 1

QUEUE_ERROR = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

WRITE:/ TEXT-010. " Unable to Close BDC Session

ENDIF.

ENDFORM. " CLOSE_BDC_SESSION

&----


*& Form CHK_AND_INS_VENDOR_EXTEND_DATA

&----


  • This form is used to process BDC data for Vendor Extend

----


FORM CHK_AND_INS_VENDOR_EXTEND_DATA .

DATA : L_LIFNR TYPE LIFNR.

CLEAR : L_LIFNR, fl_flag4.

sort it_vendor_extend by flag.

LOOP AT IT_VENDOR_EXTEND INTO WA_IT_VENDOR_EXTEND.

W_COUNT = W_COUNT + 1.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_IT_VENDOR_EXTEND-REF_LIFNR

IMPORTING

OUTPUT = WA_IT_VENDOR_EXTEND-REF_LIFNR.

if wa_it_vendor_extend-flag = 'A'.

SELECT SINGLE LIFNR

FROM LFB1

INTO L_LIFNR

WHERE LIFNR = WA_IT_VENDOR_EXTEND-REF_LIFNR

AND BUKRS = WA_IT_VENDOR_EXTEND-REF_BUKRS.

IF SY-SUBRC NE 0.

WA_IT_ERROR-LIFNR = WA_IT_VENDOR_EXTEND-REF_LIFNR.

WA_IT_ERROR-BUKRS = WA_IT_VENDOR_EXTEND-REF_BUKRS.

WA_IT_ERROR-MSG = TEXT-007.

APPEND WA_IT_ERROR TO IT_ERROR.

W_ERR_REC = W_ERR_REC + 1.

CLEAR : WA_IT_ERROR, L_LIFNR.

ELSE.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_IT_VENDOR_EXTEND-LIFNR

IMPORTING

OUTPUT = WA_IT_VENDOR_EXTEND-LIFNR.

SELECT SINGLE LIFNR

FROM LFB1

INTO L_LIFNR

WHERE LIFNR = WA_IT_VENDOR_EXTEND-LIFNR

AND BUKRS = WA_IT_VENDOR_EXTEND-BUKRS.

IF SY-SUBRC EQ 0.

WA_IT_ERROR-LIFNR = WA_IT_VENDOR_EXTEND-LIFNR.

WA_IT_ERROR-BUKRS = WA_IT_VENDOR_EXTEND-BUKRS.

WA_IT_ERROR-MSG = TEXT-015.

APPEND WA_IT_ERROR TO IT_ERROR.

W_ERR_REC = W_ERR_REC + 1.

CLEAR : WA_IT_ERROR, L_LIFNR.

ELSE.

REFRESH IT_BDCDATA.

CLEAR IT_BDCDATA.

PERFORM POPULATE_BDC_DATA_VEN_EXTEND.

PERFORM CALL_TRANSACTION.

ENDIF.

ENDIF.

CLEAR : WA_IT_VENDOR_EXTEND.

elseif wa_it_vendor_extend-flag = 'C'.

IF FL_FLAG2 = 'X' and fl_flag4 ne 'X'.

PERFORM CLOSE_BDC_SESSION.

fl_flag4 = 'X'.

ENDIF.

REFRESH IT_BDCDATA.

CLEAR IT_BDCDATA.

PERFORM POPULATE_BDC_DATA_VEN_extend.

PERFORM CALL_TRANSACTION_FK02.

CLEAR : WA_IT_VENDOR_EXTEND.

elseif wa_it_vendor_extend-flag = 'N'.

WA_IT_noupdate-LIFNR = WA_IT_VENDOR_extend-LIFNR.

WA_IT_noupdate-BUKRS = WA_IT_VENDOR_extend-BUKRS.

WA_IT_noupdate-MSG = TEXT-019.

APPEND WA_IT_noupdate TO IT_noupdate.

W_noupdate_REC = W_noupdate_REC + 1.

CLEAR : WA_IT_noupdate, WA_IT_VENDOR_EXTEND.

endif.

ENDLOOP.

IF FL_FLAG2 = 'X'.

PERFORM CLOSE_BDC_SESSION.

ENDIF.

if fl_flag3 = 'X'.

PERFORM CLOSE_BDC_SESSION.

ENDIF.

ENDFORM. " CHK_AND_INS_VENDOR_EXTEND_DATA

&----


*& Form POPULATE_BDC_DATA_VEN_EXTEND

&----


  • This form is used to populate BDC data of Vendor Extend

----


FORM POPULATE_BDC_DATA_VEN_EXTEND .

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_IT_VENDOR_EXTEND-ZTERM

IMPORTING

OUTPUT = WA_IT_VENDOR_EXTEND-ZTERM.

IF WA_IT_VENDOR_EXTEND-REPRF = 'Y'.

WA_IT_VENDOR_EXTEND-REPRF = 'X'.

ENDIF.

IF WA_IT_VENDOR_extend-XPORE = 'Y'.

WA_IT_VENDOR_extend-XPORE = 'X'.

ENDIF.

if wa_it_vendor_extend-flag = 'A'.

PERFORM :BDC_DYNPRO USING 'SAPMF02K' '0105',

BDC_FIELD USING 'RF02K-LIFNR' WA_IT_VENDOR_EXTEND-LIFNR,

BDC_FIELD USING 'RF02K-BUKRS' WA_IT_VENDOR_EXTEND-BUKRS,

BDC_FIELD USING 'RF02K-KTOKK' WA_IT_VENDOR_EXTEND-KTOKK,

BDC_FIELD USING 'RF02K-REF_LIFNR'

WA_IT_VENDOR_EXTEND-REF_LIFNR,

BDC_FIELD USING 'RF02K-REF_BUKRS'

WA_IT_VENDOR_EXTEND-REF_BUKRS,

BDC_FIELD USING 'BDC_OKCODE' '/00'.

elseif wa_it_vendor_extend-flag = 'C'.

PERFORM :BDC_DYNPRO USING 'SAPMF02K' '0106',

BDC_FIELD USING 'RF02K-LIFNR' WA_IT_VENDOR_extend-LIFNR,

BDC_FIELD USING 'RF02K-BUKRS' WA_IT_VENDOR_extend-BUKRS,

BDC_FIELD USING 'RF02K-D0210' 'X',

BDC_FIELD USING 'RF02K-D0215' 'X',

BDC_FIELD USING 'BDC_OKCODE' '/00'.

endif.

perform :BDC_DYNPRO USING 'SAPMF02K' '0210',

BDC_FIELD USING 'LFB1-AKONT' WA_IT_VENDOR_EXTEND-AKONT,

BDC_FIELD USING 'LFB1-FDGRV' WA_IT_VENDOR_EXTEND-FDGRV,

BDC_FIELD USING 'BDC_OKCODE' '=/00',

BDC_DYNPRO USING 'SAPMF02K' '0215',

BDC_FIELD USING 'LFB1-ZTERM' WA_IT_VENDOR_EXTEND-ZTERM,

BDC_FIELD USING 'LFB1-REPRF' WA_IT_VENDOR_EXTEND-REPRF,

BDC_FIELD USING 'LFB1-ZWELS' WA_IT_VENDOR_EXTEND-ZWELS,

BDC_FIELD USING 'LFB1-XPORE' WA_IT_VENDOR_extend-XPORE,

BDC_FIELD USING 'BDC_OKCODE' '=UPDA'.

ENDFORM. " POPULATE_BDC_DATA_VEN_EXTEND

&----


*& Form DISPLAY_ERROR_REPORT

&----


  • This form is used to display the error records on the output screen

----


FORM DISPLAY_ERROR_REPORT .

IF P_VENMAS = 'X'.

WRITE:/ TEXT-O05. " Error List for Vendor Master

ELSEIF P_VENEXT = 'X'.

WRITE:/ TEXT-O06. " Error List for Vendor Master Extended

ENDIF.

WRITE:/ SY-ULINE(100).

FORMAT COLOR 1.

WRITE:/1 SY-VLINE,

2 TEXT-H01, " Vendor Number

17 SY-VLINE,

18 TEXT-H02, " Company Code

31 SY-VLINE,

32 TEXT-H03, " Error Message

100 SY-VLINE.

FORMAT COLOR OFF.

WRITE:/ SY-ULINE(100).

LOOP AT IT_ERROR INTO WA_IT_ERROR.

FORMAT COLOR 2.

WRITE:/1 SY-VLINE,

2 WA_IT_ERROR-LIFNR,

17 SY-VLINE,

18 WA_IT_ERROR-BUKRS,

31 SY-VLINE,

32 WA_IT_ERROR-MSG,

100 SY-VLINE.

CLEAR : WA_IT_ERROR.

FORMAT COLOR OFF.

ENDLOOP.

WRITE:/ SY-ULINE(100).

ENDFORM. " DISPLAY_ERROR_REPORT

&----


*& Form CALL_TRANSACTION_FK02

&----


  • Form used to Call Transaction FK02

----


form CALL_TRANSACTION_FK02 .

DATA : L_OPTION TYPE CTU_PARAMS,

L_SUBRC TYPE SYSUBRC.

REFRESH IT_MESSTAB.

CLEAR IT_MESSTAB.

L_OPTION-DEFSIZE = 'X'.

L_OPTION-DISMODE = P_MODE.

L_OPTION-UPDMODE = 'S'.

CALL TRANSACTION 'FK02'

USING IT_BDCDATA

MESSAGES INTO IT_MESSTAB

OPTIONS FROM L_OPTION.

L_SUBRC = SY-SUBRC.

IF L_SUBRC = 0.

W_SUCC_REC1 = W_SUCC_REC1 + 1.

WA_IT_succ_rec1-MSG = Text-017.

IF P_VENMAS = 'X'.

WA_IT_succ_rec1-LIFNR = WA_IT_VENDOR_MASTER-LIFNR.

WA_IT_succ_rec1-BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

ELSEIF P_VENEXT = 'X'.

WA_IT_succ_rec1-LIFNR = WA_IT_VENDOR_EXTEND-LIFNR.

WA_IT_succ_rec1-BUKRS = WA_IT_VENDOR_EXTEND-BUKRS.

ENDIF.

APPEND WA_IT_succ_rec1 TO IT_succ_rec1.

ELSE.

IF FL_FLAG3 NE 'X'.

PERFORM OPEN_BDC_SESSION_fk02.

FL_FLAG3 = 'X'.

ENDIF.

PERFORM BDC_INSERT_fk02.

W_ERR_REC = W_ERR_REC + 1.

PERFORM ERROR_RECORD_DATA1.

ENDIF.

endform. " CALL_TRANSACTION_FK02

&----


*& Form OPEN_BDC_SESSION_fk02

&----


  • Form used to Open session for FK02

----


form OPEN_BDC_SESSION_fk02 .

DATA : L_USERID TYPE APQ_MAPN, " Variable to hold user-id

L_GROUP TYPE APQ_GRPN. " Variable to hold value

MOVE P_GROUP1 TO L_GROUP.

MOVE SY-UNAME TO L_USERID.

CALL FUNCTION 'BDC_OPEN_GROUP'

EXPORTING

CLIENT = SY-MANDT

GROUP = L_GROUP

KEEP = SPACE

USER = L_USERID

EXCEPTIONS

CLIENT_INVALID = 1

DESTINATION_INVALID = 2

GROUP_INVALID = 3

GROUP_IS_LOCKED = 4

HOLDDATE_INVALID = 5

INTERNAL_ERROR = 6

QUEUE_ERROR = 7

RUNNING = 8

SYSTEM_LOCK_ERROR = 9

USER_INVALID = 10

OTHERS = 11.

IF SY-SUBRC <> 0.

WRITE:/ TEXT-008. " Unable to open BDC Session

ENDIF.

endform. " OPEN_BDC_SESSION_fk02

&----


*& Form BDC_INSERT_fk02

&----


  • Form used to insert data into BDC session using FK02

----


form BDC_INSERT_fk02 .

CALL FUNCTION 'BDC_INSERT'

EXPORTING

TCODE = 'FK02'

TABLES

DYNPROTAB = IT_BDCDATA

EXCEPTIONS

INTERNAL_ERROR = 1

NOT_OPEN = 2

QUEUE_ERROR = 3

TCODE_INVALID = 4

PRINTING_INVALID = 5

POSTING_INVALID = 6

OTHERS = 7.

IF SY-SUBRC <> 0.

WRITE:/ TEXT-009. " Unable to Insert Data to BDC Session

ENDIF.

endform. " BDC_INSERT_fk02

&----


*& Form display_changed_report

&----


  • Form to display Updated Vendor data

----


form display_changed_report .

IF P_VENMAS = 'X'.

WRITE:/ TEXT-O10. " Updated List for Vendor Master

ELSEIF P_VENEXT = 'X'.

WRITE:/ TEXT-O11. " Updated List for Vendor Master Extended

ENDIF.

WRITE:/ SY-ULINE(100).

FORMAT COLOR 1.

WRITE:/1 SY-VLINE,

2 TEXT-H01, " Vendor Number

17 SY-VLINE,

18 TEXT-H02, " Company Code

31 SY-VLINE,

32 TEXT-H04, " Message

100 SY-VLINE.

FORMAT COLOR OFF.

WRITE:/ SY-ULINE(100).

LOOP AT IT_succ_rec1 INTO WA_IT_succ_rec1.

FORMAT COLOR 2.

WRITE:/1 SY-VLINE,

2 WA_IT_succ_rec1-LIFNR,

17 SY-VLINE,

18 WA_IT_succ_rec1-BUKRS,

31 SY-VLINE,

32 WA_IT_succ_rec1-MSG,

100 SY-VLINE.

CLEAR : WA_IT_succ_rec1.

FORMAT COLOR OFF.

ENDLOOP.

WRITE:/ SY-ULINE(100).

endform. " display_changed_report

&----


*& Form display_nochange_report

&----


  • Form to display No Changed data for Vendors

----


form display_nochange_report .

IF P_VENMAS = 'X'.

WRITE:/ TEXT-O12. " No Changes List for Vendor Master

ELSEIF P_VENEXT = 'X'.

WRITE:/ TEXT-O13. " No Changes List for Vendor Master Extended

ENDIF.

WRITE:/ SY-ULINE(100).

FORMAT COLOR 1.

WRITE:/1 SY-VLINE,

2 TEXT-H01, " Vendor Number

17 SY-VLINE,

18 TEXT-H02, " Company Code

31 SY-VLINE,

32 TEXT-H04, " Message

100 SY-VLINE.

FORMAT COLOR OFF.

WRITE:/ SY-ULINE(100).

LOOP AT IT_noupdate INTO WA_IT_noupdate.

FORMAT COLOR 2.

WRITE:/1 SY-VLINE,

2 WA_IT_noupdate-LIFNR,

17 SY-VLINE,

18 WA_IT_noupdate-BUKRS,

31 SY-VLINE,

32 WA_IT_noupdate-MSG,

100 SY-VLINE.

CLEAR : WA_IT_noupdate.

FORMAT COLOR OFF.

ENDLOOP.

WRITE:/ SY-ULINE(100).

endform. " display_nochange_report

&----


*& Form ERROR_RECORD_DATA1

&----


  • Form to get Error Message for Changed Vendors

----


form ERROR_RECORD_DATA1 .

DATA : L_LINES TYPE I,

L_MSG(200) TYPE C.

DESCRIBE TABLE IT_MESSTAB LINES L_LINES.

READ TABLE IT_MESSTAB INTO WA_IT_MESSTAB INDEX L_LINES.

IF SY-SUBRC = 0.

CLEAR L_MSG.

CALL FUNCTION 'FORMAT_MESSAGE'

EXPORTING

ID = WA_IT_MESSTAB-MSGID

LANG = SY-LANGU

NO = WA_IT_MESSTAB-MSGNR

V1 = WA_IT_MESSTAB-MSGV1

V2 = WA_IT_MESSTAB-MSGV2

V3 = WA_IT_MESSTAB-MSGV3

V4 = WA_IT_MESSTAB-MSGV4

IMPORTING

MSG = L_MSG

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

IF SY-SUBRC = 0.

WA_IT_ERROR_fk02-MSG = L_MSG.

ENDIF.

IF P_VENMAS = 'X'.

WA_IT_ERROR_fk02-LIFNR = WA_IT_VENDOR_MASTER-LIFNR.

WA_IT_ERROR_fk02-BUKRS = WA_IT_VENDOR_MASTER-BUKRS.

ELSEIF P_VENEXT = 'X'.

WA_IT_ERROR_fk02-LIFNR = WA_IT_VENDOR_EXTEND-LIFNR.

WA_IT_ERROR_fk02-BUKRS = WA_IT_VENDOR_EXTEND-BUKRS.

ENDIF.

APPEND WA_IT_ERROR_fk02 TO IT_ERROR_fk02.

CLEAR WA_IT_ERROR_fk02.

ENDIF.

endform. " ERROR_RECORD_DATA1

&----


*& Form display_error_report_fk01

&----


  • Form to display Error Report for Master Vendors (FK01)

----


form display_error_report_fk01 .

IF P_VENMAS = 'X'.

WRITE:/ TEXT-O05. " Error List for Vendor Master (FK01)

ELSEIF P_VENEXT = 'X'.

WRITE:/ TEXT-O06. " Error List for Vendor Master Extended (FK01)

ENDIF.

WRITE:/ SY-ULINE(100).

FORMAT COLOR 1.

WRITE:/1 SY-VLINE,

2 TEXT-H01, " Vendor Number

17 SY-VLINE,

18 TEXT-H02, " Company Code

31 SY-VLINE,

32 TEXT-H04, " Message

100 SY-VLINE.

FORMAT COLOR OFF.

WRITE:/ SY-ULINE(100).

LOOP AT IT_ERROR_fk01 INTO WA_IT_ERROR_fk01.

FORMAT COLOR 2.

WRITE:/1 SY-VLINE,

2 WA_IT_ERROR_fk01-LIFNR,

17 SY-VLINE,

18 WA_IT_ERROR_fk01-BUKRS,

31 SY-VLINE,

32 WA_IT_ERROR_fk01-MSG,

100 SY-VLINE.

CLEAR : WA_IT_ERROR_fk01.

FORMAT COLOR OFF.

ENDLOOP.

WRITE:/ SY-ULINE(100).

endform. " display_error_report_fk01

&----


*& Form display_error_report_fk02

&----


  • Form to display Error Report for changed Vendors (FK02)

----


form display_error_report_fk02 .

IF P_VENMAS = 'X'.

WRITE:/ TEXT-O14. " Error List for Vendor Master (FK02)

ELSEIF P_VENEXT = 'X'.

WRITE:/ TEXT-O15. " Error List for Vendor Master Extended (FK02)

ENDIF.

WRITE:/ SY-ULINE(100).

FORMAT COLOR 1.

WRITE:/1 SY-VLINE,

2 TEXT-H01, " Vendor Number

17 SY-VLINE,

18 TEXT-H02, " Company Code

31 SY-VLINE,

32 TEXT-H04, " Message

100 SY-VLINE.

FORMAT COLOR OFF.

WRITE:/ SY-ULINE(100).

LOOP AT IT_ERROR_fk02 INTO WA_IT_ERROR_fk02.

FORMAT COLOR 2.

WRITE:/1 SY-VLINE,

2 WA_IT_ERROR_fk02-LIFNR,

17 SY-VLINE,

18 WA_IT_ERROR_fk02-BUKRS,

31 SY-VLINE,

32 WA_IT_ERROR_fk02-MSG,

100 SY-VLINE.

CLEAR : WA_IT_ERROR_fk02.

FORMAT COLOR OFF.

ENDLOOP.

WRITE:/ SY-ULINE(100).

endform. " display_error_report_fk02

Read only

andreas_mann3
Active Contributor
0 Likes
1,010

hi,

you can also use report rfbide00

-> copy to zfbide00 and delete comment of

*PARAMETERS: XCALL

A.

Read only

Former Member
0 Likes
1,010