Current Position:Home > View cluster table child table calling problem!

View cluster table child table calling problem!

Update:10-11Source: network consolidation
Advertisement
Hi All,
I have created a cluster table with one table as header and one as item...
Header table : ZRAJ1
ITEM TABLE : ZRAJ2
ZRAJ1 :
ZPRODUCT
ZPROD_DESC
ZSTATUS
ZUSER
ZRAJ2:
ZPRODUCT
ZLABEL
This clearly shows that zraj2 is depending on ZRAJ1.
Created a cluster with these two tables.
Also, created events for ZRAJ1.
EVENT 05:
FORM create_entry.
  yraj1-zuser = sy-uname.
ENDFORM.
EVENT 02:
FORM after_save.
  IF yraj1-zstatus = 'L'.
    CALL TRANSACTION 'ZRAJ_VIEW'.
  ENDIF.
ENDFORM.
If the Zstatus is "L" in ZRAJ1, a new transaction will be called to maintain the child table zraj2.
Trasnaction 'ZRAJ_VIEW'.
REPORT 'ZRAJ_VIEW'.
INITIALIZATION.
*declaration:
  DATA : itab LIKE vimsellist OCCURS 0 WITH HEADER LINE.
START-OF-SELECTION.
*To call the MAintanence screen directly through the program:
  CALL FUNCTION 'VIEW_MAINTENANCE_CALL'
    EXPORTING
      action                               = 'S'
  CORR_NUMBER                          = ' '
  GENERATE_MAINT_TOOL_IF_MISSING       = ' '
  SHOW_SELECTION_POPUP                 = ' '
      view_name                            = 'YRAJ2'
  NO_WARNING_FOR_CLIENTINDEP           = ' '
  RFC_DESTINATION_FOR_UPGRADE          = ' '
  CLIENT_FOR_UPGRADE                   = ' '
  VARIANT_FOR_SELECTION                = ' '
  COMPLEX_SELCONDS_USED                = ' '
   TABLES
      dba_sellist                          = itab
  EXCL_CUA_FUNCT                       =
EXCEPTIONS
  CLIENT_REFERENCE                     = 1
  FOREIGN_LOCK                         = 2
  INVALID_ACTION                       = 3
  NO_CLIENTINDEPENDENT_AUTH            = 4
  NO_DATABASE_FUNCTION                 = 5
  NO_EDITOR_FUNCTION                   = 6
  NO_SHOW_AUTH                         = 7
  NO_TVDIR_ENTRY                       = 8
  NO_UPD_AUTH                          = 9
  ONLY_SHOW_ALLOWED                    = 10
  SYSTEM_FAILURE                       = 11
  UNKNOWN_FIELD_IN_DBA_SELLIST         = 12
  VIEW_NOT_FOUND                       = 13
  OTHERS                               = 14
  IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
        WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.
it is calling, ok no issues but it is not allowing me to create a new entry in the child table zraj2.
Error: Table is locked by the user Raj.Checked in SM12 yes there is an lock entry for the table zrst(cluster),  zraj1, zraj2.
Question :
By default in the execution of cluster will there be a lock in all the child table as well.
if so how to create new entries....
For your information : Standalone it is working fine.That is if i execute ZRAJ1 in SM31 i am able to create new entries..
Can any one provide some input on this............
Tahnks,
raj.

The Best Answer

Advertisement
I don't know any direct transaction for your purpose, but you can use this program RSTXSCRP to download your form into the local file and than you can open it to view.
Regards,
Naimesh Patel
  • How to get the Minum Grade level from the view cluster table V_T710CL_B Update:11-30

    Hi Guys, I want to fetch the Minum Grade level from the view cluster table V_T710CL_B kindly help me Regards Rusidar.HI Siggi, Thank you for your reply.. I am also planning to do FM to get the data. But it is saying that the Cluster table ZES does no

  • View cluster table child table calling problem! Update:10-11

    Hi All, I have created a cluster table with one table as header and one as item... Header table : ZRAJ1 ITEM TABLE : ZRAJ2 ZRAJ1 : ZPRODUCT ZPROD_DESC ZSTATUS ZUSER ZRAJ2: ZPRODUCT ZLABEL This clearly shows that zraj2 is depending on ZRAJ1. Created a

  • Applying support packs, is there way to see all tables/view/clustered table Update:11-30

    We are applying support packs, and they are taking awhile.   Upon review it looks like it's adding some fields to some tables/clustered tables.  Is there a way to see all the tables/views/cluster tables that were updated.  I know I can look at versio

  • Maintaince view creation for a cluster table Update:10-11

    Hi friends, I have created a maintaince view for a cluster table bseg and i have activated it its working fine.. now my problem is i can create maintaince view for mutiple tables if other tables are linked with primary table using foriegn key relatio

  • How to Extract Data for a Maintenance View, Structure and Cluster Table Update:10-11

    I want to develop  3 Reports 1) in First Report it consists only two Fields. Table name : V_001_B Field Name1: BUKRS Table name : V_001_B      Field Name2: BUTXT V_001_B is a Maintenance View For this one I don't Find any Datasource For this Maintena

  • F4 help for a field in item table in a view cluster Update:10-11

    Hi All, I have a view cluster with two tables. I should provide F4 help for field in item table based on the selected row of the header table. F4 should have only values fetched based on the header table entry. How can i achieve this. Please suggest.

  • View on cluster table Update:10-11

    hi all, I am trying to create a view for the tables bkpg and bseg.but am unable to as the error is "bseg is cluster table". can't  we create view for cluster table. if can, howYou cannot create a view because BSEG is in a cluster table For this

  • How to restrict data from tables in a view cluster Update:10-11

    Hi, I have 5 Z* tables, Company code is the common code in all of these. I have created a view cluster on these five tables. My requirement is to viewcluster should display the data of the user's company code. When i see the data in SE54 it is showin

  • Problem retreving data from cluster table Update:10-11

    Hi friends, Iam facing a problem while retreving data from a cluster table.. select knumv           kposn           krech           kawrt           kbetr           waers           kpein           kmein           kwert           from konv           in

  • Problem with cluster table in HR Update:11-30

    Hi everybody We are testing TDMS in HR and I have a problem: we want to transfer spanish cluster (PCL2) to the receive system, for this table the entry is transported but if I execute transaction pc_payresult the tables of the cluster don´t appear, w