cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding to the INVOICE LAYOUT Fileds and tables (URGENT)

Former Member
0 Kudos

Dear experts,

I am working for one top most FMCG client as a SD Consultant.

Needs Clarification on below mentioned things

Clent requires the fallowing fields in Invoice Output like

Sell From

Sell to

Ship From

Ship To

No

Name OF Finished Product

Material Code

Cases

Pallets

Price per case in Unit of measure

Price in Unit of measure

weight with

weight without

frieght without VAT

Vat 20%

total with VAT

Only VAT

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

Dear friends i want the table and field names for the above mentioned discriptions and let me know the data fetching logic .

If any body developed this kind of layout plse send me the funtional specification and your contact numbers for my further communication

Thanks & regards

Janardhan

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Close

Former Member
0 Kudos

Hi Janarthan,

Please find the updated field mapping which is you required as follows.

1.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

Customer bank name and address and account number

KNBK-BANKL – Bank key

KNBK-BANKN -- Bank acc. number

3. Weight with pallets: VBRP-BTGEW + VBRP-VRKME where MVKE-VRKME=”PAL”

Weight without pallets in formation: VBRP-BTGEW

4. Total without VAT: VBRP-NETWR

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

6. 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

7. Plant Address address has to come to layout

VBRP-WERKS -- Plant

VBRP-WKREG—Region

VBRP-WKCTY -- City

VBRP-WKCOU -- Country

Reward points pls.

Regards,

Govind,.

Former Member
0 Kudos

Hi Janarthan,

Pls find the following mapping for invoice output which is you required.

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

If u have queries, Pls mail to govind.adi@gmail.com

Reward points pls.

Regards,

Govind.

Former Member
0 Kudos

Dear Experts,

done send me the links

why because, i want to under stand the logic, for eg.

sell to information comes frm where

weight with and weight without fields comes from where

Price information and VAT information comes from which table and which field like that i want. specifically i want to say for all SD experts is i want to the logical information

dont misunderstanding me, i am new to this layout developments, if you have any kind f layout functional specs please forward to my mail id

mjr_raju@yahoo.co.in

thanks & regards'

Janardhan

Former Member
0 Kudos

Go to those Particular fields u mentioned, press F1, another screen will pop up, there click on Technical Info Tab, it will give you the Field name & Transparent Table, you can also double click on the field name and it will you data type, lenght etc details also.

Reward points if it helps,

Regards,

N

Message was edited by:

Nitesh Nagpal

0 Kudos