Skip to Content
avatar image
Former Member

Query data from SAP B1

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 09, 2017 at 11:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2017 at 01:12 PM

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

    Add comment
    10|10000 characters needed characters exceeded