table name required

[Former Member]

Hi all,

Can u give the table names to get invoice receipt number from shipment number. Invoice receipt number field is BELNR and shipment number field is TKNUM.

Thanks in advance

[Former Member]

VTTK, VTTP,

[Former Member]

you can use VBFA where VBELV eq TKNUM

VBTYP_N eq 'M'

[jaideepsharma]

Hi,

Please clarify whether it is a SD invoice or FI invoice or MM invoice document. Normally for SD invoice document number field is VBELN in table VBRK and not BELNR. BELNR is for MM or FI Invoices.

Accordingly, we can let you know the tables to find the invoices from shipment.

KR Jaideep,