Significance of Calendar in SAP- Logistics
Recently was involved in Retro-fit activity of Project where minor bug fixes/changes made at Support system, Transport request are copied and aligned to Development system of Project stream. This activity in basic sense performed to maintain consistency between Project and Support system landscape in terms of baseline Configuration and Business process. As a matter of fact, during this transport request release process to Development and Quality system of project stream, there were some or the other factory Calendar configuration overwritten for some plant and shipping point. The defect which we came across during Integration Test phase was good motivation to document this article and illustrate on relevancy of Calendar from logistics prospective.
Concept and relevancy at SAP:
Well the concept of Calendar is important and exhaustive in nature and Calendars in SAP are basically used to define the working days for plants/warehouses, shipping points. They are also in fact assigned to routes in logistics stream area or unloading points at Customers. For the accurate calculation of date, calendar in SAP have to be maintained & assigned correctly. For all exceptions requirement, an additional factory calendar might be necessary like for example if the production produces on all days, but shipping is done only on working days. Then the plant can have a different calendar than the shipping point.
In general synopsis, a calendar consists out of three basic elements which are clear identified below for reference and through SAP transaction “SCAL”, it is defined:
- Public Holidays – Definition of the public holidays are done with following type :
– with fixed date
– with a fixed day from date
– Distance to Easter
– Easter Sunday
– Floating Public Holiday
- Holiday calendar: This contain comprehensive list of all public holidays per country (e.g. Christmas).
- Factory calendar: This calendar defines in generic sense which days are working days. With ‘special rules’, workdays can be set as non-working days in the individual calendar. The factory calendar is defined on the basis of a public holiday calendar, weekdays that are working days must also be specified in this calendar.
Calendar is used in the following cases i.e. on the baseline of Organizational unit, Master Data and Transaction data of SAP:-
1. Organizational Unit
B:- Shipping points
C:- Transport planning points
D:- Route definitions in Logistics
E:- Sales organizations
F:- Company code
2. Master Data
A:- Unloading points in the customer master
B:- Invoice dates in the customer master (sales views)
3. Transactional Data
A:- SD Billing plan
B:- Process orders / planned orders
Impact of Calendar on Delivery scheduling :-
In the Organization unit i.e. Plant – factory calendar maintained has no influence on the delivery scheduling process. The calendar setup in the following area has impact on the delivery scheduling process:
Properties of delivery scheduling:
- Transit time : determined from the route – (factory) calendar assigned to route
- Loading time : determined from shipping point – shipping point calendar
- Pick and pack time : determined from shipping point or route – shipping point calendar
- Transportation planning time : determined from the route – (factory) calendar assigned to route
Let us take a simple example where Customer places Sales Order for 100 unit of Material and the requested delivery date indicated by customer as 10th March 2015.
The Delivery scheduling during Order creation is as follows :-
Specifics of standard Table of Calendar:
A:- TFACD: Factory calendar definition
B:- TFACS: Factory calendar (display)
C:- TFACT: Factory calendar texts
D:- THOC: Public Holiday Calendar
E:- THOCD: Public holiday definitions
F:- THOCI: Public holiday calendar index
E:- THOCS: Public holiday calendar (display)
F:- THOCT: Public holiday calendar texts
G:- TFAIN: Calendar: Intervals for company holidays, special shifts
H:- TFAIT: Calendar: Text for factory calendar intervals
Tables having factory calendar:
A:- KNVA: Customer Master Unloading Points
B:- KNVV: Customer Master Sales Data
C:- T001W: Plants
D:- TVRO: Routes
E:- TZBZ: Company code: Additional data
F:- TVST: Organizational Unit: Shipping Points
G:- TTDS: Organizational Unit: Transportation Scheduling Point
Special Note:- As the delivery and invoice creation jobs are scheduled based on the SAP calendar, it’s required to start these jobs manually on the last working day before holiday period.
Please feel free to share your thoughts, feedback or suggestion on this articulation!
PS :- Inference / Reference : –
Thank you for sharing. We have a scenario wherein the sales order was created on May 1, 2015 (Friday and Holiday) and the system automatically assigned the Delivery date on May 4, 2015 which is a Monday.
I tried assigning the custom calendar and assigned it to Sales Organization and it works.
Thanks and regards,
Well that indeed is a surprise! 😉 You can carefully check the Calendar assigned to Shipping Point and consider the transit time from Route and then arrive for a conclusion!
Thank you very much!
Just to add the to the use of Calendars; they can also be used in the Rebate Processing for Lump Sum Payments. Special Rules functionality is used.
My 2 cents. 🙂
Yes, Concept of Calendar in SAP is very extensively used across different process stream and this is one more example you have quoted for Rebate process. Well this article was very specific to use of Calendar is Logistics Process stream! 🙂 🙂