I seek SAP expert advise on how to create raw data table ?

[admin11]

HI all

Now my company just implement SAP.

We have PO Table as below :-

PO_Date…..PO_No……COY….AMT

1/10/22………….1…..ABC…10

1/10/22………….2…..ABC…20

1/10/22………….3…..ABC…30

We have Sales Order Table as below :-

SO_Date….SO._No……COY….AMT

1……1/10/22………….1…..ABC…10

2……1/10/22………….2…..ABC…20

3……1/10/22………….3…..ABC…30

We have Sales Invoice Table as below :-

SI_Date…..SI_No……COY….AMT

1……1/10/22………….1…..ABC…10

2……1/10/22………….2…..ABC…20

3……1/10/22………….3…..ABC…30

It there a better way to generate the raw data , which will be more effective for data analysis?

Paul

[v-jayw-msft]

Hi @admin11 ,

What do you mean create raw data table? Load data to Power BI?

Please take a look at the topic about How-to-Get-Your-Question-Answered-Quickly .

Best Regards,

Jay

[admin11]

Hi All

By the way PO and Sales Order are link back to back . And sales order and sales invoice are link back to back. 
hope some one can share what field I need in order to see the linkage ?

Paul