topic Re: upload xk01 in Application Development and Automation Discussions

upload xk01

former_member329386 — Thu, 06 Sep 2007 14:36:01 GMT

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

Re: upload xk01

Former Member — Fri, 07 Sep 2007 05:12:31 GMT

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

Re: upload xk01

Former Member — Fri, 07 Sep 2007 08:22:35 GMT

<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

Re: upload xk01

Former Member — Fri, 07 Sep 2007 08:32:57 GMT

hi,

chk this excelleny link.

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

Regards

Re: upload xk01

Former Member — Fri, 07 Sep 2007 09:00:48 GMT

good

go through this link

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

thanks

mrutyun^

Re: upload xk01

Former Member — Fri, 07 Sep 2007 09:04:19 GMT

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 .

Re: upload xk01

former_member329386 — Sat, 08 Sep 2007 17:04:05 GMT

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

Re: upload xk01

Former Member — Mon, 10 Sep 2007 04:58:17 GMT

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 .