The CTE_D_INV_PT_DOC table in SAP ERP or S/4HANA stores Invoice Documents data. There are total 22 fields in CTE_D_INV_PT_DOC table. The Invoice Documents 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_INV_PT_DOC table. It is in Development objects for Invoice posting (CTE_INV_POST_IMP) ABAP package and is part of the Concur S/4HANA Invoice Integration (BNS-CON-SE-S4-INV) module.
SAP CTE_D_INV_PT_DOC Table Fields
Following is the list of fields that are available in SAP CTE_D_INV_PT_DOC 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).
| 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) | |
| DOCUMENT_KEY | Concur Document Key | CTE_FND_POST_DOC_KEY | CHAR (12) | |
| HASH_KEY | Concur Document Alternative Short Hash Key | CTE_FND_POST_DOC_HASH_KEY | CHAR (10) | |
| STATUS | Concur Document Status | CTE_FND_POST_DOC_STATUS | CHAR (2) | |
| ACKNOWLEDGED_IND | Concur Document Acknowledged Indicator | CTE_FND_POST_DOC_ACKNOWLEDGED | CHAR (1) | |
| CONFIRMED_IND | Concur Document Confirmation Sent Indicator | CTE_FND_POST_DOC_CONFIRMED_IND | CHAR (1) | |
| PAID_IND | Concur Document Paid Notification Sent Indicator | CTE_FND_POST_DOC_NOTIFIED_IND | CHAR (1) | |
| MODIFIED_IND | Posting modified by customer BAdI implementations | CTE_FND_POST_DOC_MODIFIED_IND | CHAR (1) | |
| DOCUMENT_NAME | Concur Document Name | CTE_FND_POST_DOC_NAME | CHAR (40) | |
| CONCUR_PAYEE_ID | Concur Payee ID (Employee ID or Vendor ID) | CTE_FND_POST_CONCUR_PAYEE_ID | CHAR (48) | |
| CREATION_TIMSTP | Concur Documents – Created date/time | CTE_FND_POST_DOC_CREATED_AT | DEC (21) | |
| UPDATE_TIMSTP | Concur Document – Changed date/time | CTE_FND_POST_DOC_UPDATED_AT | DEC (21) | |
| FIN_SRV_DOC_ID | ID of Concur Document in Financial Queue | CTE_FND_POST_DOC_ID_FIN_QUEUE | CHAR (32) | |
| LOG_TRACE_UUID | Universal Unique Identifier | CTE_UUID | RAW (16) | |
| DOC_REF_KEY | Concur Document Reference Key | CTE_FND_POST_DOC_REF_KEY | CHAR (36) | |
| EXT_DATA_IND | External call indicator | CTE_FND_POST_EXT_DATA_IND | CHAR (1) | |
| ATTACHMENT_IND | Attachment(s) of Concur Document Retrieved | CTE_FND_POST_DOC_AT_RETR_IND | CHAR (1) | |
| PAYMENT_STATUS | Concur Document Payment Status | CTE_FND_POST_DOC_PAYMNT_STATUS | CHAR (2) |
