Activating and Installing Vistex DataSources
Activating Vistex datasources is similar to SAP standard datasources using the RSA5
transaction.
Generating a New Vistex Application Hierarchy
Before activating the datasources in transaction RSA5, the Vistex applications hierarchy
must be generated in RSA5 and RSA6 to prevent the Vistex datasources from being in the
UNASSIGNED node.
1. Access transaction /IRM/IPBWSPRO.
2. Select the BW Application Component Hierarchy node.
3. Execute Add Vistex Application Hierarchy Component to insert a Vistex application
into the hierarchy.
4. Execute Transaction Application Component Hierarchy to transfer the standard
application component hierarchy
NOTE: By executing this program, the CUSTOMER CUSTOM applications may be
assigned to NODESNOTCONNECTED. The CUSTOM nodes need to be manually
assigned back to the correct nodes again.
After performing the above procedure, all the Vistex datasources will be found under the
/IRM/VISTEX application component in RSA5 and RSA6.
Customizing or Enhancing Vistex DataSources
Use the transaction code LBWE to find the datasources that are under the /IRM/ application
component in the LO cockpit. Follow the standard procedure to customize or enhance the
datasources.
Running the Load Setup Programs
IMPORTANT: Before running the setup jobs, maintain the number ranges using transaction
SNRO. The number ranges need to be maintained separately in the ECC and BW systems.
Use the transaction /IRM/IPBWSPRO to run the following programs to load the setup tables:
Application Setup Program
Billbacks /IRM/MCIPBB_SETUP_LOAD
Chargebacks /IRM/MCIPCB_SETUP_LOAD
Sales Incentives /IRM/MCIPSI_SETUP_LOAD
Sales Rebates /IRM/MCIPCR_SETUP_LOAD
Purchasing Rebates /IRM/MCIPPR_SETUP_LOAD
Claims /IRM/MCGCR_SETUP_LOAD
Running the Delete Setup Programs
Use the transaction /IRM/IPBWSPRO to run the following programs to delete the setup
tables:
Application Delete Setup Program
Billbacks /IRM/MCIPBB_SETUP_DELETE
Chargebacks /IRM/MCIPCB_SETUP_DELETE
Sales Incentives /IRM/MCIPSI_SETUP_DELETE
Sales Rebates /IRM/MCIPCR_SETUP_DELETE
Purchasing Rebates /IRM/MCIPPR_SETUP_DELETE
Claims /IRM/MCGCR_SETUP_DELETE
NOTE: The standard transaction LBWG does not apply to the Vistex extractors to delete the
setup tables.
Running the Delta Programs
After the initialization takes place from BW, the following jobs need to be scheduled to
extract delta out of R/3. Use the transaction /IRM/IPBWSPRO to execute delta jobs.
Application Delta Program
Billbacks /IRM/MCIPBB_DELTA
Chargebacks /IRM/MCIPCB_DELTA
Sales Incentives /IRM/MCIPSI_DELTA
Sales Rebates /IRM/MCIPSI_DELTA
Purchasing Rebates /IRM/MCIPPR_DELTA
Claims /IRM/MCGCR_DELTA
Vistex Data Extractors
Vistex IP documents have two kinds of extractors: IP Standard Extractors and IP Log
Document Extractors. Both standard and log documents have the following standard
extractors:
Header
Item
Conditions
Standard IP Document Extractors
Application Structure Header Item Conditions
Extract
/IRM/H0BB /IRM/I0BB /IRM/K0BB
Billbacks Structures
DataSources /IRM/LIS_RM_IPBBHDR /IRM/LIS_RM_IPBBITM /IRM/LIS_RM_IPBBKON
Extract
/IRM/H0CB /IRM/I0CB /IRM/K0CB
Chargebacks Structures
DataSources /IRM/LIS_RM_IPCBHDR /IRM/LIS_RM_IPCBITM /IRM/LIS_RM_IPBCBKON
Extract
Sales /IRM/H0SI /IRM/I0SI /IRM/K0SI
Structures
Incentives
DataSources /IRM/LIS_RM_IPSIHDR /IRM/LIS_RM_IPSIITM /IRM/LIS_RM_IPSIKON
Extract
Sales /IRM/H0CR /IRM/I0CR /IRM/K0CR
Structures
Rebates
DataSources /IRM/LIS_RM_IPCRHDR /IRM/LIS_RM_IPCRITM /IRM/LIS_RM_IPCRKON
Extract
Purchasing /IRM/H0PR /IRM/I0PR /IRM/K0PR
Structures
Rebates
DataSources /IRM/LIS_RM_IPPRHDR /IRM/LIS_RM_IPPRITM /IRM/LIS_RM_IPPRKON
Extract
/IRM/H0GCR /IRM/I0GCR /IRM/K0GCR
Claims Structures
DataSources /IRM/LIS_RM_GCRHDR /IRM/LIS_RM_GCRITM /IRM/LIS_RM_GCRCON
IP Log Document Extractors
Application Structure Header Item Conditions
Extract
/IRM/H0BBL /IRM/I0BBL /IRM/K0BBL
Billbacks Structures
DataSources /IRM/LIS_RM_IPLBBHD /IRM/LIS_RM_IPLBBIT /IRM/LIS_RM_IPLBBKN
Extract
/IRM/H0CBL /IRM/I0CBL /IRM/K0CBL
Chargebacks Structures
DataSources /IRM/LIS_RM_IPLCBHD /IRM/LIS_RM_IPLCBIT /IRM/LIS_RM_IPLBCBKN
Extract
Sales /IRM/H0SIL /IRM/I0SIL /IRM/K0SIL
Structures
Incentives
DataSources /IRM/LIS_RM_IPLSIHD /IRM/LIS_RM_IPLSIIT /IRM/LIS_RM_IPLSIKN
Extract
/IRM/H0CRL /IRM/I0CRL /IRM/K0CRL
Sales Rebates Structures
DataSources /IRM/LIS_RM_IPLCRHD /IRM/LIS_RM_IPLCRIT /IRM/LIS_RM_IPLCRKN
Extract
Purchasing /IRM/H0PRL /IRM/I0PRL /IRM/K0PRL
Structures
Rebates
DataSources /IRM/LIS_RM_IPLPRHD /IRM/LIS_RM_IPLPRIT /IRM/LIS_RM_IPLPRKN
Extract /IRM/ESLIS_RM_IPLCP
/IRM/I0CPL /IRM/K0CPL
CMP Structures HD0002
DataSources /IRM/LIS_RM_IPLCPHD /IRM/LIS_RM_IPLCPIT /IRM/LIS_RM_IPLCPKN
Following are technical details of the IP Agreement datasources:
Agreement
Application Structure Attributes
Conditions
Extract
/IRM/K0BBASP /IRM/BBASP_ATTR
Billbacks Structures
DataSources /IRM/LIS_RM_IPBBASP /IRM/IPBBASP_ATTR/TEXT
Extract
/IRM/K0CBASP /IRM/CBASP_ATTR
Chargebacks Structures
DataSources /IRM/LIS_RM_IPCBASP /IRM/IPCBASP_ATTR/TEXT
Extract
/IRM/K0SIASP /IRM/SIASP_ATTR
Sales Incentives Structures
DataSources /IRM/LIS_RM_IPSIASP /IRM/IPSIASP_ATTR/TEXT
Extract
Sales Rebates /IRM/K0CRASP /IRM/CRASP_ATTR
Structures
DataSources /IRM/LIS_RM_IPCRASP /IRM/IPCRASP_ATTR/TEXT
Extract
Purchasing /IRM/K0PRASP /IRM/PRASP_ATTR
Structures
Rebates
DataSources /IRM/LIS_RM_IPPRASP /IRM/IPPRASP_ATTR/TEXT
Data Extractor Mechanisms
Vistex IP extractors work similar to standard SAP LO cockpit extractors that are delivered
for sales orders, deliveries, and billing. IP extractors can be enhanced in LBWE and RSA6
similar to standard SAP extractors. All the Vistex extractor data loads can be managed
through transaction code /IRM/IPBWSPRO instead of standard SBIW transaction. There are
provisions in this transaction to run setup jobs, delete setup data, and run delta programs
for each application.
The delta mechanism is different depending upon the type of data that is being extracted to
BW:
IP Standard and Claims
All the IP and Claims applications follow standard LO cockpit mechanism where the
delta needs to be extracted by running the corresponding delta program. After the
initialization and delta programs are run, the delta queue can be found in RSA7 or
LBWQ
Agreement Conditions
Delta for Agreement condition records work based on the change timestamp of the
agreement header data. For example, even if the one condition record changes or if
a status changes on the header of the agreement, the entire condition records for
that agreement are sent to BW. Since this is timestamp based, there are no before
and after records.
Agreement Attributes
Agreement master data datasources also work similar to agreement conditions based
on timestamp.
IP Log Extractors
Delta for Log Extractors work based on the timestamp field available in the Log
header tables for all the applications.
