Diagram Relationship Model

[fkleinso]

Hey Guys

I am just starting using the ERP and I am working as a kind of BI analyst.

I need to extract some information from the database to make some joins later on and come up with some the results.

I already collected, from the internet, the table names and for which process they belong to.

But I need to understand how all the tables are linked, so basically the Relationship diagram would be essential to have but I could not find anywhere.

For this first moment, I basically need to identify the following fields and which tables I need to extract and which fields must be crossed to join all the information I need. Some of them I have already identified, others not. But what tables and which fields more do I need to come up with all these information in only one table?

For that, I need the Entity Diagram Relationship Model. Someone could help me with?

	Table	Field
PO type (Opex or Capex)
PO Number	F4301	PHDOCO
PO Requestor	F4301	PHORBY
PO Creation Date	F4301	PHTRDJ
PO Amount Requested	F4311	PDAEXP
Supplier Name	F0101	ABALPH
Supplier Payment Term	F0401	A6TRAP
PO Approver	F4209	HORDB
PO Approval date	F4209	HORDJ
Invoice Number in G/L	F0911	GLDOC
Invoice Amount	F0911	GLAA
Invoice Entry date in G/L	F0911	GLDICJ
Invoice Issue Date	F0411	RPDIVJ
Invoice Due date	F0411	RPDDJ
Invoice Payment Date	F0413	RMDICJ
Amount Paid	F0413	RMPAAP
Payment Approver
Processed PO's in G/L