VITMPY SAP table for – Term: Posting Rule

Here we would like to draw your attention to VITMPY table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VITMPY is a SAP standard transp table used for storing Term: Posting Rule related data in SAP. It comes under the package RE_TM_FI.

SAP VITMPY table

Table VITMPY technical data

TableVITMPY
Data storingTerm: Posting Rule
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_TM_FI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key Fields Term Posting Rule
    Its a key field.
  • .INCLUDE : Clause: Semantic Key
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • TERMTYPE : Term Category
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • TERMNO : Term Number
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VALIDFROM : Valid-From Date of Term
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Table Fields for Posting Rule
  • VALIDTO : Valid-To Date of Term
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Table Fields for Posting Rule
  • PYMTMETH : Payment Method
    Its data type is CHAR (Character String) with field length 4
  • PYMTMETHCRMO : Payment Method for Credit Memos
    Its data type is CHAR (Character String) with field length 4
  • PYMTBLOCK : Payment block key
    Its data type is CHAR (Character String) with field length 4
  • PYMTTERM : Terms of Payment Key
    Its data type is CHAR (Character String) with field length 4
  • HOUSEBKID : Key for House Bank
    Its data type is CHAR (Character String) with field length 15
  • HOUSEBKACC : Key for House Bank Account
    Its data type is CHAR (Character String) with field length 15
  • BANKDETAILID : Bank Details ID
    Its data type is CHAR (Character String) with field length 15
  • NOTETOPAYEE : Note to Payee
    Its data type is CHAR (Character String) with field length 25
  • DUNNAREA : Dunning Area
    Its data type is CHAR (Character String) with field length 4
  • DUNNKEY : Dunning Keys
    Its data type is CHAR (Character String) with field length 4
  • DUNNBLOCK : Dunning Block
    Its data type is CHAR (Character String) with field length 4
  • ACCDETKEY : Account Determination Value
    Its data type is CHAR (Character String) with field length 10
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its data type is CHAR (Character String) with field length 22
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • ISCDSPLIT : Condition Split
    Its data type is CHAR (Character String) with field length 1
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • ISPARTNERBLOCKED : Lock of Partner Data in Posting Term
    Its data type is CHAR (Character String) with field length 1
  • SEPAMNDID : SEPA Mandate: Unique Reference to Mandate per Vendor
    Its data type is CHAR (Character String) with field length 35
  • SEPARECCRDID : SEPA Mandate: Creditor ID
    Its data type is CHAR (Character String) with field length 35