Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rahulhv1
New Contributor III

How to selecte fields from table


We are using SAP Tables (Oracle 11i) for different charts/reports. One thing we wish to understand, whether to select all fields from the table or select minimum requried fields and in due course of time select additional fields whenerever required. As per our understanding we should select only required fields and there after if require, we may select additional required fields.

4 Replies
MVP
MVP

Re: How to selecte fields from table

As per our understanding we should select only required fields and there after if require, we may select additional required fields.

Your understanding is right.

Not applicable

Re: How to selecte fields from table

Hi Rahul,

In SAP Tables have many fields in single table so if u select all fields it's take more time.

so we select only our requirement fields.

Not applicable

Re: How to selecte fields from table

Hi Rahul,

I use the ScriptBuilder to generate my SAP conector querys.

This is an example of what you get with it. I added an alias and also a where clause:

[BSEG]:   // Accounting Document Segment

Load

  BUKRS as BUKRS_BSEG,

  [BELNR] as [DocumentNo_BELNR.BSEG],

  [GJAHR] as [Fiscal Yr_GJAHR.BSEG],

  [LIFNR] as [Vendor_LIFNR.BSEG]

  ;

SQL Select BELNR BUKRS GJAHR LIFNR from BSEG

where (BUKRS like '0140') or (BUKRS like '0014')

;

STORE * FROM [BSEG] INTO .\BSEG.QVD;

DROP TABLE [BSEG];

Not applicable

Re: How to selecte fields from table

Hi Rahul,

we also use the ScriptBuilder and generate the script with all possible fields. But all the fields not needed at the moment will be commented, so just a few will be loaded.

Advantage: If you need an additional field you just can uncomment the field.

Community Browser