table relation between (invoice - service order )

[Former Member]

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

[Former Member]

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

[vinoth_aruldass]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks Vindoth & Hendrik.