Skip to Content
0

Query data from SAP B1

Oct 09, 2017 at 05:56 AM

24

avatar image
Former Member

I want to query the data from the following tables:

OIGN, IGN1, ITM1

and the fields are:

OIGN (TaxDate)

IGN1 (ItemCode, Description, Quantity, UnitMsr)

ITM1 (Price)

Kindly help me to write the query with Joining.

Regards,

Rizwan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Oct 09, 2017 at 11:50 AM
0

Hi,

Try this query,

SELECT T0.[TaxDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T2.[Price] FROM OIGE T0 INNER JOIN IGE1 T1 ON T0.[DocEntry] = T1.[DocEntry] left join ITM1 T2 on T2.[ItemCode] = T1.[ItemCode]

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 09, 2017 at 01:12 PM
0

Thank you for your response. you have solved my problem. Regards

Share
10 |10000 characters needed characters left characters exceeded