TVZ03 SAP table for – Flow control of advance payments and overpayments

Here we would like to draw your attention to TVZ03 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). TVZ03 is a SAP standard pool table used for storing Flow control of advance payments and overpayments related data in SAP. It comes under the package FVVD.

SAP TVZ03 table

Table TVZ03 technical data

TableTVZ03
Data storingFlow control of advance payments and overpayments
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-FINSERV
Table CategoryPOOL

SAP TVZ03 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 TVZ03 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
  • RANTYP : Contract Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SPRIO : Processing level / priority level flow control
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • SKRIT : Criterion for flow logic in planned record processing/IPD
    Its data type is CHAR (Character String) with field length 4
  • SEFFKAP : Effective Capital Available
    Its data type is CHAR (Character String) with field length 1
  • SFAELLIG : Next Due Date
    Its data type is CHAR (Character String) with field length 1
  • SANTEILIG : Proportional Planned Value Calculation
    Its data type is CHAR (Character String) with field length 1
  • SBTAGE : Upto days from system date
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • SMANU : Manual debit position / manually created planned records
    Its data type is CHAR (Character String) with field length 1
  • SMASU : Automatic debit position / memo records
    Its data type is CHAR (Character String) with field length 1
  • SGRENZE : Trivial Amount Limit
    Its data type is CURR (Currency Field) with field length 13