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

What is the meaning of these 3 sentences? Please see...

Hello all,

What is the meaning of the sentences 2) to 4)???

Database tables PAnnnn and PBnnnn are transparent, which means that:

1)Each infotype has its own database.

2)Each infotype has an individual length, so that you are not required to keep additional space on the database.

3)Information can be found more quickly (using an index search).

4)Infotypes can be evaluated using any SQL tools.

Please explain with examples if possible,

Thanks,

Charles.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 07:40 AM

    hi,

    1. each infotype has its own data base is nothing but it has got it's own standard table.

    like 0000 it has pa0001' 0002 has pa0002 table etc.

    2. the lengths are specified ealier for each infotype and you need not make changes or if length is not restricted then you need to have a very long fields which consume huge data storage.

    3,when you go for search whether it is a structure search of any orther search you will find an index search at the bottom of the search screen from which the information can be found more easily.

    4. as SAP uses ORacle data base mainly you can retreive the data by SQL.

    regards

    nalla

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 02:54 PM

    To add a little historical sense to these statements, prior to release 3.0, all of the PA* tables used to be part of the PREL table so if an infotype took 500 bytes or 2000 bytes, they would all take the same amount of space in the database. Obviously by splitting out the tables, we were then allowed to have indexes on specific infotypes which we were not allowed to have prior to 3.0 because of the structure of the PREL table.

    Edited by: Nathan Smith on Jun 16, 2008 4:55 PM

    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.