Skip to Content
author's profile photo Former Member
0
Former Member

A question on creating more than 500 fields In Transparent table

Posted on Mar 27, 2009 at 08:40 AM 13 Views

Hi,

I had an requirement for creation of more than 500 fields in a customized Z table. So kindly request the experts to suggest that is it suggestible to create these fields in 1 table by taking primary and secondary indexes when considered to be in performance.

Your answer is well appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Thomas Zloch
    Thomas Zloch
    Posted on Mar 27, 2009 at 09:05 AM
    0

    Look at the section "constraints" here:

    http://help.sap.com/saphelp_erp60_sp/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

    You might run into problems with such a huge table definition. Is it possible that you're projecting data in columns that should actually be reflected in rows by introducing additional key fields?

    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2009 at 10:17 AM
    0

    Hi,

    you may go for an account based data model instead of your key figured data model .

    Gives an example for the projection Thomas mentioned.

    Example:

    -

    key figured data model (Yours)

    field1 field2 keyfig1 keyfig2 keyfig3...
------------------------------------------------------
AA    BB      100      50         0.1
...

    account based data model (defined by account_type field) 

    account_type   field1    field2     field_value
--------------------------------------------
'tkeyfig1'          AA    BB     100
'tkeyfig2'          AA     BB     50
'tkeyfig3'          AA    BB      0.1
...

    i.e. incomestatement figures can be expressed in an account based model because of the

    great number of subitems you can have. Furthermore, it's easy to extend (creating another account type and there you go...)

    Search for these terms on SDN ...

    bye

    yk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.