quarta-feira, 19 de outubro de 2016

Timezone changes best practices



Purpose

The purpose of this wiki document is to make the timezone related issues are addressed with respect to an SAP system. This document explains the different levels of timezone that is set in the SAP system.

Overview

At times its needed to adjust the SAP servers timezone when there is a daylight savings DST switch. During this time switch there needs to proper procedure followed to correct the timezones. SAP system and OS (Operating system) should be the same to avoid time differences and errors. In case if they are different then you may use the below reports to set them appropriately.

System Logic

The timezone is set at different levels of an SAP system.
1. Operating System Time  [CPU Clock Settings]
2. Time zone at Client         [Transaction Code STZAC]
3. User time zone               [Transaction Code SU01/SU3]
Changing the system time zone on SAP system should not have any influence on existing data, because the times/dates on database are stored with a certain time stamp and these are not influenced by the time zone changes. The sequence and the chronological order of the document will remain the same. In the transaction STZAC you do have the following two time zone input fields:
System Time Zone             <If an application is started in a client it can use this client time zone setting>
User's Default Time Zone   <If a user is connected to a client and for this userid if there is no time zone setting defined in the transaction SU01 of this client then the user time zone will be
                                            automatically set to the time zone value which is defined in this field here>

How to check the timezone at different levels

  • Login to SAP system client  
  • Run the report from Tcode SA38   -> TZCUSTHELP
  • Run the report from Tcode SA38   -> RSDBTIME
  • Run this function module in SE37   -> TZ_SYSTEM_GET_TZONE
  • Run this report from Tocde SA38  -> TZONECHECK 

 Recommendation

  • If you would like to update your system with the newest time zone data, then I would recommend to check note 198411 regularly.
  • If you change timezone in STZAC it affects only the SAP instance timezone and only SAP system needs to be restarted.
  • If you change the database time then you need to restart both SAP instance and Database Instance.
  • Don't change the settings in STZAC when the users are connected to the system
  • The 'System Time Zone' will be automatically changed for all clients but for the 'User's Default Time Zone' setting you have to start the   transaction STZAC in each specific client.
  • We always recommend a downtime during the switch from daylight saving time to winter time to avoid issues during the so called "double hour".In this period the time does not run constantly and we cannot guarantee that the software can handle the situation if a point of time comes up twice.
  • One possibility to avoid the downtime is the system time setting UTC. Then no daylight saving time switch is performed at all and so no downtime is needed.

Related Content

TZCUSTDISP     Display System Parameters for Time Zones
TZCUSTHELP    Troubleshooting Support for Time Zone Settings
TZONECHECK   Check Time Zone Data for Consistency
TZCUSTIM          Import Customizing Data
TZCUSTEX         Export Time Zone Data
RSDBTIME         Time diagnosis

Related Documents

Related SAP Notes

481835    Analyzing the time zone settings
198411    Current data and information about time zones
7417        Conversion between standard time and daylight saving
741734    Incorrect times due to the time zone settings
926290    SWNCCOLL: SAP workload NW collector collects no data
1375438  Globalization Collection Note > point 3

Fonte: https://wiki.scn.sap.com/wiki/display/Basis/Timezone+changes+best+practices

quinta-feira, 13 de outubro de 2016

SAP Standard Reports

