What are the main SAP Payment Terms Tables ?
What are the related Tables in SAP for ZTerm ?
Find also some useful Tips dealing with Payment Terms in SAP.
Table of Contents
SAP Payment Terms Tables
The main table for Payment Terms in SAP isT052.
The SAP tableTVZBT Gives the details of a Payment Terms Description.
Main Payment Terms Tables in SAP
| Table | PAYMENT TERMS TABLE |
|---|---|
| T052 | Terms of Payment |
| TVZBT | Payment Terms Description Tables |
| T052U | SAP Own Explanations for Terms of Payment Table |
| V_T052 | Maintenance View for T052 |
T052:ZTERM Payment Terms Table & Fields
T052 is a standard SAP Table which is used to store Terms of Payment information.
Here the main list of ZTERM’s T052 Payment Terms Table:
| MANDT | CLIENT |
|---|---|
| ZTERM | Terms of payment key |
| ZTAGG | Day Limit |
| ZDART | Date Type |
| ZFAEL | Calendar Day for the Baseline Date for Payment |
| ZMONA | Additional Months |
| ZTAG1 | Days from Baseline Date for Payment |
| ZPRZ1 | Cash Discount Percentage Rate |
| ZTAG2 | Days from Baseline Date for Payment |
| ZPRZ2 | Cash Discount Percentage Rate |
| ZTAG3 | Days from Baseline Date for Payment |
| ZSTG1 | Due Date for Special Condition |
| ZSMN1 | Additional Months for Special Condition (Term 1) |
| ZSTG2 | Due Date for Special Condition |
| ZSMN2 | Additional Months for Special Condition (Term 2) |
| ZSTG3 | Due Date for Special Condition |
| ZSMN3 | Additional Months for Special Condition (Term 3) |
| XZBRV | Print terms of payment in RV papers |
| ZSCHF | Payment Block (Default Value) |
| XCHPB | Transfer payment block when changing terms of payment |
| TXN08 | Number of the standard text |
| ZLSCH | Payment method |
| XCHPM | Transfer payment method when changing terms of payment |
| KOART | Account Type of the Customer/Vendor |
| XSPLT | Indicator: Term for installment payment |
| XSCRC | Recurring Entries: Add Terms of Payment from Master Record |
SAP Payment Terms Tables for TextTVZBT
The TVZBT is for Customers: Terms of Payment Texts table.
Here the list of the most important Fields:
| MANDT | CLIENT |
|---|---|
| SPRAS | Language Key |
| ZTERM | Terms of payment key |
| VTEXT | Description of terms of payment |
Related SAP Payment Terms Tables
Find more related ZTERM Payment Terms Tables here:
| ZTERM TABLE | DESCRIPTION |
|---|---|
| TVKGGT | TEXTS FOR CUSTOMER CONDITION GROUPS(CUSTOMER MASTER) |
| TVZBT | CUSTOMERS:TERMS OF PAYMENT TEXTS |
| TINCT | CUSTOMERS:INCOTERMS:TEXTS |
| DD01T | domain Descriptions |
| DD07T | Domain Value descriptions |
| DD07T | DD: Texts for Domain Fixed Values (Language-Dependent) |
| DD07V | View on fixed values and domain texts |
| DD03T | DD: Texts for fields (language dependent) |
| DD03L | Table Fields |
| DD07V | will contain all the domain values. |
Customizing of Vendor Terms of Payment
In order to customize the Terms of Payments for Vendor, following the following Path in SPRO
SPRO > click on SAP Customizing Implementation Guid > Materials Management > Purchasing > Vendor Master > Define Terms of Payment.
Payment Terms Useful Tips
How to get text1 field data from T052 table
Actual table it is referring to is T052U. Text1 field comes from this table.
You will have to get this field from T052U.
You can join tables T052 and T052U on ZTERM and ZTAGG.
How to get Due Data based on Payment Terms ZTERM ?
Use the standard functions:
- FI_TERMS_OF_PAYMENT_PROPOSE
- DETERMINE_DUE_DATE
Or simply read our tutorial on Calculate Due Date in ABAP (BAPI DETERMINE_DUE_DATE)
