SAP ABAP Table CDBD_ORDERADM_I (Business transaction item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_ORDERADM_I	Table Relationship Diagram
Short Description	Business transaction item

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	ORDERADM_I_GUID	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	ORDERADM_H_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier	CDBD_ORDERADM_H
4	CREATED_AT_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
6	CHANGED_AT_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
7	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
8	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
9	SET_REFITEM_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
10	PARENT	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
11	ALTERNATIVE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
12	PRODUCT	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
13	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
14	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
15	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
16	ITM_LANGUAGE	☐	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
17	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
18	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
19	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
20	ORDER_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
21	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
22	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
23	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
24	QUANTITY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
26	SRV_CONF_TIME	☐	CRMT_SRV_CONF_DURATION	DAUER_5_2	QUAN	7	2	Confirmed Duration
27	SRV_CONF_TUNIT	☐	CRMT_SRV_CONF_TIME_UNIT	MEINS	UNIT	3	0	Time Unit for Confirmed Duration	*
28	DISPO_FLG	☐	CRMT_SRV_DISPO_FLG	FLAG	CHAR	1	0	Relevant for Resource Planning
29	CONFIRM_RELEVANT	☐	CRMT_CONFIRM_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Confirmation
30	DESIREDSTARTDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
31	DESIREDSTARTTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
32	DESIREDENDDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
33	DESIREDENDTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
34	ACTUALSTARTDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
35	ACTUALSTARTTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
36	ACTUALENDDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
37	ACTUALENDTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
38	TIME_ZONE	☐	CDB_TIME_ZONE	TZNZONE	CHAR	6	0	Time Zone	*
39	ITM_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
40	USER_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
41	ERROR_FLAG	☐	ERR_FLAG	CHAR1	CHAR	1	0	Error Flag denoting error with the status
42	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
43	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
44	ASSIGNMENT_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
45	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
46	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
47	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
48	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
49	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
50	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
51	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
52	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
53	NUMBER_PARENT	☐	CRMT_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Transaction
54	NUMBER_ALTERN	☐	CRMT_ITEM_NO_ALTERNATIVE	CRM_ITEM_NO	NUMC	10	0	Item for Which This Item is an Alternative in the Document
55	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
56	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
57	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
58	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
59	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
60	PRICE_PRODUCT	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
61	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
62	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
63	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
64	COMM_GROUP	☐	CRMT_COMM_GROUP	CRM_COMM_GROUP	CHAR	2	0	Commission Group	*
65	REBATE_GROUP	☐	CRMT_REBATE_GROUP	CRM_REBATE_GROUP	CHAR	2	0	Volume Rebate Group	*
66	CASH_DISC	☐	CRMT_CASH_DISC	XFELD	CHAR	1	0	Specifies Whether a Cash Discount Can Be Given for the Prod.
67	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
68	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
69	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
70	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
71	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
72	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
73	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
74	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
75	PRICE_PRODUCT_ID	☐	CRMT_PRICE_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Pricing Reference Product
76	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
77	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
78	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
79	TAX_DEPART_CTY	☐	CRMT_TAX_DEPART_CTY	LAND1	CHAR	3	0	Tax Departure Country	*
80	TAX_DEPART_REG	☐	CRMT_TAX_DEPART_REG	REGIO	CHAR	3	0	Departure Region for Tax	*
81	TAXJURCODE_FROM	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
82	TAX_GROUP_P	☐	CRMT_TAX_GROUP	CRM_TAX_GROUP	CHAR	20	0	Product Tax Group
83	TAX_TARIFF_CODE	☐	CRMT_TAX_TARIFF_CODE	CHAR16	CHAR	16	0	Tax Tariff Code
84	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
85	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
86	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
87	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
88	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
89	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
90	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
91	NET_WO_FREIGHT	☐	PRCT_NET_VALUE_WITHOUT_FREIGHT	WERTV8	CURR	15	2	Item Net Value Exclusive Shipment
92	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
93	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
94	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
95	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
96	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
97	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
98	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
99	QUOTEITEM	☐	QUOTEITEM	FLAG	CHAR	1	0	Flag for Quotation item
100	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
101	CHANGED_AT_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
102	CREATED_AT_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
103	DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
104	DURATION_UNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
105	WARRANTY	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
106	WARRANTY_ID	☐	CRMT_WTY_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Warranty ID
107	FIND_CONTRACTS	☐	CRMT_ACT	CRMT_ACT	CHAR	1	0	Show/Hide Functions in Order
108	UPDATE_FLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CDBD_ORDERADM_I	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE
2	CDBD_ORDERADM_I	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY
3	CDBD_ORDERADM_I	ORDERADM_H_GUID	CDBD_ORDERADM_H	ORDERADM_H_GUID

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A