TDBL SAP table for – Form line items (credit stnd.check, doc.values, csh budget)

Here we would like to draw your attention to TDBL table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). TDBL is a SAP standard pool table used for storing Form line items (credit stnd.check, doc.values, csh budget) related data in SAP. It comes under the package FVVD.

SAP TDBL table

Table TDBL technical data

TableTDBL
Data storingForm line items (credit stnd.check, doc.values, csh budget)
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FINSERV
Table CategoryPOOL

SAP TDBL 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 TDBL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SBFRMTYP : Form type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SBELAART : Form item type
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • SBARTTYP : Item type
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SBRCHTYP : Item types-Calculation type
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SSMBLART : Form item type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PABSCHLG : Percentage (for markdown)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SVORSLGH : Mortgage Loan Proposal
    Its data type is CHAR (Character String) with field length 1
  • SVORSLGS : Borrower’s notes proposal
    Its data type is CHAR (Character String) with field length 1
  • SVORSLGP : Rollover proposal
    Its data type is CHAR (Character String) with field length 1
  • SVORSLGX : Proposal others
    Its data type is CHAR (Character String) with field length 1
  • PRZBLART : Form item type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SZUABKZ : +/- sign for effective interest rate calculation
    Its data type is CHAR (Character String) with field length 1
  • BBELAPRS : Single amount
    Its data type is CURR (Currency Field) with field length 13
  • SWHRBELA : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • JRDINAKT : Indicator for rounding inactive
    Its data type is CHAR (Character String) with field length 1
  • SMULTP : Multiplication Factor
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SDIVSN : Division Factor
    Its data type is NUMC (Character String with Digits Only) with field length 2