Show TOC

Category Texts (Multilevel Categorization) Locate this document in the navigation structure

DataSource Texts DataSource Texts: 0CRM_CAT_CATEGORY_TEXT

 

This DataSource is used to extract texts for categories used in applications that make use of Multilevel Categorization.

Technical Data

Application Component

0CRM_SERVICE-IO

Available as of Release

CRM 5.0

Shipment

NW 2004s

Content Versions

BI Content Add-On 2

RemoteCube-Capable

No

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

No

Prerequisites

  • The categories you want to upload texts for must be part of a hierarchy (categorization schema) that is assigned to at least one BW relevant application area. You can check the relevance of application areas to BW in Customizing for Customer Relationship Management under Start of the navigation path CRM Cross-Application Components Next navigation step Multilevel Categorization Next navigation step Define Application Areas for Categorization End of the navigation path.

  • The categorization schema must be deployed and the valid-from date must not be equal to the valid-to date.

Data Modeling

Delta Update

This DataSource uses the delta method After Images via Extractor (AIE) in combination with a generic delta, which is based on the timestamp TSTAMP_MODIFY.

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

ASP_ID

Multilevel Cat - Schema ID

CRMC_ERMS_CAT_AS

ASP_ID

ASP_VAL_FROM

Multilevel Cat - UTC Timestamp

CRMC_ERMS_CAT_AS

VAL_FROM

CAT_ID

Multilevel Cat - Category ID

CRMC_ERMS_CAT_CA

CAT_ID

CAT_LABEL

Multilevel Cat – Category Description

CRMC_ERMS_CAT_CD

CAT_LABEL

LANG

Language Key

CRMC_ERMS_CAT_CD

LANG

VALID_FROM_DATE

Valid From Date

VALID_TO_DATE

Valid To Date

-

TSTAMP_MODIFY

UTC Timestamp in Short Form (YYYYMMDDhhmmss)

CRMC_ERMS_CAT_AS

TSTAMP_MODIFY