Regarding Date values in 2LIS_12_VCITM

[Former Member]

I am loading data into 0SD_C04 using 2LIS_12_VCITM. According to my functional specs, I need the following values:

Goods Issue Date.

Actual Goods issue date.

Delivery date etc.

I had used standard Update Rules for 2LIS_12_VCITM to load data into 0SD_C04. But I got numeric values for all date values.

So, I deleted the standard update rules and I applied the update rules manually. But to assign the Source Key Figure for Goods Issues Date, I am only getting 0DENOMINTR and 0NUMERATOR values. So, I selected Routine and assigned Result = Comm_structure-GIDate.

Now I got only 0 values.

How to modify the Update Rules so that I will get values in Date Format. So that I can represent Goods Issue date, Actual Delivery date etc data in my query…

[Former Member · Accepted solution]

Hi jayanth

If I got ur question correctly, the fields u mentioned are characterstics not key figures. so u can't get numeric values.explain ur query clearly. Any how

check these links

http://help.sap.com/saphelp_nw04/helpdata/en/c5/bbe737a294946fe10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/bb/f24a3d32811d72e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/a7/7367378873e67ee10000009b38f8cf/content.htm

may be helpfull.... let me know

Regards

NR

[Former Member]

These links are stating only the required details about infoobjects in SD delivery side.

But, i need to get clarified about the prblm in getting display of date format for Goods Issue date and as i earlier told in PSA it is getting displayed correctly.

Whereas in Target cube , it is giving numeric values becuase of update rules. In that update rule, for Goods Issue date we have given the result value assigned to Goods Issue date.

So, please verify the case and let me know feedback.

regards,

Jayanth.

[Former Member]

hi,

If ur data in PSA is correct, then it is sure that ur infoobject definition is wrong.

Make sure data type for Goods issue date is DATS and not NUMC or CHAR.

Pls let me know if this cld solve ur problem.

Cheers!

Bhu.

[Former Member]

Hi Bhuvana,

The Infoobjects are standard InfoObjects. I checked the Data type for 0GI_DATE and the data type is Dats both in Transfer Rules as well as in InfoCube.

Regards

YJ

[Former Member]

Hi Jayanth,

Then in this case what i cld say is problem is only in mapping. Pls check in ur transfer rules ur mapping is correct. Also check communication structure. Because if u have that field in comm structure, when u r mapping in update rules u will be able to see that field and not only denominator and Numerator.

More to hear from u.

Cheers!

Bhuvana.

[Former Member]

Hi Bhuvana,

I have checked the Transfer Rules for the Specified GI Date, Actual Goods issue date and all other date values. They were mapped properly. In the Comminication Structure for all the Date values the 'Check Object' column is blank. I tried to enter the Check Object. But it is not allowing me to add the 'Check Object' value. What is the significance of the Check Object ??

Thank you for your patience,

Please help me out...

[Former Member]

Hi All,

Can anybody help me in this regard. I am still struck up with the issue. I tried all the possible ways.

Please help me out...

Regards

YJ

[Former Member]

Hi Jayanth,

Sorry i was busy and overlooked ur msg.

In comm structure main thing u need to have is Infoobject description, data type, and for this there shld not be any conversion. etc... and there is nothing like check object.. In which version u r working?

Pls make sure for this field, whether this infoobject has a reference char 0DATE. and data type DATS, Length 8 and output length 10. U can use the standard infoobject 0GI_DATE. I am currently using the same infoobject and i dont find any issue. If u have this field in comm structure automatically u can mapp in Update rules with out any issue.

Let me know if u need anyother help. Have u settled this problem?

Cheers!

Bhuvana.

[Former Member]

Hi Jayanth

Thera r two infoobjects for Goods issue date wit tech. names 0GIDATE and 0GI_DATE. One is key fig and another one is characterstics. which one ur using

Hope it helps.........let me know

Regards

NR

[Former Member]

> Hi Jayanth

>

> Thera r two infoobjects for Goods issue date wit

> tech. names 0GIDATE and 0GI_DATE. One is key fig and

> another one is characterstics. which one ur using

>

> Hope it helps.........let me know

>

> Regards

> NR

Hi,

We are also installing business content for 0SD_CO4 and we use 2LIS_12_VCITM and 2LIS_12_VCSCL. The update rule in order to get the Goods issue date, actual goods issue date etc., (all are key figures)get numeric values. when I checked the key figures, they are using the date fields with DATS type. But the data type for the key figures are of data type DEC. Any idea of how to convert the data type to populate the correct dates instead of numeric junk values?