SAP ABAP Table CRMD_EDR (CRM Invoice Line Item - EDR Table)

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	TRANSP	Transparent table
Transparent table	CRMD_EDR	Table Relationship Diagram
Short Description	CRM Invoice Line Item - EDR Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CRMC_EDR_TYPE
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	TCURC
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	T006
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	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_EDR	CURRENCY	TCURC	WAERS
2	CRMD_EDR	EDR_TYPE	CRMC_EDR_TYPE	EDR_TYPE
3	CRMD_EDR	UNIT_OF_USAGE	T006	MSEHI

History

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