cancel
Showing results for 
Search instead for 
Did you mean: 

Delivery process: which tables are involved

Former Member
0 Kudos
96

Hi all,

I'm trying to create a schema that show the tables (and the relative keys) that are shared from the delivery process.

ODLN and DLN1 are the principals tables. But I think there are other tables like OCRD, OCRG, ecc..

Can you help me?

Thank you very much.

View Entire Topic
edy_simon
Active Contributor
0 Kudos

Hi Irene,

If you have the SDK installed, goto :

C:\Program Files (x86)\SAP\SAP Business One SDK\Help\RefDB.chm

Look for the ODLN and DLN1.

The help file contains a 'Related' Column. this is the name of external tables it is linked to.

These are the tables linked to ODLN :

OCRD
OCRN
OJDT
OCTG
OSLP
OSHP
OCPR
OCRD
NNM1
OWHS
OFPR
OUSR
OUSR
ODRF
CSTN
OIDC
OTNN
OPYM
OPYB
OCBI
OPRJ
OAGP
OACT
OBPL
OPID
OHEM
OCRD
OCPR
OCRY
OLNG
ONFM
OHEM
OHEM
OTWS
NNM4
OCUP
OCIG

Check in the help file for the DLN1 external tables.

Regards

Edy