SAP ABAP Table CRMT_IPMO_BEA_SF_DATA (IPM: Data Line for Smart Form OR Itemized Statement)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IM-IPM-RO (Application Component) Royalty Accounting
     ⤷ CRM_IPM_BEA_BASICS (Package) IPM: Objects for Billing Engine Applications

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IPMO_BEA_SF_DATA	Table Relationship Diagram
Short Description	IPM: Data Line for Smart Form OR Itemized Statement

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	BDI_GUID	☐	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
2	.INCLU-ACQ	☐				0	0	IPM BEA: Key Fields in a Transaction Item
3	LOGSYSACQ	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	TBDLS
4	OBJTYPEACQ	☐	OJ_NAME	OJ_NAME	CHAR	10	0	Object type	TOJTB
5	SRC_HEADNOACQ	☐	CRMT_IPM_BDC_OBJECT_REF	CRMT_IPM_BDC_OBJECT_REF	CHAR	18	0	Document Reference in Settlement Data Collector
6	SRC_ITEMNOACQ	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
7	.INCLU-ACQ	☐				0	0	IPM: Business Transaction Data for Smart Form
8	.INCLUDE	☐				0	0	Transfer Structure for Partners
9	REF_GUIDACQ	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
10	REF_HANDLEACQ	☐	CRMT_HANDLE		NUMC	10	0	Handle
11	REF_KINDACQ	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
12	.INCLUDE	☐				0	0	Logical Key for Identifying a Partner
13	REF_PARTNER_HANDLEACQ	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
14	REF_PARTNER_FCTACQ	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
15	REF_PARTNER_NOACQ	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
16	REF_NO_TYPEACQ	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
17	REF_DISPLAY_TYPEACQ	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
18	KIND_OF_ENTRYACQ	☐	CRMT_PARTNER_KIND_OF_ENTRY	CRM_PARTNER_KIND_OF_ENTRY	CHAR	1	0	Source of a partner in a transaction
19	.INCLUDE	☐				0	0	Externally Influenced Partner Data
20	.INCLUDE	☐				0	0	Identification Data for a Partner
21	PARTNER_FCTACQ	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
22	PARTNER_NOACQ	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
23	DISPLAY_TYPEACQ	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
24	NO_TYPEACQ	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
25	MAINPARTNERACQ	☐	CRMT_PARTNER_MAIN	CRM_BOOLEAN	CHAR	1	0	Main Partner (For Ambiguous Partner Functions)
26	RELATION_PARTNERACQ	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
27	.INCLUDE	☐				0	0	Address Data of a Partner
28	ADDR_NRACQ	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
29	ADDR_NPACQ	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
30	ADDR_TYPEACQ	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
31	ADDR_ORIGINACQ	☐	CRMT_ADDR_ORIGIN_MD	CRM_ADDR_ORIGIN_MD	CHAR	1	0	Origin of a Partner Address
32	STD_BP_ADDRESSACQ	☐	CRMT_PARTNER_STD_BP_ADDRESS	XFELD	CHAR	1	0	Standard Business Partner Address (Depending on Addr.Type)
33	ADDR_OPERATIONACQ	☐	BU_OPERATION	BU_OPERATION	CHAR	6	0	Transaction for BP Address Determination	*
34	.INCLUDE	☐				0	0	Common Attributes for all Partner Functions
35	CALENDARACQ	☐	CRMT_PARTNER_CALENDAR	CRM_BOOLEAN	CHAR	1	0	Maintain Calendar for the Partner?
36	DISABLEDACQ	☐	CRMT_PARTNER_DISABLED	CRM_BOOLEAN	CHAR	1	0	No INBOX Selection for the Partner
37	ERROR_FLAGACQ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	PARTNER_SRC_SYSACQ	☐	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
39	.INCLU--AP	☐				0	0	CRM Fields
40	.INCLUDE	☐				0	0	EEW Include
41	PARTNER_DUMMYACQ	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
42	COMP_PRD_DBACQ	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
43	BP_PARTNER_GUIDACQ	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
44	PARTNER_PFTACQ	☐	CRMT_PARTNER_PFT	COM_PARTNER_PFT	CHAR	4	0	Partner Function Category	*
45	PFT_SUBTYPEACQ	☐	CRMT_PARTNER_SUBTYPE	CHAR4	CHAR	4	0	Partner Function Sub-Type
46	PARTNER_GUIDACQ	☐	COMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
47	.INCLUDE	☐				0	0	GUID Integration of the Partner Set
48	GUIDACQ	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
49	CUST_ATTRIBUTESACQ	☐	COMT_PARTNER_CUST_ATTRIBUTES_T		TTYP	0	0
50	CUST_RELATIONSACQ	☐	COMT_PARTNER_CUST_RELATIONS_T		TTYP	0	0
51	COMPETITOR_PRODUCTSACQ	☐	COMT_PARTNER_COMP_PRD_T		TTYP	0	0
52	ATTRIBUTE_VALUESACQ	☐	COMT_PARTNER_ATTR		STRU	0	0
53	PARTNER_GUIDACQ	☐	COMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
54	COMT_ATTR_TERRITORYACQ	☐	COMT_ATTR_TERRITORY		STRU	0	0
55	PATH_GUIDACQ	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
56	PATH_IDACQ	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
57	COMT_ATTR_SCORINGACQ	☐	COMT_ATTR_SCORING		STRU	0	0
58	SCOREACQ	☐	CRMT_SCORE	CRM_SCORE	CHAR	10	0	Result Value of an Internal Creditworthiness Check
59	DATE_FROMACQ	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
60	DATE_TOACQ	☐	DATBI	DATUM	DATS	8	0	Valid To Date
61	.INCLUDE	☐				0	0	No usage flags for partner addresses
62	FLG_NOUSETELACQ	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
63	FLG_NOUSEMOBACQ	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
64	FLG_NOUSEFAXACQ	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
65	FLG_NOUSESMTACQ	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
66	FLG_NOUSEURIACQ	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
67	ADDR_CHANGEDACQ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
68	COUNTRYTELACQ	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
69	COUNTRYFAXACQ	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
70	COUNTRYMOBACQ	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
71	TELEPHONEMOBACQ	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
72	.INCLU-FRM	☐				0	0	IPM BEA: Key Fields for Time in a Transaction Item
73	DATEFRM	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
74	.INCLU-TO	☐				0	0	IPM BEA: Key Fields for Time in a Transaction Item
75	DATETO	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
76	.INCLUDE	☐				0	0	IPM BEA: Key Fields in a Transaction Item
77	LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	TBDLS
78	OBJTYPE	☐	OJ_NAME	OJ_NAME	CHAR	10	0	Object type	TOJTB
79	SRC_HEADNO	☐	CRMT_IPM_BDC_OBJECT_REF	CRMT_IPM_BDC_OBJECT_REF	CHAR	18	0	Document Reference in Settlement Data Collector
80	SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
81	.INCLUDE	☐				0	0	IPM: Business Transaction Data for Smart Form
82	.INCLUDE	☐				0	0	Transfer Structure for Partners
83	REF_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
84	REF_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
85	REF_KIND	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
86	.INCLUDE	☐				0	0	Logical Key for Identifying a Partner
87	REF_PARTNER_HANDLE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
88	REF_PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
89	REF_PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
90	REF_NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
91	REF_DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
92	KIND_OF_ENTRY	☐	CRMT_PARTNER_KIND_OF_ENTRY	CRM_PARTNER_KIND_OF_ENTRY	CHAR	1	0	Source of a partner in a transaction
93	.INCLUDE	☐				0	0	Externally Influenced Partner Data
94	.INCLUDE	☐				0	0	Identification Data for a Partner
95	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
96	PARTNER_NO	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
97	DISPLAY_TYPE	☐	CRMT_PARTNER_DISPLAY_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Object Type, for Which Partner Number is to be Shown
98	NO_TYPE	☐	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
99	MAINPARTNER	☐	CRMT_PARTNER_MAIN	CRM_BOOLEAN	CHAR	1	0	Main Partner (For Ambiguous Partner Functions)
100	RELATION_PARTNER	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
101	.INCLUDE	☐				0	0	Address Data of a Partner
102	ADDR_NR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
103	ADDR_NP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
104	ADDR_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
105	ADDR_ORIGIN	☐	CRMT_ADDR_ORIGIN_MD	CRM_ADDR_ORIGIN_MD	CHAR	1	0	Origin of a Partner Address
106	STD_BP_ADDRESS	☐	CRMT_PARTNER_STD_BP_ADDRESS	XFELD	CHAR	1	0	Standard Business Partner Address (Depending on Addr.Type)
107	ADDR_OPERATION	☐	BU_OPERATION	BU_OPERATION	CHAR	6	0	Transaction for BP Address Determination	*
108	.INCLUDE	☐				0	0	Common Attributes for all Partner Functions
109	CALENDAR	☐	CRMT_PARTNER_CALENDAR	CRM_BOOLEAN	CHAR	1	0	Maintain Calendar for the Partner?
110	DISABLED	☐	CRMT_PARTNER_DISABLED	CRM_BOOLEAN	CHAR	1	0	No INBOX Selection for the Partner
111	ERROR_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
112	PARTNER_SRC_SYS	☐	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
113	.INCLU--AP	☐				0	0	CRM Fields
114	.INCLUDE	☐				0	0	EEW Include
115	PARTNER_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
116	COMP_PRD_DB	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
117	BP_PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
118	PARTNER_PFT	☐	CRMT_PARTNER_PFT	COM_PARTNER_PFT	CHAR	4	0	Partner Function Category	*
119	PFT_SUBTYPE	☐	CRMT_PARTNER_SUBTYPE	CHAR4	CHAR	4	0	Partner Function Sub-Type
120	PARTNER_GUID	☐	COMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
121	.INCLUDE	☐				0	0	GUID Integration of the Partner Set
122	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
123	CUST_ATTRIBUTES	☐	COMT_PARTNER_CUST_ATTRIBUTES_T		TTYP	0	0
124	CUST_RELATIONS	☐	COMT_PARTNER_CUST_RELATIONS_T		TTYP	0	0
125	COMPETITOR_PRODUCTS	☐	COMT_PARTNER_COMP_PRD_T		TTYP	0	0
126	ATTRIBUTE_VALUES	☐	COMT_PARTNER_ATTR		STRU	0	0
127	PARTNER_GUID	☐	COMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
128	COMT_ATTR_TERRITORY	☐	COMT_ATTR_TERRITORY		STRU	0	0
129	PATH_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
130	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
131	COMT_ATTR_SCORING	☐	COMT_ATTR_SCORING		STRU	0	0
132	SCORE	☐	CRMT_SCORE	CRM_SCORE	CHAR	10	0	Result Value of an Internal Creditworthiness Check
133	DATE_FROM	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
134	DATE_TO	☐	DATBI	DATUM	DATS	8	0	Valid To Date
135	.INCLUDE	☐				0	0	No usage flags for partner addresses
136	FLG_NOUSETEL	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
137	FLG_NOUSEMOB	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
138	FLG_NOUSEFAX	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
139	FLG_NOUSESMT	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
140	FLG_NOUSEURI	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
141	ADDR_CHANGED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
142	COUNTRYTEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
143	COUNTRYFAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
144	COUNTRYMOB	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
145	TELEPHONEMOB	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
146	.INCLUDE	☐				0	0	IPM: Values from Data Collector for Smart Form
147	BILLED_AMOUNT	☐	CRMT_CUM_VALUE	CRM_COND_VALUE	CURR	19	2	Cumulative Value
148	BILLED_CURR	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_IPMO_BEA_SF_DATA	LOGSYS	TBDLS	LOGSYS	REF	1	CN
2	CRMT_IPMO_BEA_SF_DATA	LOGSYSACQ	TBDLS	LOGSYS	REF	1	CN
3	CRMT_IPMO_BEA_SF_DATA	OBJTYPE	TOJTB	NAME	REF	1	CN
4	CRMT_IPMO_BEA_SF_DATA	OBJTYPEACQ	TOJTB	NAME	REF	1	CN

History

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