The FOTDECLSTA table in SAP ERP or S/4HANA stores Status Information Rep Data Electronic Data Transmission data. There are total 20 fields in FOTDECLSTA table. The Status Information Rep Data Electronic Data Transmission 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 FOTDECLSTA table. It is in Electronic Advance Return for Tax on Sales/Purchases (FOT_EDECLARATION) ABAP package and is part of the Value Added Tax (VAT) (FI-GL-GL-F) module.
SAP FOTDECLSTA Table Fields
Following is the list of fields that are available in SAP FOTDECLSTA table. The primary key fields of the table are MANDT (Client), DECL_TYPE (Return Type for Authorities), TBUKRS (Dominant Enterprise/Company Code), DECL_CTRY (Reporting Country), DECL_YEAR (Reporting Year of Data Transmission to Authorities), DECL_PER (Reporting Period of Electronic Data Transmission), DECL_RUNID (Counter of a Corrected Return), DECL_VERS (New Version for Changed Return).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| DECL_TYPE | Return Type for Authorities | FOT_DCLTYP | NUMC (4) | |
| TBUKRS | Dominant Enterprise/Company Code | FOT_TBUKRS | T001 | CHAR (4) |
| DECL_CTRY | Reporting Country | FOT_DCCTRY | T005 | CHAR (3) |
| DECL_YEAR | Reporting Year of Data Transmission to Authorities | FOT_DEYEAR | NUMC (4) | |
| DECL_PER | Reporting Period of Electronic Data Transmission | FOT_DCLPER | NUMC (2) | |
| DECL_RUNID | Counter of a Corrected Return | FOT_RUNID | NUMC (3) | |
| DECL_VERS | New Version for Changed Return | FOT_VERS | NUMC (3) | |
| DECL_LEGID | ID of Reporting Data Electronic Data Transmission | FOT_LEGAID | CHAR (32) | |
| DECL_SENID | Identifies a Transfer of Reporting Data | FOT_SENDID | NUMC (8) | |
| SENDTSTMP | Transfer Time of Reporting Data | FOT_STSTMP | DEC (16) | |
| PROTTSTMP | Time of Log Receipt | FOT_PTSTMP | DEC (16) | |
| CREATSTMP | Creation Time of Reporting Data | FOT_CTSTMP | DEC (16) | |
| CHANTSTMP | Change Time of Reporting Data | FOT_CHTSTMP | DEC (16) | |
| USERCREATE | Creator of Return Data | FOT_USRCRE | * | CHAR (12) |
| USERSENT | Sender of Rep. Data Electr. Communication with Authorities | FOT_USRSEN | * | CHAR (12) |
| USERCHANGE | Changer of Rep. Data Electr. Communication with Authorities | FOT_USRCHG | * | CHAR (12) |
| DECL_STATUS | Status of Reporting Data | FOT_STATUS | CHAR (2) | |
| XIMESSKEY | Key XI Message | FOT_XIMKEY | CHAR (30) | |
| FOT_TDATA | Return Data for Test Purposes | FOT_TDATA | CHAR (1) |
