SAP ABAP Table CRM_ISU_HSS_DP_PARTNER_DATA (Free Text Search: Data Provider Business Partner Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-IU (Application Component) Utilities Industry
⤷ CRM_IU_HANA_S_ODATA (Package) Utilities: HANA Smart Search OData
⤷ CRM-IU (Application Component) Utilities Industry
⤷ CRM_IU_HANA_S_ODATA (Package) Utilities: HANA Smart Search OData
Basic Data
Table Category | INTTAB | Structure |
Structure | CRM_ISU_HSS_DP_PARTNER_DATA | Table Relationship Diagram |
Short Description | Free Text Search: Data Provider Business Partner Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
2 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider BP General Data | |||||
3 | ADDRNUMBER | CRM_ISU_HSS_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Free Text Search: Address Number | * | |
4 | ADDRESS_INFO | CRM_ISU_HSS_ADDR_FULL_INFO | STRG | 0 | 0 | Free Text Search: Address Full Information | |||
5 | DEF_ADDRNUMBER | CRM_ISU_HSS_DEF_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Free Text Search: Default Address Number | * | |
6 | DEF_ADDRESS_INFO | CRM_ISU_HSS_DEF_ADDR_FULL_INFO | STRG | 0 | 0 | Free Text Search: Default Address Full Information | |||
7 | NAME | CRM_ISU_HSS_BP_FULL_NAME | STRG | 0 | 0 | Free Text Search: Business Partner Full Name | |||
8 | DEF_LAND_TEL | CRM_ISU_HSS_DEF_LAND_TEL | STRG | 0 | 0 | Free Text Search: Default Landline Telephone | |||
9 | DEF_MOBILE_TEL | CRM_ISU_HSS_DEF_MOBILE_TEL | STRG | 0 | 0 | Free Text Search: Default Mobile Telephone | |||
10 | DEF_EMAIL | CRM_ISU_HSS_DEF_EMAIL | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Default Email | ||
11 | DEF_IND_LAND_TEL | CRM_ISU_HSS_DEF_IND_LAND_TEL | STRG | 0 | 0 | Free Text Search: Default Address-Independent Land Telephone | |||
12 | DEF_IND_MOBILE_TEL | CRM_ISU_HSS_DEF_IND_MOBILE_TEL | STRG | 0 | 0 | Free Text Search: Default Address-Independent Mobile Phone | |||
13 | DEF_IND_EMAIL | CRM_ISU_HSS_DEF_IND_EMAIL | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Default Address-Independent Email | ||
14 | BIRTH_DATE | CRM_ISU_HSS_BP_BIRTH_DATE | STRG | 0 | 0 | Free Text Search: Business Partner Birth Date | |||
15 | IDENTIFICATION | CRM_ISU_HSS_BP_IDENTIFICATION | STRG | 0 | 0 | Free Text Search: Business Partner Identification | |||
16 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Contact Data | |||||
17 | CONTACT_ID | CRM_ISU_HSS_CONTACT_ID | BU_PARTNER | CHAR | 10 | 0 | Free Text Search: Contact Person ID | * | |
18 | CONTACT_DEF_ADR_INFO | CRM_ISU_HSS_CONTACT_ADDR_INFO | STRG | 0 | 0 | Free Text Search: Contact Address Full Information | |||
19 | CONTACT_NAME | CRM_ISU_HSS_CONTACT_FULL_NAME | STRG | 0 | 0 | Free Text Search: Contact Full Name | |||
20 | CONTACT_DEF_LAND_TEL | CRM_ISU_HSS_CONTACT_DEF_L_TEL | STRG | 0 | 0 | Free Text Search: Contact Default Landline Telephone | |||
21 | CONTACT_DEF_MOBILE_TEL | CRM_ISU_HSS_CONTACT_DEF_M_TEL | STRG | 0 | 0 | Free Text Search: Contact Default Mobile Telephone | |||
22 | CONTACT_DEF_EMAIL | CRM_ISU_HSS_CONTACT_DEF_E | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Contact Default Email | ||
23 | CONTACT_DEF_IND_L_TEL | CRM_ISU_HSS_CONTACT_DEF_I_LTEL | STRG | 0 | 0 | Free Text Search: Contact Dflt Address-Independent Landline | |||
24 | CONTACT_DEF_IND_M_TEL | CRM_ISU_HSS_CONTACT_DEF_I_MTEL | STRG | 0 | 0 | Free Text Search: Contact Default Address-Independent Mobile | |||
25 | CONTACT_DEF_IND_EMAIL | CRM_ISU_HSS_CONTACT_DEF_I_E | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Contact Default Address-Independent Email | ||
26 | CONTACT_BIRTH_DATE | CRM_ISU_HSS_CONTACT_BIRTH_DATE | STRG | 0 | 0 | Free Text Search: Contact Birth Date | |||
27 | CONTACT_IDENTIFICATION | CRM_ISU_HSS_CONTACT_IDENT | STRG | 0 | 0 | Free Text Search: Contact Identification | |||
28 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Payer Data | |||||
29 | PAYER_ID | CRM_ISU_HSS_PAYER_ID | BU_PARTNER | CHAR | 10 | 0 | Free Text Search: Payer ID | * | |
30 | PAYER_DEF_ADR_INFO | CRM_ISU_HSS_PAYER_ADDR_INFO | STRG | 0 | 0 | Free Text Search: Payer Address Full Information | |||
31 | PAYER_NAME | CRM_ISU_HSS_PAYER_FULL_NAME | STRG | 0 | 0 | Free Text Search: Payer Full Name | |||
32 | PAYER_BIRTH_DATE | CRM_ISU_HSS_PAYER_BIRTH_DATE | STRG | 0 | 0 | Free Text Search: Payer Birth Date | |||
33 | PAYER_IDENTIFICATION | CRM_ISU_HSS_PAYER_IDENT | STRG | 0 | 0 | Free Text Search: Payer Identification | |||
34 | PAYER_DEF_LAND_TEL | CRM_ISU_HSS_PAYER_DEF_L_TEL | STRG | 0 | 0 | Free Text Search: Payer Default Landline Telephone | |||
35 | PAYER_DEF_MOBILE_TEL | CRM_ISU_HSS_PAYER_DEF_M_TEL | STRG | 0 | 0 | Free Text Search: Payer Default Mobile Telephone | |||
36 | PAYER_DEF_EMAIL | CRM_ISU_HSS_PAYER_DEF_E | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Payer Default Email | ||
37 | PAYER_DEF_IND_L_TEL | CRM_ISU_HSS_PAYER_DEF_I_LTEL | STRG | 0 | 0 | Free Text Search: Payer Default Address-Indpt Landline Tel. | |||
38 | PAYER_DEF_IND_M_TEL | CRM_ISU_HSS_PAYER_DEF_I_MTEL | STRG | 0 | 0 | Free Text Search: Payer Default Address-Independent Mobile | |||
39 | PAYER_DEF_IND_EMAIL | CRM_ISU_HSS_PAYER_DEF_I_E | AD_SMTPADR | CHAR | 241 | 0 | Free Text Search: Payer Default Address-Independent Email | ||
40 | PAYER_BUAG_ID | CRM_ISU_HSS_PAYER_BUAG_ID | CRMT_BUAG_ID | CHAR | 12 | 0 | Free Text Search: Payer Business Agr. ID | ||
41 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Business Agr. Data | |||||
42 | NUM_BUAG | CRM_ISU_HSS_NUMBER_OF_BUAG | STRG | 0 | 0 | Free Text Search: Number of Business Agreements | |||
43 | BUAG_INFO | CRM_ISU_HSS_BUAG_INFO | CRM_ISU_HSS_BP_INFO | STRG | 0 | 0 | Free Text Search: Business Agreement Information | ||
44 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Contract Data | |||||
45 | NUM_ACT_FUTURE_CONTRACT | CRM_ISU_HSS_NUMBER_OF_CONTRACT | STRG | 0 | 0 | Free Text Search: Number of Active and Future Contracts | |||
46 | CONTRACT_INFO | CRM_ISU_HSS_CONTRACT_INFO | CRM_ISU_HSS_BP_INFO | STRG | 0 | 0 | Free Text Search: Contract Information | ||
47 | ELEC_CONTRACT_INFO | CRM_ISU_HSS_CONTRACT_ELEC_INFO | CRM_ISU_HSS_BP_INFO | STRG | 0 | 0 | Free Text Search: Electricity Contract Information | ||
48 | GAS_CONTRACT_INFO | CRM_ISU_HSS_CONTRACT_GAS_INFO | CRM_ISU_HSS_BP_INFO | STRG | 0 | 0 | Free Text Search: Gas Contract Information | ||
49 | WATER_CONTRACT_INFO | CRM_ISU_HSS_CONTRACT_WAT_INFO | CRM_ISU_HSS_BP_INFO | STRG | 0 | 0 | Free Text Search: Water Contract Information | ||
50 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Interaction Data | |||||
51 | LAST_INT_DATE | CRM_ISU_HSS_INTER_LAST_DATE | STRG | 0 | 0 | Free Text Search: Last Interaction Date | |||
52 | LAST_INT_REASON_TXT | CRM_ISU_HSS_INTER_LAST_REASON | STRG | 0 | 0 | Free Text Search: Last Interaction Reason | |||
53 | LAST_INT_DESCR | CRM_ISU_HSS_INTER_LAST_DESCR | STRG | 0 | 0 | Free Text Search: Last Interaction Description | |||
54 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider FICA Data | |||||
55 | PARTNER_AMOUNT_DUE | CRM_ISU_HSS_BP_AMOUNT_DUE | STRG | 0 | 0 | Free Text Search: Business Partner Amount Due | |||
56 | PARTNER_AMOUNT_OPEN | CRM_ISU_HSS_BP_AMOUNT_OPEN | STRG | 0 | 0 | Free Text Search: Business Partner Amount Open | |||
57 | LAST_INV_NUMBER | CRM_ISU_HSS_INV_NUMBER | STRG | 0 | 0 | Free Text Search: Last Invoice Number | |||
58 | LAST_INV_POST_DATE | CRM_ISU_HSS_INV_POST_DATE | STRG | 0 | 0 | Free Text Search: Last Invoice Posting Date | |||
59 | LAST_INV_DUE_DATE | CRM_ISU_HSS_INV_DUE_DATE | STRG | 0 | 0 | Free Text Search: Last Invoice Due Date | |||
60 | LAST_INV_AMOUNT | CRM_ISU_HSS_INV_AMOUNT | STRG | 0 | 0 | Free Text Search: Last Invoice Amount and Currency | |||
61 | LAST_INV_BUAG_ID | CRM_ISU_HSS_INV_BUAG_ID | STRG | 0 | 0 | Free Text Search: Last Invoice Business Agreement | |||
62 | LAST_INV_RATE_CAT | CRM_ISU_HSS_INV_RATE_CATEGORY | STRG | 0 | 0 | Free Text Search: Last Invoice Rate Category | |||
63 | LAST_INV_RATE | CRM_ISU_HSS_INV_RATE | STRG | 0 | 0 | Free Text Search: Last Invoice Rate | |||
64 | LAST_INV_STATUS_TXT | CRM_ISU_HSS_INV_STATUS_TEXT | STRG | 0 | 0 | Free Text Search: Last Invoice Status Text | |||
65 | .INCLUDE | 0 | 0 | Free Text Search: Data Provider Open Issues | |||||
66 | NUM_OPEN_SERV_ORDER | CRM_ISU_HSS_NUMBER_OF_SERV_ORD | STRG | 0 | 0 | Free Text Search: Number of Service Orders | |||
67 | NUM_OPEN_SERV_NOTIF | CRM_ISU_HSS_NUMBER_OF_SERV_NOT | STRG | 0 | 0 | Free Text Search: Number of Service Notifications | |||
68 | NUM_OPEN_CASE | CRM_ISU_HSS_NUMBER_OF_CASE | STRG | 0 | 0 | Free Text Search: Number of Cases | |||
69 | NUM_OPEN_DISCON | CRM_ISU_HSS_NUMBER_OF_DISCON | STRG | 0 | 0 | Free Text Search: Number of Disconnections | |||
70 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in |