Uploading UDF

[Former Member]

Good Day,

I would like to ask something about UDF upload via DTW.

I created a UDF at the OSRI (Serial on Items) which I will use to upload via oInventoryGenEntry.

But I cannot find the UDF in that object (oInventoryGenEntry).

Can you assist me on this one?

Thanks

Version: SAP B1 2007 A SP00 PL42

[former_member186095 · Accepted solution]

Good day Cadeath,

I don't think you can upload UDF in serial management using DTW template even using DTW template of current version (B1 8.8).

try to use SQL statement to update it instead.

JimM

[Former Member]

Thank you guys

I will try to upload the Items via the BackEnd but before I will do that, I will test it thoroughly so that I will understand every field in that table.

[Former Member]

@GordonDu

As what I have heard in our supplier, it is not recommended by the support to use the BackEnd.

But as a Programmer/SDK Users, I understand that Mr. Jim iis giving the best and RIGHT solution for the limitation of the System.

But if you can recommend something that Mr. Jim didn't knew, we are happy to learn from you.

[Former Member]

What I mean is: when recommend non official way, clear mention the risk is mandatory. Although sounds safe, we never know all possible consequences in special situation.

[Former Member]

Yup

The risk will be always there if pursue.

I admit that I really get something from you both.

Thank you so much ^^

I will wait for some other guys to reply on my thread, still I will be open if you both will open up another answers.

God Bless you!

Thank you guys (Jim & GordonDu)

[Former Member]

Good Day

@GordonDu

Yes, I did but I don't know which field I will going to use.

@Jimmy

Hmmmm

So if it isn't, the SQL you mean is the BackEnd? Using the MS SQL itself?

[former_member186095]

Hi,

You are correct. After finishing importing the item using the DTW template (doc header, doc line and serial no. templates), you use sql statement to update the udf with required value

JimM

[Former Member]

If I will upload it using DTW Object oInventoryGenEntry,

What SQL Statement am I going to use and which table will I enter the entries?

Is it safe if I will use the BackEnd?

You've enlighten me, thank you.

[former_member186095]

Hi,

you are correct to use object oInventoryGenEntry but for SBO std field only. In your question, you said that you want to import value for your serial number UDF which located in the serial number table. The template to upload serial number is correct but is currently unable to use to upload UDF value that created in the serial number table. It is SAP B1 standard definition.

The backend work will not make your db inconsistent because your only update the serial number table udf . The weakness is just there is no change log for such field.

JimM

[Former Member]

Thank you Sir.

My Last Question

What should be the table if I will upload a data from oInventoryGenEntry?

Thank you Sir!

[former_member186095]

Hi,

The table is OIGN and IGN1 for oInventoryGenEntry and OSRI and SRI1 for serial number table.

Do not update non udf field in all the above mentioned tables.

JimM

[Former Member]

Hi Jimmy,

Using SQL statement to update the UDF in system table is not allowed by SAP support policy. Only UDT can be updated that way.

You may do it to take your own risk. However, to recommend to other member is not a professional advice.

Thanks,

Gordon

[Former Member]

Hi Sir,

Can you recommend of a good solution?

I know using SQL is one of the possible solution we see.

[former_member186095]

Hi,

Gordon's reply correct but we have suggested the back end solution to our customer. There are no problems in their db until present.

If you are not sure, you may test it. if you are still not sure, you could develop SDK addon. Just post message about it in the SDK forum.

JimM

[former_member186095]

Gordon,

I know it but the user said that he want to update the UDF value of OSRI table.

I think it will not give impact to other system table. You can see that the serial number table is not mixed with marketing document, master data or other. You could check it in the udf management --> category

The UDF in the serial number can't be updated starting from B1 earlier version until present. I am not sure why SAP skipped to enhance it.

JimM

[Former Member]

There are 3 files needed under oInventoryGenEntry folder for serial number upload. Have you include all 3 templates?

Thanks,

Gordon