cancel
Showing results for 
Search instead for 
Did you mean: 

field length problem

Former Member
0 Kudos

Hi

my source side field posex is of length 6 while reciever field po_item is of length 5,in map test it is working fine,but running the interface the entire 6 digits are getting picked up from source though we are giving 5 digits only,the reason might be is sender is sap field so by default 0 is getting prefixed for 5digits

ex: source(posex(6)) target(po_item(5))

00010 00001

but i should get target as 00010

both sender and reciever are sap systems

so how could i solve this issue.

regards

raghu

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

sender is sap field so by default 0 is getting prefixed for 5digits

This is not a standard behavior.

What is happening when your source have 6 characters. The example you gave have only 5 characters.

Regards,

Prateek

Former Member
0 Kudos

though i am giving 5 digits at sender side,by default it is storing as six digits in sender side

ex: if i give posex(sender field) = 00010,it is storing in sender system as 000010 since its length is 6 and sending the value to target,since in target it is of length 5 i am getting value as 00001

Former Member
0 Kudos

senders side idoc order05 ,segment E1EDP01,field posex

reciever side idoc pordcr102,segment E1BPMEPOITEM,field po_item

Shabarish_Nair
Active Contributor
0 Kudos

in the mapping, use a substring and extract the last 5 digits of your source field and map it to the target field.

Should solve the issue.

SudhirT
Active Contributor
0 Kudos

Hi,

Try like this

SourceField --length --greaterThan--constant(5) ----Ifwithoutelse---- Then--- substring(1,5)----TargetField.

Thanks!

Answers (1)

Answers (1)

SudhirT
Active Contributor
0 Kudos

Hi Raghu,

it seems to be mapping related issue. What is your mapping for this particular field.

Thanks!