The Most Important SAP Payment Terms Tables (ZTERM, Text…)

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.

SAP Payment Terms Tables

The main table for Payment Terms in SAP is T052.

The SAP table TVZBT Gives the details of a Payment Terms Description.

Main Payment Terms Tables in SAP

Payment Terms Table Description
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 Texts Table TVZBT

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 refering 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 tutotial on Calculate Due Date in ABAP (BAPI DETERMINE_DUE_DATE)