on 09-05-2005 10:23 AM
Hi gurus
i am looking for the field ETDAT (Delivered on). i went to the VA03 and took the technical details of particular field. <b>Structure RV45A</b> and <b>Field name ETDAT</b>. its easy to find the name of the field if its coming from the table name..but wondering how to locate the field if its showing the name of the structure, in which table i can find this field. i need help.Thanks
Regards
Kanth.
Hi,
Use where used concept from SE11.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
i went to se11 and entered the name of the structure , selected the etdat field and clicked on where used list. i got a pop with lots of selections like programs,classes/interfaces, screens etc. i checked database tables and table types, when i executed i got the msg saying structure rv45a not found in selected search area.
Regards
Kanth
Hi anil
thanks for your answer its useful.i will explain my scenario. i want dispatch date to be extracted in BW. i want to see the <b>table</b> from which this field <b>delivered date</b> is getting the data. when i went to the technical details its showing me the name of the structure.
i want the name of the table.
Regards
Kanth.
Hi,
Sorry, I thought that you were searching in R/3 side. What is the information do you want to extract to BW Side. i.e for which data extraction you have been given the techincal details.
There is no link or procedure which holds information about the linkage between r/3 tables and BW fields at a single place. You come to know by experience one by one.
With rgds,
Anil Kumar Sharma .P
Hi Roberto
now its very clear for me. in VCITM (LFDAT corresponds to Delivery date 0SHIP_date in BW. so, i should take 0ship_date as a deliver date? Roberto can u please tell me how can we know tat ETDAT that is populated runtime during the transaction) is the delivery date LFDAT in the application tables... because i have lot of ztransaction involved in R/3, in which technical names are given in structure name and field name. thanks
Regards
Kanth
Hi
This is Ale
My request is to find all customized reports which contain this field. RV45A-ETDAT . I found it is saved in VBAK table, the field is VDATU (Requested Delivery date)
I entered into SE11 using the "where used" option but I also watched table TSTC for Z* and Y* tcodes. And i cannot find any pogram related to the tcodes and in the where used list for this field.
can you please help me out on how to find this relationship?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kanth,
You can go in LIKP, LFDAT field...(with the name of your order number...)
Hope it helps!
Bye,
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.