Show TOC

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

DataSource Attributes DataSource Attributes: 0CRM_CAT_CATEGORY_ATTR

 

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

Technical Data

Application Component

0CRM_SERVICE-IO (Component ID)

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 attributes 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_GUID

Multilevel Cat - GUID data-element

CRMC_ERMS_CAT_CA

ASP_GUID

ASP_ID

Multilevel Cat - Schema ID

CRMC_ERMS_CAT_AS

ASP_ID

ASP_STATE

Schema Status

CRMC_ERMS_CAT_AS

ASP_STATE

ASP_VAL_FROM

Multilevel Cat - UTC Timestamp

CRMC_ERMS_CAT_AS

VAL_FROM

ASP_VAL_TO

Multilevel Cat - UTC Timestamp

CRMC_ERMS_CAT_AS

VAL_TO

CAT_GUID

Multilevel Cat - GUID data-element

CRMC_ERMS_CAT_CA

CAT_GUID

CAT_ID

Multilevel Cat - Category ID

CRMC_ERMS_CAT_CA

CAT_ID

CAT_ID_LEVEL_1

Multilevel Cat - Category ID

-

-

CAT_ID_LEVEL_2

Multilevel Cat - Category ID

—

—

CAT_ID_LEVEL_3

Multilevel Cat - Category ID

—

—

CAT_ID_LEVEL_4

Multilevel Cat - Category ID

—

—

CAT_ID_LEVEL_5

Multilevel Cat - Category ID

—

—

CAT_ID_LEVEL_6

Multilevel Cat - Category ID

—

-

CAT_ID_LEVEL_7

Multilevel Cat - Category ID

-

—

CAT_ID_LEVEL_8

Multilevel Cat - Category ID

-

—

CAT_ID_LEVEL_9

Multilevel Cat - Category ID

-

—

CAT_ID_LEVEL_10

Multilevel Cat - Category ID

-

—

SP_CATALOG

Catalog

-

—

SP_CODE

Code

—

—

SP_CODEGROUP

Code Group

-

—

TSTAMP_MODIFY

UTC Timestamp in Short Form (YYYYMMDDhhmmss)

CRMC_ERMS_CAT_AS

TSTAMP_MODIFY