LAE_CRM_BILLPLAN SAP table for – Payment Schedule

Here we would like to draw your attention to LAE_CRM_BILLPLAN 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_BILLPLAN is a SAP standard transp table used for storing Payment Schedule related data in SAP. It comes under the package FI_LA_GF.

SAP LAE_CRM_BILLPLAN table

Table LAE_CRM_BILLPLAN technical data

TableLAE_CRM_BILLPLAN
Data storingPayment Schedule
ModuleFI
Sub ModuleFI-LA
SAP PackageFI_LA_GF
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP LAE_CRM_BILLPLAN 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_BILLPLAN 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
  • BILLID : Sequence Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • KSCHA : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • KWERT : Condition Value
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PERIODDATE : Payment Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTLFROM : Start Date of Period in Billing Plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTLTO : End Date of Period in Billing Plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CASHFLOWTYPE : Flow Category
    Its data type is CHAR (Character String) with field length 4
  • SETTLFROMEXCL : FIMA Exclusive Indicator for Start Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SETTLTOINCL : FIMA Inclusive Indicator for End Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PERIODDATEINCL : FIMA Inclusive Indicator for Due Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PERIODDATEULT : FIMA Month-End Indicator for Due Date
    Its data type is CHAR (Character String) with field length 1
  • SETTLFROMULT : FIMA Month-End Indicator for Start Date
    Its data type is CHAR (Character String) with field length 1
  • SETTLTOULT : FIMA Month-End Indicator for End Date
    Its data type is CHAR (Character String) with field length 1
  • IMMSETTL : FIMA Indicator for Immediate Clearing
    Its data type is CHAR (Character String) with field length 1
  • CLEARDATE : Settlement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLEARDATEINCL : FIMA Inclusive Indicator for Settlement Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CLEARDATEULT : FIMA Month-End Indicator for Settlement Date
    Its data type is CHAR (Character String) with field length 1
  • CALCDATE : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALCDATEINCL : FIMA Inclusive Indicator for Calculation Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • CALCDATEULT : FIMA Month-End Indicator for Calculation Date
    Its data type is CHAR (Character String) with field length 1
  • PERENDD : Period To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PERENDDINCL : FIMA Inclusive Indicator for End Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • PERENDDULT : FIMA Month-End Indicator for End Date
    Its data type is CHAR (Character String) with field length 1