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
My company uses PageMaker 7.0 to create our manuals and brochures and then converts them into pdf's. I've run into this problem before and found that if I didn't properly place or import an image (not copy and paste an image or text) that once conver [More]
I am looking to download about 5-6 GB from a dell to my mac book 2.1. What is the quickest way to do that and about how long would it take? Thank you, TracyIf you have an external hard drive formated as FAT32 would be a quick way to transfer the data [More]
I managed to lose my iPhone last night ( )and I think it may have been picked up by someone as it was lost in a bar and the bar hasn't got it. I've tried calling it but it just goes straight to my voicemail. Since it was fully charged, I don't think [More]
Dear Experts, In SAP4.6C version CALL_FUNCTION_NO_RECEIVER ABAP runtime error.Rich's suggestion should work for you.  The message you are receiving is in regards to a new feature in 4.6 that did not exist in 3.1.  Using SE11, you can define an intern [More]
I am developing a windows 8.1 app with microsoft visual studio. The app shall run in an embedded box PC. From within this app I want to be able to completely shut down the computer. Is there some simple way of simulating or acessing windows/shut down [More]
Hi i installed nw2004s with abapjava with PIDI+EP usage types i cant open "http://microsoft:50000/devinf" Develepoment infractructure in Nw2004s should i need to install it seperatly. I performed JDI installation on the other machine it was nw20 [More]
I want to get a Mac with NVIDIA for the OpenGL feature, but the new ones are GT 640, 650, GTX 660, and 675 and none are on the list of NVIDIAs for Apple.  I realize the list isn't up to date and was wondering if they'll be added anytime soon if not a [More]
In the current Farm we have 2 web apps Collaboration Record Centre We are sending the document to Record Centre using the Send to Connection and the connection is setup as Move and leave a link . Once the document is sent to Record Centre its leaves [More]
Hi All, Can I please have the EDI message mapping names for the following: 1)Tradacoms versions 8 and 9 Inbound:Source message type ORDHDR and the target is IDOC structure ORDERS05(Sales Order) outbound: Source message Invoic02 Idoc and the target me [More]
Hello, Is it possible to give a Manager the permission to view randomly a timesheet  belonging to a resource or to another? ThanksHi Robert, Even being a administrator or top at RBS level, you can not view time sheet for other resources in your organ [More]