SAP CRMC_PMNTTRMS Table – Terms of Payment

The CRMC_PMNTTRMS table in SAP ERP or S/4HANA stores Terms of Payment data. There are total 8 fields in CRMC_PMNTTRMS table. The Terms of Payment table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_PMNTTRMS table. It is in CRM Order: Decoupling of Business Partner (CRM_BUPA_MD) ABAP package and is part of the Customizing for Business Transactions (CRM-BTX-BF-CU) module.

SAP CRMC_PMNTTRMS Table Fields

Following is the list of fields that are available in SAP CRMC_PMNTTRMS table. The primary key fields of the table are CLIENT (Client), PAYMENT_TERMS (Terms of Payment).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT (3)
PAYMENT_TERMS Terms of Payment CRMT_PMNTTRMS CHAR (4)
DAYS_FROM_1 Days From Payment Deadline Base Date 1st Level CRMT_DAYS_FROM_1 NUMC (3)
PERCENTAGE_1 Cash Discount Rate, Level 1 CRMT_PERCENTAGE_1 DEC (5)
DAYS_FROM_2 Days from payment deadline base date, 2nd level CRMT_DAYS_FROM_2 NUMC (3)
PERCENTAGE_2 Casn Discount Rate, Level 2 CRMT_PERCENTAGE_2 DEC (5)
DAYS_FROM_3 Days from Payment Deadline Base Date (Due Date Net Payment) CRMT_DAYS_FROM_3 NUMC (3)
PAYM_METH Payment Method CRMT_BUAG_PAYMETH CRMC_BUAG_PAYM CHAR (1)