SAP ABAP Table CRMT_IPM_BEA_BW_DS (Data Source for Billing Documents)

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_IPM_BEA_BW_DS	Table Relationship Diagram
Short Description	Data Source for Billing Documents

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	Data Source for Billing Documents
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	APPLICATION	☐	BEF_APPL	BEF_APPL	CHAR	4	0	Application	*
4	BDH_GUID	☐	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
5	BDI_GUID	☐	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
6	HEADNO_EXT	☐	BEA_HEADNO_EXT	BEA_HEADNO_EXT	CHAR	10	0	Billing Document
7	BILL_TYPE	☐	BEA_BILL_TYPE	BEA_BILL_TYPE	CHAR	4	0	Billing Type	*
8	BILL_DATE	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
9	REF_CURRENCY	☐	BEA_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
10	DOC_CURRENCY	☐	BEA_DOC_CURRENCY	WAERS	CUKY	5	0	Document Currency	*
11	REFERENCE_NO	☐	BEA_REFERENCE_NO	CHAR30	CHAR	30	0	Reference Number
12	TERMS_OF_PAYMENT	☐	BEA_TERMS_OF_PAYMENT	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
13	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
14	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
15	MAINT_DATE	☐	BEA_MAINT_DATE	SYDATS	DATS	8	0	Processing Date
16	MAINT_USER	☐	BEA_MAINT_USER	USERNAME	CHAR	12	0	Created/Last Changed By
17	RECORDMODE	☐	BEA_BW_RODMUPDMOD	BEA_BW_RODMUPDMOD	CHAR	1	0	BW Delta Process: Update Mode
18	ITEMNO_EXT	☐	BEA_ITEMNO_EXT	NUMC10	NUMC	10	0	Billing Item (External Identifier)
19	ITEM_CATEGORY	☐	BEA_ITEM_CATEGORY	BEA_ITEM_CATEGORY	CHAR	4	0	Billing Item Category	*
20	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
21	NET_VALUE	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
22	TAX_VALUE	☐	BEA_TAX_VALUE	WERTV8	CURR	15	2	Tax Amount in Document Currency
23	GROSS_VALUE	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
24	EXCHANGE_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
25	EXCHANGE_RATE	☐	BEA_EXCHANGE_RATE	BEA_EXCHANGE_RATE	DEC	9	5	Exchange Rate
26	EXCHANGE_DATE	☐	BEA_EXCHANGE_DATE	SYDATS	DATS	8	0	Conversion Date
27	REVERSAL	☐	BEA_REVERSAL	BEA_REVERSAL	CHAR	1	0	Reversal Indicator
28	IS_REVERSED	☐	BEA_IS_REVERSED	BEA_IS_REVERSED	CHAR	1	0	Flag: Billing Item Is Offset
29	BILL_ORG	☐	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
30	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
31	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
32	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
33	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
34	BEA_LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
35	SRC_HEADNO	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
36	SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
37	LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
38	OBJTYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
39	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
40	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Ship-to Party ID	*
41	BILL_TO_PARTY	☐	CRMT_BILL_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Bill-To Party ID	*
42	PAYER	☐	BEA_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
43	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
44	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
45	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
46	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
47	QUANTITY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
48	RENDERED_DATE	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
49	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
50	PRICING_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
51	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
52	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
53	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
54	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
55	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
56	NUM_OF_HEAD	☐	BEA_NUMBER_OF_H	INT4	INT4	10	0	Number of Billing Headers
57	NUM_OF_ITEM	☐	BEA_NUMBER_OF_I	INT4	INT4	10	0	Number of Billing Items
58	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
59	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
60	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
61	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
62	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
63	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
64	BILL_CATEGORY	☐	BEA_BILL_CATEGORY	BEA_BILL_CATEGORY	CHAR	1	0	Billing Category	*
65	SRC_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
66	PARTBILL_STAT	☐	BEA_PARTBILL_STAT	BEA_PARTBILL_STAT	CHAR	1	0	Partial Settlement Status of Settlement Item
67	BILL_RELEVANCE	☐	BEA_BILL_RELEVANCE	BEA_BILL_RELEVANCE	CHAR	1	0	Billing Relevance
68	CREDIT_DEBIT	☐	BEA_CREDIT_DEBIT	BEA_CREDIT_DEBIT	CHAR	1	0	Debit/Credit Indicator
69	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
70	FUND	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
71	FUNDS_PLAN	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
72	FUND_USAGE_ITEM	☐	CRM_FM_FU_ITEM_GUID	SYSUUID	RAW	16	0	TFM Fund Usage: Fund Usage Item Guid
73	PREPAYMENT_ITEM	☐	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
74	CLAIM_SUBMISSION	☐	CRMT_HEADER_GUID	SYSUUID	RAW	16	0	GUID for a CRM Document Header
75	INITIATIVE	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
76	CAMPAIGN	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
77	PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
78	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
79	TRADE_PROMOTION	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
80	SPEC_PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
81	TRANSFER_DATE	☐	BEA_TRANSFER_DATE	SYDATS	DATS	8	0	Value Date
82	ITEM_TYPE	☐	BEA_ITEM_TYPE	BEA_ITEM_TYPE	CHAR	1	0	Billing Document Item Type
83	TRANSFER_TYPE	☐	BEA_TRANSFER_TYPE	BEA_TRANSFER_TYPE	CHAR	1	0	Type of Integration to Follow-On Applications
84	VENDOR	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
85	TPOP_PLANT	☐	BEA_TPOP_PLANT	CRM_APO_LOCNO	CHAR	20	0	Plant for TPOP
86	TAX_EXEMPT_ID	☐	CRM_TAX_EXEMPT_ID	CRM_TAX_EXEMPT_ID	CHAR	30	0	Customer Tax Exemption Certificate ID
87	POINT_TYPE	☐	CRMT_MKTPL_LOY_POINT_CODE	CRM_MKTPL_LOY_POINT_CODE	CHAR	10	0	ID of Point Type
88	POINT_SPENT	☐	CRMT_LOY_POINTS_SPENT		DEC	10	2	Loyalty Points Spent
89	POINTS	☐	CRM_LOY_PT_POINT		DEC	10	2	Loyalty Point
90	DECISION_CODE	☐	CRMT_DECISION_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
91	DEFECT_CODE	☐	CRMT_DEFECT_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
92	P_LOGSYS	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
93	P_OBJTYPE	☐	BEA_OBJTYPE	BEA_OBJTYPE	CHAR	10	0	Object Type
94	P_SRC_HEADNO	☐	BEA_P_SRC_HEADNO	BEA_SRC_HEADNO_EXT	CHAR	10	0	Preceding Document Number
95	P_SRC_ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
96	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
97	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
98	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
99	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
100	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
101	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
102	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
103	SEPA_MNDID	☐	CRMT_MANDATE_ID	CRM_MANDATE_ID	CHAR	35	0	Unique Reference to Mandate per Payment Recipient
104	.INCLUDE	☐				0	0	IPM: Specific Fields for Incoming Royalties (BEA IPMI)
105	UPDG_ITEMNO	☐	CRMT_IPM_BEA_UPDG_ITEMNO	CRM_IPM_BEA_ITEMNO	NUMC	10	0	Update Groups Number
106	IS_CLEARING	☐	CRMT_IPM_BEA_IS_CLEARING	CRMT_IPM_BEA_IS_CLEARING	CHAR	1	0	Clearing Item
107	ACE_REL	☐	BEA_ACE_REL	BEA_BOOLEAN	CHAR	1	0	Relevant for Accrual Engine
108	DG_ITEMNO	☐	CRMT_IPM_BEA_DG_ITEMNO	CRM_IPM_BEA_ITEMNO	NUMC	10	0	Difference Group Number
109	.INCLU-IPM	☐				0	0	IPM: Reference to Contract
110	SRC_GUIDIPM	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
111	SRC_ITEM_GUIDIPM	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
112	SRC_OBJECT_IDIPM	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
113	SRC_ITEM_NUMBERIPM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
114	SRC_SUB_ITM_GUIDIPM	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
115	SRC_SUB_ITEM_NUMIPM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
116	SRC_PROCESS_TYPEIPM	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
117	SRC_ITM_GUIDIPM	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
118	SRC_OBJ_IDIPM	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
119	SRC_ITM_NUMIPM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
120	SRC_SI_GUIDIPM	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
121	SRC_SI_NUMIPM	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
122	SRC_PRCSTYPEIPM	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
123	.INCLUDE	☐				0	0	IPM: BILLPLAN_D Data for BW DataSources
124	REV_ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
125	GROUP1	☐	CRMT_GROUP1	CRMT_GROUP	CHAR	32	0	Group 1
126	GROUP2	☐	CRMT_GROUP2	CRMT_GROUP	CHAR	32	0	Group 2
127	GROUP3	☐	CRMT_GROUP3	CRMT_GROUP	CHAR	32	0	Group 3
128	GROUP4	☐	CRMT_GROUP4	CRMT_GROUP	CHAR	32	0	Group 4
129	GROUP5	☐	CRMT_GROUP5	CRMT_GROUP	CHAR	32	0	Group 5
130	GROUP6	☐	CRMT_GROUP6	CRMT_GROUP	CHAR	32	0	Group 6
131	GROUP7	☐	CRMT_GROUP7	CRMT_GROUP	CHAR	32	0	Group 7
132	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
133	.INCLU--AP	☐				0	0	IPM-BW: Append Structure for CRMT_IPM_BW_BILLPLAN_D (Add-On)
134	TITLE_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
135	REV_NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
136	.INCLUDE	☐				0	0	IPM: PARTNER Data for BW DataSources
137	BW_IPM_PARTNER01	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
138	BW_IPM_PARTNER02	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
139	BW_IPM_PARTNER03	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
140	BW_IPM_PARTNER04	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
141	BW_IPM_PARTNER05	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
142	BW_IPM_PARTNER06	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
143	BW_IPM_PARTNER07	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
144	BW_IPM_PARTNER08	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
145	BW_IPM_PARTNER09	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
146	BW_IPM_PARTNER10	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
147	BW_IPM_PARTNER11	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
148	BW_IPM_PARTNER12	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
149	BW_IPM_PARTNER13	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
150	BW_IPM_PARTNER14	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
151	BW_IPM_PARTNER15	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
152	.INCLUDE	☐				0	0	IPM: Revenue Distribution Values
153	REV_NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
154	REV_NET_VALUE_M	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
155	REV_NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
156	REV_GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
157	REV_TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
158	REV_SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
159	REV_SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
160	REV_SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
161	REV_SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
162	REV_SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
163	REV_SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
164	REV_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
165	REV_RSV_CREATED	☐	CRMT_IPM_BEA_RSV_CREATED	WERTV8	CURR	15	2	Reserve Created
166	REV_RSV_RELEASED	☐	CRMT_IPM_BEA_RSV_RELEASED	WERTV8	CURR	15	2	Released Reserve

History

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