topic Re: data upload in Application Development and Automation Discussions

data upload

Former Member — Mon, 29 Oct 2007 12:33:11 GMT

hi abapers.

i am facing a problem why uploading data from flat file to bdc program .

i have done bdc recording fro tcode xk01.

while filling the flat file i have filled the fields based on vendor details.

for ex:

for one vendor i have entered the fields TELF1 and TELFX and for another vendor i have not entered these field as per the data i have recieved .i left these fields as blanks and finally i uploaded the flat file while uploading i am facing a problem i.e.,upto these fields data is being uploaded correctly and from the next screens i am facing problem , data is not being uploaded properly.can any one help me regarding this issue.

With Regards,

ROHINI.

Re: data upload

Former Member — Mon, 29 Oct 2007 13:02:33 GMT

Hi Rohini,

Just check whether these fields are mandatory or not.

If Mandatory, SAP will not allow you to procede, else you have to check whether your flat file data are valid or not.

If not in proper format again it will create probs, then you have to convert it into proper format using some conversion routine Function Modules.

You didnt mention about the error message coming, if any messsage is displaying , let me know so that I can help you more.

regards,

Antony Thomas

rewards if find useful.

Re: data upload

Former Member — Mon, 29 Oct 2007 13:05:20 GMT

for customer master after giving the personel details u have to use bdc table control to upload bank details....................

Re: data upload

Former Member — Mon, 29 Oct 2007 13:51:25 GMT

To enter this sort of data, you have to use central address management. You specify this on the initial screen:

PERFORM dynpro
  TABLES bdcdata
  USING:
 'X' 'SAPMF02K'     '0105',         "Create Vendor: Initial Screen
  ' ' 'RF02K-BUKRS'     'XXXX',
  ' ' 'RF02K-KTOKK'     'YYYY',
  ' ' 'USE_ZAV'         'X'.   "<======== Use Central address management

Rob

Re: data upload

Former Member — Tue, 30 Oct 2007 04:16:50 GMT

hi Thomas .

thanks 4 ur response and one thing i want to tell is , those fields which i have mentioned are not mandatory they are FAX no and EMAIL add .

With Regards,

ROHINI.K.

Re: data upload

Former Member — Tue, 30 Oct 2007 04:22:42 GMT

HI Suguna.

thanq for ur reply. one more thing i want to intimate is that, after entering the personel datails i am not uploading any bank details i.e., i have not entered any values in in bank details in recording directly i have entered tax details.

With Regards,

ROHINI.K.

Re: data upload

Former Member — Tue, 30 Oct 2007 04:33:19 GMT

hi .

i am sending my recording details i.e., which fields i have recorded.

PERFORM bdc_dynpro USING 'SAPMF02K' '0100'.

PERFORM bdc_field USING 'BDC_CURSOR'

'RF02K-KTOKK'.

PERFORM bdc_field USING 'BDC_OKCODE'

'/00'.

PERFORM bdc_field USING 'RF02K-BUKRS'

it_tab-BUKRS.

PERFORM bdc_field USING 'RF02K-EKORG'

it_tab-EKORG.

PERFORM bdc_field USING 'RF02K-KTOKK'

it_tab-KTOKK.

PERFORM bdc_dynpro USING 'SAPMF02K' '0110'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFA1-LFURL'.

PERFORM bdc_field USING 'BDC_OKCODE'

'/00'.

PERFORM bdc_field USING 'LFA1-ANRED'

it_tab-ANRED.

PERFORM bdc_field USING 'LFA1-NAME1'

it_tab-NAME1.

PERFORM bdc_field USING 'LFA1-SORTL'

it_tab-SORTL.

PERFORM bdc_field USING 'LFA1-NAME2'

it_tab-NAME2.

PERFORM bdc_field USING 'LFA1-NAME3'

it_tab-NAME3.

PERFORM bdc_field USING 'LFA1-ORT01'

it_tab-ORT01.

PERFORM bdc_field USING 'LFA1-PSTLZ'

it_tab-PSTLZ.

PERFORM bdc_field USING 'LFA1-LAND1'

it_tab-LAND1.

PERFORM bdc_field USING 'LFA1-REGIO'

it_tab-REGIO.

PERFORM bdc_field USING 'LFA1-SPRAS'

it_tab-SPRAS.

PERFORM bdc_field USING 'LFA1-TELF1'

