cancel
Showing results for 
Search instead for 
Did you mean: 

Document number in BOM table

DM-kiko
Explorer
0 Kudos

Hi all,

To get the correct document numbers on drawing partlist I need to know how these document are called in the backend.

In default.txt of ECTR configuration, I have placed the SAPMaterial number with this parameter:

# -----------------------------------------------------------------------------	
# Drawing PartList column name for update
#
# plm.options.BOMTable.Column.INV.[CAD_COLUMN] = [SAP_FIELD]
#
# If a BOM table exists and it contains a column of the name [CAD_COLUMN]
# values within this column will be updated with the content of [SAP_FIELD]
# Implemented values (tags) for [SAP_FIELD] are
# MATERIAL - internal material number, returned in return table ET_BALLOONS, column MATERIAL
# MATERIAL_EXT - external material number, returned in return table ET_BALLOONS, column MATERIAL_EXT
# POSTEXT1 - value returned in return table ET_BALLOONS, column POSTEXT1
# POSTEXT2 - value returned in return table ET_BALLOONS, column POSTEXT2
# -----------------------------------------------------------------------------    
    plm.options.BOMTable.Column.INV.SAPMATERIAL = MATERIAL_EXT
# -----------------------------------------------------------------------------	

I have tried some values: DOCUMENT_EXT, DOCID, but they gave me nothing.

So does anybody know how the [SAP_FIELD] is called for document number?

regards, Danny

Accepted Solutions (0)

Answers (2)

Answers (2)

sdalmaso
Participant
0 Kudos

You should customize content center - of course is not so easy and it shoul be done every time you add a new item in your "custom library"..

When we installed ECTR we noticed that Content center could be an issue to manage, so we import every content center part as standard, of course is a big renounce on the TD point of view. Standard parts are read/write unless you don't release them so we can add every iproperty we like.

By the way, since this really interested me I tried with "F1" on the field in "derive BOM" window to call performance assistant.

If you are in a "try" mood you should try "DOCUMENT" or "DOKNR" but sincerly I fear it will not works..

The feature you ask for is probably the best way to reolve this issue, home some SAP insider could help!

sdalmaso
Participant
0 Kudos

Hi,

this is not exactly the answer you asked but it's a good working workaround.

If you need the DOC number in partlist on DRAWINGS (idw/dwg/pdf) you can always work on attributes-from-sap to capture the DIR field="DOCUMENTNUMBER" and store it inside a custom iproperty. When defining BOM table in your default idw template you can always map custom iproprties so you got it.

Defining the attribute transfer in attribute-from-sap is easy and you will not even need to define previously the iproperty in the template file - ECTR create it in the file if there is no match with existing. You can put it in the very template of any document since you could need the document number in every original file you will manage (otherwise it will not hurt you to have it when unneeded..).

Hope it helps

Best

Samuele

DM-kiko
Explorer
0 Kudos

Hi Samuele,

I know, I already did it for the easy parts.

But the problem is all the parts from Content Center, those files are library files (read-only) for Inventor and ECTR and cannot be altered, so there will not be an SAP_DOCID

For SAPmaterial number the same applies.

Regards, Danny