SAP ABAP Table CRMT_LAE_UPLOAD_ITEMS (LAE View of Contract: Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM-BTX-LAE (Application Component) Connection to Accounting
     ⤷ CRM_LAE (Package) Integration of CRM into Lease Accounting in R/3

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_LAE_UPLOAD_ITEMS	Table Relationship Diagram
Short Description	LAE View of Contract: Items

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	ITEMID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	PARENTID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	EVENT	☐	CRMT_LEAS_CHNG_LAE	CHAR20	CHAR	20	0	Change Process for Lease for Lease Accounting Engine
4	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number
5	ITEMTXT	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
6	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
7	ITEMNO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
8	ITEMNO_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
9	FINPROD	☐	MATNR	MATNR	CHAR	18	0	Material Number
10	FINCLAS	☐	CRMT_FINCLASSIFICATION	CRMT_FINCLASSIFICATION	NUMC	2	0	Classification of Financing Type
11	CLASSIF_LOCAL	☐	CRMT_CLASSIF_LOCAL	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Tax)
12	CLASSIF_GROUP	☐	CRMT_CLASSIF_GROUP	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type
13	CLASSIF_LO_FLAG	☐	CRMT_CLASSIFI_FLAG	XFELD	CHAR	1	0	Default Local Classification (Tax)
14	CLASSIF_GR_FLAG	☐	CRMT_CLAS_GROUP_FLAG	XFELD	CHAR	1	0	Default Group Classification (Tax)
15	CLAS_CUSTOMER	☐	CRMT_CLAS_CUSTOMER	CRMT_FILA_CLASS	CHAR	2	0	Customer Classification Type (Tax)
16	SZBMETH	☐	CRMT_SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
17	SEFFMETH	☐	CRMT_SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method
18	USEDPRODUCT	☐	CRMT_USED_FLAG	XFELD	CHAR	1	0	Leased Object Is Used
19	OPTIONID	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
20	DEVICECLASS	☐	CRMT_DEV_TYPE_GRP	CRMT_DEV_TYPE_GRP	CHAR	10	0	Device Class
21	REM_USEFUL_LIFE	☐	CRMT_REMAINING_USEFUL_LIFE		NUMC	3	0	Remaining Useful Life
22	CONTSTARTDT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
23	CONTENDDT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
24	LEASTARTDT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
25	LEASOPTEXEDT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
26	TERM	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
27	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
28	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
29	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
30	CUSTGROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
31	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
32	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
33	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
34	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
35	SOLDTO	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
36	INSTAT	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
37	QUANTITY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
38	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
39	REF_HEADER_GUID	☐	CRMT_PRED_HEADER_GUID	SYSUUID	RAW	16	0	Header GUID of Preceding CRM Document
40	REF_ITEM_GUID	☐	CRMT_PRED_ITEM_GUID	SYSUUID	RAW	16	0	Guid from a Preceding Item
41	XREVERSE	☐	FLAG	FLAG	CHAR	1	0	General Flag
42	CLASSIF_LOCALBK	☐	CRMT_CLASSIF_LOCAL_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Local Classification Type (Book)
43	CLASSIF_GROUPBK	☐	CRMT_CLASSIF_GROUP_BOOK	CRMT_FILA_CLASS	CHAR	2	0	Group Classification Type (Book)
44	CLASSIF_LOBK_FL	☐	CRMT_CLAS_LOCAL_BOOK_FLG	XFELD	CHAR	1	0	Default Local Classification (Book)
45	CLASSIF_GRBK_FL	☐	CRMT_CLAS_GROUP_BOOK_FLG	XFELD	CHAR	1	0	Default Group Classification (Book)
46	TMSTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
47	ALLOCATION_ID	☐	CRMT_ALLOCATION_ID	CRM_ALLOCATION_ID	CHAR	16	0	External Allocation Number
48	TERM_PROC	☐	CRMT_LEAS_TERM_PROC	XFELD	CHAR	1	0	End-of-Lease Process
49	BP_USAGE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
50	BUS_SCENARIO_ID	☐	CRMT_BS_IDENTIFICATION		CHAR	16	0	Business Scenario in Controlling for Logistics Objects
51	PROC_SEQ_ID	☐	LFDNR	LFDNR	CHAR	3	0	Sequence Number
52	PARENTID_STG	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
53	VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
54	BU_ID_NUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
55	BU_ID_TYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
56	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
57	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
58	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
59	UIID	☐	CRMT_LAEUIID	CRMT_LAEUIID	CHAR	12	0	Unique Item Identifier in Life Cycle
60	EXT_ITEM_REF	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
61	FREE_EXT_ITEM_REF	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number

History

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