Amsted Rail: Sales [Open orders]

1. Amsted Rail

1.1. The leading global provider of systems and components for freight and transit railcars and locomotives.

1.2. Consultant assgn. Juan Carlos Crespo

1.2.1. juan.crespo@syntax.com

2. To Be

2.1. Direct view for User's consumption

2.2. SAP HANA technology

2.3. Replace | Improve actual ETL flow

2.4. Proposal for solution

2.4.1. Green field: Creation of query based on actual output

2.4.1.1. Based on actual output and technical doc. for constructing query

2.4.1.2. Ad-Hoc Calculation View

2.4.2. SDI - Recycle standard extractors delivered by SAP for SAP BW

2.4.2.1. ABAP

2.4.2.2. Initialize standard extractors

2.4.2.3. Identify structures (data model)

2.4.2.4. HANA artifacts: Joins, Union, etc highly probable needed

2.4.3. CDS views from business content

2.4.3.1. Already exposed on HANA

2.4.3.2. Flexible

2.4.3.3. Reusable

2.4.3.4. Ad-Hoc calculation view

2.4.3.5. Business Content

2.4.3.5.1. Consider / verify versioning of the CDS that could be considered in the solution

2.5. Estimated delivery time

2.5.1. May 24, 2023

3. Key Users

3.1. Paul Jones

3.1.1. Team lead and SAP specialist

3.2. Chuck Baisden

3.2.1. Manager and project sponsor

3.3. Collaboration channels

3.3.1. Teams

3.3.1.1. Amsted Rail channel

3.3.1.1.1. Not Sync with Syntax

3.3.1.2. Plan sheet

3.3.1.2.1. AR Teams Folder

3.3.2. Mail

3.3.2.1. Priority topics

3.3.3. Follow up

3.3.3.1. Daily

3.3.3.1.1. Meet

3.3.3.1.2. Stand up

3.3.3.2. EOW

3.3.3.2.1. Send report to AR key users

3.3.3.2.2. Syntax SNOW

4. Actual process

4.1. ETL: BO Data Services

4.1.1. Process mining: discovering ETL processes as they actually are

4.1.2. Black box as is now

4.1.3. Batch job | Night

4.2. Output: Datamart Open Orders

4.2.1. SQL View

4.2.2. Request script view if there are some conditions to consider

4.2.3. Fact Tables

4.2.4. On Time delivery table

4.2.4.1. Occurs every hour

4.2.5. Sales data mart

4.3. DB Engine: MS SQL Server