How to Restore Query into Older Version

 

• Added by Mahesh Kumar, last edited by Arun Varadarajan

Once older verion (3.x) queries are migrated into latest version (7.0).Query can be restored to 3.x after migration. The backup for any query created in 3.x will be taken when first opened for editing in 7.0 Query Designer. The backup contains the last change done to the query using 3.x editor, any changes done in 7.0 Query Designer will be lost on restore. Also the query originally created in 7.0 can not be restored to older versions as there is no Backup in 3.x.

   Queries can be restored to 3.x version using program COMPONENT_RESTORE.

Steps followed for Restoring Query with 3.x versions:

Step 1 : Execute "COMPONENT_RESTORE" program in SE38.

Step 2 :   Next screen Select InfoProvider and component type. Different component types are available like

Step 3 : Select REP as a component type to revert back Query.  


Step 4 :  Execute (F8). In the next screen it will displays all related Queries for that particular infoprovider.

Step 5 : Search for the query which you want to revert back to older versions.

Step 6 : Then say transfer selection. below message will appears in the system.

Technorati Tags: SAP BI INTERVIEW QUESTIONS,SAP BI,BI Reporting,BI QUERIES

Step 7 : Once we select Yes, Query successfully restored into older versions.

Production Planning Module Business content Implementation

These are the BW datasource for PP area.
2lis_04_P_MATNR (Material level),
2lis_04_P_COMP (Component level),
2lis_04_P_ARBPL (Operation leve) and
0PRODORDER_ATTR (Process/ Production order master data).

BI Best Practice Business content for PP:
http://help.sap.com/saphelp_nw70/helpdata/en/79/0a383fdb800804e10000000a114084/frameset.htm


To re-consulate the data with R3:

COOIS will server your purpose, but make sure the selection.

These are the standard reports from PP end.
BOM related tables :- Engineering Change Management
AENR Customer and priority
STKO --- BOM - header AEOI Revision Numbers

STPO --- BOM - item Work Center
CRHD Workcenter Header Data
STAS --- BOMs - Item Selection CRCA Workcenter Capacity Allocation
CRCO Workcenter Cost Center Assignment
STPN --- BOMs - follow-up control CRHH Hierarchy Header
CRHS Hierarchy Structure
STPU --- BOM - sub-item CRTX Workcenter Text
KAKO Capacity Header
STZU --- Permanent BOM data KAZY Intervals of Capacity

PLMZ --- Allocation of BOM - items to operations Routing
PLPO Routing Operation Details
MAST --- Material to BOM link PLKO Routing Header Details
MAPL Routing Link to Material
KDST --- Sales order to BOM link PLAB Relationships - Standard Network
PLAS Task List - Selection of Operations
PLPLAN_PARAM --- BOM-dependent planning parameter PLMZ Component Allocation
PLPH CAPP Sub-operations
SNUM --- BOM explosion number PLFH PRT Allocation
PLWP Maintenance Package Allocation
T415S --- BOM status PLMK Inspection Characteristics

T415T --- BOM Status Texts Bill of Material
STPO BOM Item Details
T416 --- BOM Usage - Item Statuses STPU BOM Sub Items (designators)
STKO BOM Header Details
T416T --- BOM Usage Texts MAST BOM Group to Material
STZU BOM History Records
T618EM --- BOM of CAP material components STAS BOM Item Selection
STPF BOM Explosion Structure
TCS09 --- BOM Control Depending on Category and Usage
Line Design
TCS11 --- BOM Objects LDLH Line Hierarchy Header
LDLP Line Hierarchy Items
TCS15 --- BOMs with History Requirement LDLT Line Hierarchy Takt Times
LDLBC Takts/No. Individual Capacities per Line
TCS17 --- BOMs with History Requirement LDLBH Line Balance Header
LDLBP Line Balance Items
TCS19 --- BOM Item Object Types LDLBT Line Hierarchy Entry and Exit Takts

TCS21 --- BOM Item Object Types: internal > external PRT's
CRFH PRT Master Data
TCS22 --- BOM Item Object Types: external > internal CRVD_A Link of PRT to Document
CRVD_B Link of Document to PRT
TCS31 --- BOM Field Selection - Usage (T416) CRVE_A Assignment of PRT data to Equipment
CRVE_B Assignment of equipment to PRT data
TCS32 --- BOM to Plant Allocation - Field Selection CRVM_A Link of PRT data to Material
CRVM_B Link of Material to PRT data
TCS33 --- BOM Field Selection (SAP) CRVS_A Link of PRT Internal number to PRT External number
CRVS_B Link of PRT External number to PRT Internal number
TCS34 --- BOM Field Selection - Control Data (TCS03)

SAP BI Inventory Management

By: Raj Kandula and Jitu Krishna
 Source: sdn.sap.com
Hi,
     Few points in Inventory Management.

BW Inventory movement cubes are initialised in two stages.
Firstly you load & compress the initial onhand stocks as of "todays" date;
secondly you load & compress the historic stock movements.
Once that's all done you do your regular delta loads to keep the info up to date.
The Marker is used as a reference point during compression to keep a running
total of what's onhand.
When you initially load "today's" onhands you UNCHECK the "No Marker Update" box, so that the marker records those stock levels.
When you load the historic stock movements you CHECK the "No Marker

Update" box, so that these movements do not affect the marker (as those
movements have already affected the current onhand level).
For the regular delta loads you UNCHECK the the "No Marker Update" box again so that the "future" movements net off the marker as they go.



Marker is used to reduce the time of fetching the non-cummulative key figures while reporting.

Refer
https://www.sdn.sap.com/irj/sdn/thread?messageID=4885115
https://www.sdn.sap.com/irj/sdn/thread?messageID=4764397
https://www.sdn.sap.com/irj/sdn/thread?messageID=4862257
https://www.sdn.sap.com/irj/sdn/thread?messageID=3254753#3254753
https://www.sdn.sap.com/irj/sdn/thread?threadID=422530
Inventory management
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/How%20to%20Handle%20Inventory%20Management%20Scenarios.pdf
How to Handle Inventory Management Scenarios in BW (NW2004)
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01e328
https://www.sdn.sap.com/irj/sdn/thread?threadID=776637&tstart=0

•• ref.to page 18 in "Upgrade and Migration Aspects for BI in SAP NetWeaver 2004s" paper
http://www.sapfinug.fi/downloads/2007/bi02/BI_upgrade_migration.pdf
Non-Cumulative Values / Stock Handling
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/93ed1695-0501-0010-b7a9-d4cc4ef26d31
Non-Cumulatives
http://help.sap.com/saphelp_nw2004s/helpdata/en/8f/da1640dc88e769e10000000a155106/frameset.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a62ebe07211d2acb80000e829fbfe/frameset.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a62f8e07211d2acb80000e829fbfe/frameset.htm
Here you will find all the Inventory Management BI Contents:
http://help.sap.com/saphelp_nw70/helpdata/en/fb/64073c52619459e10000000a114084/frameset.htm

Hope this helps.

SAP BW BI Interview Questions Continued....

By: leela naveen

This are questions I faced. If u have any screen shots for any one of the question provide that one also.
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario
2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
4. when u creating infoobject it shows reference and template what is it
5. what is meant by compounding attribute tell me the scenario?
6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
7. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
9. I have 80 queries which query is taking so much time how can you solve it
10. In compression level all requests are becoming zero which data is compressing tell me detail
11. what is meant by flat aggregate?explain in detail
12. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
13. how can u know the cube size? in detail show me u have screen shots
14. where can we find transport return codes
15. I have a report it taking so much time how can I rectify
16. what is offset? Without offset we create queries?
17. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
18. how client access the reports
19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
20. what is structure in reporting?
21. which object based you created extended star schema?
22. what is line item dimension tell me brief
23. what is high cardinality tell me brief
24. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped?
in multiprovider can I use aggregations
25. what is direct schedule and what is meta chain
26. which patch u used presently? How can I know which patch that one?
27. how can we increase data packet size
28. hierarchies are not there in bi?why
29. remodeling is applied only on info cube? why not dso/ods?
30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
31. why ods activation fail? What types of fails are there? What are the steps to handle
32. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible?

Give me any performance and loading issues or support issues
Reporting errors, Loading errors, process chain errors?