Home / Course catalog / SAP Query Configuration (CFG302)


Get this course

Configuration

SAP Query Configuration (CFG302)


Description
This course teaches the basics of using the NLINK Query Connector to get data from tables and views in an SAP system from NLINK. The exercises are designed with the assumption that readers already possess general NLINK conceptual knowledge, and know how to navigate through the NLINK Configuration Module, NLINK Debug Module, and the NLINK Management Module. In addition, the reader should be somewhat familiar with SAP in general and know how to navigate the SAPGUI.
Content
  • Overview
  • Setup
  • Basic Requirements
  • Create a New NLINK Meta-Database
  • A Note about SAP Authorizations
  • Set up the NLINK to SAP Connection
  • EXERCISE 1: DOWNLOAD MATERIAL MASTER LIST FROM SAP
  • Exercise 1 Overview
  • 1.1 Create a New Transaction and Launch the SAP Query Wizard
  • 1.2 Wizard: Select External System
  • 1.3 Add SAP Tables for SAP Query Configuration
  • 1.4 Build Query Configuration Parameters
  • 1.4.1 Extend Query Configuration Parameters
  • 1.5 Map Selected Parameters and Fields to Workset Objects
  • 1.6 Specify Name and Actions Series Options
  • 1.7 Wizard Results
  • 1.8 Configuration Cleanup and Test
  • 1.9 Add an Event
  • 1.10 Test it!
  • 1.11 Look at the Results in the NDM
  • EXERCISE 1A: ADD A LOOP AND MODIFY THE DESCRIPTIONS
  • Exercise 1A Overview
  • 1A Step 1 - Add a Set Current Table Action
  • 1A Step 2 - Add a Loop Table Action
  • 1A Step 3 - Add a String Action
  • 1A Test the Change
  • EXERCISE 1B: REPORT THE NUMBER OF MATERIALS RETRIEVED
  • Exercise 1B Overview
  • 1B Step 1 - Add a Get Table Record Count Action
  • 1B Step 2 - Add a Log Message Action
  • 1B Step 3 - Add a Text Message Template
  • 1B Step 4 - Add the Log Message Action Parameters
  • 1B Test the Change
  • EXERCISE 1C: WRITE TO THE INTERFACE LOG
  • Exercise 1C Overview
  • 1C Step 1 - Add Set Interface Name & Log Action
  • 1C Step 2 - Modify the Log Message Action
  • 1C Test the Change
  • Exercise 1 Summary
  • EXERCISE 2: GET PURCHASE ORDER DATA
  • Exercise 2 Overview
  • 2.1 Create a New Transaction and Launch the SAP Query Wizard
  • 2.2 Add SAP Tables for SAP Query Configuration
  • 2.3 Build Query Configuration Parameters
  • 2.4 Configuration Cleanup
  • 2.5 Test it!
  • EXERCISE 2A: USING GROUP ACTIONS
  • Exercise 2A Overview
  • 2A Step 1 - Add a Set Current Table Action
  • 2A Step 2 - Add a Loop Table Action
  • 2A Step 3 - Add a Create Workset Group Action
  • 2A Step 4 - Complete Configuration and Test
Completion rules
  • All units must be completed
Back