Setting Up DataSources for Category Value Extraction 

Procedure

1. Creating DataSources for Category Extraction

 

       1.      Use the parameters listed below to extract categories in CAF. These mechanisms are similar to those used for extracting information from entity services.

○       Method to access categories: findByMultipleParameters

○       Entity service: sap.com/caf.tc/CategoryService

○       CAF_BW_DATASOURCE_NAME_PREFIX: E41

○       DataSource: E41CategorycaftcfindByMultiple

Since this DataSource is based on an entity service, delta load is supported.

       2.      Use the information in the following table to structure the DataSource:

Name	Description	SQL Type	Length
KEY	Category key	VARCHAR	36
CREATEDBY	Created by	VARCHAR	60
CREATEDAT	Created at	VARCHAR	30
LASTCHANGEDBY	Last changed by	VARCHAR	60
LASTCHANGEDAT	Last changed at	VARCHAR	30
ID	Category ID	VARCHAR	60
NAME	Category name	VARCHAR	60
DESCRIPTION	Category description	VARHAR	60
SAVEDRID	Saved category RID	VARCHAR	60
RECORDMODE	Technical field for generic extractor	VARCHAR	1

2. Creating DataSources for Category Value Extraction

 

       1.      Use the parameters listed below to extract categories in CAF. These mechanisms are similar to those used for extracting information from entity services.

○       Method to access categories: findByMultipleParameters

○       Entity service: sap.com/caf.tc/CategoryService

○       CAF_BW_DATASOURCE_NAME_PREFIX: E41

○       DataSource: E41CategoryValuecaftcfindByMult

DataSource name was shortened to 30 characters.

       2.      Use the information in the table in the section above to structure the DataSource.