AKNETIQ AcademyA common thread: the fictitious company SENTINEL SA
/n
GuidesProcessesPathsExamSign in
OUTILS
MODULE OUTILS

Cross-functional tools

In every department, the same question comes back: “how do I get this list out?”. And in every project: “how do we load these 20,000 lines?”. This module provides the tools that make you self-sufficient: ALV, tables, SQVI, SAP Query, LSMW, recordings, and the consultant's reflexes in customizing, on ECC 6 as on S/4HANA.

Audience
All key users (level 1), analysts and key users (level 2), functional consultants (level 3).
Prerequisites
Level 1: knowing how to navigate in SAP. Level 2: knowing a business module. Level 3: having done customizing for a module.
Duration
3 days (0.5 + 1.5 + 1)
21 h · day-by-day schedule
🔒 Members only

Extracting and loading data

This level is part of a higher offer.

See the offers

Chapters in this level

  1. SQVI: your first report in ten minutes · QuickViewer combines several tables without a line of code. It is the self-sufficiency tool.
  2. Understanding joins · A join is the same question as VLOOKUP in Excel, only more powerful.
  3. SE16H: count, total, join · A query with totals, without writing a line of code.
  4. SAP Query: the shared report · When a report must serve a whole team, it moves beyond the personal scope of SQVI.
  5. Which tool for which need? · The best tool is the simplest one that meets the need.
  6. LSMW: loading data in 14 steps · The Legacy System Migration Workbench reads a file, transforms it and feeds SAP without development.
  7. SHDB and SM35: record, replay, correct · The recording stores the screens and fields of a transaction. SM35 replays everything and keeps track of the errors.
  8. Mass changes · Correcting in series without going through a load.
Next level
Advanced — The consultant's toolbox
Continue →