What tables contain data for the CUP requests in 5.3?

[Former Member]

What are all of the tables that contain the data that appears in the CUP requests? We are on version 5.3 SP13.

We are selling off one of the divisions of our company and one of the terms is that we have to provide all relevant data, including CUP requests. Since there are several hundreds of requests for this division (last count was over 600), it is not practical to just download the individual requests out of CUP. So plan B is to just give them the data.

I know there are several tables that contain this data, and I know some of them (such as VIRSA_AE_REQD_HDR and VIRSA_AE_RQD_WPHS), but I don't know all of them. (and I would rather not have go thru and to check every table)

Thanks.

[Former Member]

Hi Bob,

If you are a SP which is later than 09, the tables are stored in the Data Mart.

Refer Note 1369045 - AC SP09 Data Mart Design Description that contains more information on the Data mart feature. Refer the attachment "AC_5_3_Datamart.pdf" for detailed information.

Regards,

Raghu

[Former Member]

We do not have the Data Mart functions activated.

[Former Member]

Hi Bob,

Did you check the tables in J2EE database which starts from VT_AE_*?

Also, I recommend contacting SAP with your requirement. They may deliver a script that quickly enables you to download the data from the respective tables.

Regards,

Raghu

[Former Member]

I was hoping to get a smaller list. There are over 100 tables that start with VT_AE. I was hoping to get a list of just the ones that have request data.

As for the script from SAP, unless they have changed their policy again, they don't provide scripts anymore. We've run into similar situations with them in the past where they don't want to provide scripts or more information on what is contained in specific tables.

Thanks.

[Former Member]

Hi Bob,

I have never looked at the VT_AE tables to extract any information. Since your requirement is unique, I have a positive note that SAP would help you with it. Giving a try would worth it sometimes

Else, paste the list of tables here, so that some one can help you.

Have a great weekend!!

Cheers,

Raghu

[Former Member]

Response from SAP Support:

Since CUP request data is stored in several tables, I cannot recommend

to give you just a list of a few tables since it may cause database

inconsistencies when the CUP request details are retrieved. Having said

that, I recommend all tables starting with the following prefixes:

VIRSA_AE* and VT_AE*

[Former Member]

Did you check these??

*AE_RQDAPL - Request Application, Provision Status

*AE_RQDUSERS - Request user information

*AE_RQDHDR- Request details

Infact Data mart reference document provides information about the individual tables. May be you can give a try looking at the link.

Regards,

Raghu

Edited by: Raghu Boddu on Sep 9, 2011 10:23 PM. Added more info.