CR PO Printing issue in SAP

[Former Member]

Hello Expert,

I crate Crystal report layout for  Purchase Order for that i take OPOR & POR1 Table

when i import it in SAP it will work & show the proper result but after that i create user defined Table at Purchase Order Title level Table name is @AC_Dispatch

& i enter value in that field at the time of PO

I link  OPOR .U_dispatch inner join To @AC_Dispatch.code  in crystal Report  & run the crystal report outside SAP it show result but when i import it in SAP PO Layout & then Preview then it show blank

It will work outside SAP perfectly showing field in user define table

I create key for user defined field ,my udf  is U_dispatch Alphanumeric & regular link to user defined table @AC_Dispatch

So what is the problem

[former_member209066]

Hi,

This is Sql Query Link problem Changed the Link in User Define Table for Left Outer Join.

Thanks,

Nithi

[Former Member]

Hi Jay,

i had a problem like this, a couple of things that can help:

1, create a view on top the  @AC_Dispatch with a "normal" name (create view myview as select * from [@AC_Dispatch] ), and use that in the report as a select * from myview as a command

2, for an added option add _only to the name of the command in CR

3, make sure your links in CR are all left joined, so none of the data falls out

hope this helps

Regards,

D