VFPLT SAP table for – Billing Plan: Dates

Here we would like to draw your attention to VFPLT table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). VFPLT is a SAP standard transparent table used for storing Billing Plan: Dates related data in SAP. It comes under the package VZ.

SAP VFPLT table

Table VFPLT technical data

TableVFPLT
Data storingBilling Plan: Dates
ModuleSD
ComponentSD-BF
SAP PackageVZ
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VFPLT Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VFPLT table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • KURFP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • FAKWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FAKSP
    Its data type is C (Character String) with field length 2
  • FKARV
    Its data type is C (Character String) with field length 4
  • FKSAF
    Its data type is C (Character String) with field length 1
  • PERIO
    Its data type is C (Character String) with field length 2
  • FPLAE
    Its data type is N (Character String with Digits Only) with field length 3
  • MLSTN : Usage
    Its data type is N (Character String with Digits Only) with field length 12
  • MLBEZ
    Its data type is C (Character String) with field length 5
  • FPLNR : Billing plan number / invoicing plan number
    Its a key field. Its data type is C (Character String) with field length 10
  • ZTERM
    Its data type is C (Character String) with field length 4
  • KUNRG : Payer
    Its data type is C (Character String) with field length 10
  • TAXK1 : Tax classification 1 for customer
    Its data type is C (Character String) with field length 1
  • TAXK2 : Tax classification 2 for customer
    Its data type is C (Character String) with field length 1
  • TAXK3 : Tax classification 3 for customer
    Its data type is C (Character String) with field length 1
  • TAXK4 : Tax classification 4 for customer
    Its data type is C (Character String) with field length 1
  • TAXK5
    Its data type is C (Character String) with field length 1
  • TAXK6
    Its data type is C (Character String) with field length 1
  • TAXK7
    Its data type is C (Character String) with field length 1
  • TAXK8
    Its data type is C (Character String) with field length 1
  • FPLTR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • TAXK9
    Its data type is C (Character String) with field length 1
  • VALTG
    Its data type is N (Character String with Digits Only) with field length 2
  • VALDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TEMAN
    Its data type is C (Character String) with field length 1
  • FAKCA
    Its data type is C (Character String) with field length 2
  • AFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NETPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • WAVWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • FPTTP
    Its data type is C (Character String) with field length 2
  • KZWI1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CMPRE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SKFBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BONBA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PRSOK
    Its data type is C (Character String) with field length 1
  • TETXT
    Its data type is C (Character String) with field length 4
  • TYPZM
    Its data type is C (Character String) with field length 1
  • CMPRE_FLT
    Its data type is F (Floating point number) with field length 8
  • UELNR
    Its data type is C (Character String) with field length 10
  • UELTR
    Its data type is N (Character String with Digits Only) with field length 6
  • KURRF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • CCACT
    Its data type is C (Character String) with field length 10
  • KORTE
    Its data type is C (Character String) with field length 1
  • FKDAT : Billing date for billing index and printout
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FPFIX
    Its data type is C (Character String) with field length 1
  • FAREG
    Its data type is C (Character String) with field length 1
  • FPROZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3