SAP ABAP Table LAE_CRM_ITEMS_MODX (Contract Maint.Dialog Structure (LAE_CRM_ITEMS + Add.Fields))

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ FI-LA (Application Component) Lease Accounting
     ⤷ FI_LA_CA (Package) Leasing Accounting R/3 Contract Processing

Basic Data

Table Category	INTTAB	Structure
Structure	LAE_CRM_ITEMS_MODX	Table Relationship Diagram
Short Description	Contract Maint.Dialog Structure (LAE_CRM_ITEMS + Add.Fields)

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	OBJID	☐	FILA_OBJID		RAW	16	0	Object Number	LAE_CRM_HEADER
4	SUBID	☐	FILA_SUBID		NUMC	5	0	Subobject Number
5	TMSTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
6	EVENT	☐	FILA_EVENT	FILA_EVENT	CHAR	20	0	Process	*
7	STATUS	☐	FILA_STATUS	FILA_STATUS	NUMC	1	0	Processing Status
8	ITEMNO	☐	FILA_ITEMNO		NUMC	10	0	Item Number
9	ITEMTXT	☐	FILA_ITEMTXT	TEXT50	CHAR	50	0	Item Description
10	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	EXCHG_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
12	QUANTITY	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
13	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	OBJID_REF	☐	FILA_OBJID_REF		RAW	16	0	Object Number of Reference Object
15	SUBID_REF	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
16	CONTSTARTDT	☐	FILA_CONTSTARTDT	DATUM	DATS	8	0	Start Date of Contract for Contract Item
17	CONTENDDT	☐	FILA_CONTENDDT	DATUM	DATS	8	0	End Date of Contract for Contract Item
18	LEASTARTDT	☐	FILA_LEASTARTDT	DATUM	DATS	8	0	Date on Which Contract Processes Are Active(Lease Start Date
19	LEASOPTEXEDT	☐	FILA_LEASOPTEXEDT	DATUM	DATS	8	0	Option Exercise Date
20	TERM	☐	FILA_TERM	NUMC3	NUMC	3	0	Contract Term (in Months)
21	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
22	USEDPRODUCT	☐	FILA_USEDPRODUCT	XFELD	CHAR	1	0	Used Goods
23	CUSTGROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
24	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
25	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
26	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
27	FINPROD	☐	FILA_FINPROD	MATNR	CHAR	18	0	Financing Product	*
28	FINCLAS	☐	FILA_FINCLASS_MODX	FILA_FINCLASSIFICATION	CHAR	2	0	Financing Type
29	DEVICECLASS	☐	FILA_DEVICECLASS		CHAR	10	0	Device Class
30	OPTIONID	☐	FILA_OPTIONID	FILA_OPTIONID	CHAR	2	0	Option ID	TFILA_LC_006
31	CLASSIF_LO_FLAG	☐	FILA_CLASS01_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
32	CLASSIF_GR_FLAG	☐	FILA_CLASS02_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
33	CLAS_CUSTOMER	☐	FILA_CLASSCU		CHAR	2	0	Classification - Customer
34	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
35	CLASSIF_LOBK_FL	☐	FILA_CLASS03_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
36	CLASSIF_GRBK_FL	☐	FILA_CLASS04_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
37	INTRATE	☐	FILA_INTRATE	AFPROZ	DEC	7	4	Annual Interest Rate
38	TMSTAMPADJ	☐	FILA_TMSTAMPADJ	TZNTSTMPS	DEC	15	0	Time Stamp of Last Business Transaction from CRM
39	PROCMODE	☐	FILA_PROCMODE	FILA_PROCMODE	NUMC	1	0	Processing Mode of Process
40	LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
41	TMSTAMPREV	☐	FILA_TMSTAMPREV	TZNTSTMPS	DEC	15	0	Time Stamp of Business Transaction to be Reversed
42	ALLOCATION_ID	☐	FILA_ALLOCATION_ID	CHAR16	CHAR	16	0	External Assignment Indicator
43	TMSTAMPESP	☐	FILA_TMSTAMPESP	TZNTSTMPS	DEC	15	0	Time Stamp - Processed Successfully (BW Delta Extraction)
44	FIELD01	☐	FILA_FIELD01	CHAR20	CHAR	20	0	Field for Customer-Specific Data
45	FIELD02	☐	FILA_FIELD02	CHAR20	CHAR	20	0	Field for Customer-Specific Data
46	FIELD03	☐	FILA_FIELD03	CHAR20	CHAR	20	0	Field for Customer-Specific Data
47	.INCLUDE	☐				0	0	LAE: Substructure Contract Item Sales Data
48	CLASSIF_LOCAL	☐	FILA_CLASS01		CHAR	2	0	Classification by Local Laws
49	CLASSIF_GROUP	☐	FILA_CLASS02		CHAR	2	0	Classification by IAS
50	CLASSIF_LOCALBK	☐	FILA_CLASS03		CHAR	2	0	Financing Classification - 3rd Accounting Principle
51	CLASSIF_GROUPBK	☐	FILA_CLASS04		CHAR	2	0	Financing Classification - 4th Accounting Principle
52	TXT_DEVICECLASS	☐	FILA_DESCRIPTION_50	TEXT50	CHAR	50	0	Name
53	TXT_CLASSIF_LOCAL	☐	FILA_DESCRIPTION_50	TEXT50	CHAR	50	0	Name
54	TXT_CLASSIF_GROUP	☐	FILA_DESCRIPTION_50	TEXT50	CHAR	50	0	Name
55	TXT_CLASSIF_LOCALBK	☐	FILA_DESCRIPTION_50	TEXT50	CHAR	50	0	Name
56	TXT_CLASSIF_GROUPBK	☐	FILA_DESCRIPTION_50	TEXT50	CHAR	50	0	Name
57	PUSHBUTTON_SIMU	☐	FILA_PUSHBUTTON_TXT		CHAR	15	0	Pushbuttom Text for Additional Function
58	BUKRS_REF	☐	FILA_BUKRS	BUKRS	CHAR	4	0	Company Code of Accounting Principles	*
59	OBJECTID_REF	☐	FILA_REFOBJ	FILA_REFOBJ	CHAR	10	0	Contract Number	*
60	ITEMNO_REF	☐	FILA_ITEMNO		NUMC	10	0	Item Number
61	.INCLUDE	☐				0	0	Names for Additional Pushbuttons
62	PUSHBUTTON_01	☐	FILA_PUSHBUTTON_TXT		CHAR	15	0	Pushbuttom Text for Additional Function
63	PUSHBUTTON_02	☐	FILA_PUSHBUTTON_TXT		CHAR	15	0	Pushbuttom Text for Additional Function
64	PUSHBUTTON_03	☐	FILA_PUSHBUTTON_TXT		CHAR	15	0	Pushbuttom Text for Additional Function
65	.INCLUDE	☐				0	0	Structure for Fields Required Additionally
66	DUMMY	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LAE_CRM_ITEMS_MODX	CUSTGROUP	T151	KDGRP	REF	1	CN
2	LAE_CRM_ITEMS_MODX	DIS_CHANNEL	TVTW	VTWEG	REF	1	CN
3	LAE_CRM_ITEMS_MODX	OBJID	LAE_CRM_HEADER	OBJID
4	LAE_CRM_ITEMS_MODX	OPTIONID	TFILA_LC_006	OPTIONID
5	LAE_CRM_ITEMS_MODX	SALESORG	TVKO	VKORG	REF	1	CN
6	LAE_CRM_ITEMS_MODX	SOLDTO	KNA1	KUNNR	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200