topic Re: table relation between (invoice - service order ) in Application Development and Automation Discussions

table relation between (invoice - service order )

Former Member — Fri, 28 Dec 2012 06:40:34 GMT

Hi Experts,

the requirement is: The billing document should be the input and the output should be Service notification .

The service notification is there in service order.

All i need is the relation between Invoice & service order .

From VIQMEL table, i can see the relation between the Service order and service notiofication. (Invoice data not available)

But How do i connect Invoice and Service order ???

Pls guide.

thanks

Re: table relation between (invoice - service order )

vinoth_aruldass — Fri, 28 Dec 2012 06:59:14 GMT

hi,

VBELN is the field name in the tables of VBAK (sales order), LIKP (delivery) and VBRK (billing).
VBFA table provides links between preceeding (sales document) and subsequent (delivery) documents.
in VBFA table a delivery can be a preceeding document to an invoice(subsequent document)

Document number can be found within the transaction table.

in the delivery : field VGBEL contain the sales order number.

in the invoice : field VGBEL contain the delivery number & field VBELV contain sales order number.

hope it helps,

Vinoth

Re: table relation between (invoice - service order )

Former Member — Fri, 28 Dec 2012 07:11:30 GMT

Hi Vinoth,

Thanks for ur reply.

But, the proceszs goes like this... service order ( IW32 ) - in service order advance shipment icon is clicked , it took me to the Debit memo req (VA02) screen ...since its debitmemo request, delivary is not created and therefore with reference to the debit memo req, the invoice is created (VF01).

Hope im clear now.

Now, in the service order, there is a field service notification.

I need to relate the Invoice , service order and the service notification.(that is , input if i give invoice number , the output should be service notification number)

Pls share your valueable ideas and sugggesions for this..

Thanks.

Re: table relation between (invoice - service order )

Former Member — Fri, 28 Dec 2012 10:06:55 GMT

Hi Saravanan,

Link between service order (VIQMEL-AUFNR) and debit memo request should be found via VBAK-AUFNR (head) and VBAP-AUFNR (item).

The invoice could be found via VBRK-AUFNR (head) and VBRP-AUFNR (item).

Regards Hendrik

Re: table relation between (invoice - service order )

Former Member — Fri, 28 Dec 2012 11:02:45 GMT

Thanks Vindoth & Hendrik.