How to selecte fields from table

[rahulhv1]

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.

[tresesco]

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.

[#3]

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.

[#4]

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];

[#5]

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.