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 xk01

former_member329386
Participant
0 Likes
984

hi wxperts

Can u tell me steps for recording bdc foe xko1 and what are the fields to be taken in programe & how to decide about fields(is there any condition). send screen shots if possible

Thanks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
925

Hi,

Please check this program.These are the fields entered while recording.

report Z_XK01

no standard page heading line-size 255.

include bdcrecx1.

parameters: dataset(132) lower case.

      • DO NOT CHANGE - the generated data section - DO NOT CHANGE ***

*

  • If it is nessesary to change the data section use the rules:

  • 1.) Each definition of a field exists of two lines

  • 2.) The first line shows exactly the comment

  • '* data element: ' followed with the data element

  • which describes the field.

  • If you don't have a data element use the

  • comment without a data element name

  • 3.) The second line shows the fieldname of the

  • structure, the fieldname must consist of

  • a fieldname and optional the character '_' and

  • three numbers and the field length in brackets

  • 4.) Each field must be type C.

*

      • Generated data section with specific formatting - DO NOT CHANGE ***

data: begin of record,

  • data element: LIF16

LIFNR_001(016),

  • data element: BUKRS

BUKRS_002(004),

  • data element: EKORG

EKORG_003(004),

  • data element: KTOKK

KTOKK_004(004),

  • data element: ANRED

ANRED_005(015),

  • data element: NAME1_GP

NAME1_006(035),

  • data element: SORTL

SORTL_007(010),

  • data element: STRAS_GP

STRAS_008(035),

  • data element: ORT01_GP

ORT01_009(035),

  • data element: PSTLZ

PSTLZ_010(010),

  • data element: LAND1_GP

LAND1_011(003),

  • data element: SPRAS

SPRAS_012(002),

  • data element: J_1AFITP_D

FITYP_013(002),

  • data element: STKZU

STKZU_014(001),

  • data element: BANKS

BANKS_01_015(003),

  • data element: BANKK

BANKL_01_016(015),

  • data element: BANKN

BANKN_01_017(018),

  • data element: KOINH_FI

KOINH_01_018(060),

  • data element: NAMEV_VP

NAMEV_01_019(035),

  • data element: NAME1_GP

NAME1_01_020(035),

  • data element: AKONT

AKONT_021(010),

  • data element: DZTERM

ZTERM_022(004),

  • data element: MAHNA

MAHNA_023(004),

  • data element: BSTWA

WAERS_024(005),

end of record.

      • End generated data section ***

start-of-selection.

perform open_dataset using dataset.

perform open_group.

do.

read dataset dataset into record.

if sy-subrc <> 0. exit. endif.

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-LIFNR'

record-LIFNR_001.

perform bdc_field using 'RF02K-BUKRS'

record-BUKRS_002.

perform bdc_field using 'RF02K-EKORG'

record-EKORG_003.

perform bdc_field using 'RF02K-KTOKK'

record-KTOKK_004.

perform bdc_dynpro using 'SAPMF02K' '0110'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-SORTL'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFA1-ANRED'

record-ANRED_005.

perform bdc_field using 'LFA1-NAME1'

record-NAME1_006.

perform bdc_field using 'LFA1-SORTL'

record-SORTL_007.

perform bdc_field using 'LFA1-STRAS'

record-STRAS_008.

perform bdc_field using 'LFA1-ORT01'

record-ORT01_009.

perform bdc_field using 'LFA1-PSTLZ'

record-PSTLZ_010.

perform bdc_field using 'LFA1-LAND1'

record-LAND1_011.

perform bdc_field using 'LFA1-SPRAS'

record-SPRAS_012.

perform bdc_dynpro using 'SAPMF02K' '0120'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-STKZU'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFA1-FITYP'

record-FITYP_013.

perform bdc_field using 'LFA1-STKZU'

record-STKZU_014.

perform bdc_dynpro using 'SAPMF02K' '0130'.

perform bdc_field using 'BDC_CURSOR'

'LFBK-KOINH(01)'.

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_field using 'LFBK-BANKS(01)'

record-BANKS_01_015.

perform bdc_field using 'LFBK-BANKL(01)'

record-BANKL_01_016.

perform bdc_field using 'LFBK-BANKN(01)'

record-BANKN_01_017.

perform bdc_field using 'LFBK-KOINH(01)'

record-KOINH_01_018.

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

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_field using 'KNVK-NAMEV(01)'

record-NAMEV_01_019.

perform bdc_field using 'KNVK-NAME1(01)'

record-NAME1_01_020.

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

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB1-AKONT'

record-AKONT_021.

perform bdc_dynpro using 'SAPMF02K' '0215'.

perform bdc_field using 'BDC_CURSOR'

'LFB1-ZTERM'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB1-ZTERM'

record-ZTERM_022.

perform bdc_dynpro using 'SAPMF02K' '0220'.

perform bdc_field using 'BDC_CURSOR'

