Sitemap

Amicuk Programming Answers

Any table or program to get the number of records in P, A and F tables

2015-10-11   Views:0

Advertisement

HI all any table for program to get the number of records in P, A and F tables. I want to create SQ01 queries to get the status of number of records. We are gng for a production cutover next week. Want to capture all the data before and after Upgrade

HI all
any table for program to get the number of records in P, A and F tables. I want to create SQ01 queries to get the status of number of records. We are gng for a production cutover next week. Want to capture all the data before and after Upgrade cutover.
Also suggest me how to create sq01 queries.
Thanks in advance
regards
Janardhan KUmar K.

The replay answer
Advertisement
Use Transaction LISTSCHEMA to see all the tables assosciated with ur cube
Total number would be what you find in both the E & F fact tables. If there is no compression in the cube then E table will be empty.
Alternatively u can use se16 transaction and enter E table and F table manually
E table - /BIC/E(Cube name) and Ftable -  /BIC/F(Cube name)
Or else u can go to the manage of the cube and without selecting any field for O/P and ticking the option output number of hits execute. The total of Row Count will give u the total no of records in the cube.

Go to See the other 6 answers

Any table or program to get the number of records in P, A and F tables

Category:DefaultRelease time:2015-10-11Views:130

HI all any table for program to get the number of records in P, A and F tables. I want to create SQ01 queries to get the status of number of records. We are gng for a production cutover next week. Want to capture all the data before and after Upgrade[More]

Program Process chain-- Number of records per day.

Category:DefaultRelease time:-0001-11-30Views:130

Hi  Friends, i need to  develop a program based   upon the below template. Chain Name      Start Date     Start Time   End Date      End Time     Total Run Time    Number of Records      Total number of records                                        [More]

Count total number of record of table with deletion from archiving object

Category:DefaultRelease time:-0001-11-30Views:130

Does anyone know is there any SAP standard program to count the total number of record of the table with deletion from Archiving Object and display in repprt?Not sure of the question. Are you looking to get the sql "select count(*) from table" f[More]

How to get number of records in all user tables in one select

Category:DefaultRelease time:2015-10-11Views:130

Please advise how to retrieve the number of records in all user tables in one select. I would likt to extract the data to excel file. Many thanks, AndrewYou could always analyze the tables: declare begin   for X in (select owner, table_name from all_[More]

Spilt the number of records in a internal table

Category:DefaultRelease time:2015-10-11Views:130

Hi all,         I have a requirement where i must spilt the number of records in my internal table itab .Say if i have 2000 records , i must spilt it taking the first 990 records and doing some posting using Bapi and again take the next 990 records a[More]

Count number of records in a internal table

Category:DefaultRelease time:2015-10-11Views:130

hi i want to count number of records in internal table pls let me know how to count the number of records in a internal table. regards Arorahi one way is data field type i. Decribe table itab lines field. write: / field. displays the no of records in[More]

How to restrict the number of Records into the Table?

Category:DefaultRelease time:2015-10-11Views:130

Is there any way that I can restrict the number of records can be entered into the table? For example I have created a table TAB1 with size category 0( zero). User dont want to enter more than 100 values, How to restrict the number entries? Whether B[More]

Number of records in internal table

Category:DefaultRelease time:2015-10-11Views:130

Hi How can I tjeck an internal table for the number of records it contains (even if it contains 0). Thanks in advance, regards TorbenHi, DESCRIBE TABLE itab. Effect Returns the attributes of the internal table itab. You must use at least one of the a[More]

Number of records in setup tables

Category:DefaultRelease time:2015-10-11Views:130

Hi all, How do we find out the number of records extracted into setup tables ? Thanks in advance KiranHi Kiran, You can check in the RSA3 for the data source. In TA NPRT check for the no.of records and then cross check in SE16. Assign points if it he[More]

Number of records in FAGLFLEXT table

Category:DefaultRelease time:2015-10-11Views:130

Dear colleagues, Could You please tell me what the maximum number of records FAGLFLEXT table may contain. I was said during FI-GL migration project in 2008 that the optimal number of records is 500 000 per year. After having implemented new project w[More]

Number of records in a standard table

Category:DefaultRelease time:2015-10-11Views:130

Hi, How to find number of records, without fetching them into a internal table? is there any command for that? I want to know the number of records of a standard table in a report. ThanksHi, If you want to know the number of records in your internal[More]

Hot
I continue to keep looking for the answer to this question however, it's seems that I continue to keep running into a wall.  I have several of my smart playlists that rely on monitoring the skip counts.  I never had an issue until I upgraded from a t [More]
The rest of my music is still on my iPad, so how do I get it from my iPad to the computer, and back on my phone? All my music is sitting there safely on my iPad, but whenever I try to sync it with my computer the only option I get is to wipe the iPad [More]
Most of my iTunes looks like this: I have plenty of space on the screen, but can't see the whole line. Anyone know how to fix it.You signature shows you have Mac OS X 10.7.4. If you do not have an Info tab in iTunes, you have Mac OS X 10.9. You sync [More]
I'm unable to find a solution to, or explination for, the following problem with Address Book and Smart Folders. I added a custom date field for my contacts. Set the date for one year and five days ago. Created Smart folder with condition: custom dat [More]
Been happily using PS CS daily for several years. All of a sudden, I am now experiencing a delay between my mouse commands and PS. eg. I select the clone brush. When I want to set the area to clone, I hold alt key and click left mouse button. It take [More]
For those use Domains Juggler: I updated Domains Juggler, why? you ask. Because some people still use it, and it allows a bit simpler way to create new Domain.sites. http://hac.i4host.net/ --> iWeb.html For those use Domain Backup: Domain Backup ONLY [More]
I would like to connect the Active Directory with our SAP 4.6C system. Goal is to synchronize the user data (address, company, department,...) of AD with SAP user data, so we would only have to maintain this kind of data in the AD. Can anyone give me [More]
Received these errors when trying to test replication. "REPAPI 26522:plsql rpc refresh context get failed." "PLS 00201: identifier sys.dbms_snap_repapi must be declared." Here's what I have done: I defined snapshot log on master ok. Wh [More]
How do you uninstall ICC color profiles? I can install ICC color profiles by right clicking on the profile and selecting "Install" but there seems to be no way to uninstall a profile.John, the dictionary Schöffler/Weiß, 1967, translates 'pendant [More]
Hi Folks, As you can see i have run the KKAKor kka3 for single case  to calcutate Result Analysis. i found this errror but i cant' understand how to solve it, i should calcolate the plan revenue on the Sd order? How? Is it something automatically or [More]