CRMD_EDR

CRM Invoice Line Item - EDR Table | #masterdata | Component: Integration to Billing System
Column Name Description
CLIENT Client
EDR_GUID GUID of Event Detail Record
Column Name Description
💲 Currency (CURRENCY):
AMOUNT Value
TAX_AMOUNT Tax Amount
Column Name Description
📏 Unit of Usage (UNIT_OF_USAGE):
USAGE_QUANTITY Usage Quantity
Column Name Description
Column Name Description
REF_DOC_KIND CRMB Billing Document Kind Show values
NET_GROSS Value Is Net or Gross Show values
DISPUTED Disputed EDR Show values
ARCHIVING_STATUS Archiving Status Show values
EDR_STATUS Shows the status of EDR Show values
Column Name Description Domain name
EDR_ID ID of Event Detail Record CRM_EDR_ID
EDR_CREATE_DATE Creation Date and Time of Event Detail Record BCOS_TSTMP
EDR_LOAD_DATE Load Date and Time of Event Detail Record BCOS_TSTMP
REF_GUID_INDOB Internal Unique ID of Product SYSUUID
REF_DOC_GUID Reference to CRMB Billing Document GUID SYSUUID
CONTRACT_ID IST Contract Number CRMT_EDR_EXT_REF
BUAG_GUID GUID of the Business Agreement SYSUUID
PARTNER_GUID Business Partner GUID SYSUUID
EDR_SOURCE_SYS External System Where EDR Was Created LOGSYS
EDR_DESCRIPTION EDR Description CRM_EDR_DESCRIPTION
VERIFY_DATE Verify Date BCOS_TSTMP
TR_OBJ_ID ID of Technical Resource CRM_TC_TECH_RES_ID
TR_TYPE Technical Resource Type VTTRT_KK
Master Data Relations Join Conditions
Currency
  • CRMD_EDR.CLIENT == TCURC.MANDT
  • CRMD_EDR.CURRENCY == TCURC.WAERS
Type of Billing Detail Record
  • Type of Billing Detail Record
  • Client
Unit of Usage
  • CRMD_EDR.CLIENT == T006.MANDT
  • CRMD_EDR.UNIT_OF_USAGE == T006.MSEHI