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:
|ZTERM||Terms of payment key|
|ZFAEL||Calendar Day for the Baseline Date for Payment|
|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|
|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:
|ZTERM||Terms of payment key|
|VTEXT||Description of terms of payment|
Related SAP Payment Terms Tables
Find more related ZTERM Payment Terms Tables here:
|TVKGGT||TEXTS FOR CUSTOMER CONDITION GROUPS(CUSTOMER MASTER)|
|TVZBT||CUSTOMERS:TERMS OF PAYMENT TEXTS|
|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)|
|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:
Or simply read our tutotial on Calculate Due Date in ABAP (BAPI DETERMINE_DUE_DATE)