Select data from a table and a view: field with same content and different type

10-11  Source: Network gathering  Views:0 

Advertisement
hi all,
I need data from a table hrp1001 and a view V_USR_NAME. What they have in common are the content of the fields SOBID and BNAME .
It will be easier if those fields add a same type but they dont.
Any suggestions for a workaround?
Thanks
Hi Ramesh,
Specify the date format as YYYYMMDD in where condition.
Dates are internally stored in SAP as YYYYMMDD only.
Change your date format in WHERE condition as follows.
data itab like equk occurs 0 with header line.
select * from equk into table itab where werks = 'C001'
and bdatu = <b>'99991231'.</b>
I doubt check your data base table EQUK on this date for the existince of data.
Otherwise, just change the conidition on BDATU like below to see all entries prior to this date.
data itab like equk occurs 0 with header line.
select * from equk into table itab where werks = 'C001'
and <b> bdatu <= '99991231'.</b>
Thanks,
Vinay
Thanks,
Vinay
Related articles
  • Select data from a table and a view: field with same content and different type 10-11

    hi all, I need data from a table hrp1001 and a view V_USR_NAME. What they have in common are the content of the fields SOBID and BNAME . It will be easier if those fields add a same type but they dont. Any suggestions for a workaround? ThanksHi Rames

  • Error while selecting date from external table 10-11

    Hello all, I am getting the follwing error while selecting data from external table. Any idea why? SQL> CREATE TABLE SE2_EXT (SE_REF_NO VARCHAR2(255),   2        SE_CUST_ID NUMBER(38),   3        SE_TRAN_AMT_LCY FLOAT(126),   4        SE_REVERSAL_MAR

  • How to select data from a table using a date field in the where condition? 10-11

    How to select data from a table using a date field in the where condition? For eg: data itab like equk occurs 0 with header line. select * from equk into table itab where werks = 'C001'                                                   and bdatu = '3

  • How to select data from a table by passing document number from another tab 10-11

    How to select data from a table by passing document number from another table. for eg:- I want to display name, adres, region from ADRC table by using field delivery document number Kind Regards, Shanbagavalli.SHi Shanbagavalli, There are multiple so

  • Select data from two tables...! 10-11

    HI Experts...! i m a beginner user and i want to select data from two tables proj and prps.....using joins.....and internal tables i have written a code... SELECT prps~pspnr        prps~objnr        prps~psphi        proj~ernam        proj~erdat     

  • Selecting data from two tables 11-30

    I am trying to select data from two tables.  The only problem that I am running into, is that i am only seeing results from my 'uploads' table.  there is also a record in documents where user = 1 that should show up.  here is my sql: $userIDNum = 1;

  • How to select data from cluster table 11-30

    hi experts,                I have a report which picks data from bseg (cluster table ) for a month report it is taking around 4 minutes to process.I feel it is not good when take the report after some months. how to select data from these table???how

  • Selecting data from external table 10-11

    Hi there I was wondering if somebody could assist me. When I try to select data from an external table, no data is displayed, and in my log file I receive the following error: KUP-04026: field too long for datatype. Please find attached my external t

  • Select data from database tables with high performance 11-30

    hi all, how to select data from different database tables with high performance. im using for all entries instead of inner joins, even though burden on data base tables is going very high ( 90 % in se30) hw to increase the performance. kindly, reply.

  • How Select data from four tables 11-30

    Hi Sdners, How select data from four or more tables please give me any suggestion. iam learner please help me Advance wishes sreenu Moderator Message: I've already locked 2 threads of yours. Please read the Rules of Engagement of this forum and abide

  • Selecting data from a table which has a LONG column 10-11

    hi all, In the table user_views there is a LONG column. Now i want to select rows from that table based on this LONG column. like.... select *from user_views where text like '%account%; but i am getting the error.."ORA-00932: Inconsistent datatypes:E

  • DB connectivi​ty toolkit: syntax error in a SELECT data from joined tables 11-30

    Hello everyone I'm trying to put in labview an SQL query on joined tables. As example I take a DB for storing the data of 2on2 basketball games, whose tables are matches(matchId,teamA,teamB) teams(teamId,PlayerAname,PlayerBname,Nationality) nationali

  • Select Data from BSIS table taking too long 10-11

    Hi I have to develop a report to give the  details of Extended Withholding Tax (EWT)  for a list of Expenses GL. Each expense GL is  linked to another Gl which is the EWT Tax GL Account. This is maintained in a Ztable. I havae wirtten the following c

  • # coming when I select data from oracle table using Native SQL 11-30

    Hi Gurus, I am selecting 'First name' from oracle table directly using native sql. I am fetching 65000 records but 10+ records having '#' at the end of firstname. For eg: John#. But oracle team couldn't find '#' in their table for those records. What

  • Problem while selecting data from external tables 10-11

    Hi All, I am facing a problem with external tabels. I have created an external table create table ext_org_table ( id varchar2(10) , name varchar2(100) ,id_parent varchar2(10) ,name_parent varchar2(100)) organization external ( type oracle_loader defa

  • Selecting data from single table with different condition in single query 10-11

    Hi everybody... I have one table with col1, col2, col3, col4, col5... as columns. I want to select col1, col2, col3 with condition (x=y and a=b and c=d) I want to select col4, col5 with condition (x=y and a=b and m=n ) in single query... Thanx for ur

  • How do you Select data from two tables with similar data amd merge the output together. 10-11

    I have two Tables containing Sales Data. I want to read the Table a sort by date and accumulate dollars by order date. Then I want to read the second table and accumulate these dollar amounts by date and then merge the records together so that I gave

  • Need SQL help in select data from 2 table.. 11-30

    hi, i need some help here as i am new to sql statement I have 3 tables. Table1 :- TeamID, Team_Name, Team_Logo Table2:- TeamID, PlayerID Table3:- PlayerID, Player_Name How do i do a single select statement that select all information from table1 and

  • ADF Faces - Select data from a table row 10-11

    Hi! I have to build a Select One table but I'd like to use instead the combination: radio button (to select) command button (to submint), only a command button placed in each row wich make both action with a single click. Is it possible? How? Thanks!

  • Selecting data from a table using Execute Immediate in 9i 10-11

    Hi, I was wondering how I would be able to do a SELECT on a table using EXECUTE IMMEDIATE. When I tried it (with the proc below), I got the following below. Can anyone tell me what I am doing wrong? Using Scott/Tiger I tried this: SQL> ed Wrote file