SAP ABAP Table CRMT_EDR_WRK (WRK for EDRs)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IT-BI (Application Component) Integration to Billing System
     ⤷ CRM_EDR (Package) CRM 5.1 Telco : Package for FSCM -Line Item Dispute EDR

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_EDR_WRK	Table Relationship Diagram
Short Description	WRK for EDRs

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	EDR: Key Fields
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	EDR_GUID	☐	CRMT_EDR_GUID	SYSUUID	RAW	16	0	GUID of Event Detail Record
4	.INCLUDE	☐				0	0	EDR: Structure of System Fields
5	EDR_ID	☐	CRMT_EDR_ID	CRM_EDR_ID	CHAR	32	0	ID of Event Detail Record
6	EDR_TYPE	☐	CRMT_EDR_TYPE	CRM_EDR_TYPE	CHAR	4	0	Type of Billing Detail Record	*
7	EDR_CREATE_DATE	☐	CRMT_EDR_CREATE_DATE	BCOS_TSTMP	DEC	15	0	Creation Date and Time of Event Detail Record
8	EDR_LOAD_DATE	☐	CRMT_EDR_LOAD_DATE	BCOS_TSTMP	DEC	15	0	Load Date and Time of Event Detail Record
9	REF_GUID_INDOB	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
10	REF_DOC_GUID	☐	CRMT_EDR_REF_DOC_GUID	SYSUUID	RAW	16	0	Reference to CRMB Billing Document GUID
11	REF_DOC_KIND	☐	CRMT_EDR_REF_DOC_KIND	CRM_EDR_REF_DOC_KIND	CHAR	1	0	CRMB Billing Document Kind
12	CONTRACT_ID	☐	CRMT_EDR_EXT_REF	CRMT_EDR_EXT_REF	CHAR	20	0	IST Contract Number
13	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
14	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
15	AMOUNT	☐	CRMT_EDR_BILL_AMT	CRM_EDR_BILL_AMT	CURR	15	2	Value
16	CURRENCY	☐	CRMT_EDR_CURR	WAERS	CUKY	5	0	Currency	*
17	NET_GROSS	☐	CRMT_EDR_NET_GROSS	CRM_EDR_NET_GROSS	CHAR	1	0	Value Is Net or Gross
18	USAGE_QUANTITY	☐	CRMT_EDR_USAGE_QTY	CRM_EDR_USAGE_QTY	QUAN	13	3	Usage Quantity
19	UNIT_OF_USAGE	☐	CRMT_EDR_USAGE_UNIT	MEINS	UNIT	3	0	Unit of Usage	*
20	TAX_AMOUNT	☐	CRMT_EDR_TAX_AMT	CRM_EDR_TAX_AMT	CURR	15	2	Tax Amount
21	EDR_SOURCE_SYS	☐	CRMT_EDR_SOURCE_SYS	LOGSYS	CHAR	10	0	External System Where EDR Was Created	*
22	DISPUTED	☐	CRMT_EDR_DISPUTED	XFELD	CHAR	1	0	Disputed EDR
23	EDR_DESCRIPTION	☐	CRMT_EDR_DESCRIPTION	CRM_EDR_DESCRIPTION	CHAR	100	0	EDR Description
24	ARCHIVING_STATUS	☐	CRMT_EDR_ARCHIVE_STATUS	CRM_EDR_ARCHIVE_STATUS	CHAR	1	0	Archiving Status
25	VERIFY_DATE	☐	CRMT_EDR_VERIFY_DATE	BCOS_TSTMP	DEC	15	0	Verify Date
26	EDR_STATUS	☐	CRMT_EDR_STATUS	CRMT_EDR_STATUS	CHAR	2	0	Shows the status of EDR
27	TR_OBJ_ID	☐	CRMT_TC_TECH_RES_ID	CRM_TC_TECH_RES_ID	CHAR	50	0	TC: ID of Technical Resource
28	TR_TYPE	☐	CRMT_TC_TR_TYPE	CRM_TC_TR_TYPE	CHAR	2	0	Technical Resource Type	*
29	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
30	NOT_DB_REL	☐	FLAG	FLAG	CHAR	1	0	General Flag
31	EDR_SEND	☐	FLAG	FLAG	CHAR	1	0	General Flag
32	.INCLUDE	☐				0	0	Payment data for EDRs
33	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
34	BANK_ID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
35	AUTH_NO	☐	COMT_AUTH_NO	CHAR10	CHAR	10	0	Payment Cards: Authorization Number
36	AUTH_REF	☐	COMT_AUTH_REF	CHAR30	CHAR	30	0	Authorization Reference Number of Clearing House
37	AUTH_TIMESTAMP	☐	COMT_AUTH_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date and Time of Authorization
38	AUTH_AMOUNT	☐	COMT_AUTH_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Authorized Amount
39	AUTH_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	CARD_MERCH_ID	☐	COMT_CARD_MERCH_ID	COM_MERCH_ID_CC	CHAR	15	0	Identification of Merchant at Clearing House	*
41	.INCLUDE	☐				0	0

History

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