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
how do I transfer music from my itunes library to my other libraries on my PCHello gbouie, The following article provides steps that can help transfer content from various libraries into a single library. Just follow the steps outlined in the "Extern [More]
Hi all, a problem puzzled with me, that is whether the measurement swf could capture netstream info from the playback swf in the html page not in the AS environment, such as: <script type="text/javascript">              var swfVersionStr = [More]
When I have my 16 midi channels of my triton in open logic with midi data inside, and I turn the Reverb or Chorus button in the mixer window, there are no affects taking place. why?? ThanksHi, Does your Triton have the General MIDI effects onboard? I [More]
I have a scan of a drawing that I need to get into photoshop but the scan goes onto page 2 of a pdf file.  How can I edit the two scanned pages to end up with the drawing on one page in psd file?It is actually a single file, but goes onto a second pa [More]
When using Facetime or texting, do you have to have internet?Correct. iPod touch: Requires Internet for texting and FaceTime. iPhone: Requires Internet OR 3G connection for texting and FaceTime. iPad: Requires Internet OR 3G connection for texting an [More]
My ATV is only including music videos purchased from iTunes in Shuffle ... is this normal or is there something I'm doing wrong? And, is it doing the same thing with my music (I have so much it would really be hard to tell). Thanks!I have music video [More]
''locking this thread as duplicate, please continue at [https://support.mozilla.org/en-US/questions/1033271 /questions/1033271]'' Java settingshello, javascript is enabled in firefox by default (java is something different, please see [http://kb.mozi [More]
I have a new IMac and when I first started using it my internet connection was quick and responsive. After several days of use it has become much slower. I have tried deleting my history etc. but that doesn't seem to make a difference. I am new to th [More]
I have an iMac and recently it has started flashing every second between wallpaper and blank screen, the dock also disappears, this makes it very difficult to use, the only way to start an application id via the finder --> Go --> applications. Even [More]
How much minutes does an iPod to take to die from a full charge?It really depends on what you are trying to achieve. If you simply want to know how long it will play between charges, consider what JEM has told you. If you want to know how long before [More]