SAP FOTDECLSTA Status Information Rep Data Electronic Data Transmission Table data and field list

FOTDECLSTA is a standard SAP Table which is used to store Status Information Rep Data Electronic Data Transmission data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FOTDECLSTA table consists of various fields, each holding specific information or linking keys about Status Information Rep Data Electronic Data Transmission data available in SAP. These include DECL_TYPE (Return Type for Authorities), TBUKRS (Dominant Enterprise/Company Code), DECL_CTRY (Reporting Country), DECL_YEAR (Reporting Year of Data Transmission to Authorities)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FOTDECLSTA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FOTDECLSTA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FOTDECLSTA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
DECL_TYPEReturn Type for Authorities FOT_DCLTYPNUMC4FOT_DCLTYPFOTTYP
TBUKRSDominant Enterprise/Company Code FOT_TBUKRSCHAR4T001BUKRSFOTORG
DECL_CTRYReporting Country FOT_DCCTRYCHAR3T005LAND1FOTCTRY
DECL_YEARReporting Year of Data Transmission to Authorities FOT_DEYEARNUMC4FOT_DEYEARFOTYEAR
DECL_PERReporting Period Electronic Data Transmission FOT_DCLPERNUMC2FOT_DCLPER
DECL_RUNIDCounter of a Corrected Return FOT_RUNIDNUMC3FOT_RUNID
DECL_VERSNew Version for Changed Return FOT_VERSNUMC3FOT_VERS
DECL_LEGIDID of Reporting Data Electronic Data Transmission FOT_LEGAIDCHAR32FOT_LEGAID
DECL_SENIDIdentifies a Transfer of Reporting Data FOT_SENDIDNUMC8FOT_SENDID
SENDTSTMPTransfer Time of Reporting Data FOT_STSTMPDEC16FOT_TSTMP
PROTTSTMPTime of Log Receipt FOT_PTSTMPDEC16FOT_TSTMP
CREATSTMPCreation Time of Reporting Data FOT_CTSTMPDEC16FOT_TSTMP
CHANTSTMPChange Time of Reporting Data FOT_CHTSTMPDEC16FOT_TSTMP
USERCREATECreator of Return Data FOT_USRCRECHAR12Assigned to domainXUBNAME
USERSENTSender of Rep. Data Electr. Communication with Authorities FOT_USRSENCHAR12Assigned to domainXUBNAME
USERCHANGEChanger of Rep. Data Electr. Communication with Authorities FOT_USRCHGCHAR12Assigned to domainXUBNAME
DECL_STATUSStatus of Reporting Data FOT_STATUSCHAR2FOT_STATUS
XIMESSKEYKey XI Message FOT_XIMKEYCHAR30FOT_XIMKEY
FOT_TDATAReturn Data for Test Purposes FOT_TDATACHAR1FOT_TDATA

Key field Non-key field



How do I retrieve data from SAP table FOTDECLSTA using ABAP code

The following ABAP code Example will allow you to do a basic selection on FOTDECLSTA to SELECT all data from the table
DATA: WA_FOTDECLSTA TYPE FOTDECLSTA.

SELECT SINGLE *
FROM FOTDECLSTA
INTO CORRESPONDING FIELDS OF WA_FOTDECLSTA
WHERE...

How to access SAP table FOTDECLSTA

Within an ECC or HANA version of SAP you can also view further information about FOTDECLSTA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).