Want shipping Point address(not Number) in the invoice layout

[Former Member]

Dear Experts

Please tell me tables and fields how get the shipping point address in invoice layout, if i give likp-vstel, it picks the shipping point number only,

issue resolution is very urgent

Thanks and regards

Janardhan

[Former Member]

Closed

[Former Member]

Hi janardhan,

i am also working on the same type of requirement. here i am giving the details. i think it will helpful to u..

Sold to: VBRK_KUNAG

Ship To: VBPA-KUNNR where VBPA-PARVW=”SH”

Invoice No: VBRK-VBELN

Name OF Finished Product

Material Code: VBRP-MATNR

Cases : VBRP-VRKME where MVKE-VRKME=”CSE”

Pallets : VBRP-VRKME where MVKE-VRKME=”PAL”

Price per case in Unit of measure: KONV-KBETR

Price in Unit of measure: RV61A-AWEIN

Net weight : VBRP-NTGEW

frieght without VAT: VBRP-NETWR + VBKD-INCO1

Vat 20%: 20% of KONV-KBETR where KONV-KSCHL=”ZVAT”

total with VAT: VBRP-NETWR (VBRP-NETWR + VBKD-INCO1) + VBRP-MWSBK where KONV-KSCHL=”ZVAT”

Only VAT : KONV-KBETR where KONV-KSCHL=”ZVAT”

Ammount in words ( if value is 10rs, that should be come in ten repees only): VBRP-BRTWR

1. My Client requires the company code address ( Name , city, pincode, phone number, etc) and his bank details in the layout

VBRK-BUKRS – Com. Code

ADRC-NAME1—Name

ADRC-STREET—Street

ADRC-CITY1 --- City

ADRC-COUNTRY – Country

ADRC-REGION—Region

ADRC-POST_CODE1- Postal code

ADRC-TEL_NUMBER – Telephone number

2.He requires the customer Address like name , street, house number, pincode, phone number, and fax number)

KNA1-NAME1 -

---

Name

KNA1-STRAS --- Street and house number

KNA1-ORT01 --- City

KNA1-REGIO --- State

KNA1-PSTLZ -

---

Pin code

KNA1-LAND1 --- Country Key

KNA1-TELF1 -- Telephone number

KNA1-TELFX --- Fax number

3. Total without VAT: VBRP-NETWR

4. Freight without VAT : VBRP-NETWR + VBKD-INCO1

5. Shipping Point Address has to come to layout

ADDR1_DATA-NAME1 --- Shipping point name

ADDR1_DATA-STREET --- Street

ADDR1_DATA—HOUSUE_NUM1—house number

ADDR1_DATA-CITY1 --- City

ADDR1_DATA-REGION --- State

ADDR1_DATA—POST_CODE1—postal code

ADDR1_DATA—COUNTRY-- Country

6. Plant Address address has to come to layout

VBRP-WERKS -- Plant

VBRP-WKREG—Region

VBRP-WKCTY -- City

VBRP-WKCOU -- Country

these r the fields needs to be taken based on the requirement..

Reward if helpfull.

Regards,

Praveen kumar.D

[Former Member]

Hi janarthan,

Yesterduy i posted which is u required (Shipping point address) for invoice layout. Please check it.

Reward points pls.

Regards,

Govind.