Creating user-defined fields

[Former Member]

Hi,

Is there a document or matrix that will show which SAP B1 tables are affected if I create a UDF?

For example, if I create a Tracking Number field in Delivery table, what other tables are affected?

Kindly advise.

Thanks,

Noel

[kothandaraman_nagarajan · Accepted solution]

Hi,

Run below query to know affected tables.  In short, all marketing documents tables are affected.

SELECT * FROM CUFD

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan,

Thank you very much.  The Select statement would help me generate the matrix I need.

Warm Regards,

Noel

[Former Member]

Hi Noel,

When you created a UDF under marketing document, all tables (> 10 objects) would be affected. This Tracking Number field will be available for all other tables such as ORDR, OPOR etc.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thank you very much.  Your answer together with Nagarajan's answer gave me an idea on how I will create the matrix I need.

Warm Regards,

Noel

[former_member205766]

Hi

Check the below link

http://www.pioneerb1.com/wp-content/uploads/2012/06/How-to-Create-User-Defined-Fields-and-Tables.pdf

With Regards

Balaji Sampath

[Former Member]

Thanks Balaji,

However, this is not the one I need to know.

Warm Regards,

Noel