SAP ABAP Table CRMT_UBB_CR_I_DB_WRK (UBB Credit Overview: Item Data - Structure: Work Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-CTR-UCO (Application Component) Usage-Based Service Contract
     ⤷ CRM_UBB_CR_I (Package) UBB Credit Item Enhancement

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_UBB_CR_I_DB_WRK	Table Relationship Diagram
Short Description	UBB Credit Overview: Item Data - Structure: Work Structure

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	Credit Overview
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Credit Overview: External Structure
6	.INCLUDE	☐				0	0	Credit Overview: External Structure 1
7	ITEM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
8	.INCLUDE	☐				0	0	Credit Overview: External Structure 2
9	PRED_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
10	VALID_FROM	☐	CRMT_UBB_VALID_FROM	CRM_TSTMP	DEC	15	0	Valid from
11	VALID_TO	☐	CRMT_UBB_VALID_TO	CRM_TSTMP	DEC	15	0	Valid To
12	QUANTITY	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
13	CURRENT_QUANTITY	☐	CRMT_UBB_CRED_CURR_QUANTITY	CRM_MENGV15	QUAN	15	3	Current Credit Quantity
14	UNIT	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
15	USAGEFCTCAT	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_CAT
16	USAGEFCT	☐	CRMT_UBB_USAGEFCT	CRM_UBB_USAGEFCT	CHAR	4	0	Usage Function	CRMC_UBB_USG_FCT
17	COMMENT_LANGU	☐	CRMT_UBB_COMMENT_LANGU	SYLANGU	LANG	1	0	Language of Credit Comment
18	COMMENTS	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
19	CREDIT_STATUS	☐	CRMT_UBB_CREDIT_STATUS	CRM_UBB_CREDIT_STATUS	CHAR	1	0	Credit Status
20	CR_TYPE	☐	CRMT_UBB_CR_TYPE	CRM_UBB_CR_TYPE	CHAR	1	0	Type of Credit	CRMC_UBB_CR_TYPE
21	READING_ID	☐	CRMT_MPK_OBJECT_ID_READING	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Reading Number
22	VALUE	☐	CRMT_UBB_CRED_VALUE	CRM_UBB_COND_VALUE	CURR	19	2	Credit Value
23	CURRENT_VALUE	☐	CRMT_UBB_CRED_VALUE_CURRENT	CRM_UBB_COND_VALUE	CURR	19	2	Current Credit Value
24	CURRENCY	☐	CRMT_UBB_CRED_CURR	WAERS	CUKY	5	0	Credit Currency	*
25	SOURCE	☐	CRMT_UBB_CRED_SOURCE	CRM_UBB_CRED_SOURCE	CHAR	1	0	Credit Source
26	SRC_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
27	RELATIONID	☐	BINRELID	SYSUUID_22	CHAR	22	0	Object Relationship Service : GUID binary link
28	POSNO	☐	CRMT_POSNO	NUMC6	NUMC	6	0	Item Number in Document Flow
29	RELATIONID_CANC	☐	BINRELID	SYSUUID_22	CHAR	22	0	Object Relationship Service : GUID binary link
30	POSNO_CANC	☐	CRMT_POSNO	NUMC6	NUMC	6	0	Item Number in Document Flow
31	VALID_TIMEZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
32	.INCLUDE	☐				0	0	UBB Credit Overview: DB Buffer: Dynamic Fields
33	NOREC_FLAG	☐	CRMT_NOREC	CRM_BOOLEAN	CHAR	1	0	Entry does not Exist in Database

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_UBB_CR_I_DB_WRK	CR_TYPE	CRMC_UBB_CR_TYPE	CR_TYPE		1	CN
2	CRMT_UBB_CR_I_DB_WRK	USAGEFCT	CRMC_UBB_USG_FCT	USAGEFCT		1	CN
3	CRMT_UBB_CR_I_DB_WRK	USAGEFCTCAT	CRMC_UBB_USG_CAT	USAGEFCTCAT		1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	310