'LFB5-MAHNA'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB5-MAHNA'

record-MAHNA_023.

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'

record-WAERS_024.

perform bdc_dynpro using 'SAPMF02K' '0320'.

perform bdc_field using 'BDC_CURSOR'

'RF02K-LIFNR'.

perform bdc_field using 'BDC_OKCODE'

'=UPDA'.

perform bdc_transaction using 'XK01'.

enddo.

perform close_group.

perform close_dataset using dataset.

<b>Reward Points if Useful</b>

Regards

Gokul

hi wxperts

Can u tell me steps for recording bdc foe xko1 and what are the fields to be taken in programe & how to decide about fields(is there any condition). send screen shots if possible

Thanks

7 REPLIES 7
Read only

Former Member
0 Likes
926

Hi,

Please check this program.These are the fields entered while recording.

report Z_XK01

no standard page heading line-size 255.

include bdcrecx1.

parameters: dataset(132) lower case.

      • DO NOT CHANGE - the generated data section - DO NOT CHANGE ***

*

  • If it is nessesary to change the data section use the rules:

  • 1.) Each definition of a field exists of two lines

  • 2.) The first line shows exactly the comment

  • '* data element: ' followed with the data element

  • which describes the field.

  • If you don't have a data element use the

  • comment without a data element name

  • 3.) The second line shows the fieldname of the

  • structure, the fieldname must consist of

  • a fieldname and optional the character '_' and

  • three numbers and the field length in brackets

  • 4.) Each field must be type C.

*

      • Generated data section with specific formatting - DO NOT CHANGE ***

data: begin of record,

  • data element: LIF16

LIFNR_001(016),

  • data element: BUKRS

BUKRS_002(004),

  • data element: EKORG

EKORG_003(004),

  • data element: KTOKK

KTOKK_004(004),

  • data element: ANRED

ANRED_005(015),

  • data element: NAME1_GP

NAME1_006(035),

  • data element: SORTL

SORTL_007(010),

  • data element: STRAS_GP

STRAS_008(035),

  • data element: ORT01_GP

ORT01_009(035),

  • data element: PSTLZ

PSTLZ_010(010),

  • data element: LAND1_GP

LAND1_011(003),

  • data element: SPRAS

SPRAS_012(002),

  • data element: J_1AFITP_D

FITYP_013(002),

  • data element: STKZU

STKZU_014(001),

  • data element: BANKS

BANKS_01_015(003),

  • data element: BANKK

BANKL_01_016(015),

  • data element: BANKN

BANKN_01_017(018),

  • data element: KOINH_FI

KOINH_01_018(060),

  • data element: NAMEV_VP

NAMEV_01_019(035),

  • data element: NAME1_GP

NAME1_01_020(035),

  • data element: AKONT

AKONT_021(010),

  • data element: DZTERM

ZTERM_022(004),

  • data element: MAHNA

MAHNA_023(004),

  • data element: BSTWA

WAERS_024(005),

end of record.

      • End generated data section ***

start-of-selection.

perform open_dataset using dataset.

perform open_group.

do.

read dataset dataset into record.

if sy-subrc <> 0. exit. endif.

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-LIFNR'

record-LIFNR_001.

perform bdc_field using 'RF02K-BUKRS'

record-BUKRS_002.

perform bdc_field using 'RF02K-EKORG'

record-EKORG_003.

perform bdc_field using 'RF02K-KTOKK'

record-KTOKK_004.

perform bdc_dynpro using 'SAPMF02K' '0110'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-SORTL'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFA1-ANRED'

record-ANRED_005.

perform bdc_field using 'LFA1-NAME1'

record-NAME1_006.

perform bdc_field using 'LFA1-SORTL'

record-SORTL_007.

perform bdc_field using 'LFA1-STRAS'

record-STRAS_008.

perform bdc_field using 'LFA1-ORT01'

record-ORT01_009.

perform bdc_field using 'LFA1-PSTLZ'

record-PSTLZ_010.

perform bdc_field using 'LFA1-LAND1'

record-LAND1_011.

perform bdc_field using 'LFA1-SPRAS'

record-SPRAS_012.

perform bdc_dynpro using 'SAPMF02K' '0120'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-STKZU'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFA1-FITYP'

record-FITYP_013.

perform bdc_field using 'LFA1-STKZU'

record-STKZU_014.

perform bdc_dynpro using 'SAPMF02K' '0130'.

perform bdc_field using 'BDC_CURSOR'

'LFBK-KOINH(01)'.

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_field using 'LFBK-BANKS(01)'

record-BANKS_01_015.

perform bdc_field using 'LFBK-BANKL(01)'

record-BANKL_01_016.

perform bdc_field using 'LFBK-BANKN(01)'

record-BANKN_01_017.

perform bdc_field using 'LFBK-KOINH(01)'

record-KOINH_01_018.

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

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_field using 'KNVK-NAMEV(01)'

