SAP Data Analysis for Sales Documents and More

Name: SAP Data Analysis for Sales Documents and More
Rating: 4.5 (82 reviews)

A guide for becoming an expert at analyzing SAP table data for troubleshooting, reporting, project planning, & more.

Last updated 2/2020

English

English [Auto],

What you'll learn

By the end of this course you'll have a great understanding of data entities used in the SAP ECC sales order process, their relationships, and usage.
You'll have a good understanding of many tools involved in analysis and be able to apply this to other processes in SAP as well.
You'll be able to map data from the business object to the table fields.
You'll be able to query the table data, filter, sort, etc... so that you can present the data meaningfully.
You'll be able to use data analysis to assist in troubleshooting application issues.
You'll be ready to help the business blue-print and design new functionality and identify impacts and relationships to existing data.
You'll be able to identify data needed to help cover existing reporting gaps & Much more!

9 sections • 30 lectures • 3h 40m total length

Data Analysis Course - Welcome & Introduction6:02
Begin the SAP data analysis course by exploring how data analysis centers on the sales order, examining tables, data models, and ad hoc methods to troubleshoot and analyze sales documents.

Sales Document Business Object Introduction & Overview for Data Analysis1:53
Introduction to the sales document business object
Sales Document Access and Navigation Overview6:23
Access and navigate a sales order in SAP GUI using logistics sales and distribution menus to create, change, and display and review header and item data via overview tabs.
Review Sales Order Main Screens: Header10:48
Navigate the sales order header across tabs, focusing on order type, sales area, document and create dates, currency, pricing, shipping and billing data for analysis.
Review Sales Document Screens: Line Items & Schedule Lines15:31
Overview of Document Flow, Status Overview and other data5:25
Explore document flow and status overview for sales orders, tracing from contract or quote to delivery, billing, accounting, returns, and credits, with a focus on table-based data analysis.
Sales Order logical data setup1:55
Bridge the gap between sales documents and table analysis by examining a data-centric diagram of orders, headers, items, schedules, document flow, and pricing.

Table Overview Introduction0:56
Explore the data dictionary and core tables used in sales order analysis, including vibha, bop, bep, vb, kaytee, vba, conn, and bfa in vienna, to understand data structure.
Access & Navigation: Data Dictionary & Object Navigator9:15
Access the SAP data dictionary with SE11 and SE84 to analyze tables, fields, domains, and views. Learn display-focused navigation for sales document data and cross-table field usage.
SO Data Analysis Tables: Header, Line Items, & Schedule Lines9:16
SO Data Analysis Tables: Business Data Table1:58
SO Data Analysis Table: Pricing Table5:07
Explore the SO data analysis table for pricing within SAP, detailing how sales documents link to pricing conditions via condition numbers, applications, types, dates, currency, and inactive statuses.
SO Data Analysis Tables: Document Flow, Contracts , & Status11:51
Explore how to analyze sales documents using the document flow table, contract data, and status tables to link preceding and subsequent documents and assess item and header statuses.

Data Model Overview, Access & Navigation6:20
Explore the SAP data model for sales objects by navigating the SD 11 data modeler, viewing business objects like sales orders, and comparing application and SFP architecture views.
Sales Order Data Model: Usage7:49
Explore the sales order data model, its hierarchy and sub-objects, and navigate the graphics, data dictionary, and attributes to see tables and one-to-many relationships from header to items.

Table Data Analysis Introduction1:21
Learn basic table data analysis for sales documents by accessing data, applying selection criteria, and interpreting online outputs to make sense of large data sets, with offline options.
Data Browser: Access & Overview5:39
This lecture focuses on the original Data Browser
New Data Browser Overview: Access, Navigation & Usage13:45
New Data Browser Output Overview10:57
Explore the data browser output, apply selection filters, sort, search, and drill into records, and export to Excel or local files for analysis of sales documents.
Multiple Table with Spreadsheet example12:22
More complex analysis using the sales document table data with pricing data and exporting the results to excel for more advanced spreadsheet analysis
Data Analaysis: Customer Business Partner and Address Example4:37
You'll understand the link between the sales order business partner and the partner address details
SO Data Analysis for Document Status10:34
Analyze document status in SAP sales orders using header and item statuses, and status tables. Examine document flow to identify credit holds, incompletes, and completions.
SO Data Analysis on Document Changes11:02
Explore sales order changes with the header and item CD HDR and CD Pause tables, tracking who changed what and when, and viewing old versus new values.
SO Data Analysis for Document Texts10:47

Get strong understanding about performing a data analysis in SAP ECC Sales Document processing.

This will include

Sales Order object reviews of header, line item, partner, business data, conditions, and more.
Data Dictionary Table Overviews
Mapping application fields to table fields
Data Modeler Overview and usage
Table Display & Data Browser
Advanced Data Dictionary usage
Data Query usage
Examples & exercises and common requests across the objects to be used in analysis
Recommendations on analysis
How to Apply your skills on this data model as well as other data models.

There will be significant time spent in the system.

Most subjects are introduced and then the majority of the time is spent going through the steps in the system.
Students can follow along or watch and then try similar steps in their system.

Why take this course

You want to obtain a better understanding of how to analyze the data used in SAP ECC applications.
You need a better understanding of the application data before you can move from system user to system super user.
You're a consultant or new employee who's looking to hit the ground running on your project and make a bigger positive impact quicker.
A Business or IT manager looking to analyze system data and make recommendations for projects and other department planning items.
Keep coming back for more and more examples.

Thank you for considering this course. This has been my favorite course to put together so far!