BAPI_GOODSMVT_CREATE For MB1A

[Former Member]

Hi ,

I used BAPI_GOODSMVT_CREATE for MB1A. It is working fine.

Doc date & Posting Date format = 20091028.

Can we change it to DDMMYYYY ?

When I run bapi for for this month in back date it is working fine .but in the last month it is not generating material doc no.

Manually If I issue in last month using MB1A, then it is generating mat doc no. but using bapi it is not running for last month .

Plz reply for both the questions.

Thanks in Advance.

Already searched in SDN

Sai

[Former Member]

Hi ,

I used BAPI_GOODSMVT_CREATE for MB1A. It is working fine.

Doc date & Posting Date format = 20091028.

Can we change it to DDMMYYYY ?

When I run bapi for for this month in back date it is working fine .but in the last month it is not generating material doc no.

Manually If I issue in last month using MB1A, then it is generating mat doc no. but using bapi it is not running for last month .

Plz reply for both the questions.

Thanks in Advance.

Already searched in SDN

Sai

[Former Member]

hai,

use the edit-mask concept then date format can be changed to ddmmyy

[Former Member]

hi

Can we write dateformat ddmmyyyy in excel sheet & upload in bapi ?

Plz elaborate your ans

Sai

[Former Member]

No, before calling the BAPI u need to change the format of this field to yyyymmdd. U can use in Excel the format u want but change in program before calling the BAPI.

[Former Member]

Hi Sai,

Use following code to convert the date

data : final_date(8) type c,

test(8) type c,

dat(2) type c,

month(2) type c,

year(4) type c.

test = '20091028'.

dat = test+6(2).

month = test+4(2).

year = test+0(4).

concatenate dat month year into final_date.

In this case final_date will contain 28102009.

[Former Member]

You can format date in excel sheet. But, in program before you call bapi BAPI_GOODSMVT_CREATE, format date to YYYYMMDD using EDIT MASK or CONCATENATE

[Former Member]

Hi,

In the excel file you can give ddmmyyyy but when you pass it to BAPI table you have pass it as yyyymmdd. Beacuse in the BAPI it hasrefered as DATUM domain.

Venkat

[Former Member]

Hi Venkat ,

Thank you for your proper answer.

What about second Question ,what could be the problem ?

Sai