After the installation of the EPO Connector and importing the ETL Workbench transports some customizing things must be done.
Please read the ETL Concept.
Setting up the number range for /EPO1/ETL
Transaction SNRO: Object /EPO1/ETL, Button "Interval editing"
Insert number range 00 with the broadest range possible: 0000000000000001 to 9999999999999999
Next Steps for EPO ETL
Depending on, if the EPO ETL Interface is SAP Inbound or SAP Outbound, the next steps are different.
In general there are 2 more customizing steps to be done:
- EPO Connector Customizing for interface functionality
- EPO ETL Customizing for data transfer options
Either see: EPO Connector ETL for SAP Inbound Calls
Or see: EPO Connector ETL for SAP Outbound Calls
ETL objects definition
Transaction SM30, table /EPO1/ETLOBJ defines the base properties of ETL objects. The 'Prefix Length' will be used in the SYNC - service (and checked against the actually used prefix).
| Object | ServiceDir | Max Len | Prefix Len | Key Prefix Description | Key Description | Object name |
|---|---|---|---|---|---|---|
| ETLAccount | I | 10 | 4 | Company Code | SKA1-SAKNR Account | ETL Account |
| ETLAsset | I | 16 | 4 | Company Code | ANLA- BUKRS ANLN1 ANLN2 | ETL Asset |
| ETLCoPost | I | 10 | 4 | KOKRS | CSKS-KOKRS CSKS-KOSTL | ETL Cost Centres |
| ETLCustmer | I | 10 | 4 | Company Code | KNB1-BUKRS, KNB1-KUNNR Customer | ETL Customer complete |
| ETLEqui | I | 18 | 4 | Company Code | EQUI-EQUNR equipment number | ETL Equipment |
| ETLFictr | I | 0 | 4 | FIKRS - Financial Managemt. Ar | FIKRS, FICTR | ETL Funds Center |
| ETLFuncLoc | I | 18 | 4 | Company Code | IFLOT-TPLNR functional location | ETL Functional Location |
| ETLKostl | I | 10 | 4 | KOKRS | CSKS-KOKRS CSKS-KOSTL | ETL Cost Centres |
| ETLMateria | I | 18 | 4 | Company Code | MARA-MATNR Material | ETL Material |
| ETLMatkl | I | 0 | 0 | MATKL | ETL Material class | |
| ETLOrgStru | I | 0 | 0 | Company Code | BUKRS | ETL Org. Structure |
| ETLPO | I | 18 | 4 | Company Code | EKKO-EBELN purchase order | ETL Room Number |
| ETLRaumn | I | 0 | 4 | WERKS - Plant | WERKS, RAUMN | ETL Standort |
| ETLStand | I | 0 | 4 | WERKS - Plant | WERKS, STAND | ETL Vendor |
| ETLVendor | I | 0 | 4 | Company Code | ETL Werks | |
| ETLWerks | I | 0 | 0 | WERKS |
Transaction SM30, table /EPO1/ETLOBJ_IN defines the object-specific function modules for GETDATA and SYNC - service. This remains true, unless the base class /EPO1/CL_ETL_USER_EXITS is redefined with another logic.
If the checkbox Fill Log is filled, a GETLIST request will fill the log table /EPO1/ETLLOG with the requested ETL keys.
| Object | GET DATA - FM | SYNC - FM |
|---|---|---|
| ETLAccount | /EPO1/ETL_ACCOUNT | /EPO1/ETL_ACCOUNT_SYNC |
| ETLAsset | /EPO1/ETL_ASSET | /EPO1/ETL_ASSET_SYNC |
| ETLCoPost | /EPO1/ETL_COPOSTING | /EPO1/ETL_COPOSTING_SYNC |
| ETLCustmer | /EPO1/ETL_CUSTOMER | /EPO1/ETL_CUSTOMER_SYNC |
| ETLEqui | /EPO1/ETL_EQUIPMENT | /EPO1/ETL_EQUIPMENT_SYNC |
| ETLFictr | /EPO1/ETL_FICTR | /EPO1/ETL_FICTR_SYNC |
| ETLFuncLoc | /EPO1/ETL_FUNCT_LOC | /EPO1/ETL_FUNCT_LOC_SYNC |
| ETLKostl | /EPO1/ETL_KOSTL | /EPO1/ETL_KOSTL_SYNC |
| ETLMateria | /EPO1/ETL_MATERIAL | /EPO1/ETL_MATERIAL_SYNC |
| ETLMatkl | /EPO1/ETL_MATKL | /EPO1/ETL_MATKL_SYNC |
| ETLOrgStru | /EPO1/ETL_ORGSTRUCT | /EPO1/ETL_ORGSTRUCT_SYNC |
| ETLPO | /EPO1/ETL_PO | /EPO1/ETL_PO_SYNC |
| ETLRaumn | /EPO1/ETL_RAUMN | /EPO1/ETL_RAUMN_SYNC |
| ETLStand | /EPO1/ETL_STAND | /EPO1/ETL_STAND_SYNC |
| ETLVendor | /EPO1/ETL_VENDOR | /EPO1/ETL_VENDOR_SYNC |
| ETLWerks | /EPO1/ETL_WERKS | /EPO1/ETL_WERKS_SYNC |