cancel
Showing results for 
Search instead for 
Did you mean: 

Requirement on actual goods and planned date

yashcp
Active Participant
0 Kudos

Hi All,

I have a requirement in which customer wants to see Actual document date(WADAT_IST in LIKP table) against the particular sales order. If Actual goods date is not generated or blank then customer should see Planned date of goods (WADAT in LIKP table). Also, both I have both the fields in my Infocube.

Can Someone please tell me on the logic of this?

Regards,

Yash Parikh

Accepted Solutions (0)

Answers (4)

Answers (4)

yashcp
Active Participant
0 Kudos

What I suppose is that I need to make one infoobject of type date and map these two source fields, and then write the code. Is that correct?

Regards,

yash

Former Member
0 Kudos

Yes the target will be a date field while the source will be the 2 fields.

Regards,

Anupama

yashcp
Active Participant
0 Kudos

Ok so anyhow I need to add one more field to my infocube and map those two fields to this newly created field. Also, just to let you know I have both these fields avaialbe in target side (0GI_DATE and 0ACT_GI_DATE). Still i need to make new field. Is there anyway i can avoid creating/adding new field to cube?

yashcp
Active Participant
0 Kudos

Hi Anupama & Koen,

Thank you. I will try both the mentioned approaches and get back.

Regards,

Yash Parikh

Former Member
0 Kudos

You can do this in the transformation by 2 ways:

Using  rule type formula -> as suggested by Koen

or using field level Routine

if WADAT_IST is initial.

result = WADAT.

else

result = WADAT_IST

endif.

yashcp
Active Participant
0 Kudos

Hi Anupama,

Just one question in my TRFN there are two targets fields WADAT and WADAT_IST. Where should be the code/formula written? Also, if I write the code in one field I would need to map other one to the same field( Where I am writing the code) right?

Regards,

Yash Parikh

kohesco
Active Contributor
0 Kudos

Hi,

in your transformation, you can create a formula saying:

IF( IS_INITIAL( WADAT_IST ), WADAT, WADAT_IST )

Grtz

Koen