VDBILL_HIST SAP table for – Billing History

Here we would like to draw your attention to VDBILL_HIST 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). VDBILL_HIST is a SAP standard transp table used for storing Billing History related data in SAP. It comes under the package FVVD_BILL.

SAP VDBILL_HIST table

Table VDBILL_HIST technical data

TableVDBILL_HIST
Data storingBilling History
ModuleFS
Sub ModuleFS-CML-PO
SAP PackageFVVD_BILL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for Billing History
    Its a key field.
  • BILL_NUMBER : Bill Number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : Secondary Key for Billing History
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RANL : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Billing History Details
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • BILL_CATEGORY : Billing Category
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TOTAL_DUE : Total Due Amount for Bill
    Its data type is CURR (Currency Field) with field length 13
  • MINIMUM_DUE : Minimum Due Amount for a Bill
    Its data type is CURR (Currency Field) with field length 13
  • PRIN_BALANCE : Outstanding Net Payoff Amount
    Its data type is CURR (Currency Field) with field length 13
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CREATION_DATE : Bill Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUE_DATE : Due date/calculation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BILL_FORMAT : Bill Format Key
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LOGNUMBER : Application Log: External ID
    Its data type is CHAR (Character String) with field length 100