Skip to Content
avatar image
Former Member

query from 2 screens

Hi,

How do we get data from 2 screens like Goods receipt and landed cost in a single query.

Rgds,

Rajeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 13, 2008 at 07:40 AM
    Select * FROM PDN1 T0
    
    Select * FROM IPF1 T0
    
    Select * From PDN1 T0 Where T0.TargetType <> 18

    Jeyakanthan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You can try something like:

      Select * From PDN1 T0 Left Join IPF1 T1 ON T1.BaseEntry
      = T0.DocEntry
      

      You can choose any fields you like from two tables for the query.

      If you need header table as well, it can be done through Inner Join for OPDN and Left Join for OIPF.

      Thanks,

      Gordon

  • avatar image
    Former Member
    Oct 11, 2008 at 05:20 PM

    Hi Rajeev,

    It dosen't matter how many screens you got. As long as they have relationship, they will be lined by different tables.

    In you case, landed cost has OIPF and IPF1. Goods Receipt PO has OPDN and PDN1. All links happend on the row level, i.e. between IPF1 and PDN1.

    You can get the table reference from SDK help REFDB.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gordon,

      Thanks for your reply.

      Since i am not good in queries, can you send me a sample query which gives the row details for goods receipts and landed costs , also the same query should give row details which have only goods receipt and not landed cost.

      Rgds,

      Rajeev