White Papers
Abstract
The Pack for SAP Applications is a complex component of IBM Infosphere Information Server. This article helps you start the development of DataStage SAP jobs with several predefined scenarios.
Content
- Introduction
- Importing the DS SAP Connection ER0_DEMO
- Importing the jobs
- BAPI job BAPI_USER_GETLIST
- IDOC Extract job IDOC_EXTRACT_MATMAS01
- IDOC Load job IDOC_Load_MATMAS01
- Delta Extract job DELTA_0MATERIAL_ATTR
- ABAP Extract job ABAP_MARA
- OData job OData_Join_API_PURCHASEORDER_PROCESS_SRV
Introduction
This article helps you start the development of DataStage SAP jobs with several predefined scenarios. The file attachment SAPPackStarterKit.zip contains:
1. The DS SAP Connection delivered in file ER0_DEMO.cxp
1. The DS SAP Connection delivered in file ER0_DEMO.cxp
2. The jobs delivered as DS job export SAPPackStarterKit.dsx. Jobs imported in DS Designer will be located in folder Jobs/SAPPackStarterKit.
Importing the DS SAP Connection ER0_DEMO
1. Import the connection in DS Admin for SAP. It includes the IDOC type definition MATMAS01.
Open DS Administrator for SAP; in DataStage Connections tab click Add/Import; select file ER0_DEMO.cxp
2. Edit the connection properties: Application Server, User, Password etc. Then press Add to test connection and add.
3. You may be prompted to confirm importing the IDOC type MATMAS01 definition. Click OK to confirm.
If prompted, select your SAP system version (or 700 if unsure) from the SAP Version dropdown and click OK to save.
Importing the jobs 
Open DataStage Designer; click Import/Datastage Components. Select the file SAPPackStarterKit.dsx
After import, confirm the jobs are located in folder Jobs/SAPPackStarterKit.
BAPI job BAPI_USER_GETLIST
Due to a known bug (Defect 279505), the user connection defaults are not automatically preserved in the job (Use connection defaults is not available in Stage/General/SAP Logon Details as it is for Delta and IDOC). If needed, enter them again on the Output/General tab. Then compile and run the job.
IDOC Extract job IDOC_EXTRACT_MATMAS01
Verify the connection details are present on the Stage/General tab (Use connection details is available in the IDOC stage, therefore all details should be
pre-populated from the connection settings). Compile and run the job.
IDOC Load job IDOC_LOAD_MATMAS01
Steps:
1. This job uses 3 input files (IDOC_C.txt, IDOC_S.txt, IDOC_D.txt for IDOC Control Record, Status and Data respectively). Copy them to a folder local to IS Engine tier (Datastage server).
2. Select Edit / Job properties / Parameters. Edit the default parameter value for FileInputPath and provide the folder used above (eg. C:\tmp). Click OK to save.
3. Verify the connection details are present on the Stage/General tab (Use connection details is available in the IDOC stage, therefore all details should be
pre-populated from the connection settings).
4. Compile and run the job. It should report in job log: IDoc_Load,0: Summary: 1 IDocs have been sent to SAP in 1 transactions
Delta Extract job DELTA_0MATERIAL_ATTR
Verify the connection details are present on the Stage/General tab (Use connection details is available in the Delta stage, therefore all details should be
pre-populated from the connection settings). Similarly with ABAP stage, there's a Validate stage option in the Stage/General tab, use it to check the settings.
Compile and run the job.
Compile and run the job.
ABAP Extract job ABAP_MARA
1. For ABAP, the user connection defaults are not automatically preserved in the job (Use connection defaults is not available - special security requirement for ABAP). Enter them again on the Output/General tab, section SAP Logon Details.
2. On the ABAP Program tab, click Generate Program; answer Yes when asked to load to SAP. Should get a confirmation the program has been uploaded.
3. On the Output/General tab click Validate. Make sure all checks are green:
4. Compile and run the job.
OData job OData_Join_API_PURCHASEORDER_PROCESS_SRV
This job joins 2 entity sets (parent/child) and uses job parameters for the connection information.
Edit the job properties and change the default parameters values. Then compile and run the job.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"Pack for SAP Applications","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"8.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 October 2019
UID
ibm10956477