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