Authorisation Object Problem

[former_member251546]

Hi,

Good day folks

I ve got a problem with Authorisation object. Previous dev had dev the report . For the report, he was created ztables also. and tested as well as , Transport to QA also.

Now if we run the trasaction code for the report in QA. its goes to short dump.

its shows the error on the Table[ZCS_WO_AGE_PER] one which is not using in any programme. ZCS_WO_AGE_PER table is in the active mode in DEV client. but its not using in any programmes.

ive seen the table maintainence in ZCS_WO_AGE_PER] .. the Authorisation object same one which custom table also.

is it problem or any reasons to go for short dump?plz let me know..

If authorisation object problem then how to resolve it?

regards

[SuhaSaha]

its shows the error on the TableZCS_WO_AGE_PER one which is not using in any programme.

What is the error on the table ZCS_WO_AGE_PER ?

[former_member251546]

Hi,

I think, Before this table[ZCS_WO_AGE_PER] using in the report. first its got only three feild. then later as per client requirement, its was changed and Added Two more feilds. unfortunatelly again client has changed the requirement, then developer had deleted the added feilds.

I think, first time added two fields and then deleted those fields. but its in active status. if we check it doesnt show any error messages.

Table feilds now
ILART	ILA	CHAR	3	0	Maintenance activity type
EXP1		NUMC	3	0	Expire 1
EXP2		NUMC	3	0	Expire 2

Regards

Edited by: balaji kiran on Mar 23, 2010 7:11 AM

[former_member209217]

Hi,

Check if the report program is using or accessing any of the deleted fields or not.If so, make corrections

Check the table fields once whether they are the same in development system and quality system.You need to generate the table maintainence once again whenever some fields are added or deleted in the table.

Regards,

Lakshman.

[GauthamV]

Did you activate and adjust database for that table in SE14 before transporting it to QA ?

Also be more specific about the dump which you are getting if the above

option doesn't solve your problem.

[former_member251546]

hi

Thank you for reply. One field is using the both tables.. is it cause of problem?

ZFI_DEBTORS_AGEING_SUMMARY progamme is using the table ZFI_DEBTORS_REG.
Table feilds:
MANDT	MANDT	CLNT	3	0	Client
REGION		CHAR	10	0	Group
REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
EXP1		CHAR	2	0	                                                            


ZCS_WO_AGE_PER
Table Fields:
ILART	ILA	CHAR	3	0	Maintenance activity type
EXP1		NUMC	3	0	Expire 1
EXP2		NUMC	3	0	Expire 2

[former_member209217]

Hi,

Regenerate the Table maintainence using SE14. Its enough

[former_member209217]

Hi Balaji,

Could you please post the dump error you are getting while execution.

[former_member251546]

Hi,

error
wht happend?
Error in the sap application programme
The current ABAP Program "SAPLSVIM" had to be teminated because it has come acros a statement that unfortunately cannot be executed.
the forllowing syntax error occurred in the programm "SAPLZTAVLEMAINT" in include "LZTABLEMAINTT00" in like 19:
the Dictionary strcture or table  ZCS_WO_AGE_PER  is either not active or doesnt exist"


The include has been created and  last changed by created by SAP "

Error analysis:
The following sysntax error was found in the program SAPLZTAVLEMAINT : the dictionary stracture or table ZCS_WO_AGE_PER 
is either not active or doesnt active

ZCS_WO_AGE_PER is table is not using in the programme one which is in the QA. as well as ive checked the ZCS_WO_AGE_PER. its in active status..

regards

[SuhaSaha]

The FuGr ZTAVLEMAINT is the function group for the table maintenance generator (TMG).

As suggested by Gautham you have to use the Database Utility Tool (SE14) to adjust & activate the database. Also you have to regenerate the TMG & reactivate it again.

BR,

Suhas

[former_member251546]

Hi,

Thank you for reply.

I did same wht you told for ZCS_WO_AGE_PER. must i transport ZCS_WO_AGE_PER table to QA?

ZCS_WO_AGE_PER table is no more using in any programme. just it was confirmed now

regards

[GauthamV]

If the ztable is removed from the program now then you should transport that particular reuqest to

QA .Also transport the table also to QA as it reduces data inconsistency in other systems as well.

[former_member251546]

hi,

Good day sap gurus

Thank you. ZCS_WO_AGE_PER was Regenerate the Table maintainence using SE14. but see

ZCS_WO_AGE_PER is not using from strating onwards in the programme. In the programme, we are using ZFI_DEBTORS_REG table. But Authorisations objects are same in the both tables. As well as EXP1 feild is using in both tables.

Regards