SAP VITMPY Term: Posting Rule Table
Overview
VITMPY is a standard SAP S/4HANA table that stores Term: Posting Rule data. There are total 30 fields in the VITMPY table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VITMPY belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Terms - Finance (Terms for Posting Parameters) (RE_TM_FI).
In addition, following links provide an overview of foreign key relationships, if any, that link VITMPY to other SAP tables and standard CDS views available based on VITMPY table in S/4HANA 2020.
Techincal Settings of VITMPY
Below are technical details of the table VITMPY
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VITMPY Fields
The following table gives you an overview of the fields available in VITMPY
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| TERMTYPE | Term Category | RETMTERMTYPE | TIVTMTERMTYPE | CHAR | 4 |
| TERMNO | Term Number | RETMTERMNO | VITMTERM | CHAR | 4 |
| VALIDFROM | Valid-From Date of Term | RETMTERMVALIDFROM | DATS | 8 | |
| VALIDTO | Valid-To Date of Term | RETMTERMVALIDTO | DATS | 8 | |
| PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | |
| PYMTMETHCRMO | Payment Method for Credit Memos | RERAPYMTMETHCRMO | CHAR | 4 | |
| PYMTBLOCK | Payment block key | RERAPYMTBLOCK | CHAR | 4 | |
| PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | |
| HOUSEBKID | Key for House Bank | RERAHOUSEBKID | CHAR | 15 | |
| HOUSEBKACC | Key for House Bank Account | RERAHOUSEBKACC | CHAR | 15 | |
| BANKDETAILID | Bank Details ID | RERABANKDETAILID | CHAR | 15 | |
| NOTETOPAYEE | Note to Payee | RERANOTETOPAYEE | CHAR | 25 | |
| DUNNAREA | Dunning Area | RERADUNNAREA | CHAR | 4 | |
| DUNNKEY | Dunning Keys | RERADUNNKEY | CHAR | 4 | |
| DUNNBLOCK | Dunning Block | RERADUNNBLOCK | CHAR | 4 | |
| ACCDETKEY | Account Determination Value | RERAACCDETKEY | * | CHAR | 10 |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| TAXCOUNTRY | Alternative Tax Reporting Country | RERATAXCOUNTRY | * | CHAR | 3 |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| ISPARTNERBLOCKED | Lock of Partner Data in Posting Term | RERAISPARTNERBLOCKED | CHAR | 1 | |
| SEPAMNDID | SEPA Mandate: Unique Reference to Mandate per Vendor | RETMSEPAMNDID | CHAR | 35 | |
| SEPARECCRDID | SEPA Mandate: Creditor ID | RETMSEPARECCRDID | CHAR | 35 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VITMPY
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VITMPY | TAXGROUP | 1: CN | * |
| VITMPY | TAXTYPE | C: CN | TIVRATAXTYPE |
| VITMPY | TERMNO | 1: CN | VITMTERM |
| VITMPY | TERMTYPE | 1: CN | TIVTMTERMTYPE |