Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

5 Comments

  1. Cluster tables

    • In cluster table the records having the same key are stored in a single key in the cluster. One consequence:
    • DATA l_sdata TYPE EDI_SDATA.
    • SELECT SINGLE sdata
      INTO l_sdata
      FROM edid4
      WHERE docnum = i_edidc-docnum
        AND counter = '000'
        AND segnum = i_edidc-countr
        AND segnam =  SPAN
      Unknown macro: { font-family}
      .L0S33
      Unknown macro: { color}
      'E1EDL24'.
    • If there is an overflow of the data records a continuation record is created with the same table key, the code will trigger a runtime error DBIF_RSQL_INVALID_RSQL / Exception CX_SY_OPEN_SQL_DB. I used this work around
    •   SPAN
      Unknown macro: { font-family}
      .L0S32
      Unknown macro: { color}
      .L0S52
      Unknown macro: { color}
            SELECT sdata INTO l_sdata UP TO 1 ROWS
              FROM edid4
              WHERE docnum = i_edidc-docnum
                AND counter =  SPAN
      Unknown macro: { font-family}
      .L0S33
      Unknown macro: { color}
      '000' 
                AND segnam = 'E1EDL24'.
              ....
            ENDSELECT.
  2. Guest

    can we create cluster & poled tables?

  3. Guest

    What is lock objects?

    A lock object is a virtual link of several SAP tables which is used to synchronize simultaneous access by two users to the same set of data ( SAP lock concept).

    Locks are requested and released in the programming of online transactions by calling certain function modules which are automatically generated from the definition of the lock objects. These lock objects must be explicitly created in the ABAP Dictionary.

    To set locks, you must perform the following steps:

  4. Guest

    This is really cool. One can have very good insight in the data dictionary. It really helped me solving some of my interview questions.

    Thanks SDN, thanks Wiki.

    Ankit