Skip to main content

Posts

Showing posts with the label Reports

SQVI Query

At times, businesses will ask for a report based on the table extract of single or multiple tables. As this is a direct table extract, we need not take the help of a developer to extract the data from the tables. SAP has given a provision to generate this kind of report by functional consultants rather than taking the help of the technical team. This report extracts by the functional team will be done with the help of SQVI and SQ01 queries. SQVI query created by a user cannot be accessed by another user ( User Dependent) SQ01 query created by a user can be accessed by other users based on the user group ( User Independent) SQVI queries in general will be generated by the business and consultants will mostly assist business users. But at times, consultants use the SQVI query to extract specific data in a quick way as per business needs and then subsequently extract them to excel and provide the required information to business users. If business insists on the query access for the SQVI,...

[PS] Commonly used reports and T.codes

 RKANBU01 - Transfer Purchase Requisition and Purchase Order Commitments RKACOR04 - Adjustment Betw. Line Items and Totals Records (Act.Cost + Commitment) CJEN - Reconstruct Project info database CJBN -  Re-construct availability check for projects S_ALR_87013558 - Budget - Actual - Commitment report

Functionality of Report SDVBUK00

Consultants usually misunderstand that this program is used to perform mass changes for the document status but this is usually used only if the status of the document is inconsistent with the status of the document at database level Only those inconsistent documents will be corrected using this report. In case, if the status of the document and database is same this report will not correct the document As the status of the documents gets changed regularly at times there might be documents with this inconsistent behaviour only in this case you can use this report. This should not be scheduled daily and can be used to fixed individual sales documents