SAP Table V_LAECRM_ITEMS stores Generated Table for Viewdata

  

In this post, I will try and describe everything you need to know about the SAP v_laecrm_items table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for V_LAECRM_ITEMS what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from V_LAECRM_ITEMS....Right lets get started!


SAP V_LAECRM_ITEMS dictionary attributes

Object Name: V_LAECRM_ITEMS
Dictionary Type: Table view
Description: Generated Table for View


V_LAECRM_ITEMS field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) ClientMANDTTEST
BUKRSBUKRSCHAR4(0) Company CodeBUKRSBUKFBC_T001BUKRS
OBJIDFILA_OBJIDRAW16(0) LAE_CRM_HEADERObject Number
REF_SUBKEYFILA_SUBIDNUMC5(0) Subobject Number
TMSTAMPTIMESTAMPDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPS
EVENTFILA_EVENTCHAR20(0) ProcessFILA_EVENTFILA_EVENT
STATUSFILA_STATUSNUMC1(0) Processing StatusFILA_STATUS
ITEMNOFILA_ITEMNONUMC10(0) Item NumberKPO
ITEMNO_EXTFILA_ITEMNO_EXTNUMC10(0) External Item NumberKPO
ITEMTXTFILA_ITEMTXTCHAR50(0) Item DescriptionTEXT50
CURRENCYWAERSCUKY5(0) Currency KeyWAERSFWSFB
EXCHG_RATEKURSFDEC9(5) Exchange rateKURSFFB
QUANTITYAM_MENGEQUAN13(3) QuantityMENG13VMG
UNITMEINSUNIT3(0) Base Unit of MeasureMEINSMG
BUKRS_REFBUKRSCHAR4(0) Company CodeBUKRSBUKFBC_T001BUKRS
OBJID_REFFILA_OBJID_REFRAW16(0) Object Number of Reference Object
SUBID_REFFILA_SUBID_REFNUMC5(0) Reference Sub-Object Number
SUBID_STGFILA_SUBID_REFNUMC5(0) Reference Sub-Object Number
UIIDFILA_UIIDCHAR12(0) Unique Item ID in Life CycleFILA_UIID
EXT_POS_REFFILA_EXT_ITEM_REFCHAR35(0) External Item ReferenceFILA_EXT_ITEM_REF
FREE_POS_REFFILA_FREE_EXT_ITEM_REFCHAR35(0) Custom External Item ReferenceFILA_EXT_ITEM_REF
CONTSTARTDTFILA_CONTSTARTDTDATS8(0) Start Date of Contract for Contract ItemDATUMAA
CONTENDDTFILA_CONTENDDTDATS8(0) End Date of Contract for Contract ItemDATUMAA
LEASTARTDTFILA_LEASTARTDTDATS8(0) Date on Which Contract Processes Are Active(Lease Start DateDATUMAA
LEASOPTEXEDTFILA_LEASOPTEXEDTDATS8(0) Option Exercise DateDATUM
TERMFILA_TERMNUMC3(0) Contract Term (in Months)NUMC3AA
REM_USEFUL_LIFEFILA_REMAINING_USEFUL_LIFENUMC3(0) Remaining Useful Life
PRODUCTMATNRCHAR18(0) Material NumberMATNRMATMGS_MAT1MATNR
USEDPRODUCTFILA_USEDPRODUCTCHAR1(0) Used GoodsXFELD
CUSTGROUPKDGRPCHAR2(0) T151Customer groupKDGRPVKDV
SALESORGVKORGCHAR4(0) TVKOSales OrganizationVKORGVKOVC_VKORGVKORG
DIS_CHANNELVTWEGCHAR2(0) TVTWDistribution ChannelVTWEGVTWVC_VTWEGVTWEG
SOLDTOKUNAGCHAR10(0) KNA1Sold-to partyKUNNRVAGVP
INSTATFILA_INSTATCHAR10(0) Installation LocationKUNNR
FINPRODFILA_FINPRODCHAR18(0) Financing ProductMATNR
FINCLASFILA_FINCLASSIFICATIONCHAR2(0) Classification of Financing TypeFILA_FINCLASSIFICATION
BP_USAGEFILA_BP_USAGECHAR1(0) Use of Billing PlanFILA_BP_USAGE
DEVICECLASSFILA_DEVICECLASSCHAR10(0) Device Class
OPTIONIDFILA_OPTIONIDCHAR2(0) Option IDFILA_OPTIONID
CLASSIF_LOCALFILA_CLASSLOCHAR2(0) Tax Financing Classification - Local
CLASSIF_GROUPFILA_CLASSGRCHAR2(0) Tax Financing Classification - Group
CLASSIF_LO_FLAGFILA_CLASSLO_FLAGCHAR1(0) Forced Classification IndicatorXFELD
CLASSIF_GR_FLAGFILA_CLASSGR_FLAGCHAR1(0) Forced ClassificationXFELD
CLAS_CUSTOMERFILA_CLASSCUCHAR2(0) Classification - Customer
BUS_AREAGSBERCHAR4(0) Business AreaGSBERGSBFB
CLASSIF_LOCALBKFILA_CLASSLOCBKCHAR2(0) Book Financing Classification - Local
CLASSIF_GROUPBKFILA_CLASSGRPBKCHAR2(0) Book Financing Classification - Group
CLASSIF_LOBK_FLFILA_CLASSLOCBK_FLAGCHAR1(0) Forced Classification IndicatorXFELD
CLASSIF_GRBK_FLFILA_CLASSGRPBK_FLAGCHAR1(0) Forced Classification IndicatorXFELD
INTRATEFILA_INTRATEDEC7(4) Annual Interest RateAFPROZABA
PROC_INDICATORFILA_PROC_CNTRL_INDICATORNUMC1(0) Process Indicator for Leveraged Debt CostFILA_PROC_CNTRL_INDICATOR
BU_ID_NUMBERFILA_BU_ID_NUMBERCHAR60(0) Identification NumberCHAR60
BU_ID_TYPEFILA_BU_ID_TYPECHAR6(0) Identification TypeBU_ID_TYPE
BU_PARTNERFILA_BU_PARTNERCHAR10(0) Business Partner NumberBU_PARTNERBPABUPAPARTNER
BEMOTFILA_BEMOTCHAR2(0) Accounting IndicatorBEMOT
BUAG_IDFILA_BUAG_IDCHAR12(0) Business Agreement NumberCHAR12
TMSTAMPADJFILA_TMSTAMPADJDEC15(0) Time Stamp of Last Business Transaction from CRMTZNTSTMPS
PROCMODEFILA_PROCMODENUMC1(0) Processing Mode of ProcessFILA_PROCMODE
LOGHANDLEBALLOGHNDLCHAR22(0) Application Log: Log HandleSYSUUID_22
TMSTAMPREVFILA_TMSTAMPREVDEC15(0) Time Stamp of Business Transaction to be ReversedTZNTSTMPS
ALLOCATION_IDFILA_ALLOCATION_IDCHAR16(0) External Assignment IndicatorCHAR16
TMSTAMPESPFILA_TMSTAMPESPDEC15(0) Time Stamp - Processed Successfully (BW Delta Extraction)TZNTSTMPS
RUNIDFILA_RUNID_MIGNUMC10(0) Migration Run NumberNUMC10
BUS_SCENARIO_IDFILA_BS_IDENTIFICATIONCHAR16(0) Business Scenario for Which Controlling Is Performed
FIELD01FILA_FIELD01CHAR20(0) Field for Customer-Specific DataCHAR20
FIELD02FILA_FIELD02CHAR20(0) Field for Customer-Specific DataCHAR20
FIELD03FILA_FIELD03CHAR20(0) Field for Customer-Specific DataCHAR20
LESSORLIFNRCHAR10(0) Account Number of Vendor or CreditorLIFNRLIFFBKRED_CLIFNR