topic Re: create record for condition table via upload file tcode vk14/ SD in Application Development and Automation Discussions

create record for condition table via upload file tcode vk14/ SD

former_member445510 — Wed, 13 Nov 2013 13:32:07 GMT

Hello Every one,

i create manually a records for the my created condition table Axxx via tcode vk14/ vk11.

I want to create those records for my condition table via uploading file(XML or EXCEL or TEXT..) and not manually.

Example of my file :

ShipFrom	ShipTo	CustomerCountry	TaxCode
BE	FR	BE	A1
BE	BE	BE	A0
BE	CH	BE	A2

There is no ABAP code/prog to create for example a upload input, when i select my upload file, i click on execute, and than i find my condition table(s) axxx filled in with data, like we doing via vk11 / 14?

Hope my question is clear ... Thanks for your help.

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Thu, 14 Nov 2013 08:40:59 GMT

Hello,

no one has idea about my question?

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Thu, 14 Nov 2013 08:52:28 GMT

Go for BDC .

Record the Data with one set of data and right the program.

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Thu, 14 Nov 2013 13:03:02 GMT

Thank u Hanumanth for you reply.

When i create a program via SHDB, i receive the flowing screen:

I have text file en xls file, but i don't know how to upload my file?

Wish extension i have to use? txt or xls ?

Where can i make my locale file? in C:/.... ?

Do you have any idea ?

Thank u.

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Thu, 14 Nov 2013 13:24:47 GMT

Give Program Name

and select Transfer from Recording

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Thu, 14 Nov 2013 13:30:02 GMT

But i need to do that from excel or text File.

Is that the same ?

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Thu, 14 Nov 2013 13:44:02 GMT

Yes first record the data and you can upload data using excel file or tab delimited text file

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Thu, 14 Nov 2013 13:51:48 GMT

ok good.

This is my received code:

report ZZ_RECORD_UPLOAD
        no standard page heading line-size 255.

include bdcrecx1.

start-of-selection.

perform open_group.

perform bdc_dynpro      using 'SAPMV13A' '0100'.
perform bdc_field       using 'BDC_CURSOR'
                               'RV13A-KOTABNR'.
perform bdc_field       using 'BDC_OKCODE'
                               '/00'.
perform bdc_field       using 'RV13A-KSCHL'
                               'zmws'.
perform bdc_field       using 'RV13A-KOTABNR'
                               '558'.
perform bdc_dynpro      using 'SAPMV13A' '1558'.
perform bdc_field       using 'BDC_CURSOR'
                               'KOMG-ZZTRANSPORT(01)'.
perform bdc_field       using 'BDC_OKCODE'
                               '/00'.
perform bdc_field       using 'KOMG-VKORG'
                               'BE22'.
perform bdc_field       using 'KOMG-VTWEG'
                               '01'.
perform bdc_field       using 'KOMG-MATKL'
                               '00105'.
perform bdc_field       using 'KOMG-ZZTRANSPORT(01)'
                               'GOOD_FERT_1'.
perform bdc_dynpro      using 'SAPMV13A' '1558'.
perform bdc_field       using 'BDC_CURSOR'
                               'KONP-MWSK1(01)'.
perform bdc_field       using 'BDC_OKCODE'
                               '/00'.
perform bdc_field       using 'KONP-MWSK1(01)'
                               'AK'.
perform bdc_dynpro      using 'SAPMV13A' '1558'.
perform bdc_field       using 'BDC_CURSOR'
                               'KOMG-ZZTRANSPORT(01)'.
perform bdc_field       using 'BDC_OKCODE'
                               '=SICH'.
perform bdc_transaction using 'VK15'.

perform close_group.

****************************************************************************

And this is my file data:

KSCHL	KOTABNR	VKORG	VTWEG	MATKL	ZZTRANSPORT	MWSK1
ZMWS	558	BE22	1	1	GOOD_FERT_1	AA
ZMWS	558	BE22	1	105	GOOD_FERT_1	AK
ZMWS	558	BE22	1	105	GOOD_FERT_1	AN
ZMWS	558	BE22	1	105	GOOD_FERT_1	A0

Do you know the next step, I'm new here ...

Thank u.

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Thu, 14 Nov 2013 15:36:43 GMT

I created this program, it's woks but i have to click on enter every time to create a records.

There is no anther way to upload this file without every doing this enter?

because i have more data.

thanks.

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Fri, 15 Nov 2013 05:25:04 GMT

Dear Roukbi,

Do below steps.

1. Get data from Excel file to internal Table using 'TEXT_CONVERT_XLS_TO_SAP'

2. Now loop this internal table with the above code.

3. collect the erros in BDCmsgcoll

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Fri, 15 Nov 2013 09:18:18 GMT

Hi Hanumanth,

It's works but not 100 %.

I have to small problems:

1- i want to upload the excel file without clicking every time on enter?

2- in Excel the numbers entered (like Distr. Channel) are 01 for example, but when i upload i find 1 instead 01.

example of my excel file:

ZMWS 558 BE22 01 00105 GOOD_FERT_1 AA

ZMWS 558 BE22 01 02004 GOOD_FERT_1 AK

ZMWS 558 BE22 01 02004 GOOD_FERT_1 AN

ZMWS 558 BE22 01 02004 GOOD_FERT_1 A0

i deed it with cell format:

any idea ?

Thank u very mach.

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Fri, 15 Nov 2013 09:28:13 GMT

2- question 2 i resolved by choosing text format.

For the first question, do you have any idea ?

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Fri, 15 Nov 2013 09:42:57 GMT

Hi,

In the report section screen you can put the values as below.

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Fri, 15 Nov 2013 09:46:40 GMT

Thank u for replaying.

Is that for my first question? (1- i want to upload the excel file without clicking every time on enter? )

this is my first output screen.

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Fri, 15 Nov 2013 10:11:52 GMT

Hi,

In this case you have to place all your files in application server(AL11) directory and run the program in back ground.

Thanks,

Kiran.

Re: create record for condition table via upload file tcode vk14/ SD

Former Member — Fri, 15 Nov 2013 10:58:21 GMT

Use application server

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Fri, 15 Nov 2013 14:19:26 GMT

I convert my xls file to csv :

i deed in ABAP code the following:

DATA: filename type string,
wa_string TYPE string.

filename = 'D:\usr\sap\put\record_vk15_conv.csv'.
open dataset filename for output in text mode encoding default.

DO.
read DATASET filename INTO wa_string.
ENDDO.

CLOSE DATASET filename.

Here i transfer no data, wish code can i add to transfer data to server ?

Re: create record for condition table via upload file tcode vk14/ SD

former_member445510 — Fri, 15 Nov 2013 15:34:34 GMT

no idea.??.