SAP ABAP Table CRMT_BW_SRV_IBASE_ATTR (BW Extraction Structure for CRM IBase Master Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ANA-EXT (Application Component) Extraction Technology
     ⤷ CRM_SERVICE_IBASE_BW (Package) Package for Objects for IBase Replication in BW

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_SRV_IBASE_ATTR	Table Relationship Diagram
Short Description	BW Extraction Structure for CRM IBase Master 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	IBASE_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
2	IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
3	IBTYP	☐	IB_IBTYP	IB_IBTYP	CHAR	2	0	IB: Installed Base Category	*
4	EXTID	☐	IB_EXTID	CHAR30	CHAR	30	0	IB: External Name/ID of Installed Base
5	HEADER_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
6	AUTHG	☐	IB_AUTHG	IB_AUTHG	CHAR	4	0	IBase: Authorization Group for IBase
7	IB_CRNAM	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
8	IB_CREATED_AT	☐	CRMT_INSTALLATION_CREATED_AT	DATUM	DATS	8	0	Installed Base Creation Date
9	IB_PTN_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
10	IB_PTN_NUM	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
11	IB_PARTNERSET_1	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
12	IB_PARTNERSET_2	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
13	IB_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
14	IB_STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
15	IB_HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
16	IB_POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	IB_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
18	IB_CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
19	IB_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
20	IB_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
21	IB_REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
22	IB_LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
23	IB_LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
24	IB_PRECIS	☐	GEOPRECIS	D_GEOPREC	NUMC	4	0	Precision (street, postal code, ...) of a Geo location
25	IB_COMP_NUMBER	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
26	IB_COMP_DEVI_ID	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
27	IB_COMP_OBJ_TYPE	☐	IB_OBJTYP_INSTANCE	IB_OBJTYP_INSTANCE	CHAR	4	0	IB: Object Type of Component Master Record
28	IB_COMP_REFOBJ	☐	CRMT_IB_COMP_GUID	SYSUUID_C	CHAR	32	0	IB: Component Assignment
29	IB_COMP_REFOB_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
30	IB_COMP_REFTYP	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
31	IB_COMP_OBJFAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
32	IB_COMP_LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
33	IB_COMP_MLANG	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
34	IB_COMP_SORTF	☐	IB_SORTF	CHAR10	CHAR	10	0	Sort string
35	IB_COMP_AMOUNT	☐	MENGV13	MENGV13	QUAN	13	3	Quantity field, length 13, with +/- sign
36	IB_COMP_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
37	IB_COMP_FLAG	☐	CRMT_IB_COMP_FLAG	CRMT_IB_COMP_FLAG	CHAR	1	0	Characteristics for Installed Base or Component
38	IB_COMP_DEL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
39	IB_COMP_PARENT	☐	IB_PARENT	IB_INSTANCE	NUMC	18	0	IB: Superior component
40	IB_COMP_ROOT	☐	IB_ROOT	IB_INSTANCE	NUMC	18	0	IB: Top-most component of an installed base/IBase
41	IB_COMP_PTGUID	☐	CRMT_IB_COMP_GUID	SYSUUID_C	CHAR	32	0	IB: Component Assignment

History

Last changed by/on	SAP	20130604
SAP Release Created in	400