No
Broad level Report
Options available for report execution
Tcode in SAP
Remarks
Used by
Report area
1
Purhase order analysis
By delivey schedule 
By purchase order details
By purchase order hostory
ME80FN
This report can be used for displaying the information of purchase orders created and the transactions that has taken place.
Purchase
Purchase
2
Purchase order display
By supplier 
By material 
By buyer 
By plant
ME2L 
ME2M
Facility available to restrict the viewing based on the status of PO viz. Partly received, 
Closed, No GR made 
Bill passing not done , etc.
Purchase
Purchase
3
Anlysis of order values
By Material 
By buyer 
By supplier
ME81N
Totals analysis 
ABC analysis 
Analysis using comparison period 
Frequency analysis
Purchase & Finance
Purchase
4
Goods receipt forecast
By purchase order 
By vendorwise 
By material wise
ME2V
Number of anticipated deliveries
Pruchase & Stores
Purchase
5
Stock lying with subcontractors
By Supplier 
By material
ME2O
Can be useful in deciding which component is to be given to supplier if the procurement is on subcontracting basis. It also helps in giving the visibility of stocks lying at subcontractor.
Pruchase & Stores
Purchase
6
Monitor supplier confirmation
By Supplier 
By buyer
ME2A
This program is useful especially for imported purchase orders or such cases where the lead time of procurement is very high.
Purchase & planning
Purchase
7
Purchase analysis
By buyer 
By Material 
By commodity type 
By supplier
MCE1 
MCE3 
MCE5 
MCE7 
MCE8
This program will give you information on purchase value, invoice value during a selected period. However for these reports it is necessary to update the relevant LIS structure.
Purchase Executives
Purchase
8
Long term planning analysis
By supplier 
By material 
By commodity type
MCEA 
MCEB 
MCEC
This report can be used for Purchase budget requirement. However for this report to work, long term planning functionality should be put in use.
Purchase Executives
Purchase
9
Material document listing
By Material 
By movement wise 
By supplier
MB51
This report provides you with a list of the material documents which  were posted for one or more materials.
Stores / Finance
Inventory
10
Account document listing
By material 
By date
MR51
The report Accounting documents for material produces a list containing all accounting documents available for a selected material.
Finance
Inventory
11
Stock Overview
By material 
By Plant 
By batch
MMBE
The stock overview provides you with an overview of the current stocks of a material at all places within plant       
All
Inventory
12
Stock requirement list
By material 
By material planner
MD04
This report will help you to analyse material requirement plan considering stocks and future requirements.
Planning
Inventory
13
Plant Stock availability
By material 
By material type 
By buyer group
MB52 
MB53 
MCBA 
MCBE 
MCBR
This report provides an overview of the stock situation of a given  material in selected plants. If there are multiple plants where the same material exists, this report can give the information on stocks at various places 
Stores / Purchase
Inventory
14
Expiration date list
By material 
By Plant 
By batch
MB5M
This report provides an overview of the remaining shelf life of batches. This report is generally useful in Pharma.
Stores / Planning
Inventory
15
Stock on posting date
By material 
By Plant 
By batch
MB5B
The report Stock for posting date lists a company's own stocks in a particular time period.      
Stores
Inventory
16
Stock in transit
By material 
By supplying plant 
By receiving plant
MB5T
This report issues a list with all stocks that are located in a plant's  stock in transit. This information is useful when interplant / intercompnay material transfer is taking place.
Stores / Finance
Inventory
17
Stock with subcontractor
By plant 
By supplier 
By plant
MBLB
This report provides an overview of the stocks of material provided to vendor    
Stores / Purchase / Accounts
Inventory
18
List of GR / IR balances
By material 
By supplier 
By buyer 
By Purchase order
MB5S
The report compares the GR quantities and values relating to a purchase order with the invoice quantities and values for the same PO. The report can thus be used to check goods and invoice receipts when purchasing documents show some discrepancy.           
Purchase / Accounts
Inventory
19
MRP Controller analysis
By inventory controller
MCBG
This report will help you in tracking the inventory by responsible person.
Executive
Inventory
20
Material usage based ABC Analysis
By usage 
By requirement
MC40 
MC41
This report will help you in identifying the fast moving, slow moving / non moving items. The report can be executed at the material level / plant level
Executive
Inventory
21
Range of coverage
By usage 
By requirement
MC42 
MC43 
MC.G 
MC.4
This report will help you in getting the information of coverage of the material for production purpose based on the past consumption pattern. The report can be executed material wise, commodity type wise, material planner wise etc.
Stores / Planning
Inventory
22
Inventory turnover
By material 
By commodity type 
By buyer 
By material planner
MC44 
MC.3 
MC.B 
MC.7 
Mc.O
This report will help you in getting the information on the inventory turn over ratio.
Executive
Inventory
23
Slow moving items
By material 
By commodity type 
By buyer 
By material planner
MC46
This report will help you to identify slow moving items.
Executive
Inventory
24
Dead Stock items
By material 
By commodity type 
By buyer 
By material planner
MC50
This report will help you to identify dead inventory
Executive
Inventory
25
Usage value
By material 
By commodity type 
By buyer 
By material planner
MC45
This report identifies the share of the usage value to the total usage. You can also see the report graphically for a selected material in detail screen.
Executive
Inventory
26
Sales analysis
By Customer 
By material 
By sales person 
By sales office
MCTA 
MCTC 
MCTE 
MCTI 
MCTG
These reports can give you information regarding incoming sales order, credit memos, quantity, value etc.
All
Sales
27
Report on: - 
Incoming orders 
Invoiced sales 
Credit Memo 
Sales return
By material 
By Customer 
By sales channels
MC(A 
MC+A 
MC+E 
MC+I 
MC+U 
MC+Y
These reports can be used for seeking the information on billing
All
Sales
28
Sale report with option like 
Area wise 
Statewise 
Executive wise
By sales area 
By customer
By material
MC+2 
MC+6 
MCSI
The standard report MC+2 & MC+6 can meet the reporting requirement. However in case the standard report are not serving the reporting requirement user defined info structure can be created and transaction MCSI can be used for sales analysis.
All
Sales
29
Vendoe master list
By Supplier 
By Purchase group
MKVZ
This report can give you the list of suppliers
Purchase
Purchase
30
Status of indents
By indent 
By material 
By buyer
ME5A 
ME5K 
This report can be used to seek the information of status of indent raised, purchase order number, goods receipt status etc.
Purchase 
Stores
Purchase
31
Quotations listing
By suppliers
By mateial 
By commodity group 
ME4L 
ME4M 
ME4C 
This report is useful to view / extract information on quotations from supplier in case  the quotations are invited for a particular indent
Purchase Executives
Purchase
32
Commodity price
By material 
By plant 
By Supplier 
ME1L 
ME1M 
ME1W 
ME1P 
This report is useful to view the purchase order price change history for various pricing conditions
Purchase Manager 
Finance
Purchase
33
Planned share of business
By material 
By supplier
MEQM
This report can be useful to know the % share of business planned with a supplier in case multiple sources exist for a commodity.
Purchase Executives
Purchase
34
Vendor rating
By commodity 
By commodity group 
By supplier
ME64 
ME6D 
ME6C 
ME65
This report is useful to extract information of supplier performance on various parameters such as delivery, quality, cost etc.
Purchase Manager 
Quality Manager 
Purchase
35
Commodity listing
By commodity 
By plant 
By commodity group
MM60
This report will give you the list of all materials created in the system with the parameter values
All
Logistics
36
Purchase value 
Purchase quantity 
Quantity reliability 

MC$G 
MC$1 
MC$M
This report can be used by purchase buyer / manager to track purchase performance
Purchase Executives
Logistics
37
Availability overview

CO09
This report gives you the information of material availble for production
Stores
Inventory
38
Physical inventory listing

MI24
This report may be used in case physical inventory system is followed in an organization
Stores 
Finance
Inventory
39
Bill of Materials
Display BOM 
Display BOM allocation to Plant 
Where used list 
BOM Comparison 
BOM explode - Multi level 
Bom explode - Level by level
CS03 
CS09 
CS15 
CS14 
CS12 
CS11
This report can give  you information related to Bill of materials, comparison of BOM between two materials etc.
All
Production
40
Work center information system
By machine wise 
By planner wise 
By plant wise
CR60 
CR05
This report will give you information of the machines used for the purpose of manufacturing. The machines / work center could be labor work center also
Shop floor 
Costing
Production
41
Work cener analysis 
Operation analysis
By lead times 
By date 
By quantity 
MCPB 
MCPY 
MCPK 
MCPQ
This report can be used to extract the information of operation qy, scrap qty, lead time, target lead time etc.
Shop floor Manager 
Production
42
Material analysis
By lead times 
By date 
By quantity 
By product cost 
By material consumption
By sales / production plan 
MCPW 
MCPF 
MCPO 
MC89
This report is useful for giving the information of Target vs actual lead time, 
Planned order qty vs actual order qty, 
Planned cost vs actual cost, 
Planned consumption vs actual consumption 
Executive
Production
43
Operation analysis 
Material analysis 
Work center analysis 
Production order analysis
By plant 
By material 
By order 
By machine
MCP1 
MCP3 
MCP5 
MCPB 
MCPU 
MCPW
The order information system is a tool for shop floor control with a reporting function for production orders and planned orders. These reports are useful in discreet manufacturing set up.
Shop floor
Production
44
In repetitive manufacturing set up: - 
Production analysis 
Material consumption analysis 
Product cost analysis 
By plant 
By material 
By component used
MCRP 
MCRK 
MCP6
These reports are extensively used for reporting purpose in the repetitive manufacturing environment
Shop floor
Production
45
Pull list
By plant 
By material 
By quantity 
By storage location
MF60
This report can be used in repetitive manufacturing environment to know the shortage of material for production
Shop floor 
Stores
Production
46
For process industry: - 
Shop floor information system related to material analysis, 
operation analysis, process order analysis, material usage analysis, product cost analysis
By plant 
By material 
By order 
By machine
MCP5 
MCRU 
MCRV 
MCRW 
MCRX 
MCRY
These reports are useful only when PP-PI component is installed.
Shop floor
Production
47
Kanban analysis
By plant 
By supply area 
By material
MCQ.
This report will give the information of Kanban usage. Can be used only when Kanban component is used
Shop floor
Production
48
Kanban analysis
By demand source overview 
By supply source overview 
By plant overview
PK13 
PK12 
PK11 
PK18
This report can be used only when Kanban feature of SAP is used.
Shop floor
Production
49
Material usage analysis
By plant 
By material 
By component used 
By order
MCRE
This report can be used for analysing the actual material usage against plan in manufacturing process.
All
Production
50
Product cost analysis
By plant 
By material 
By component used 
By order
MCRI
This report can be used for finding out planned cost vs. actual cost in the manufacturing process
All
Production
51
Product cost analysis - Summarised
By hierarchy
By period
KKBC_HOE
This report can give you summrised information of all the production orders related to cost & quantity
Executive
Production
52
Cost Variance Target / Actual 
Variance analysis
By plant
S_ALR_8701348
This report can give you information on the cost variance analysis
Executive
Production
53
Missing parts checklist
By plant 
By material 
By component used 
By order
CO24
Missing Part list check


54
Order progress report
By plant 
By material 
By order
CO46
This report can give you information of the order which is in process.
Shop floor
Production
55
Production order information system
By order 
By Material 
By plant 
By production planner
COOIS
This report give information on production order
Shop floor
Production
56
Production order cost analysis
By order 
KKBC_Ord
This report can give you information on target cost against actual cost for production order
Executive
Production
57
Actual comparison of financial results by period with previous period
By GL Account 
By Financial statement version
S_ALR_8701249 / 87012250 / 87012251 / 87012252
This report can give you financial statement for the selected period with comparison. The report can be viewed on half yearly / quarterly / periodic basis as well. For 10year comparison use transaction S_ALR_87012257
GL
Finance
58
Balance sheet / P&L statement
By financial statement 
By company code
S_ALR_870122284
This report will give you balance sheet / P&L
GL
Finance
59
Plan /  actual comparison on periodic basis

S_ALR_87012253
This report will be useful incase you are using GL planning.
GL
Finance
60
Cash flow report

S_ALR_87012271
This report will give you cash flow.
GL
Finance
61
GL Balances

S_ALR_87012277 
S_ALR_87012301
This report can be used to display GL balances
GL
Finance
62
Document Journal at summary level 
Document Journal at line item level

S_ALR_87012287 
S_ALR_87012291
This report is useful to extract information of GL entries
GL
Finance
63
Statement of customer / vendor / GL Accounts
By company
GL Account 
Customer account 
Supplier Account
S_ALR_87012332
This report will give you statement of customer wise / Vendor wise / GL wise accounts
GL
Finance
64
Customer payment history

S_ALR_87012177
This report will help you to analyse history of customers. It contains a forecast of payment volumes and arrears.
AR
Finance
65
Due date analysis for customer open items

S_ALR_87012168

AR
Finance
66
Account receivable information system

S_ALR_87012167
The report is used for displaying the evaluations available in the customer information system.
AR
Finance
67
Customer balances

S_ALR_87012172
This report will give you balance at the period start, debit total & credit total for the reporting period and closing balance at the end of reporting period.
AR
Finance
68
Customer evaluation with open item sorted list
By Customer 
By Company
S_ALR_87012176
This report can give you open AR sorted in days bucket as per your selection
AR
Finance
69
Vendor information system
By company
By supplier
S_ALR_87012077
This report is used for displaying the vendor payment information based on due date, over due, currency etc.
AP
Finance
70
Vendor business
By company
By supplier
S_ALR_87012093
This report is to be used  when you want to see the information of purchases made from a supplier
AP
Finance
71
Due date analysis for supplier open items
By company
By supplier
S_ALR_87012078

AP
Finance
72
Vendor payment history
By company
By supplier
S_ALR_87012085
This report is used for determining the current payment status for vendors. The report carrry out an analysis of the vendor open items according to user defined time pattern.
AP
Finance
73
Check register
By bank 
By amount
S_P99_41000101
This report is used to extract the information of check issued
Bank
Finance
74
Asset History
By Asset 
By asset class 
By company code
S_ALR_87012075 
AR02
It is the most important and most coprehensive report for the year-end clsoing or for an interim financial statement
Asset
Finance
75
Depreciation simulation / forecast
By Asset 
By asset class 
By company code
S_ALR_87012936
This is a report for the simulation of future depreciation
Asset
Finance
76
Posted depreciation
By Asset 
By company code
S_P99_41000192
The report list the period values from posting depreciation
Asset
Finance
77
Year end income tax depreciation report
By Asset 
By company code
J1IQ

Asset
Finance
78
Asset Inventory list

S_ALR_87011981

Asset
Finance
79
Cost center accounting - Plan / Actual comparison
By Cost Center 
By cost center group
By version
S_ALR_87013611 
S_ALR_87013615 
S_ALR_87013620
This report lists actual and plan figures for cost center .
CCA
Controlling
80
Cost center accounting - Actual / Actual comparison
By Cost Center 
By cost center group
S_ALR_87013640
This report can be used to compare the actual costs on period basis
CCA
Controlling
81
Cost center plan
By cost center
KSBL
This report can be used to view cost center plan
CCA
Controlling
82
Analyse / compare product cost estmates
By plant 
By material number
S_P99_41000111 
S_ALR_87013047
This report can give you the information on standard cost of material
PC
Controlling
83
Profitability report
By sales order 
By material 
By plant
KE30
This report can give you profitability at the sales order level. However it is necessary to implement PA module
PA
Controlling
84
Profit center report

S_ALR_87010777 
S_ALR_87010779

PA
Controlling
85
Display machine list
By machine number 
By plant 
By status
IH08 
IW29 
IW33 
IW39
This report will give you the list of machines installed in the plant
Shop floor
Maintenance
86
MTTR / MTBR for machine
By machine number
MCJB 
MCJC
This report can be used for extracting information on Meant time to repair.
Shop floor
Maintenance
87
Damage analysis
By machine 
By damage code
MCI5
This report can be used to extract the information on damage analysis
Shop floor
Maintenance
88
Breakdown analysis
By machine 
By machine group
MCI7
This report can be used to extract the information on breakdown such as number of break down, MTTR, MTBF
Shop floor
Maintenance
89
Maintenance cost analysis
By machine 
By machine group
MCI8
This report will be used to extract information on planned cost and actual cost for different type of breakdown
Shop floor
Maintenance
90
Customer notification analysis

MCIA
This report can be used for reporting customer notifications. It can be used if service management functionality is put in use.
Service
Maintenance
91
History of inspection characteristics

QGP1
You can use this report to display inspection results for a task list characteristics
Quality
Quality Magt
92
Control Chart

QGC1 
QGC2 
QGC3
You can get quality control charts are lot level / characteristics level
Quality
Quality Magt
93
Quality Notification analysis

QM11 
QM15 
QM50

Quality
Quality Magt
94
Defect analysis report

MCXX 
MCVX 
MCOX
This report can be used to view quality defects at material / vendor / customer level
Quality
Quality Magt
95
Calliberation inspection

IP24 
IP19 
QA33
These reports can be used for extracting information related to calliberation of equipments
Quality
Quality Magt
96
Project cost / revenue / expenditure

S_ALR_87013531 
S_ALR_87013532
These reports gives you cost related information of projects. However it is necessary to implement Project systems module to extract these reports
Projects
Project System
97
Batch where used list

S_ALR_87012972
For extracting the information of batch traceability
Logistics
Logistics
98
Engineering change management

S_ALR_87012975 
S_ALR_87012976
For tracking engineering changes.
Logistics
Logistics
99
All Standard SAP Reports -- Module wise
Module wise
SAP1
Displays all the Standard report available in SAP in each module
Logistics
Logistics




Fonte: https://wiki.scn.sap.com/wiki/display/ERPLO/SAP+Standard+Reports