what is the relation table field spool request number & invoice number

[Former Member]

Hi ALL,

what is the relation table field spool request number & invoice number

THANKS,

RAMA.

[LucianoBentiveg]

I think that this relation table dosen't exist.

Regards.

[suresh_datti]

don't know if there is direct elarion between an invoice number & spool id.. but you can check hte entries in the table TSP01..

Regards,

Suresh Datti

[former_member181962]

Hi Ram,

There is no relation between the spool request and invoice document.

If you generate a submit a report in background, then it creates a spool number auomatically.

You can get the spool number from the system field sy-SPONO

Regards,

Ravi

[Former Member]

Spool request no is a number that identifies a spool request in the SAP spool system. The spool request numbers are not assigned sequentially. Instead, the spool system assigns a unique ID number (up to ten places) to each spool request. Using these numbers print outs can be taken for documents at any time.

Where as an invoice no is a unique no which identifies a particular product has been billed by a vendor to a customer. i.e, sales invoice.

Hope this would information is useful.

Please reward points for good answers.

Lakshminarayanan

[former_member188685]

Hi Ram,

there is no Relation at all..

in your case when ever invoice created you need to store the data like spool number,invoice number,user name etc..into a ZTable, and then when ever you enter the invoice select the data from the ZTABLE and convert the spool to PDF and show it.

and also please refer your thread , don't make Duplicate threads...

Regards

vijay

[Former Member]

Hi RAMA,

To calculate the number of spool enter the invoice number in the table NAST, in OBJKY. Copy a number from the field CMFPNR and enter this in the table CMFP. Enter the value in the NR. In the field MSGV1 you will find the number of spool.

Regards,

Claudio