topic BDC in Application Development and Automation Discussions

BDC

Former Member — Sun, 20 Apr 2008 05:43:01 GMT

How to upload Numeric Fields,Quantity and Date into BDC?Points will be no doubtedly awarded to the deserve one.

Re: BDC

vinod_vemuru2 — Sun, 20 Apr 2008 09:49:30 GMT

Hi Ajaya,

Declare the character variable of length equal to the output length of the date/quantity/Currency/Numeric field.

U can get the output length from the domain of that field.

EG: System field length of date is 8, But output length is 10 including 2 seperators.

Next use WRITE statement to convert the data as per the user settings.

EG: User 1 may use date seperator as period(.) and user 2 may use slash(/). If we use WRITE statement then it will written as per the user settings.

eg: DATA: l_date(10) TYPE c,

l_lfmng(16) TYPE c.

WRITE: sy-datum TO l_date,

wa_lips-lfmng TO l_lfmng.

Then while building BDC table use these character variables.

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on Apr 20, 2008 3:20 PM

Re: BDC

Former Member — Mon, 21 Apr 2008 07:54:53 GMT

where we need to declare this data and write statement.

Re: BDC

vinod_vemuru2 — Mon, 21 Apr 2008 16:13:26 GMT

Hi Ajaya,

Just declare these variables either in TOP include of the report or forms where u r populating the bdc data.

WRITE statement should be used before populating the data to BDC table. Now u might be directly using the data from internal table. What u have to do is pass the work area value to the variable of character type and populate the bdcdata internal table with this variable.

Hope this clarified ur doubts.

Thanks,

Vinod.