SAP ABAP View CRMV_BUT_FRG0040 (BW Extraction: CRM Sales Classification)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-BP (Application Component) Business Partners
⤷ CRM_BUPA_EXT_FRG (Package) CRM BP Extraction BW for Business Partner (CRM Enhancements)
⤷ CRM-MD-BP (Application Component) Business Partners
⤷ CRM_BUPA_EXT_FRG (Package) CRM BP Extraction BW for Business Partner (CRM Enhancements)
Basic Data
View Type | D | Database View |
Database View | CRMV_BUT_FRG0040 | |
Short Description | BW Extraction: CRM Sales Classification | |
Root table | BUT000 | BP: General data I |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | BUT000 | BUT000 | ||
2 | CRMM_BUT_FRG0041 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | BUT000 | CLIENT | JL | EQ | 0 | 0 | ||||
2 | CRMM_BUT_FRG0041 | CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | BUT000 | PARTNER_GUID | JL | EQ | 0 | 0 | ||||
4 | CRMM_BUT_FRG0041 | PARTNER_GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | CLIENT | BUT000 | CLIENT | MANDT | Client | |||
2 | PARTNER | BUT000 | PARTNER | BU_PARTNER | Business Partner Number | |||
3 | PARTNER_GUID | BUT000 | PARTNER_GUID | BU_PARTNER_GUID | Business Partner GUID | |||
4 | TYPE | BUT000 | TYPE | BU_TYPE | Business partner category | |||
5 | IS_COMPETITOR | CRMM_BUT_FRG0041 | IS_COMPETITOR | CRMT_BU_IS_COMPETITOR | Indicator: Business partner is competitor | |||
6 | IS_PROSPECT | CRMM_BUT_FRG0041 | IS_PROSPECT | CRMT_BU_IS_PROSPECT | Indicator: Business partner is a prospect | |||
7 | IS_CONSUMER | CRMM_BUT_FRG0041 | IS_CONSUMER | CRMT_BU_IS_CONSUMER | Indicator: Business partner is consumer | |||
8 | IS_CUSTOMER | CRMM_BUT_FRG0041 | IS_CUSTOMER | CRMT_BU_IS_CUSTOMER | Indicator: Business partner is customer | |||
9 | CUSTOMER_SINCE | CRMM_BUT_FRG0041 | CUSTOMER_SINCE | CRMT_CUSTOMER_SINCE | Customer Since Date | |||
10 | IS_COD_CUSTOMER | CRMM_BUT_FRG0041 | IS_COD_CUSTOMER | CRMT_BU_IS_COD_CUSTOMER | Indicator: Business partner is cash on delivery customer | |||
11 | INDUSTRY | CRMM_BUT_FRG0041 | INDUSTRY | CRMT_INDUSTRY | Industry Sector | |||
12 | IS_RENTED | CRMM_BUT_FRG0041 | IS_RENTED | CRMT_BU_IS_RENTED | Indicator: Rented Address | |||
13 | ACCOUNT_GROUP | CRMM_BUT_FRG0041 | ACCOUNT_GROUP | CRMT_BU_ACCOUNT_GROUP | R/3 Account Group | |||
14 | NIELSEN_ID | CRMM_BUT_FRG0041 | NIELSEN_ID | CRMT_BU_NIELSEN_ID | Nielsen ID | |||
15 | CLASSIFIC | CRMM_BUT_FRG0041 | CLASSIFIC | CRMT_BU_CUST_CLASSIFIC | Customer Classification | |||
16 | ATTRIBUTE | CRMM_BUT_FRG0041 | ATTRIBUTE | CRMT_BU_KATR1 | Attribute 1 | |||
17 | ATTRIB_2 | CRMM_BUT_FRG0041 | ATTRIB_2 | CRMT_BU_KATR2 | Attribute 2 | |||
18 | ATTRIB_3 | CRMM_BUT_FRG0041 | ATTRIB_3 | CRMT_BU_KATR3 | Attribute 3 | |||
19 | ATTRIB_4 | CRMM_BUT_FRG0041 | ATTRIB_4 | CRMT_BU_KATR4 | Attribute 4 | |||
20 | ATTRIB_5 | CRMM_BUT_FRG0041 | ATTRIB_5 | CRMT_BU_KATR5 | Attribute 5 | |||
21 | ATTRIB_6 | CRMM_BUT_FRG0041 | ATTRIB_6 | CRMT_BU_KATR6 | Attribute 6 | |||
22 | ATTRIB_7 | CRMM_BUT_FRG0041 | ATTRIB_7 | CRMT_BU_KATR7 | Attribute 7 | |||
23 | ATTRIB_8 | CRMM_BUT_FRG0041 | ATTRIB_8 | CRMT_BU_KATR8 | Attribute 8 | |||
24 | ATTRIB_9 | CRMM_BUT_FRG0041 | ATTRIB_9 | CRMT_BU_KATR9 | Attribute 9 | |||
25 | ATTRIB_10 | CRMM_BUT_FRG0041 | ATTRIB_10 | CRMT_BU_KATR10 | Attribute 10 | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 20B |