on 05-23-2014 10:04 AM
最近在編輯報表時發現必須同時用到A/R發票和A/R訂金發票的資料，在B1內的關係地圖可以看到2張Table的關聯性，可是在資料庫中卻找不到儲存A/R發票(OINV,INV1)和A/R訂金發票(ODPI,DPI1)的關聯欄位，導致在寫SQL Procedure時沒辦法將兩張表Join起來，想請問一下各位專家，有沒有辦法找出2張Table的關聯性
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
我用的SAP B1是8.82 PL13的版本
Hi
試這個看看：
ODPI T0 INNER JOIN DPI1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T0.SlpCode = T2.SlpCode INNER JOIN ORIN T3 ON T2.SlpCode = T3.SlpCode INNER JOIN INV9 T4 ON T0.DocEntry = T4.BaseAbs INNER JOIN OINV T5 ON T4.DocEntry = T5.DocEntry INNER JOIN INV1 T6 ON T5.DocEntry = T6.DocEntry
謝謝
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.