LAE_CRM_ITEMS

LAE: Contract Items | #masterdata | Component: Lease Accounting
Column Name Description
MANDT Client
BUKRS Company Code
OBJID FK Object Number
SUBID Subobject Number
TMSTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Column Name Description
Column Name Description
📏 Base Unit of Measure (UNIT):
QUANTITY Quantity
Column Name Description
CONTSTARTDT Start Date of Contract for Contract Item
CONTENDDT End Date of Contract for Contract Item
LEASTARTDT Date on Which Contract Processes Are Active(Lease Start Date
LEASOPTEXEDT Option Exercise Date
Column Name Description
STATUS Processing Status Show values
USEDPRODUCT Used Goods Show values
FINCLAS Classification of Financing Type Show values
BP_USAGE Use of Billing Plan Show values
CLASSIF_LO_FLAG Forced Classification Indicator Show values
CLASSIF_GR_FLAG Forced Classification Show values
CLASSIF_LOBK_FL Forced Classification Indicator Show values
CLASSIF_GRBK_FL Forced Classification Indicator Show values
PROC_INDICATOR Process Indicator for Leveraged Debt Cost Show values
PROCMODE Processing Mode of Process Show values
Column Name Description Domain name
EVENT Process FILA_EVENT
ITEMNO Item Number
ITEMNO_EXT External Item Number
ITEMTXT Item Description TEXT50
EXCHG_RATE Exchange rate KURSF
BUKRS_REF Company Code BUKRS
OBJID_REF Object Number of Reference Object
SUBID_REF Reference Sub-Object Number
SUBID_STG Reference Sub-Object Number
UIID Unique Item ID in Life Cycle FILA_UIID
EXT_POS_REF External Item Reference FILA_EXT_ITEM_REF
FREE_POS_REF Custom External Item Reference FILA_EXT_ITEM_REF
TERM Contract Term (in Months) NUMC3
REM_USEFUL_LIFE Remaining Useful Life
PRODUCT Material Number MATNR
INSTAT Installation Location KUNNR
FINPROD Financing Product MATNR
DEVICECLASS Device Class
OPTIONID Option ID FILA_OPTIONID
CLASSIF_LOCAL Tax Financing Classification - Local
CLASSIF_GROUP Tax Financing Classification - Group
CLAS_CUSTOMER Classification - Customer
BUS_AREA Business Area GSBER
CLASSIF_LOCALBK Book Financing Classification - Local
CLASSIF_GROUPBK Book Financing Classification - Group
INTRATE Annual Interest Rate AFPROZ
BU_ID_NUMBER Identification Number CHAR60
BU_ID_TYPE Identification Type BU_ID_TYPE
BU_PARTNER Business Partner Number BU_PARTNER
BEMOT Accounting Indicator BEMOT
BUAG_ID Business Agreement Number CHAR12
TMSTAMPADJ Time Stamp of Last Business Transaction from CRM TZNTSTMPS
LOGHANDLE Application Log: Log Handle SYSUUID_22
TMSTAMPREV Time Stamp of Business Transaction to be Reversed TZNTSTMPS
ALLOCATION_ID External Assignment Indicator CHAR16
TMSTAMPESP Time Stamp - Processed Successfully (BW Delta Extraction) TZNTSTMPS
RUNID Migration Run Number NUMC10
BUS_SCENARIO_ID Business Scenario for Which Controlling Is Performed
FIELD01 Field for Customer-Specific Data CHAR20
FIELD02 Field for Customer-Specific Data CHAR20
FIELD03 Field for Customer-Specific Data CHAR20
LESSOR Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Customer Group
  • Customer Group
  • Client
  • LAE_CRM_ITEMS.CUSTGROUP == T151.KDGRP
  • LAE_CRM_ITEMS.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • LAE_CRM_ITEMS.DIS_CHANNEL == TVTW.VTWEG
  • LAE_CRM_ITEMS.MANDT == TVTW.MANDT
Sales Organization
  • LAE_CRM_ITEMS.MANDT == TVKO.MANDT
  • LAE_CRM_ITEMS.SALESORG == TVKO.VKORG
Sold-to Party
  • LAE_CRM_ITEMS.MANDT == KNA1.MANDT
  • LAE_CRM_ITEMS.SOLDTO == KNA1.KUNNR