SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz SAP and ABAP Programming Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

CRM Companies List
Web Based CRM Software

SAP Payment Terms Table and ZTERM Texts Table for ABAP Developers

ABAP developers frequently use Payment Terms ZTERM especially on SAP Smartform output documents.
ABAP developers will find two common SAP tables T052 and TVZBT that can be used to query detailed data about payment terms used in SAP documents.

Payment Terms

ABAP developers can use the SAP table T052 (Terms of Payment) in order to get details about the ZTERM payment terms of an order or invoice. The SAP Table T052 Terms of Payment has the following table columns.

ZTERMTerms of payment key
ZTAGGDay Limit
ZDARTDate Type
ZFAELCalendar Day for the Baseline Date for Payment
ZMONAAdditional Months
ZTAG1Days from Baseline Date for Payment
ZPRZ1Cash Discount Percentage Rate
ZTAG2Days from Baseline Date for Payment
ZPRZ2Cash Discount Percentage Rate
ZTAG3Days from Baseline Date for Payment
ZSTG1Due Date for Special Condition
ZSMN1Additional Months for Special Condition (Term 1)
ZSTG2Due Date for Special Condition
ZSMN2Additional Months for Special Condition (Term 2)
ZSTG3Due Date for Special Condition
ZSMN3Additional Months for Special Condition (Term 3)
XZBRVPrint terms of payment in RV papers
ZSCHFPayment Block (Default Value)
XCHPBTransfer payment block when changing terms of payment?
TXN08Number of the standard text
ZLSCHPayment method
XCHPMTransfer payment method when changing terms of payment?
KOARTAccount Type of the Customer/Vendor
XSPLTIndicator: Term for installment payment
XSCRCRecurring Entries: Add Terms of Payment from Master Record

Payment Terms Texts Table

If as an ABAP developer, you want to display payments terms text in different languages, you can read ZTERM text from SAP table TVZBT, Customers: Terms of Payment Texts table.

Customers: Terms of Payment Texts TVZBT table has the following table columns.

SPRASLanguage Key
ZTERMTerms of payment key
VTEXTDescription of terms of payment

SAP Resources

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table

Related Articles and Tutorials(http://www.kodyaz.com/articles/sap-payment-terms-table-and-zterm-texts-table-for-abap.aspx)
Complete List of SAP Modules
Sales Tables among ABAP Tables (SAP Sales and Distribution SD Tables)
SAP Invoice Output Determination Analysis for Not Created Output Message
SAP Payment Terms Table and ZTERM Texts Table for ABAP Developers
SAP Smartforms Table for Sales Order and Invoice Outputs
Assign SAP Item Category to Sales Document Type using SPRO
Convert the table using the Database Utility (SE14)
Create Sales Order, Delivery and Billing Document in SAP
How to Find Output Determination Procedure for a Billing Document
Invoice Split due to Manual Invoice Maintenance Check on Sales Order
Invoice Output fail because of missing Billing Type text in TVFKT table
Primary key change not permitted for value table
Get Proforma Invoice from Commercial Invoice in ABAP
SAP VKM3 to Release Sales Order from Credit Block
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
SAP Invoice Output ZZZZ is not Defined
SAP Purchase Order Tables, Transaction Codes and Output
Trigger Output Re-Determination for Billing Documents
TVAP Item Category and SAP Table TVAPT for Text Translations
Update Database Table Data using ABAP SE16N_INTERFACE
VF31 SAP Transaction to Reprocess Billing Output Messages

Copyright © 2004 - 2016 Eralper Yilmaz. All rights reserved.
Community Server by Telligent Systems