Issue in Invoice out put

[Former Member]

Dear All,

I am in process of preparing Functional Specs.

Requirement is Vendor name should print in Invoice out put. Shipment process exists. please help me in writing a logic in the specs. Vendor number will be entered in VTTK TDLNR. But my requirement is Vendor name should print in Invoice.

Regards,

Raju

[Former Member · Accepted solution]

hi

pass vendor number to KNA1 table and fetch name.

[Former Member · Accepted solution]

Hi Yadav,

Thanks for your mail.

VTTK-TDLNR = LFA1-LIFNR , Then print LFA1-NAME1. Is it correct Yadav. If its correct then where is the link between Billing doc to Shipment doc. Kindly help me in writing a complete logic.pls.

Regards,

Raju

[Former Member · Accepted solution]

hi

VTTK-TDLNR = LFA1-LIFNR , Then print LFA1-NAME1.

This is correct.

the link between Billing doc to Shipment doc, you could find that in VBFA table.

try and revert

[Former Member · Accepted solution]

Hi,

Pass the Vendor number into LIFNR field in LFA1 and execute.

Fetch the name from NAME1 field.

There is alink between the billing document and Shipment document if the billing is created with respect to Shipment one.

Goto VBRK table and paa the billing number into this table for VBELN field.

And fetch the value from "ZUONR".

Regards,

Krishna.

[former_member1249468 · Accepted solution]

Hi ,

Link between Billing document and Shipping Document : Pass the Billing Document (VBRK:VBELN) to VBFA:VBELV then pick the VBELN with VBTYP_N as 8 (Shipment).

Hope it helps.

Regards,

Sash.

[Former Member · Accepted solution]

Hi Krishna,

Thanks for your reply, But Billing will be created with ref to delivery.

Regards,

Raju

[Former Member · Accepted solution]

Hi,

I think this shipment document is created with respect to Delivery.Am I right?

If so get the number of this delivery as suggested inthe earlier post and then goto VBFA table.

Pass the same in VBELV .

Pass the Billing document number into the same table for the field VBELN.And double click on that number.Select not equal to.

Execute.

Fetch your Shipment number from the field VBELN.

Regards,

Krishna.

[Former Member]

Hi All,

Its working.. Thanks for all.

Regards,

Raju