it_tab-TELF1.

PERFORM bdc_field USING 'LFA1-TELFX'

it_tab-telfx.

PERFORM bdc_field USING 'LFA1-LFURL'

it_tab-LFURL.

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-BANKS(01)'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=ENTR'.

PERFORM bdc_dynpro USING 'SAPMF02K' '0380'.

PERFORM bdc_field USING 'BDC_CURSOR'

'KNVK-NAMEV(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_tab-AKONT.

PERFORM bdc_field USING 'LFB1-FDGRV'

it_tab-FDGRV.

PERFORM bdc_dynpro USING 'SAPMF02K' '0215'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFB1-TOGRU'.

PERFORM bdc_field USING 'BDC_OKCODE'

'/00'.

PERFORM bdc_field USING 'LFB1-TOGRU'

it_tab-TOGRU.

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' '0610'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=P+'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFBW-QSREC(06)'.

PERFORM bdc_field USING 'LFB1-QLAND'

it_tab-QLAND.

have a look over this .

With Regards.

ROHINI.K.

Re: data upload

Former Member — Tue, 30 Oct 2007 13:20:02 GMT

Change it the way I suggested:


PERFORM bdc_dynpro USING 'SAPMF02K' '0100'.
PERFORM bdc_field USING 'BDC_CURSOR'
'RF02K-KTOKK'.
PERFORM bdc_field USING 'BDC_OKCODE'
'/00'.
PERFORM bdc_field USING 'RF02K-BUKRS'
it_tab-BUKRS.
PERFORM bdc_field USING 'RF02K-EKORG'
it_tab-EKORG.
PERFORM bdc_field USING 'RF02K-KTOKK'
it_tab-KTOKK.
PERFORM bdc_field USING 'USE_ZAV'         'X'.   "<======== Use CAM
PERFORM bdc_dynpro USING 'SAPMF02K' '0110'.
PERFORM bdc_field USING 'BDC_CURSOR'
'LFA1-LFURL'.
PERFORM bdc_field USING 'BDC_OKCODE'
'/00'.
PERFORM bdc_field USING 'LFA1-ANRED'
it_tab-ANRED.
PERFORM bdc_field USING 'LFA1-NAME1'
it_tab-NAME1.
PERFORM bdc_field USING 'LFA1-SORTL'
it_tab-SORTL.
PERFORM bdc_field USING 'LFA1-NAME2'
it_tab-NAME2.
PERFORM bdc_field USING 'LFA1-NAME3'
it_tab-NAME3.
PERFORM bdc_field USING 'LFA1-ORT01'
it_tab-ORT01.
PERFORM bdc_field USING 'LFA1-PSTLZ'
it_tab-PSTLZ.
PERFORM bdc_field USING 'LFA1-LAND1'
it_tab-LAND1.
PERFORM bdc_field USING 'LFA1-REGIO'
it_tab-REGIO.
PERFORM bdc_field USING 'LFA1-SPRAS'
it_tab-SPRAS.
PERFORM bdc_field USING 'LFA1-TELF1'
it_tab-TELF1.
PERFORM bdc_field USING 'LFA1-TELFX'
it_tab-telfx.
PERFORM bdc_field USING 'LFA1-LFURL'
it_tab-LFURL.
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-BANKS(01)'.
PERFORM bdc_field USING 'BDC_OKCODE'
'=ENTR'.
PERFORM bdc_dynpro USING 'SAPMF02K' '0380'.
PERFORM bdc_field USING 'BDC_CURSOR'
'KNVK-NAMEV(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_tab-AKONT.
PERFORM bdc_field USING 'LFB1-FDGRV'
it_tab-FDGRV.
PERFORM bdc_dynpro USING 'SAPMF02K' '0215'.
PERFORM bdc_field USING 'BDC_CURSOR'
'LFB1-TOGRU'.
PERFORM bdc_field USING 'BDC_OKCODE'
'/00'.
PERFORM bdc_field USING 'LFB1-TOGRU'
it_tab-TOGRU.
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' '0610'.
PERFORM bdc_field USING 'BDC_OKCODE'
'=P+'.
PERFORM bdc_field USING 'BDC_CURSOR'
'LFBW-QSREC(06)'.
PERFORM bdc_field USING 'LFB1-QLAND'
it_tab-QLAND.

Rob