Standard field display name

[attila_sarkady]

In which table are stored the SBO field original display names?

ex: OCRD.CardFName -> Foreign Name

OITM.FirmCode -> Manufacturer

I look for the "Foreign Name" or "Manufacturer".

Thank you,

Attila Sarkady

[CRVMANISH]

SDIS Table

[attila_sarkady]

The SDIS table contains only the display names which I renamed.

I want to know, where are the original names stored.

[CRVMANISH]

Original Description does not get stored anywhere it comes from XML

[attila_sarkady]

Do you know, where are theese XML files?

[CRVMANISH]

First tell me why u want original name, what is purpose behind it

[Former Member]

C:\Program Files\SAP\SAP Business One\GUI\SBO_ language... (becasue each language in SBO has different default field name)

[attila_sarkady]

I want to export the SBO table structure with data types, precision, field names, and original display names.

The other things I found in the syscolumns view.

I Ithought that there are stored the language dependent original display names somewhere in SQL tables.

The big problem is:

We would like to export the SBO data and import it into another system: SAP R3

Thank you for your help.

Attila

[Former Member]

Its not easy to modify or read LRF file (its a long time fight between developers and SAP), but there exists one workarounf for your problem.

In SBO is query generator where when you wrote table name, you get in one matrix all fields and description of these fields. This matrix you may export to csv file, or if you need all tables, create small addon which will change the table name in itemUID = 4 and with sendkeys send tab key. After this the matrix is populated with datas you need, work with matrix and loop go through all tables (from sysview). In this way youll get fieldname and fielddescription too in few easy steps.

Creating tables to R3 in same data structure as in SBO you may do as you suggested from system views on tables, fields a type structure or in management studio as scrip to Create...

hope it helps