LAE_CRM_ITEMS SAP (LAE: Contract Items) Table details

Dictionary Type: Table
Description: LAE: Contract Items




ABAP Code to SELECT data from LAE_CRM_ITEMS
Related tables to LAE_CRM_ITEMS
Access table LAE_CRM_ITEMS




Table field list including key, data, relationships and ABAP select examples

LAE_CRM_ITEMS is a standard SAP Table which is used to store LAE: Contract Items data and is available within R/3 SAP systems depending on the version and release level.

The LAE_CRM_ITEMS table consists of various fields, each holding specific information or linking keys about LAE: Contract Items data available in SAP. These include BUKRS (Company Code), OBJID (Object Number), SUBID (Subobject Number), TMSTAMP (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP LAE_CRM_ITEMS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
OBJIDObject Number FILA_OBJIDRAW16LAE_CRM_HEADER
SUBIDSubobject Number FILA_SUBIDNUMC5
TMSTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
EVENTProcess FILA_EVENTCHAR20Assigned to domainFILA_EVENTFILA_EVENT
STATUSProcessing Status FILA_STATUSNUMC1FILA_STATUS
ITEMNOItem Number FILA_ITEMNONUMC10KPO
ITEMNO_EXTExternal Item Number FILA_ITEMNO_EXTNUMC10KPO
ITEMTXTItem Description FILA_ITEMTXTCHAR50TEXT50
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
EXCHG_RATEExchange rate KURSFDEC9(5) EXCRTKURSF
QUANTITYQuantity AM_MENGEQUAN13(3) MENG13V
UNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
BUKRS_REFCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
OBJID_REFObject Number of Reference Object FILA_OBJID_REFRAW16
SUBID_REFReference Sub-Object Number FILA_SUBID_REFNUMC5
SUBID_STGReference Sub-Object Number FILA_SUBID_REFNUMC5
UIIDUnique Item ID in Life Cycle FILA_UIIDCHAR12FILA_UIID
EXT_POS_REFExternal Item Reference FILA_EXT_ITEM_REFCHAR35FILA_EXT_ITEM_REF
FREE_POS_REFCustom External Item Reference FILA_FREE_EXT_ITEM_REFCHAR35FILA_EXT_ITEM_REF
CONTSTARTDTStart Date of Contract for Contract Item FILA_CONTSTARTDTDATS8DATUM
CONTENDDTEnd Date of Contract for Contract Item FILA_CONTENDDTDATS8DATUM
LEASTARTDTDate on Which Contract Processes Are Active(Lease Start Date FILA_LEASTARTDTDATS8DATUM
LEASOPTEXEDTOption Exercise Date FILA_LEASOPTEXEDTDATS8DATUM
TERMContract Term (in Months) FILA_TERMNUMC3NUMC3
REM_USEFUL_LIFERemaining Useful Life FILA_REMAINING_USEFUL_LIFENUMC3
PRODUCTMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
USEDPRODUCTUsed Goods FILA_USEDPRODUCTCHAR1XFELD
CUSTGROUPCustomer group KDGRPCHAR2T151KDGRPVKD
SALESORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
DIS_CHANNELDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SOLDTOSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
INSTATInstallation Location FILA_INSTATCHAR10Assigned to domainALPHAKUNNR
FINPRODFinancing Product FILA_FINPRODCHAR18Assigned to domainMATN1MATNR
FINCLASClassification of Financing Type FILA_FINCLASSIFICATIONCHAR2FILA_FINCLASSIFICATION
BP_USAGEUse of Billing Plan FILA_BP_USAGECHAR1FILA_BP_USAGE
DEVICECLASSDevice Class FILA_DEVICECLASSCHAR10
OPTIONIDOption ID FILA_OPTIONIDCHAR2Assigned to domainFILA_OPTIONID
CLASSIF_LOCALTax Financing Classification - Local FILA_CLASSLOCHAR2
CLASSIF_GROUPTax Financing Classification - Group FILA_CLASSGRCHAR2
CLASSIF_LO_FLAGForced Classification Indicator FILA_CLASSLO_FLAGCHAR1XFELD
CLASSIF_GR_FLAGForced Classification FILA_CLASSGR_FLAGCHAR1XFELD
CLAS_CUSTOMERClassification - Customer FILA_CLASSCUCHAR2
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
CLASSIF_LOCALBKBook Financing Classification - Local FILA_CLASSLOCBKCHAR2
CLASSIF_GROUPBKBook Financing Classification - Group FILA_CLASSGRPBKCHAR2
CLASSIF_LOBK_FLForced Classification Indicator FILA_CLASSLOCBK_FLAGCHAR1XFELD
CLASSIF_GRBK_FLForced Classification Indicator FILA_CLASSGRPBK_FLAGCHAR1XFELD
INTRATEAnnual Interest Rate FILA_INTRATEDEC7(4) AFPROZ
PROC_INDICATORProcess Indicator for Leveraged Debt Cost FILA_PROC_CNTRL_INDICATORNUMC1FILA_PROC_CNTRL_INDICATOR
BU_ID_NUMBERIdentification Number FILA_BU_ID_NUMBERCHAR60CHAR60
BU_ID_TYPEIdentification Type FILA_BU_ID_TYPECHAR6Assigned to domainBU_ID_TYPE
BU_PARTNERBusiness Partner Number FILA_BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BEMOTAccounting Indicator FILA_BEMOTCHAR2Assigned to domainBEMOT
BUAG_IDBusiness Agreement Number FILA_BUAG_IDCHAR12CHAR12
TMSTAMPADJTime Stamp of Last Business Transaction from CRM FILA_TMSTAMPADJDEC15TZNTSTMPS
PROCMODEProcessing Mode of Process FILA_PROCMODENUMC1FILA_PROCMODE
LOGHANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
TMSTAMPREVTime Stamp of Business Transaction to be Reversed FILA_TMSTAMPREVDEC15TZNTSTMPS
ALLOCATION_IDExternal Assignment Indicator FILA_ALLOCATION_IDCHAR16CHAR16
TMSTAMPESPTime Stamp - Processed Successfully (BW Delta Extraction) FILA_TMSTAMPESPDEC15TZNTSTMPS
RUNIDMigration Run Number FILA_RUNID_MIGNUMC10NUMC10
BUS_SCENARIO_IDBusiness Scenario for Which Controlling Is Performed FILA_BS_IDENTIFICATIONCHAR16
FIELD01Field for Customer-Specific Data FILA_FIELD01CHAR20CHAR20
FIELD02Field for Customer-Specific Data FILA_FIELD02CHAR20CHAR20
FIELD03Field for Customer-Specific Data FILA_FIELD03CHAR20CHAR20
LESSORAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C

Key field Non-key field



How do I retrieve data from SAP table LAE_CRM_ITEMS using ABAP code

The following ABAP code Example will allow you to do a basic selection on LAE_CRM_ITEMS to SELECT all data from the table
DATA: WA_LAE_CRM_ITEMS TYPE LAE_CRM_ITEMS.

SELECT SINGLE *
FROM LAE_CRM_ITEMS
INTO CORRESPONDING FIELDS OF WA_LAE_CRM_ITEMS
WHERE...

How to access SAP table LAE_CRM_ITEMS

Within an ECC or HANA version of SAP you can also view further information about LAE_CRM_ITEMS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!