The CTE_D_PAYMENT table in SAP ERP or S/4HANA stores Table for Payment Information data. There are total 16 fields in CTE_D_PAYMENT table. The Table for Payment Information 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 CTE_D_PAYMENT table. It is in Central Posting Objects (CTE_FND_POST_IMP) ABAP package and is part of the Concur S/4HANA Integration (BNS-CON-SE-S4) module.
SAP CTE_D_PAYMENT Table Fields
Following is the list of fields that are available in SAP CTE_D_PAYMENT table. The primary key fields of the table are CLIENT (Client), SYSTEM_KEY (System Key), DOCUMENT_TYPE (Concur Document Type), DOCUMENT_ID (ID of Concur Document), REVISION_ID (Concur Document Revision Number), CLEARING_REF (Clearing Reference).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| SYSTEM_KEY | System Key | CTE_SYSTEM_KEY_NUMBER | INT1 (3) | |
| DOCUMENT_TYPE | Concur Document Type | CTE_FND_POST_DOC_TYPE | CHAR (2) | |
| DOCUMENT_ID | ID of Concur Document | CTE_FND_POST_DOC_ID | CHAR (32) | |
| REVISION_ID | Concur Document Revision Number | CTE_FND_POST_DOC_REV_ID | CHAR (3) | |
| CLEARING_REF | Clearing Reference | CTE_FND_POST_CLEARING_REF | CHAR (32) | |
| CLEARING_DATE | Clearing Date | AUGDT | DATS (8) | |
| PAYMENT_STATUS | Concur Document Payment Status | CTE_FND_POST_DOC_PAYMNT_STATUS | CHAR (2) | |
| CREATION_TIMSTP | Concur Documents – Created date/time | CTE_FND_POST_DOC_CREATED_AT | DEC (21) | |
| RECEIVER_ID | Concur Payee ID (Employee ID or Vendor ID) | CTE_FND_POST_CONCUR_PAYEE_ID | CHAR (48) | |
| RECEIVER_NAME | Receiver Name of Payment | CTE_FND_POST_RECEIVER_NAME | CHAR (40) | |
| IS_REC_AN_EMPLOYEE | Boolean | CTE_BOOLEAN | CHAR (1) | |
| AMOUNT | Concur Integration: Amount with sign | CTE_AMOUNT_WITH_SIGN | CURR (23) | |
| CURR | Currency Key | WAERS | CUKY (5) | |
| NOTIFY_IND | Boolean | CTE_BOOLEAN | CHAR (1) | |
| LOGICALLY_DELETED | Boolean | CTE_BOOLEAN | CHAR (1) |
