topic Re: IN bdc uploading program select the data from db in Application Development and Automation Discussions

IN bdc uploading program select the data from db

Former Member — Wed, 03 Apr 2013 10:26:42 GMT

hi friends,

iam write the bdc uploading program for transaction fd32, in this uploading file iam having fields below like this

customerno controlarea creditlimit

1 1000 30000

2 1000 5000

based upon uploading file(customer number), i want to select the data from CDPOS table based on customer number in cdpos table having same customer multiple records, but i want first record new_value only?

iam trying different types of select statements but it is not working, i didnt get the data from database. if anybody know please tell me.

Re: IN bdc uploading program select the data from db

Former Member — Wed, 03 Apr 2013 10:53:11 GMT

Hi Priya,

Please select first than sorting by DESCENDING .Than u have to read it.Than u will get the Current data.

Thanks

Tarak

Re: IN bdc uploading program select the data from db

former_member585060 — Wed, 03 Apr 2013 10:54:20 GMT

Hi,

Add leading zero's to the Customer Numbers from file.

Then for all those Customer Number access CDPOS table by below select statement.

SELECT *

FROM CDPOS

INTO TABLE lt_cdpos

FOR ALL ENTRIES IN lt_file

WHERE OBJECTCLAS = 'KLIM'

AND OBJECTID = lt_file-kunnr

AND TABNAME = 'KNKK'

AND FBAME = 'KLIMK'

AND VALUE_NEW <> space.

IF sy-subrc = 0.

SORT lt_cdpos.

ENDIF.

Thanks & Regards

Bala Krishna

Re: IN bdc uploading program select the data from db

Former Member — Wed, 03 Apr 2013 11:02:45 GMT

Hi,

try control break statements in loop.

LOOP AT ITAB.

AT NEW customer no

perform fill_screen_details.

perform fill_field_details.

endat.

ENDLOOP.

Or if your flat is an excel type,put filter to customer no and take the req data and upload ..

Re: IN bdc uploading program select the data from db

Former Member — Wed, 03 Apr 2013 11:11:07 GMT

hi it will show error message like this...

when we are using for 'all entries in tab' the field objectid and it_tab-kunnr must have the same type ans same length

Re: IN bdc uploading program select the data from db

Former Member — Wed, 03 Apr 2013 11:33:30 GMT

hi, uploading is working but my is not uploading,

in uploading file iam having customer number i want to select the data from cdpos (FIELD- VALUE_NEW) table where customernumber is same.

and then cdpos table value_new field having some amount, now i want to calculate the % cdpos value_new and Uploading file credit limit value, if percentage is 10% i want uploading data successfully, otherwise it will show error message it will not uploaded.

Re: IN bdc uploading program select the data from db

former_member585060 — Wed, 03 Apr 2013 15:19:58 GMT

Create a new internal table with only one field and move all the customer numbers into that and use that table.

Ex:-

TYPES : BEGIN OF ty_kunnr,

kunnr TYPE cdpos-objectid,

END OF ty_kunnr.

DATA : lt_kunnr TYPE STANDARD TABLE OF ty_kunnr,

wa_kunnr TYPE ty_kunnr.

LOOP AT lt_file INTO wa_file.

wa_kunnr-kunnr = wa_file-kunnr.

ENDLOOP.

* Then use select.

SELECT *

FROM CDPOS

INTO TABLE lt_cdpos

FOR ALL ENTRIES IN lt_kunnr

WHERE OBJECTCLAS = 'KLIM'

AND OBJECTID = lt_kunnr-kunnr

AND TABNAME = 'KNKK'

AND FBAME = 'KLIMK'

AND VALUE_NEW <> space.

IF sy-subrc = 0.

SORT lt_cdpos.

ENDIF.

Thanks and Regards

Bala Krishna