Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SOX complaince for ZTABLES creation

Former Member
0 Kudos

Dear All,

Is there any restriction on creating ZTables in SAP (not about naming conventions)

Does ZTABLES has to be created only to meet funcitonal perspective so that in complaince with SOX,,

is it true that ZTABLES should not be created for techncial purposes as they are not in line with SOX complaince

REason for coming up with these questions is my peers are finding fault in my program stating that I had created zTABLES for my techncial convneince and it should not be done

My requirement is

Actually I have to develop a Report which has to display 700 entries

like

Account num descripton amount

10000 desc1 100

145678 desc2 230

And so onu2026..

But in no particular sequence like ascending order 1u2014700 and in that particualr sequence no table is holding data

So in this case I have to fill a internal table itab

Like

Wa_itab-acountnum = 10000

Wa_itab-description = desc1

Wa_itab-amount = 100

Append wa_itab to itab.

Like this 700 times right.

So instead of writing 700 append statements what I have done is I uploaded them into ztable(through excel sheet

Hardly 5min job ) and used a Select query to fetch 700 entries from the ZTABLE

But my peers are objecting for creating a ztable, they say according to SOX u cannot create ztables only for tech requirements ZTABLES should be created only if they have functional requirement and et all they are saying

So I want to know how far they are true

1 ACCEPTED SOLUTION

SuhaSaha
Advisor
Advisor
0 Kudos

>

> But my peers are objecting for creating a ztable, they say according to SOX u cannot create ztables only for tech requirements ZTABLES should be created only if they have functional requirement.

> So I want to know how far they are true

Absolutely rubbish. SAP has tables TVARV & TVARVC tables, please ask your colleagues what functional requirement do these tables serve?

I have seen many a projects in which they have custom tables for maintaining constants. Pure technical purpose.

Definitely creating tables eats into the valuable space of the database, but creating one table doesn't K.I.L.L anyone.

BR,

Suhas

PS: I had worked on a project which was SOX complaint & nobody questioned us about the utility of a particular table as long as we had maintained proper authorization group in the TMG

6 REPLIES 6

Sandeep_Kumar
Advisor
Advisor
0 Kudos

What your peers are sugegstning is right.

You should not create a dictionary object until and unless it servers some purpose.

In your case , you can very simply and easily do it in your program.

SuhaSaha
Advisor
Advisor
0 Kudos

>

> But my peers are objecting for creating a ztable, they say according to SOX u cannot create ztables only for tech requirements ZTABLES should be created only if they have functional requirement.

> So I want to know how far they are true

Absolutely rubbish. SAP has tables TVARV & TVARVC tables, please ask your colleagues what functional requirement do these tables serve?

I have seen many a projects in which they have custom tables for maintaining constants. Pure technical purpose.

Definitely creating tables eats into the valuable space of the database, but creating one table doesn't K.I.L.L anyone.

BR,

Suhas

PS: I had worked on a project which was SOX complaint & nobody questioned us about the utility of a particular table as long as we had maintained proper authorization group in the TMG

Former Member
0 Kudos

True. But i guess for the kind of requirement the OP had, creating a local internal table should be more than sufficient. Creating ZTABLES or ZSTRUCTURES for every small requirement in a report is quite ilogical.

Vikranth

0 Kudos

Hi Vik,

I should have added a foreword I didn't get into the details of the OP's requirement.

I was answering to the OP's query whether his/her peers were correct. Personally i don't think they've a valid point be it SOX / non-SOX.

Anyways i have already made a comment regarding DB memory consumed by a DDIC table. The OP should take cue from it.

Cheers,

Suhas

Former Member
0 Kudos

This is total trash. Forget it!

The pure existence of a Z-Table (for whatever it's purpose) does not even come anywhere close to SOX-considerations. You could probably discuss something like that if the table in question were containing data that are somewhat SOX-contradictionary plus you had failed to apply the proper authorisations to them, thus allowing data to be visible in an uncontrolled or SOX-incompatible way.

That being said - I am a security person, no developer ... so I cannot and will not judge whether you could have managed without creating a physical table ...

Well, Suhas has covered the topic of space on the DB, nothing to add there.

Former Member
0 Kudos

Dear All

thanks for your quick replies,,actually i was literally being cornerd by them by tossing a new term to me SOX compliance.and now i got a clear picture,,let me take a call

And thankz atonnn suhas and Mylène Dorias