LAE_CRM_ITEMS - LAE: Contract Items

LAE: Contract Items information is stored in SAP table LAE_CRM_ITEMS.
It is part of development package FI_LA_GF in software component FI-LA. This development package consists of objects that can be grouped under "Lease Accounting General Functions".

Fields for table LAE_CRM_ITEMS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
BUKRS	Company Code	X	BUKRS	CHAR	8	*
OBJID	Object Number	X	FILA_OBJID	RAW	16	LAE_CRM_HEADER
SUBID	Subobject Number	X	FILA_SUBID	NUMC	10
TMSTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	X	TIMESTAMP	DEC	8
.INCLUDE				LAE_CRM_ITEMS_01	0
EVENT	Process		FILA_EVENT	CHAR	40	*
STATUS	Processing Status		FILA_STATUS	NUMC	2
ITEMNO	Item Number		FILA_ITEMNO	NUMC	20
ITEMNO_EXT	External Item Number		FILA_ITEMNO_EXT	NUMC	20
ITEMTXT	Item Description		FILA_ITEMTXT	CHAR	100
CURRENCY	Currency Key		WAERS	CUKY	10	*
EXCHG_RATE	Exchange rate		KURSF	DEC	5
QUANTITY	Quantity		AM_MENGE	QUAN	7
UNIT	Base Unit of Measure		MEINS	UNIT	6	*
BUKRS_REF	Company Code		BUKRS	CHAR	8	*
OBJID_REF	Object Number of Reference Object		FILA_OBJID_REF	RAW	16
SUBID_REF	Reference Sub-Object Number		FILA_SUBID_REF	NUMC	10
SUBID_STG	Reference Sub-Object Number		FILA_SUBID_REF	NUMC	10
UIID	Unique Item ID in Life Cycle		FILA_UIID	CHAR	24
EXT_POS_REF	External Item Reference		FILA_EXT_ITEM_REF	CHAR	70
FREE_POS_REF	Custom External Item Reference		FILA_FREE_EXT_ITEM_REF	CHAR	70
.INCLUDE				LAE_CRM_ITEMS_02	0
CONTSTARTDT	Start Date of Contract for Contract Item		FILA_CONTSTARTDT	DATS	16
CONTENDDT	End Date of Contract for Contract Item		FILA_CONTENDDT	DATS	16
LEASTARTDT	Date on Which Contract Processes Are Active(Lease Start Date		FILA_LEASTARTDT	DATS	16
LEASOPTEXEDT	Option Exercise Date		FILA_LEASOPTEXEDT	DATS	16
TERM	Contract Term (in Months)		FILA_TERM	NUMC	6
REM_USEFUL_LIFE	Remaining Useful Life		FILA_REMAINING_USEFUL_LIFE	NUMC	6
.INCLUDE				LAE_CRM_ITEMS_03	0
PRODUCT	Material Number		MATNR	CHAR	80	*
USEDPRODUCT	Used Goods		FILA_USEDPRODUCT	CHAR	2
CUSTGROUP	Customer Group		KDGRP	CHAR	4	T151
SALESORG	Sales Organization		VKORG	CHAR	8	TVKO
DIS_CHANNEL	Distribution Channel		VTWEG	CHAR	4	TVTW
SOLDTO	Sold-to Party		KUNAG	CHAR	20	KNA1
INSTAT	Installation Location		FILA_INSTAT	CHAR	20	*
FINPROD	Financing Product		FILA_FINPROD	CHAR	80	*
FINCLAS	Classification of Financing Type		FILA_FINCLASSIFICATION	CHAR	4
BP_USAGE	Use of Billing Plan		FILA_BP_USAGE	CHAR	2
DEVICECLASS	Device Class		FILA_DEVICECLASS	CHAR	20
OPTIONID	Option ID		FILA_OPTIONID	CHAR	4	*
CLASSIF_LOCAL	Tax Financing Classification - Local		FILA_CLASSLO	CHAR	4
CLASSIF_GROUP	Tax Financing Classification - Group		FILA_CLASSGR	CHAR	4
CLASSIF_LO_FLAG	Forced Classification Indicator		FILA_CLASSLO_FLAG	CHAR	2
CLASSIF_GR_FLAG	Forced Classification		FILA_CLASSGR_FLAG	CHAR	2
CLAS_CUSTOMER	Classification - Customer		FILA_CLASSCU	CHAR	4
BUS_AREA	Business Area		GSBER	CHAR	8	*
CLASSIF_LOCALBK	Book Financing Classification - Local		FILA_CLASSLOCBK	CHAR	4
CLASSIF_GROUPBK	Book Financing Classification - Group		FILA_CLASSGRPBK	CHAR	4
CLASSIF_LOBK_FL	Forced Classification Indicator		FILA_CLASSLOCBK_FLAG	CHAR	2
CLASSIF_GRBK_FL	Forced Classification Indicator		FILA_CLASSGRPBK_FLAG	CHAR	2
INTRATE	Annual Interest Rate		FILA_INTRATE	DEC	4
PROC_INDICATOR	Process Indicator for Leveraged Debt Cost		FILA_PROC_CNTRL_INDICATOR	NUMC	2
BU_ID_NUMBER	Identification Number		FILA_BU_ID_NUMBER	CHAR	120
BU_ID_TYPE	Identification Type		FILA_BU_ID_TYPE	CHAR	12	*
BU_PARTNER	Business Partner Number		FILA_BU_PARTNER	CHAR	20	*
BEMOT	Accounting Indicator		FILA_BEMOT	CHAR	4	*
BUAG_ID	Business Agreement Number		FILA_BUAG_ID	CHAR	24
TMSTAMPADJ	Time Stamp of Last Business Transaction from CRM		FILA_TMSTAMPADJ	DEC	8
PROCMODE	Processing Mode of Process		FILA_PROCMODE	NUMC	2
LOGHANDLE	Application Log: Log Handle		BALLOGHNDL	CHAR	44
TMSTAMPREV	Time Stamp of Business Transaction to be Reversed		FILA_TMSTAMPREV	DEC	8
ALLOCATION_ID	External Assignment Indicator		FILA_ALLOCATION_ID	CHAR	32
TMSTAMPESP	Time Stamp - Processed Successfully (BW Delta Extraction)		FILA_TMSTAMPESP	DEC	8
RUNID	Migration Run Number		FILA_RUNID_MIG	NUMC	20
BUS_SCENARIO_ID	Business Scenario for Which Controlling Is Performed		FILA_BS_IDENTIFICATION	CHAR	32
FIELD01	Field for Customer-Specific Data		FILA_FIELD01	CHAR	40
FIELD02	Field for Customer-Specific Data		FILA_FIELD02	CHAR	40
FIELD03	Field for Customer-Specific Data		FILA_FIELD03	CHAR	40
LESSOR	Account Number of Supplier		LIFNR	CHAR	20	*