topic Re: table name required in Application Development and Automation Discussions

table name required

Former Member — Thu, 25 Jun 2009 15:27:56 GMT

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

Re: table name required

Former Member — Thu, 25 Jun 2009 15:32:20 GMT

VTTK, VTTP,

Re: table name required

Former Member — Thu, 25 Jun 2009 19:15:24 GMT

you can use VBFA where VBELV eq TKNUM

VBTYP_N eq 'M'

Re: table name required

jaideepsharma — Thu, 25 Jun 2009 21:11:09 GMT

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,