How to find out the table storing the Forwarding Order Notes?

[former_member713810]

Hello,

I am trying to find out the table in which the texts recorded in the Notes Text Box within the Forwarding Orders General Data tab, are stored. My unsuccessful approach so far has been to navigate the BOPF using the BOBX transaction.

How can I resolve this issue?

Thanks and best regards.

[philippbergthaler · Accepted solution]

Hi Juan,

check table /BOBF/D_TXCCON.

You can get there from the TRQ Root via asssociations.

TRQ Root --> Assoc: Textcollection --> Assoc: Text --> Assoc: Text_Content

Best regards

Philipp

[01a02b03c]

Hi Juan,

Hopefully this will help you:

BR,

Rene

[former_member713810]

Very useful. Thanks a lot Rene.

[former_member713810]

Many thanks Philipp.

I have tried to join /BOBF/D_TXCCON to /SCMTMS/D_TORROT but so far no ID worked. Do you know which fields or intermediate tables, if any, should I use?

Thanks and best regards.

[philippbergthaler]

Hi Juan,

if this is for a development you really should use BOPF associations instead of table joins.

Check the TM Enhancement Guide for further information.

In case table joins are your only option try to start with /SCMTMS/D_TRQROT, this will contain the FWO root data.

1. /SCMTMS/D_TRQROT-DB_KEY = /BOBF/D_TXCROOT-HOST_KEY
2. /BOBF/D_TXCROOT-DB_KEY = /BOBF/D_TXCTXT-PARENT_KEY
3. /BOBF/D_TXCTXT-DB_KEY = /BOBF/D_TXCCON-PARENT_KEY

BR

Philipp

[former_member713810]

Great piece of information and guide. Many thanks Philipp.