Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi ALL,

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

THANKS,

RAMA.

6 REPLIES 6

LucianoBentiveg
Active Contributor
0 Kudos

I think that this relation table dosen't exist.

Regards.

suresh_datti
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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