topic Re: Problem with Update Custom DDIC table in Application Development and Automation Discussions

Problem with Update Custom DDIC table

Missschaaa — Wed, 05 Jun 2019 06:50:52 GMT

Hello guys,

I'm facing a strange problem. I use a custom report which is rolled-out to customers. Therefor I have transaction code. When user clicks on save in the custom report it saves data to DDIC in our custom table. Now when I go via transaction code, the DDIC changes do not happen. When I use programm name in SE38, everything works fine. In both cases MODIFY routine in programm gets runned through. In our development system both works fine so It onl can be authority problem? But which authority is missing when it goes about updating the DDIC table in programm? And why does it work with report but not with transaction for report? Where is the difference?

Authority check does not display any problems.

Any Ideas?

Regards

Michael

Re: Problem with Update Custom DDIC table

Sandra_Rossi — Wed, 05 Jun 2019 06:59:57 GMT

Use transaction code SAT to trace the ABAP code with the "no aggregation" option, for both cases, and there's an option to compare the two traces (and see where the execution varies).

Re: Problem with Update Custom DDIC table

Missschaaa — Wed, 05 Jun 2019 07:13:22 GMT

Hm what can I see there? In both cases the relevant routine which updates the DDIC table gets triggered. So I think It canot be something in program routine.

Re: Problem with Update Custom DDIC table

BaerbelWinkler — Wed, 05 Jun 2019 07:51:28 GMT

Just a couple of questions (and sorry if some sound too obvious!):

Have you checked if anything shows up in the Systemlog (SM21) or Lock Entries (SM12)?
Are there any users for which the update does work via the TCode?
Has the TCode been set up with some kind of special authorization?
Could you do SAT as Sandra suggests in the system where you have the issue or only in DEV?

Re: Problem with Update Custom DDIC table

rameez_khan — Wed, 05 Jun 2019 12:40:24 GMT

Did you try SU53 after executing tcode ?

Re: Problem with Update Custom DDIC table

Nawanandana — Wed, 05 Jun 2019 13:05:04 GMT

Hi,

you have to check How you create the Ztable and how ur passing the values to the same set of primary keys.

if its duplicate use the code

INSERT Ztable FROMTABLE itab ACCEPTINGDUPLICATEKEYS.

or In order to update/modify the Z-table, it is create Z-table structure.

Create the structure for the Z-table, using Move-corresponding copy the value into Work Area.

and update the Z-table using Modify statement.

Negards,

Nawa