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 am trying to create eventually an iDVD but want to put together several mvi files I took. I am doing it right in iphoto to allow me to import them.Hi Margaret, I'm not certain, but try this... In finder, locate the video, then drag & drop it on iMo [More]
OK So I have been building folios for the new iPad (retnia) and the only way I can get a full page animation built in edge to work is to build it on a stage that is half res (1024x768). If I build a full screen edge animation (2048x1536) it just show [More]
Hello! I just got an iPhone 4 and I can´t buy apps because it says that the password is not valid. I have checked it out several times and it is. The name presented as the usename of my account is not the right one though. How do I change it? Or shou [More]
Hi This is Regarding KANBAN Business scenario: Container will have safety stock maintained, Procurement will trigger only when stock in container goes below safety stock. not when container is empty. We dont want system to calculate KANBAN quantity P [More]
Hi, I can't find where I can set the options for "Save as PDF"? I want to be able to tell it how much to compress the images in my file and how much to downsample the images, but I can't find any documentation to tell me where these options or p [More]
I have a<!-- BODY { FONT-FAMILY:Tahoma; FONT-SIZE:0pt } P { FONT-FAMILY:Tahoma; FONT-SIZE:0pt } DIV { FONT-FAMILY:Tahoma; FONT-SIZE:0pt } TD { FONT-FAMILY:Tahoma; FONT-SIZE:0pt } --> PCI Express X-Fi Xtreme Audio. It works great, with one exception: [More]
I have a friend with an old Blueberry iMac and whas a mass of images she wishes to transfer to her new mini mac. I have a couple of remote H/Ds one a usb and the second a firewire but each is formatted to 0SX. I could swap one of the disks to a redun [More]
Hi, I have recently started with java and been running through the Tutorials. Here is my computer setup: Windows EXP Pro J2SE and NetBeans IDE Bundle NB 4.1 / J2SE 5.0 Update 3 FCS Firefox 1.0.4 (java/javascript enabled) Eclpise 3.1.0 I have been enc [More]
Hello Oracle forums,      We have a situation where we need to make some structural changes to a database that is running a streams capture process, and do not want these changes to be propagated from the capture database to the apply database.       [More]
why is there no option as "none" for the billing account in iphone5?If you only want the free apps, take a look here: http://support.apple.com/kb/HT2534 Read the steps carefully as the order in which you follow them is  critical. Note that you c [More]