Query Generator SAP B1

[former_member106913]

Hi,

We are using prefixes in numbering series while generating sales and purchasing documents, while I try to use the query generator to get some reports, how can I combine prefixes with a purchase order number???

[Johan_H]

Hi,

You need the NNM1 table.

Regards,

Johan

[former_member106913]

SELECT T0.[DocNum], T0.[CANCELED], T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal] FROM OPOR T0 INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry]

Please suggest how to combine it in the above query...

Regards