SAP ABAP Table CRM_IUMD_ACCOUNT_QUERY (Attribute Structure for Generic Query Service IUMD_GEN_QUERY)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-IU-IC (Application Component) Utilities Industry: Interaction Center
     CRM_IU_IC_MD (Package) Utilities: IC WebClient - Identification & Master Data
Basic Data
Table Category INTTAB    Structure 
Structure CRM_IUMD_ACCOUNT_QUERY   Table Relationship Diagram
Short Description Attribute Structure for Generic Query Service IUMD_GEN_QUERY    
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 .INCLUDE       0   0   Attribute Structure for Generic Query Service IUMD_GEN_QUERY  
2 .INCLUDE       0   0   Search Parameter for IS-U Data Finder in R/3  
3 C_BUPART BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
4 C_MC_NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
5 C_MC_NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
6 C_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
7 C_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
8 C_POST_CO1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
9 C_POST_CO2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
10 C_POST_CO3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
11 C_PO_BOX_L AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
12 C_STREET AD_STREET TEXT60 CHAR 60   0   Street  
13 C_HOUSE_N1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
14 C_HOUSE_N2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
15 C_HOUSE_N3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
16 C_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
17 C_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
18 C_SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
19 C_SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
20 C_SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
21 C_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
22 C_TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
23 C_SOC_SECURE ECRM_ISU_SOC_SECU ECRM_ISU_SOC_SECU CHAR 12   0   Social Insurance Number  
24 C_DR_LICENSE ECRM_ISU_DR_LICENSE ECRM_ISU_DR_LICENSE CHAR 20   0   Driver's License Number  
25 C_WELFARE ECRM_ISU_WELFARE ECRM_ISU_WELFARE CHAR 9   0   Welfare Office  
26 C_BANK_ACCOUNT BANKN BANKN CHAR 18   0   Bank account number  
27 C_BANK_NUMBER BANKL BANKL CHAR 15   0   Bank number  
28 C_BANK_COUNTRY BANKS LAND1 CHAR 3   0   Bank country key *
29 C_TAXTYPE BPTAXTYPE BPTAXTYPE CHAR 4   0   Tax Number Category  
30 C_TAXNUM BPTAXNUM BPTAXNUM CHAR 20   0   Business Partner Tax Number  
31 A_VKONT ECRM_ISU_VKONT_KK ECRM_ISU_VKONT_KK CHAR 12   0   Contract Account Number  
32 A_ABWRE ECRM_ISU_ABWRE_KK BU_PARTNER CHAR 10   0   Alternative Payer *
33 A_ABWRA ECRM_ISU_ABWRA_KK BU_PARTNER CHAR 10   0   Different Payment Recipient *
34 A_ABWRH ECRM_ISU_ABWRH_KK BU_PARTNER CHAR 10   0   Alternative Bill Recipient *
35 A_ABWMA ECRM_ISU_ABWMA_KK BU_PARTNER CHAR 10   0   Alternative Dunning Recipient *
36 A_ABWVK ECRM_ISU_ABWVK_KK ECRM_ISU_VKONT_KK CHAR 12   0   Alternative Contract Account for Collective Bills  
37 A_VKONV ECRM_ISU_VKONV_KK ECRM_ISU_VKONT_KK CHAR 12   0   Contract Account Used for Payment Transactions  
38 V_VERTRAG ECRM_ISU_VERTRAG ECRM_ISU_VERTRAG CHAR 10   0   Contract  
39 V_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
40 V_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
41 V_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
42 C_OPBEL ECRM_ISU_ABPLANNR ECRM_ISU_ABPLANNR CHAR 12   0   Budget Billing Plan  
43 U_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
44 O_HAUS TPLNR TPLNR CHAR 30   0   Functional Location *
45 O_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
46 O_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
47 O_POST_CO1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
48 O_POST_CO2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
49 O_POST_CO3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
50 O_PO_BOX_L AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
51 O_STREET AD_STREET TEXT60 CHAR 60   0   Street  
52 O_HOUSE_N1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
53 O_HOUSE_N2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
54 O_HOUSE_N3 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
55 O_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
56 O_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
57 O_SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
58 O_SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
59 O_SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
60 O_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
61 P_VSTELLE ECRM_ISU_VSTELLE ECRM_ISU_VSTELLE CHAR 10   0   Premise  
62 P_HAUS_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
63 P_STR_ERG2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
64 P_STR_ERG4 AD_LCTN TEXT40 CHAR 40   0   Street 5  
65 P_FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
66 P_ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
67 P_EIGENT ECRM_ISU_GPARTNER BU_PARTNER CHAR 10   0   Owner *
68 I_ANLAGE ECRM_ISU_ANLAGE ECRM_ISU_ANLAGE CHAR 10   0   Installation  
69 I_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
70 I_AKLASSE ECRM_ISU_AKLASSE ECRM_ISU_AKLASSE CHAR 4   0   Billing Class  
71 I_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
72 I_POD ECRM_ISU_EXT_UI ECRM_ISU_EXT_UI CHAR 50   0   Point of Delivery ID  
73 I_POD_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
74 L_DEVLOC ECRM_ISU_DEVLOC TPLNR CHAR 30   0   Device Location *
75 L_STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object *
76 D_EQUNR CRM_ISU_EQUNR CRM_ISU_EQUNR CHAR 18   0   Equipment Number  
77 D_GERAET CRM_ISU_GERNR CRM_ISU_GERNR CHAR 18   0   Serial Number  
78 D_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
79 D_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
80 R_OPBEL ECRM_ISU_OPBEL_KK ECRM_ISU_OPBEL_KK CHAR 12   0   Contract Accounts Receivable and Payable Document Number  
81 R_DATE ECRM_ISU_BUDAT_KK DATUM DATS 8   0   Posting Date in the Document  
82 S_AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
83 S_ASTNR AUFASTNR AUFSTNR NUMC 2   0   Order status *
84 S_AUART AUFART AUFART CHAR 4   0   Order Type *
85 S_AUTYP AUFTYP AUFTYP NUMC 2   0   Order category  
86 S_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
87 M_AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
88 M_ASTNR AUFASTNR AUFSTNR NUMC 2   0   Order status *
89 M_QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
90 M_AUART AUFART AUFART CHAR 4   0   Order Type *
91 X_DATE ECRM_ISU_ECF_DATE DATUM DATS 8   0   Date Used in Finding Object  
92 X_BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
93 X_SPARTE CRM_ISU_SPARTE CRM_ISU_SPART CHAR 2   0   Division  
94 L_BY_DEVIC ECRM_ISU_ECF_BY_DEV CHAR1 CHAR 1   0   Search for Device Location via Device  
95 KEEPSEL ECRM_ISU_ECF_KEEP CHAR1 CHAR 1   0   Data Finder: Keep Selection  
96 SEARCHSTRING ECRM_ISU_SEARCHSTRING TEXT132 CHAR 132   0   Generic Search String in From of a User-Defined Field  
97 C_BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
98 C_BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
99 C_EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
100 V_DATE_TO     DATS 8   0    
101 SD_PONUMBER BSTKD_M CHAR35 CHAR 35   0   Customer PO number as matchcode field  
102 SD_VBELN VBELN VBELN CHAR 10   0   Sales and Distribution Document Number  
103 SD_VKORG VKORG VKORG CHAR 4   0   Sales Organization *
104 SD_AUART AUART AUART CHAR 4   0   Sales Document Type *
105 X_ALL_NATIONS     CHAR 1   0    
106 X_NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
107 J_DISCPROCV     CHAR 4   0    
108 J_DISCREASON CRM_ISU_DISCREASON CRM_ISU_DISCREASON CHAR 2   0   Disconnection Reason  
109 J_STATUS CRM_ISU_EDCDOCSTAT CRM_ISU_EDCDOCSTAT NUMC 2   0   Status of Disconnection Document  
110 J_ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
111 J_DISCNO CRM_ISU_DISCNO CRM_ISU_DISCNO CHAR 12   0   Disconnection Document Number  
112 C_BANK_IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
113 C_ID_TYPE BU_ID_TYPE BU_ID_TYPE CHAR 6   0   Identification Type *
114 C_ID_NUMBER BU_ID_NUMBER CHAR60 CHAR 60   0   Identification Number  
115 R_TOBRELEASD     CHAR 1   0    
116 X_ADDR_TYPE CRM_ISU_ADDR_TYPE CRM_ISU_ADDR_TYPE CHAR 1   0   Address Category for Search  
117 .INCLUDE       0   0   Help Structure for Generic Address Fields  
118 X_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
119 X_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
120 X_POST_CO1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
121 X_POST_CO2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
122 X_POST_CO3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
123 X_PO_BOX_L AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
124 X_STREET AD_STREET TEXT60 CHAR 60   0   Street  
125 X_HOUSE_N1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
126 X_HOUSE_N2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
127 X_HOUSE_N3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
128 X_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
129 X_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
130 X_USE_DEPENDENT CRM_ISU_USE_DEP_PREMISE FLAG CHAR 1   0   Include Identified Premise in Search  
History
Last changed by/on SAP  20130604 
SAP Release Created in 400