Searching for field name and table name

[Former Member]

Hello SAP Experts,

I am searching for table name and field name for following. Please guide me.

• Transportation:     To be fetched from Commercial Invoice ( Header Text)
• Lorry Receipt No: To be fetched from Commercial Invoice ( Header Text)
• Date:                   To be fetched from Commercial Invoice ( Header Text)
• Vehicle No:          To be fetched from Commercial Invoice ( Header Text)

and

• Delivery Note No & Date: To be fetched from Outbound Delivery          

• Name & Address of Purchase: to be fetched from Sold to party
• Name & Address of Consignee: to be fetched from Ship to party
• Name of Excisable Commodity:  To be fetch from CIN detail.
• Tariff Sub‐Heading No: To be fetch from CIN detail.

• Debit Entry No: To be fetched from CIN
• Entry no:  To be fetched from CIN

Please tell me how to search field name and table name for above. Thank you in advance.

Regards,

Biraj Adeshara

[Former Member · Accepted solution]

Dear Adeshara,

if you want these filed names and table names for giving the Functional Spec to the abaper

then

The first four details of your query will get from funciton module read_text

This read_text function reads your header data text field and give the result. Please ask your abaper regarding this function Module.

For delivery details you can ref the tables

LIKP:Delivery Header Data

LIPS:Delivery Item Data

For Billing Details

VBRK:Billing header

VBRP: Item Details.

Regards

Khajahussain

[Former Member · Accepted solution]

As Khaja suggested READ_TEXT function module will fetch you header text .

Function module READ_TEXT with input parameters ID = text ID, LANGUAGE = Lang, NAME =
delivery order number (LIKP-VBELN), OBJECT = VBBK (for header texts)

Delivery Note No & Date : LIKP-VBELN and LIKP-LFDAT

Name & Address of Purchase : KNA1-NAME1 , KNA1-ADRNR

Name & Address of Consignee : KNA1-NAME1 , KNA1-ADRNR

Name of Excisable Commodity and other CIN details : : http://scn.sap.com/thread/428117

Hope this helps and have a good day !

Thanks

Rajesh

[former_member211462]

Dear Biraj Adeshara

Please check this link

http://scn.sap.com/thread/1849397

regards

JNM