Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with Mid Function


i have in datebase index like this 60001000.  I am trying display it like this 6000 1000. I used mid function in formula:

if {PKL1.BaseObject}=17 then {MID({RDR1.ItemCode}, 1, 4); MID({RDR1.ItemCode}, 4); }

else {MID({INV1.ItemCode}, 1, 4); MID({INV1.ItemCode},4)} 

I have error that this field doesnt exist. When i remove mid function its display properly.

Former Member

Hi Krystian,


if {PKL1.BaseObject}=17 then

MID({RDR1.ItemCode}, 1, 4) &' ' & MID({RDR1.ItemCode}, 4)

else MID({INV1.ItemCode}, 1, 4) & ' ' & MID({INV1.ItemCode},4)


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question