LAE_CRM_ITEMS SAP table for – LAE: Contract Items

Here we would like to draw your attention to LAE_CRM_ITEMS table in SAP. As we know it is being mainly used with the SAP FI-LA (Lease Accounting in FI) component which is coming under FI module (Financial Accounting). LAE_CRM_ITEMS is a SAP standard transp table used for storing LAE: Contract Items related data in SAP. It comes under the package FI_LA_GF.

SAP LAE_CRM_ITEMS table

Table LAE_CRM_ITEMS technical data

TableLAE_CRM_ITEMS
Data storingLAE: Contract Items
ModuleFI
Sub ModuleFI-LA
SAP PackageFI_LA_GF
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP LAE_CRM_ITEMS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in LAE_CRM_ITEMS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OBJID : Object Number
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • SUBID : Subobject Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • TMSTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • .INCLUDE : LAE: Substructure for Contract Items Gen. Data
  • EVENT : Process
    Its data type is CHAR (Character String) with field length 20
  • STATUS : Processing Status
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ITEMNO : Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITEMNO_EXT : External Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITEMTXT : Item Description
    Its data type is CHAR (Character String) with field length 50
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EXCHG_RATE : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • QUANTITY : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • UNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BUKRS_REF : Company Code
    Its data type is CHAR (Character String) with field length 4
  • OBJID_REF : Object Number of Reference Object
    Its data type is RAW (Byte string) with field length 16
  • SUBID_REF : Reference Sub-Object Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • SUBID_STG : Reference Sub-Object Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • UIID : Unique Item ID in Life Cycle
    Its data type is CHAR (Character String) with field length 12
  • EXT_POS_REF : External Item Reference
    Its data type is CHAR (Character String) with field length 35
  • FREE_POS_REF : Custom External Item Reference
    Its data type is CHAR (Character String) with field length 35
  • .INCLUDE : LAE: Substructure Contract Item Dates/Term
  • CONTSTARTDT : Start Date of Contract for Contract Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONTENDDT : End Date of Contract for Contract Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LEASTARTDT : Date on Which Contract Processes Are Active(Lease Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LEASOPTEXEDT : Option Exercise Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERM : Contract Term (in Months)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REM_USEFUL_LIFE : Remaining Useful Life
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : LAE: Substructure Contract Item Sales Data
  • PRODUCT : Material Number
    Its data type is CHAR (Character String) with field length 18
  • USEDPRODUCT : Used Goods
    Its data type is CHAR (Character String) with field length 1
  • CUSTGROUP : Customer group
    Its data type is CHAR (Character String) with field length 2
  • SALESORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • DIS_CHANNEL : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • SOLDTO : Sold-to party
    Its data type is CHAR (Character String) with field length 10
  • INSTAT : Installation Location
    Its data type is CHAR (Character String) with field length 10
  • FINPROD : Financing Product
    Its data type is CHAR (Character String) with field length 18
  • FINCLAS : Classification of Financing Type
    Its data type is CHAR (Character String) with field length 2
  • BP_USAGE : Use of Billing Plan
    Its data type is CHAR (Character String) with field length 1
  • DEVICECLASS : Device Class
    Its data type is CHAR (Character String) with field length 10
  • OPTIONID : Option ID
    Its data type is CHAR (Character String) with field length 2
  • CLASSIF_LOCAL : Tax Financing Classification – Local
    Its data type is CHAR (Character String) with field length 2
  • CLASSIF_GROUP : Tax Financing Classification – Group
    Its data type is CHAR (Character String) with field length 2
  • CLASSIF_LO_FLAG : Forced Classification Indicator
    Its data type is CHAR (Character String) with field length 1
  • CLASSIF_GR_FLAG : Forced Classification
    Its data type is CHAR (Character String) with field length 1
  • CLAS_CUSTOMER : Classification – Customer
    Its data type is CHAR (Character String) with field length 2
  • BUS_AREA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • CLASSIF_LOCALBK : Book Financing Classification – Local
    Its data type is CHAR (Character String) with field length 2
  • CLASSIF_GROUPBK : Book Financing Classification – Group
    Its data type is CHAR (Character String) with field length 2
  • CLASSIF_LOBK_FL : Forced Classification Indicator
    Its data type is CHAR (Character String) with field length 1
  • CLASSIF_GRBK_FL : Forced Classification Indicator
    Its data type is CHAR (Character String) with field length 1
  • INTRATE : Annual Interest Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • PROC_INDICATOR : Process Indicator for Leveraged Debt Cost
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • BU_ID_NUMBER : Identification Number
    Its data type is CHAR (Character String) with field length 60
  • BU_ID_TYPE : Identification Type
    Its data type is CHAR (Character String) with field length 6
  • BU_PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • BEMOT : Accounting Indicator
    Its data type is CHAR (Character String) with field length 2
  • BUAG_ID : Business Agreement Number
    Its data type is CHAR (Character String) with field length 12
  • TMSTAMPADJ : Time Stamp of Last Business Transaction from CRM
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PROCMODE : Processing Mode of Process
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • LOGHANDLE : Application Log: Log Handle
    Its data type is CHAR (Character String) with field length 22
  • TMSTAMPREV : Time Stamp of Business Transaction to be Reversed
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ALLOCATION_ID : External Assignment Indicator
    Its data type is CHAR (Character String) with field length 16
  • TMSTAMPESP : Time Stamp – Processed Successfully (BW Delta Extraction)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • RUNID : Migration Run Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • BUS_SCENARIO_ID : Business Scenario for Which Controlling Is Performed
    Its data type is CHAR (Character String) with field length 16
  • FIELD01 : Field for Customer-Specific Data
    Its data type is CHAR (Character String) with field length 20
  • FIELD02 : Field for Customer-Specific Data
    Its data type is CHAR (Character String) with field length 20
  • FIELD03 : Field for Customer-Specific Data
    Its data type is CHAR (Character String) with field length 20
  • LESSOR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10