BDC

[Former Member]

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

[vinod_vemuru2]

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

[Former Member]

where we need to declare this data and write statement.

[vinod_vemuru2]

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.