2007 Sep 06 3:36 PM
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
2007 Sep 07 6:12 AM
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
2007 Sep 07 6:12 AM
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
2007 Sep 07 9:22 AM
<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
2007 Sep 08 6:04 PM
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
2007 Sep 10 5:58 AM
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 .
2007 Sep 07 9:32 AM
hi,
chk this excelleny link.
<b>http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm</b>
Regards
2007 Sep 07 10:00 AM
hi
good
go through this link
http://www.sap-img.com/abap/bdc-example-using-table-control-in-bdc.htm
thanks
mrutyun^
2007 Sep 07 10:04 AM
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 .
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |