1. What are the fields you have used in you are SD report?
InfoObject Description KeyFigures Description
0BILLTOPRTY Bill-to party 0QUANT_B Quantity in base unit of measure
0COMP_CODE Company code 0DOCUMENTS Number of documents
0DISTR_CHAN Distribution channel 0DOC_ITEMS Number of document items
0DOC_CATEG Sales document category 0NET_VAL_S Net value in statistics currency
0PLANT Plant 0COST_VAL_S Cost in statistics currency
0SALESORG Sales organization 0GR_WT_KG Gross weight in kilograms
0SALES_GRP Sales group 0NT_WT_KG Net weight in kilograms
0SALES_OFF Sales office 0VOLUME_CDM Volumes in cubic decimeters
0SHIP_T Ship-to party 0SOLD_TO Sold-to party
2. How do u stop a Process chain at any step?
SE37 RSPC_API_CHAIN_INTRUPET
Using SM51 T-Code we can stop the Process Chain
3. I have 80 queries which query is taking so much time how can you solve it?
Using BW Steatites we can find
4. I have 10 cubes I created multi provider I want only 1 cube data what u do?
We have to fetch data from that single InfoCube.
5. 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
Multiple Reasons Bases
6. Where can we find transport return codes?
After Request release we can see return codes
7. I have a report it taking so much time how can I rectify
Based on Selection Parameters
8. What is offset? Without offset we create queries?
Offset -1, month, date, year.....
9. Process chain is running I have to stop the process for 1 hour after that re run the process where it is stopped?
Manually stop the Process chain by making red and then Reschedule it for after 1 hour
10. What is Alpha Conversion?
Alpha Conversion is used to store data consist by storing any numeric values with prefix 000
InfoObject Description KeyFigures Description
0BILLTOPRTY Bill-to party 0QUANT_B Quantity in base unit of measure
0COMP_CODE Company code 0DOCUMENTS Number of documents
0DISTR_CHAN Distribution channel 0DOC_ITEMS Number of document items
0DOC_CATEG Sales document category 0NET_VAL_S Net value in statistics currency
0PLANT Plant 0COST_VAL_S Cost in statistics currency
0SALESORG Sales organization 0GR_WT_KG Gross weight in kilograms
0SALES_GRP Sales group 0NT_WT_KG Net weight in kilograms
0SALES_OFF Sales office 0VOLUME_CDM Volumes in cubic decimeters
0SHIP_T Ship-to party 0SOLD_TO Sold-to party
2. How do u stop a Process chain at any step?
SE37 RSPC_API_CHAIN_INTRUPET
Using SM51 T-Code we can stop the Process Chain
3. I have 80 queries which query is taking so much time how can you solve it?
Using BW Steatites we can find
4. I have 10 cubes I created multi provider I want only 1 cube data what u do?
We have to fetch data from that single InfoCube.
5. 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
Multiple Reasons Bases
6. Where can we find transport return codes?
After Request release we can see return codes
7. I have a report it taking so much time how can I rectify
Based on Selection Parameters
8. What is offset? Without offset we create queries?
Offset -1, month, date, year.....
9. Process chain is running I have to stop the process for 1 hour after that re run the process where it is stopped?
Manually stop the Process chain by making red and then Reschedule it for after 1 hour
10. What is Alpha Conversion?
Alpha Conversion is used to store data consist by storing any numeric values with prefix 000