Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

data upload

Former Member

‎10-29-2007 12:33 PM

0 Kudos

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.

7 REPLIES 7

Former Member

‎10-29-2007 1:02 PM

0 Kudos

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.

Former Member
In response to Former Member

‎10-30-2007 4:16 AM

0 Kudos

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.

Former Member

‎10-29-2007 1:05 PM

0 Kudos

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

Former Member
In response to Former Member

‎10-30-2007 4:22 AM

0 Kudos

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.

Former Member
In response to Former Member

‎10-30-2007 4:33 AM

0 Kudos

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.

Former Member
In response to Former Member

‎10-30-2007 1:20 PM

0 Kudos

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

Former Member

‎10-29-2007 1:51 PM

0 Kudos

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