The FTCOMT table in SAP ERP or S/4HANA stores Foreign Trade: Communication: Audit table for FT documents data. There are total 18 fields in FTCOMT table. The Foreign Trade: Communication: Audit table for FT 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 FTCOMT table. It is in Application development R/3 foreign trade (VEI) ABAP package and is part of the Basic Functions (SD-FT-PRO) module.
SAP FTCOMT Table Fields
Following is the list of fields that are available in SAP FTCOMT table. The primary key fields of the table are MANDT (Client), TZONE (Time Zone), TSTMP (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), VBELN (Billing Document), POSNR (Item number on FT document), KAPPL (Application), KSCHL (Condition type), SPRAS (Message language), PARNR (Message partner), PARVW (Partner function (for example SH for ship-to party)), NACHA (Message transmission medium), HEFEL (Origin field).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| TZONE | Time Zone | TZNZONE | TTZZ | CHAR (6) |
| TSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC (15) | |
| VBELN | Billing Document | VBELN_VF | * | CHAR (10) |
| POSNR | Item number on FT document | FTDRPOS | NUMC (6) | |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHL | T685 | CHAR (4) |
| SPRAS | Message language | NA_SPRAS | T002 | LANG (1) |
| PARNR | Message partner | NA_PARNR | CHAR (10) | |
| PARVW | Partner function (for example SH for ship-to party) | SNA_PARVW | CHAR (2) | |
| NACHA | Message transmission medium | NA_NACHA | CHAR (1) | |
| HEFEL | Origin field | HEFEL | DD03L | CHAR (30) |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AHBAS | Basis document category for foreign trade processing | AHBAS | CHAR (3) | |
| HETAB | Communication structure SAPScript | FTCOMST | CHAR (30) | |
| ELEMENT | Characteristic on the Foreign Trade form | FTWINDM | CHAR (40) | |
| FTCOM_ALT | Communication text for audit entry – old | FTCOM_ALT | CHAR (60) | |
| FTCOM_NEU | Communication text for audit entry – new | FTCOM_NEU | CHAR (60) |
