How to find from which table we r fetching the data

10-11  Source: Network gathering  Views:0 

Advertisement
Hi friends,
i got a requirement to design a query,in my transfer rules i check the info object related to the fiels.but in my crm the field name is different.
how to find from which table the field is fetched........
please tell me........
Regards
sridath
Dear Sridath,
In ST05 switch on the SQL Trace.
Goto RSA3.
Give your DataSource name > Execute
Goto ST05...Switch OFF the Trace
Analyze the Trace file
Gives you details about the fields and Tables from where you are fetching.
OR
Goto LBWE
Find your DataSource > Maintenance > Display mode
In right side window...expand ALL list box...
Exclude MC and take other words...they are the Source Tables.
Regards,
Ramkumar.
Related articles
  • How to find from which table we r fetching the data 10-11

    Hi friends, i got a requirement to design a query,in my transfer rules i check the info object related to the fiels.but in my crm the field name is different. how to find from which table the field is fetched........ please tell me........ Regards sr

  • How to find from which table we got the data 10-11

    Hi friends , How can we find from which table we r getting data in the datasource. I am getting data from crm system.based on that we created cubes and dsos. we have only one datasource.now i need to know from which table we pull the data? can any on

  • From which table i can get the details of cancled documents 10-11

    Hi All, here is an quarry, Iam haveing an Z report on purchase tax which has all tax report. but now the user want to same details for cancled document also.So can any help me from which table i can fetch the data urgent ! pls help me out! Regards, R

  • How to check from which table data is picking by datasource 0CDCY_ACT_ATTR 10-11

    Hi Experts, Could you please help me in finding out of the table from which datasource 0CDCY_ACT_ATTR is extracting. As per my knowledge is should be extract from tables(infotypes) HRP5135 - 5141.If i am wrong please correct me. Issue : My extractor(

  • How to find out which table store historical data for V_T001B? 10-11

    dear all, how i want to trace and find out which table that store all maintenance data history from V_T001B? thanks.i already find out into both table... but the data not store there...Read other 4 answers

  • From which table we can get the Role of the User in SRM 10-11

    Hi  All,     I need to prepare a report which displays the user and his role in srm. So from which table i can get  the role of the user if i have the Userid. Thanks Channappa SajjanarHi t- code SUIM->rOLES->BY USER ASSIGNMENT SELECT WITHASSIGNMENT

  • From which table can we get the status of sales order 10-11

    hi from which table can we get the status of sales orderHi Check the Table <b>VBUK for HEADER level status</b> of Sales order and <b>VBUP for Item level statuses</b> enter VBELN  = Sales order and VBTYP = C for sales orders as VBUK

  • How to Find out the from which table we can get the following fields? 10-11

    The following fields are from invoice data How to  know or from which table we get the following fields: Header Details: Manifest:, Finance Control #:, Alternate SID:, Carrier:, Container/Trailer #:, Hazmat Code:, Harmonizing Code, Freight Forwarder,

  • ADF table: How to find out which rows were modified by the user 10-11

    Hi, I am using ADF table to display data that can be modified by the user (ReadOnly = false in the input text). I need to find out which rows were modified by the user, and only update (persist) those rows in the database. Is there an easy way to fin

  • How to find out which Tables have been accessed without looking at the SQL query ? 10-11

    Hi, I would like to know is there a way to find out what queries have been executed and on which tables without looking at the SQL query. I have an old C++ code which calls some library functions to access the Oracle database. The source code for the

  • From which table i can get the long text 10-11

    Hi All I have created some long text through function module CREATE_TEXT And i am able to see the text in the transaction . My requirement is from which table i can get these stored long text??? Any suggestions please. ThanksAppreciate your answers.

  • How to find out which table/column is causing an error 10-11

    Oracle database 10gR1. Whiling running a process in a commercial software, I got an error "ORA-01858 A non-numeric character was found where a numeric was expected". Are there anyway I can check the log file in the database to find out exactly w

  • How to find to which table the net payment is posted.... 10-11

    Hi all i am making payment to a vendor for 3 different invoices in a single payment run (F-58) with cash discount.Now i could like to know that in which tabe the net amount for the all the 3 invoices  were posted . eg: Invoice No         Amt         

  • How to find out which jobs are connected to the user 10-11

    Hello, i have a question, but i was unable to find the answer. The problem is that our internal consultant left the company, and there are certain jobs that run under his account. We want now to switch this jobs to other accounts. The problem we are

  • From which table do i fetch cost center???? 10-11

    Hi.. i have material and plant as selection screen parameters.. CSKS table has plant and cost center.. but when i checked the contents of the table...there is no value for plant.. so plz suggest me smeother table wherein i can fetch cost center detai

  • Which table in SRM give the date of confirmations and invoices done in R/3 10-11

    Hi all, I'm loocking on SRM to find a table (or smthg else) which is updated when a PO has a confirmation or an invoice MADE IN R/3. I'm sure it's existing as in the web we can see in the document history, but I can't find a table in SRM that can tel

  • How to insert row in table control and save the data in tables 10-11

    Hi, I have one table control i am displaying data into table control , my problem is : i want to display data into read mode in table control. but when i click on insert button on the same screen i want one blank line should inserted into table contr

  • ON WHICH TABLE WE WILL GET THE DATA 10-11

    HI I WANT TO KNOW ON WHICH TABLE WE GET THE  INFORMATON OF LOANS AND ADVANCES AND WHAT INFORMATION I HAVE TO GIVE A ABAPER SO THAT HE WILL PREPARE A REPORT ON SUNDRY ADVANCES  AND DEPOSITS ITS URGENT THANHS IN ADVANCEHi Santosh, I am not sure whether

  • How to map from one table to another dependable on data from lookup? 10-11

    I'm new in warehouse builder and i wonder how to do something what is very easily done by sql.. I want to map data from table_a to table_b, but not all rows - only those for which one of attributes in table_a have reference in table_c (is not null)..

  • How to update a Z-table in ECC for the data coming from CRM 10-11

    Hi Experts, I need to store the industry code and description from customer master from CRM into a Z-table in ECC.I have checked the BDOC segments is already there in CRM.This Z-table has to be updated each time when the user save the customer master