on 08-25-2007 10:58 AM
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
Close
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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-NAME1Name
ADRC-STREETStreet
ADRC-CITY1 --- City
ADRC-COUNTRY Country
ADRC-REGIONRegion
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_DATAHOUSUE_NUM1house number
ADDR1_DATA-CITY1 --- City
ADDR1_DATA-REGION --- State
ADDR1_DATAPOST_CODE1postal code
ADDR1_DATACOUNTRY-- Country
7. Plant Address address has to come to layout
VBRP-WERKS -- Plant
VBRP-WKREGRegion
VBRP-WKCTY -- City
VBRP-WKCOU -- Country
Reward points pls.
Regards,
Govind,.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
see this link
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.