topic Re: bdc conversion in Application Development and Automation Discussions

bdc conversion

Former Member — Fri, 09 Mar 2007 08:20:21 GMT

hi have been asked to upload data from excel sheets into transaction mek1 using call transaction method.

also i have been asked to do validation checks on delivery country(KOMG-HLAND) and country of origin(KOMG-HERKL) from t005

and the rate unit(currency or percentage)KONP-KONWA from tcurc table.

how to do it?

Former Member — Fri, 09 Mar 2007 08:43:49 GMT

when u upload data into SAP, u need to take care of two aspects of data correcteness.

first one is,whether that data is uploaded in correct format or not

second one is.. whether the uploaded data is valid data or not...

first one we can say syntactical correctness of data,

second one is symantic correctness of data.

for delivery country, you need to check the table T005 for this.

regarding origin also u need to check the same table.

for rate unit, u need to chcek TCURC table.

loop at the internal table and check whether the entry exists in those correspoding table.

Hope this helps u.

Regards,

Sujatha.

Former Member — Fri, 09 Mar 2007 08:46:35 GMT

first upload data into internal table with gui_upload

and in the FM give HAS_FIELD_SEPARATOR = 'X'.

after that

select HLAND

HERKL

.......................

from t005

check sy-subrc.

this check for validation

and another select statement for the currency filed validation

this is also check for validation the currency

...some additional code is required...

rewards if its helpful.

Vijay Pawar