: 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.
| Application Components | Master Data Customer Relationship Management (0CRM-IO) |
|---|---|
| Available as of Release | SAP CRM 5.0 |
| Shipment | NW 2004s BI Content Add-On 2 |
| Content Version | 700 |
| RemoteCube-Capable | No |
| Delta-Capable | Yes |
| Extraction from Archives | No |
| Verifiable | Yes |
Only master data, compare it directly to the data stored in the CRM master data tables.
| 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 |