• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Diagram Relationship Model

fkleinso

Member
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



 
Top