Invoic Mapping

[Former Member]

Hi,

I am trying to map the following condition for Invoic to EDI.

The Condition is : If first digit of E1EDK01 - KUNDEUINR <> "0", then Pass source into target else " ".

Source Idoc segment is E1EDK01 and Source Element is KUNDEUINR.

Target EDI Segment is SG30-RFF and Target Element C506 1154

Can you please help me out in this mapping.

Best Regards,

Sudhansu.

[Former Member · Accepted solution]

Hi,

you could use the (Text) standard function startsWith with input KUNDEUINR and constant(0).

The result goes into an if-function:

True: then KUNDEUINR

False: else Constant " "

Guess it's better to use the startsWith function then the substring function because if your value is empty you will have a mapping error in case of using the substring function.

Regards

Patrick

[sunil_singh13]

HI Sudhanshu,

Do Not use SUBSTRING function available in text because it does not handle exception if input is null or length is 0 ,and if exception happens then your mapping will fails .

So you can first use MapDefaultWith give some default value youcan keep it blank also([]) and then give it to SUBSTRING or STARTWITH .

rest of the things will be same as suggested by above people.

Try to check queue(right click on any graphical mapping you will find queue there and try to trace your problem)

Reward points if helpful.

thanks

Sunil Singh

[Former Member]

Hi,

Try this,

Input --> substring(start position = 0, count = 1) --> Equals(Text category)2nd input is Constant value = 0 --> If function(if true send source field else pass "").

Regards,

Rohit

Reward points if helpful

[Former Member]

Hi Sudhansu,

If substring(E1EDK01 - KUNDEUINR, 0, 1) = "0" then mapt E1EDK01 - KUNDEUINR to SG30-RFF - C506 1154. Else pass nothing to target EDI element.

Regards

Bhanu

Intelligroup.

[Former Member]

Hi,

Wrong Understood

Regards

Seshagiri

[prateek]

First use substring function to get the first character. Then use equals function to check if it is 0

Regards,

Prateek

[Former Member]

Hi,

I am able to generate the Segment SG3 aswell as the field C506 1154,but the value reflection after testing is blank for element 1154.It is unable to pass the value of KUNDEUIRN into C506 1154.Its showing a blank.

Can you please help in this regards.

Thanks,

Sudhansu

Edited by: Sudhansu on May 8, 2008 7:54 PM