SAP ABAP Table CRMT_EDR_DEPENDENT_EXT (Structure for the EDR Dependent Objects)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_EDR_DEPENDENT_EXT	Table Relationship Diagram
Short Description	Structure for the EDR Dependent Objects

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	WRK for EDRs
2	.INCLUDE	☐				0	0	EDR: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	EDR_GUID	☐	CRMT_EDR_GUID	SYSUUID	RAW	16	0	GUID of Event Detail Record
5	.INCLUDE	☐				0	0	EDR: Structure of System Fields
6	EDR_ID	☐	CRMT_EDR_ID	CRM_EDR_ID	CHAR	32	0	ID of Event Detail Record
7	EDR_TYPE	☐	CRMT_EDR_TYPE	CRM_EDR_TYPE	CHAR	4	0	Type of Billing Detail Record	*
8	EDR_CREATE_DATE	☐	CRMT_EDR_CREATE_DATE	BCOS_TSTMP	DEC	15	0	Creation Date and Time of Event Detail Record
9	EDR_LOAD_DATE	☐	CRMT_EDR_LOAD_DATE	BCOS_TSTMP	DEC	15	0	Load Date and Time of Event Detail Record
10	REF_GUID_INDOB	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
11	REF_DOC_GUID	☐	CRMT_EDR_REF_DOC_GUID	SYSUUID	RAW	16	0	Reference to CRMB Billing Document GUID
12	REF_DOC_KIND	☐	CRMT_EDR_REF_DOC_KIND	CRM_EDR_REF_DOC_KIND	CHAR	1	0	CRMB Billing Document Kind
13	CONTRACT_ID	☐	CRMT_EDR_EXT_REF	CRMT_EDR_EXT_REF	CHAR	20	0	IST Contract Number
14	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
15	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
16	AMOUNT	☐	CRMT_EDR_BILL_AMT	CRM_EDR_BILL_AMT	CURR	15	2	Value
17	CURRENCY	☐	CRMT_EDR_CURR	WAERS	CUKY	5	0	Currency	*
18	NET_GROSS	☐	CRMT_EDR_NET_GROSS	CRM_EDR_NET_GROSS	CHAR	1	0	Value Is Net or Gross
19	USAGE_QUANTITY	☐	CRMT_EDR_USAGE_QTY	CRM_EDR_USAGE_QTY	QUAN	13	3	Usage Quantity
20	UNIT_OF_USAGE	☐	CRMT_EDR_USAGE_UNIT	MEINS	UNIT	3	0	Unit of Usage	*
21	TAX_AMOUNT	☐	CRMT_EDR_TAX_AMT	CRM_EDR_TAX_AMT	CURR	15	2	Tax Amount
22	EDR_SOURCE_SYS	☐	CRMT_EDR_SOURCE_SYS	LOGSYS	CHAR	10	0	External System Where EDR Was Created	*
23	DISPUTED	☐	CRMT_EDR_DISPUTED	XFELD	CHAR	1	0	Disputed EDR
24	EDR_DESCRIPTION	☐	CRMT_EDR_DESCRIPTION	CRM_EDR_DESCRIPTION	CHAR	100	0	EDR Description
25	ARCHIVING_STATUS	☐	CRMT_EDR_ARCHIVE_STATUS	CRM_EDR_ARCHIVE_STATUS	CHAR	1	0	Archiving Status
26	VERIFY_DATE	☐	CRMT_EDR_VERIFY_DATE	BCOS_TSTMP	DEC	15	0	Verify Date
27	EDR_STATUS	☐	CRMT_EDR_STATUS	CRMT_EDR_STATUS	CHAR	2	0	Shows the status of EDR
28	TR_OBJ_ID	☐	CRMT_TC_TECH_RES_ID	CRM_TC_TECH_RES_ID	CHAR	50	0	TC: ID of Technical Resource
29	TR_TYPE	☐	CRMT_TC_TR_TYPE	CRM_TC_TR_TYPE	CHAR	2	0	Technical Resource Type	*
30	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
31	NOT_DB_REL	☐	FLAG	FLAG	CHAR	1	0	General Flag
32	EDR_SEND	☐	FLAG	FLAG	CHAR	1	0	General Flag
33	.INCLUDE	☐				0	0	Payment data for EDRs
34	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
35	BANK_ID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
36	AUTH_NO	☐	COMT_AUTH_NO	CHAR10	CHAR	10	0	Payment Cards: Authorization Number
37	AUTH_REF	☐	COMT_AUTH_REF	CHAR30	CHAR	30	0	Authorization Reference Number of Clearing House
38	AUTH_TIMESTAMP	☐	COMT_AUTH_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date and Time of Authorization
39	AUTH_AMOUNT	☐	COMT_AUTH_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Authorized Amount
40	AUTH_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
41	CARD_MERCH_ID	☐	COMT_CARD_MERCH_ID	COM_MERCH_ID_CC	CHAR	15	0	Identification of Merchant at Clearing House	*
42	.INCLUDE	☐				0	0
43	.INCLUDE	☐				0	0	Extended attribute structure for EDR Object (BOL/Genil)
44	HEADNO_EXT	☐	BEA_HEADNO_EXT_UBD	BEA_HEADNO_EXT	CHAR	10	0	Invoice
45	PAYER	☐	BEA_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
46	ITEMNO_ALPHA	☐	BEA_ITEMNO_ALPHA	BEA_ITEMNO_ALPHA	NUMC	10	0	Item Number (with Alpha Conversion)
47	SRC_HEADNO	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
48	PAYER_NAME	☐	BEA_PAYER_NAME	BU_TEXT50	CHAR	50	0	Payer (Name/Location)
49	PD_EXT_UI	☐	EUI_EXT_UI_UI	EUI_EXT_UI	CHAR	50	0	Point of Delivery ID
50	PD_SPARTE	☐	SPART	SPART	CHAR	2	0	Division
51	PD_SPARTE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
52	EDR_TYPE_DESC	☐	CRMT_DESCR	TEXT40	CHAR	40	0	Description for Type of Event Detail Record
53	DISPUTE_STATUS	☐	CRMT_EDR_DISPUTE_STATUS	CRMT_EDR_DISPUTE_STATUS	CHAR	1	0	EDR Dispute Status
54	NET_VALUE	☐	CRMT_EDR_BILL_AMT	CRM_EDR_BILL_AMT	CURR	15	2	Value
55	GROSS_VALUE	☐	CRMT_EDR_BILL_AMT	CRM_EDR_BILL_AMT	CURR	15	2	Value
56	EDR_DESCRIPTION_CONV	☐	CRMT_EDR_DESCRIPTION	CRM_EDR_DESCRIPTION	CHAR	100	0	EDR Description
57	USAGE_DESCRIPTION	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
58	DISPUTE_STATUS_DESC	☐	CRMT_EDR_DISPUTE_STATUS_DESC	CRMT_EDR_DISPUTE_STATUS_DESC	CHAR	30	0	Event Detail Record - Dispute Status description
59	CONTRACT_ID_DESC	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
60	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
61	BUAG_ID_DESC	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
62	ADJREQ_STATUS	☐	CRMT_EDR_DISPUTE_STATUS	CRMT_EDR_DISPUTE_STATUS	CHAR	1	0	EDR Dispute Status
63	ADJREQ_STATUS_DESC	☐	CRMT_EDR_DISPUTE_STATUS_DESC	CRMT_EDR_DISPUTE_STATUS_DESC	CHAR	30	0	Event Detail Record - Dispute Status description
64	CCACCNAME	☐	BU_CREDITCNAME	BU_BKCCNAME	CHAR	40	0	Description of Credit Card Details
65	BANKA	☐	BANKA	TEXT60	CHAR	60	0	Name of bank
66	TR_TYPE_DESC	☐	CRMT_TC_TEXT	TEXT40	CHAR	40	0	Toll Collection: Short Text / Description
67	EDR_STATUS_DESC	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values

History

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