Outstanding Pre AP

[Former Member]

Dear Expert..

Is there any report in SAP B one for outstanding Pre Ap (GRPO not yet become PI)

base on certain date? or maybe anyone could help me with query for this..

Regards,

Dani

[former_member186095 · Accepted solution]

Hi,

Yes, you can use open item list report. Ada di module inventory.

You can check there and see if it is helpful, you can avoid to use query

Good luck

Rgds,

Jimm

[Former Member]

Thank you for the response..

  Mr. Unnikrishnan Balan, Thank for query, but i need amount, and only for inventory item only..

Thank.

Dani

[former_member212181]

Hi Dani,

Please try below query

SELECT T0.DocNum , T0.DocDate, T0.DocDueDate, T0.CardCode, T2.CardName

  , T1.ItemCode, T3.ItemName, T1.Quantity, T1.Price, (T1.Quantity*T1.Price)[LineTotal],  T1.OpenQty, (T1.OpenQty*T1.Price)[Open Item Total]

FROM OPDN T0

  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry

  INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode

  Inner Join OITM T3 on T1.ItemCode = T3.ItemCode and T3.InvntItem = 'Y'

WHERE T0.DocStatus ='O'

  and T1.LineStatus = 'O'

  and  T0.DocDate >= [%0]

  and T0.DocDate <= [%1]

Thanks

Unnikrishnan

[former_member212181]

Hi Dani,

Please try below Query,

SELECT T0.DocNum , T0.DocDate, T0.DocDueDate, T0.CardCode, T2.CardName

  , T1.ItemCode, T1.Dscription, T1.Quantity, T1.OpenQty

FROM OPDN T0

  INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry

  INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode

WHERE T0.DocStatus ='O'

  and T1.LineStatus = 'O'

  and  T0.DocDate >= [%0]

  and T0.DocDate <= [%1]

Thanks

Unnikrishnan