record-NAMEV_01_019.

perform bdc_field using 'KNVK-NAME1(01)'

record-NAME1_01_020.

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

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB1-AKONT'

record-AKONT_021.

perform bdc_dynpro using 'SAPMF02K' '0215'.

perform bdc_field using 'BDC_CURSOR'

'LFB1-ZTERM'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB1-ZTERM'

record-ZTERM_022.

perform bdc_dynpro using 'SAPMF02K' '0220'.

perform bdc_field using 'BDC_CURSOR'

'LFB5-MAHNA'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB5-MAHNA'

record-MAHNA_023.

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'

record-WAERS_024.

perform bdc_dynpro using 'SAPMF02K' '0320'.

perform bdc_field using 'BDC_CURSOR'

'RF02K-LIFNR'.

perform bdc_field using 'BDC_OKCODE'

'=UPDA'.

perform bdc_transaction using 'XK01'.

enddo.

perform close_group.

perform close_dataset using dataset.

<b>Reward Points if Useful</b>

Regards

Gokul

Read only

Former Member
0 Likes
925

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/profile?userid=3632819">see my reply here towards the end of the thread</a>

regards,

srinivas

Read only

0 Likes
925

Hi sir

Thanks for ur help.

I have doubt in bdc recording

1) I we have bulk data then we prefer session method rather than call transaction..

but if we have just 100 records then which method will be suitable & why ?

thanks

Read only

0 Likes
925

Hi ,

If u have 100 Records In ur Flat file then u go for call transaction method,

As u knwon call tranction is faster than session method , but in case of session method u have create a seesion first then u run that session using Tcode SM35 ,

call transaction is the synchronous process.means wait and replay method , it means ist one record updated then another record come .

Regards,

Nihar .

Read only

Former Member
0 Likes
925

hi,

chk this excelleny link.

<b>http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm</b>

Regards

Read only

Former Member
0 Likes
925
Read only

Former Member
0 Likes
925

Hi plz see this BDC for XK01 for vendor creation .

REPORT zn_bdc_vendorcreation NO STANDARD PAGE HEADING LINE-SIZE 255.

DATA: bdcdata LIKE bdcdata OCCURS 0 WITH HEADER LINE.

START-OF-SELECTION.

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-LIFNR'

'4'.

PERFORM bdc_field USING 'RF02K-BUKRS'

'1000'.

PERFORM bdc_field USING 'RF02K-EKORG'

'1000'.

PERFORM bdc_field USING 'RF02K-KTOKK'

'0001'.

PERFORM bdc_dynpro USING 'SAPMF02K' '0110'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFA1-TELFX'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

PERFORM bdc_field USING 'LFA1-ANRED'

'Ms'.

PERFORM bdc_field USING 'LFA1-NAME1'

'Keerthi Kamath'.

PERFORM bdc_field USING 'LFA1-SORTL'

'VKM'.

PERFORM bdc_field USING 'LFA1-STRAS'

'ricmond road'.

PERFORM bdc_field USING 'LFA1-PFACH'

''.

PERFORM bdc_field USING 'LFA1-ORT01'

'bangalore'.

PERFORM bdc_field USING 'LFA1-PSTLZ'

'560001'.

PERFORM bdc_field USING 'LFA1-ORT02'

'bangalore'.

PERFORM bdc_field USING 'LFA1-LAND1'

'IN'.

PERFORM bdc_field USING 'LFA1-SPRAS'

'en'.

PERFORM bdc_field USING 'LFA1-TELF1'

'24356785'.

PERFORM bdc_field USING 'LFA1-TELFX'

'65467509'.

PERFORM bdc_dynpro USING 'SAPMF02K' '0210'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFB1-FDGRV'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

PERFORM bdc_field USING 'LFB1-AKONT'

'31000'.

PERFORM bdc_field USING 'LFB1-FDGRV'

'A1'.

PERFORM bdc_dynpro USING 'SAPMF02K' '0310'.

PERFORM bdc_field USING 'BDC_CURSOR'

'LFM1-WAERS'.

PERFORM bdc_field USING 'BDC_OKCODE'

'=UPDA'.

PERFORM bdc_field USING 'LFM1-WAERS'

'INR'.

CALL TRANSACTION 'XK01'

USING bdcdata

UPDATE 'A'

MODE 'A' .

----


  • Start new screen *

----


FORM bdc_dynpro USING program dynpro.

CLEAR bdcdata.

bdcdata-program = program.

bdcdata-dynpro = dynpro.

bdcdata-dynbegin = 'X'.

APPEND bdcdata.

ENDFORM. "BDC_DYNPRO

----


  • Insert field *

----


FORM bdc_field USING fnam fval.

CLEAR bdcdata.

bdcdata-fnam = fnam.

bdcdata-fval = fval.

APPEND bdcdata.

ENDFORM. "BDC_FIELD

Regards.

Nihar Swain .