Required help to the proforma invoice layout

[Former Member]

Dear Experts

My client requires the following things in the proforma invoice

1.Seller address and VAT number

2.Truck No

3. Pallet No

4.Place of Loading (Ship From)

5.Commodity code number

6.Quantity in Pallets

7.quantity in cases/bandles

8.Price in EURO for Cases/Bandles

9. country of origin

10. Seller reference, ex: PO no

11.Proforma Invoice number

12. Proforma Invoice date

13. total Value

14. Freight Value.

Please give me the tables and fields from where to invoice data is flowing

Issue is very urgent

Please help me on this

Thanks & Regards

Janardhan

[Former Member]

Closed

[Former Member]

Hi Janarthan,

Plase go through the following field mapping which is you required.

1.Seller address: With the help of ABAPer, You can extract address data from ADRC table.

VBRK-STCEG OR KNA1-STCEG --VAT number

2.Truck No: VTTK-SIGNI

3. Pallet No:

4.Place of Loading (Ship From): LIPS-LSTEL

5.Commodity code number

6.Quantity in Pallets

VBRP-FKIMG – Qty

VBRP-VRKME—UoM (MVKE-VRKME=”PAL”)

7.quantity in cases/bandles:

VBRP-FKIMG --- Qty.

VBRP-VRKME --- unit of measure (MVKE-VRKME=”CSE”)

8.Price /currency(EURO)/UoM (Cases/Bandles):

KOMV-KBETR / RV61A-AWEIN (currency, sale unit)

9. Country of origin: ADRC-COUNTRY

10. Seller reference, ex: PO no: VBKD-BSTKD

11.Proforma Invoice number: VBRK-VBELN

12. Proforma Invoice date: VBRK-ERDAT

13. total Value: VBRK-NETWR

14. Frieght Value: KOMV-KBETR where KONV-KSCHL=”FB00”

Reward points pls.

Regards,

Govind.

[Former Member]

Hi ,

Use the transaction SE16 and table ZMDEMAIN and give the material number .

Than you can find the all the details.

Reward if it helpful

Regards,

P.Srinivasa Reddy