SAP ABAP Table V_LAECRM_ITEMS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_LAECRM_ITEMS	Table Relationship Diagram
Short Description	Generated Table for View

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	REF_SUBKEY	☑	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	ITEMNO_EXT	☐	FILA_ITEMNO_EXT		NUMC	10	0	External Item Number
10	ITEMTXT	☐	FILA_ITEMTXT	TEXT50	CHAR	50	0	Item Description
11	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key
12	EXCHG_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
13	QUANTITY	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
14	UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
15	BUKRS_REF	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
16	OBJID_REF	☐	FILA_OBJID_REF		RAW	16	0	Object Number of Reference Object
17	SUBID_REF	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
18	SUBID_STG	☐	FILA_SUBID_REF		NUMC	5	0	Reference Sub-Object Number
19	UIID	☐	FILA_UIID	FILA_UIID	CHAR	12	0	Unique Item ID in Life Cycle
20	EXT_POS_REF	☐	FILA_EXT_ITEM_REF	FILA_EXT_ITEM_REF	CHAR	35	0	External Item Reference
21	FREE_POS_REF	☐	FILA_FREE_EXT_ITEM_REF	FILA_EXT_ITEM_REF	CHAR	35	0	Custom External Item Reference
22	CONTSTARTDT	☐	FILA_CONTSTARTDT	DATUM	DATS	8	0	Start Date of Contract for Contract Item
23	CONTENDDT	☐	FILA_CONTENDDT	DATUM	DATS	8	0	End Date of Contract for Contract Item
24	LEASTARTDT	☐	FILA_LEASTARTDT	DATUM	DATS	8	0	Date on Which Contract Processes Are Active(Lease Start Date
25	LEASOPTEXEDT	☐	FILA_LEASOPTEXEDT	DATUM	DATS	8	0	Option Exercise Date
26	TERM	☐	FILA_TERM	NUMC3	NUMC	3	0	Contract Term (in Months)
27	REM_USEFUL_LIFE	☐	FILA_REMAINING_USEFUL_LIFE		NUMC	3	0	Remaining Useful Life
28	PRODUCT	☐	MATNR	MATNR	CHAR	18	0	Material Number
29	USEDPRODUCT	☐	FILA_USEDPRODUCT	XFELD	CHAR	1	0	Used Goods
30	CUSTGROUP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
31	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
32	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
33	SOLDTO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
34	INSTAT	☐	FILA_INSTAT	KUNNR	CHAR	10	0	Installation Location
35	FINPROD	☐	FILA_FINPROD	MATNR	CHAR	18	0	Financing Product
36	FINCLAS	☐	FILA_FINCLASSIFICATION	FILA_FINCLASSIFICATION	CHAR	2	0	Classification of Financing Type
37	BP_USAGE	☐	FILA_BP_USAGE	FILA_BP_USAGE	CHAR	1	0	Use of Billing Plan
38	DEVICECLASS	☐	FILA_DEVICECLASS		CHAR	10	0	Device Class
39	OPTIONID	☐	FILA_OPTIONID	FILA_OPTIONID	CHAR	2	0	Option ID
40	CLASSIF_LOCAL	☐	FILA_CLASSLO		CHAR	2	0	Tax Financing Classification - Local
41	CLASSIF_GROUP	☐	FILA_CLASSGR		CHAR	2	0	Tax Financing Classification - Group
42	CLASSIF_LO_FLAG	☐	FILA_CLASSLO_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
43	CLASSIF_GR_FLAG	☐	FILA_CLASSGR_FLAG	XFELD	CHAR	1	0	Forced Classification
44	CLAS_CUSTOMER	☐	FILA_CLASSCU		CHAR	2	0	Classification - Customer
45	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area
46	CLASSIF_LOCALBK	☐	FILA_CLASSLOCBK		CHAR	2	0	Book Financing Classification - Local
47	CLASSIF_GROUPBK	☐	FILA_CLASSGRPBK		CHAR	2	0	Book Financing Classification - Group
48	CLASSIF_LOBK_FL	☐	FILA_CLASSLOCBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
49	CLASSIF_GRBK_FL	☐	FILA_CLASSGRPBK_FLAG	XFELD	CHAR	1	0	Forced Classification Indicator
50	INTRATE	☐	FILA_INTRATE	AFPROZ	DEC	7	4	Annual Interest Rate
51	PROC_INDICATOR	☐	FILA_PROC_CNTRL_INDICATOR	FILA_PROC_CNTRL_INDICATOR	NUMC	1	0	Process Indicator for Leveraged Debt Cost
52	BU_ID_NUMBER	☐	FILA_BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
53	BU_ID_TYPE	☐	FILA_BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type
54	BU_PARTNER	☐	FILA_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
55	BEMOT	☐	FILA_BEMOT	BEMOT	CHAR	2	0	Accounting Indicator
56	BUAG_ID	☐	FILA_BUAG_ID	CHAR12	CHAR	12	0	Business Agreement Number
57	TMSTAMPADJ	☐	FILA_TMSTAMPADJ	TZNTSTMPS	DEC	15	0	Time Stamp of Last Business Transaction from CRM
58	PROCMODE	☐	FILA_PROCMODE	FILA_PROCMODE	NUMC	1	0	Processing Mode of Process
59	LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
60	TMSTAMPREV	☐	FILA_TMSTAMPREV	TZNTSTMPS	DEC	15	0	Time Stamp of Business Transaction to be Reversed
61	ALLOCATION_ID	☐	FILA_ALLOCATION_ID	CHAR16	CHAR	16	0	External Assignment Indicator
62	TMSTAMPESP	☐	FILA_TMSTAMPESP	TZNTSTMPS	DEC	15	0	Time Stamp - Processed Successfully (BW Delta Extraction)
63	RUNID	☐	FILA_RUNID_MIG	NUMC10	NUMC	10	0	Migration Run Number
64	BUS_SCENARIO_ID	☐	FILA_BS_IDENTIFICATION		CHAR	16	0	Business Scenario for Which Controlling Is Performed
65	FIELD01	☐	FILA_FIELD01	CHAR20	CHAR	20	0	Field for Customer-Specific Data
66	FIELD02	☐	FILA_FIELD02	CHAR20	CHAR	20	0	Field for Customer-Specific Data
67	FIELD03	☐	FILA_FIELD03	CHAR20	CHAR	20	0	Field for Customer-Specific Data
68	LESSOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in