Show TOC

BP: CRM Sales-Dependent Status with Template Locate this document in the navigation structure

: 0CRM_BP_STATUS_SALES_50

 

This DataSource extracts for the sales area dependent status of the business partner the respective blocking reason. The values directly maintained are extracted from table CRMM_BUT_FRG0100, the referenced values come from the mini-templates from table CRMC_BPMTSET0100.

Technical Data

Application Component

Master Data Customer Relationship Management (0CRM-IO)

Available as of Release

SAP CRM 5.0

Shipment

NW 2004s BI Content Add-On 2

Content Versions

700

RemoteCube-Capable

No

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

Yes

Data Modeling

Delta Update

Only master data, compare it directly to the data stored in the CRM master data tables.

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

CLIENT

Client

BUT000

CLIENT

PARTNER

Business Partner Number

BUT000

PARTNER

BIL_BLOCK_REASON

Business Partner (CRM): Billing Block Reason

CRMM_BUT_FRG0100 / CRMC_BPMTSET0100

BIL_BLOCK_REASON

DEL_BLOCK_REASON

Business Partner (CRM): Delivery Block Reason

CRMM_BUT_FRG0100 / CRMC_BPMTSET0100

DEL_BLOCK_REASON

ORD_BLOCK_REASON

Business Partner (CRM): Transaction Blocking Reason

CRMM_BUT_FRG0100 / CRMC_BPMTSET0100

ORD_BLOCK_REASON

PARTNER_GUID

Business Partner GUID

BUT000

PARTNER_GUID

SALES_ORG

Sales Organization

CRMM_BUT_FRG0100

SALES_ORG

CHANNEL

Distribution Channel

CRMM_BUT_FRG0100

CHANNEL

DIVISION

Division

CRMM_BUT_FRG0100

DIVISION