Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

FIWTIN_QEFILE SAP (Quarterly returns e-file) Structure details

Dictionary Type: Structure
Description: Quarterly returns e-file

ABAP Code to SELECT data from FIWTIN_QEFILE
Related tables to FIWTIN_QEFILE
Access table FIWTIN_QEFILE

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

FIWTIN_QEFILE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Quarterly returns e-file" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FIWTIN_QEFILE TYPE FIWTIN_QEFILE.

The FIWTIN_QEFILE table consists of various fields, each holding specific information or linking keys about Quarterly returns e-file data available in SAP. These include RECTYPE (Record Type), FILETYPE (File Type), UPLDTYPE (Upload Type), FCDATE (File creation date).. 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. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FIWTIN_QEFILE structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FIWTIN_QHEADER				0
RECTYPE	Record Type	FIWTIN_RECTYPE	CHAR	2
FILETYPE	File Type	FIWTIN_FILETYPE	CHAR	4
UPLDTYPE	Upload Type	FIWTIN_UPLDTYPE	CHAR	2
FCDATE	File creation date	FIWTIN_FCDATE	DATS	8			DATUM
FSEQNUMBER	File sequence number	FIWTIN_FSEQNUMBER	NUMC	9
UPLRTYPE	Uploader type	FIWTIN_UPLDRTYPE	CHAR	1
DEDTAN	Tan Number	FIWTIN_TANNO	CHAR	10
NOBATCHES	Total number of batches	FIWTIN_NOBATCHES	NUMC	9
UTILNAME	Name of Return Preparation Utility	FIWTIN_UTILNAME	CHAR	75
BRECTYP	Record Type	FIWTIN_RECTYPE	CHAR	2
BATCHNO	Batch number	FIWTIN_BATCHNUM	NUMC	9
CHALLANCNT	Challan Count	FIWTIN_CHLNCNT	NUMC	9
FORMNO	Form Number	FIWTIN_FORMNO	CHAR	4			FIWTIN_FORMNO
TANNO	Tan Number	FIWTIN_TANNO	CHAR	10
RECEIPTNO	Receipt Number	FIWTIN_RECEIPT	CHAR	8
PANNO	PAN Number	FIWTIN_PANNO	CHAR	10
ASSESMENTYEAR	Assesment year	FIWTIN_ASYEAR	NUMC	6
FISCALYEAR	Fiscal Year	FIWTIN_YEAR	NUMC	6
PERIOD	Reporting Period	FIWTIN_PERIOD	CHAR	2
DEDU_NAME	Name	FIWTIN_NAME	CHAR	75
DEDU_BRANCH	Deductor Branch	FIWTIN_BRANCH	CHAR	75
DEDU_ADDR1	Address	FIWTIN_ADDRESS	CHAR	25
DEDU_ADDR2	Address	FIWTIN_ADDRESS	CHAR	25
DEDU_ADDR3	Address	FIWTIN_ADDRESS	CHAR	25
DEDU_ADDR4	Address	FIWTIN_ADDRESS	CHAR	25
DEDU_ADDR5	Address	FIWTIN_ADDRESS	CHAR	25
DEDU_STATE	State	FIWTIN_STATE	NUMC	2
DEDU_PINCODE	PIN Code	FIWTIN_PIN	NUMC	6
DEDU_MAILID	Mail ID	FIWTIN_MAIL	CHAR	75
DEDU_STD	STD Code	FIWTIN_STD	CHAR	6
DEDU_TELNO	Telephone Number	FIWTIN_TEL	NUMC	10
DEDU_ADDRCHANGE	Address change	FIWTIN_ADRCHNG	CHAR	1
DEDU_TYPE	Deductor Type	FIWTIN_DEDTYPE	CHAR	1
RESP_NAME	Name	FIWTIN_NAME	CHAR	75
RESP_DESIG	Designation	FIWTIN_DESIG	CHAR	20
RESP_ADDR1	Address	FIWTIN_ADDRESS	CHAR	25
RESP_ADDR2	Address	FIWTIN_ADDRESS	CHAR	25
RESP_ADDR3	Address	FIWTIN_ADDRESS	CHAR	25
RESP_ADDR4	Address	FIWTIN_ADDRESS	CHAR	25
RESP_ADDR5	Address	FIWTIN_ADDRESS	CHAR	25
RESP_STATE	State	FIWTIN_STATE	NUMC	2
RESP_PINCODE	PIN Code	FIWTIN_PIN	NUMC	6
RESP_EMAILID	Mail ID	FIWTIN_MAIL	CHAR	75
RESP_MOBILE	Mobile Number	FIWTIN_MOBILE	CHAR	10
RESP_STD	STD Code	FIWTIN_STD	CHAR	6
RESP_TELNO	Telephone Number	FIWTIN_TEL	NUMC	10
RESP_ADDRCHANGE	Address change	FIWTIN_ADRCHNG	CHAR	1
TOTDEPAMT	Total Deposit Amount	FIWTIN_TOTDEPAMT	CURR	15(2)
CHALLAN_UNMATCH	Challan Unmatched	FIWTIN_CHLNUNMAT	CHAR	9
AOAPPROVAL	AO Approval	FIWTIN_APPROVAL	CHAR	1
AOAPPROVALNO	Approval Number	FIWTIN_APPRNO	CHAR	15
STATE	State	FIWTIN_STATECODE	CHAR	2
PAOCODE	PAO Code	FIWTIN_PAOCODE	CHAR	20
DDOCODE	DDO Code	FIWTIN_DDOCODE	CHAR	20
MINISTRY	Ministry Code	FIWTIN_MINISTRY	CHAR	3
MINISTRYNAME	Ministry Name	FIWTIN_MINNAME	CHAR	150
PAOREGNO	PAO Registration Number	FIWTIN_PAONO	CHAR	7
DDOREGNO	DDO Registration Number	FIWTIN_DDONO	CHAR	10
ALT_DEDU_STD	STD Code	FIWTIN_STD	CHAR	6
ALT_DEDU_TELNO	Telephone Number	FIWTIN_TEL	NUMC	10
ALT_DEDU_EMAILID	Mail ID	FIWTIN_MAIL	CHAR	75
ALT_RESP_STD	STD Code	FIWTIN_STD	CHAR	6
ALT_RESP_TELNO	Telephone Number	FIWTIN_TEL	NUMC	10
ALT_RESP_EMAILID	Mail ID	FIWTIN_MAIL	CHAR	75
AIN	Account Office Identification Number	FIWTIN_AIN	CHAR	7
WAERS	Currency Key	WAERS	CUKY	5			WAERS	FWS
FIWTIN_QCHALLAN				0
RECTYPE	Record Type	FIWTIN_RECTYPE	CHAR	2
BATCHNO	Batch number	FIWTIN_BATCHNUM	NUMC	9
RECNUM	Challan Record Number	FIWTIN_RECNUM	NUMC	9
CNTDEDREC	Deductee / Party Detail Record Number	FIWTIN_CNTDEDREC	NUMC	9
CHLIND	NIL Challan Indicator	FIWTIN_CHLIND	CHAR	1
BNKCHLNNO	Bank Challan Number	FIWTIN_BNKCHLNNO	CHAR	5
TRNSVOUCHNUM	Transfer Voucher Number	FIWTIN_TRNSVOUCHNUM	NUMC	9
BNKBRCHCD	Bank-Branch Code/ Form 24G Receipt Number	FIWTIN_BNKBRCHCD	NUMC	7
CHLNDT	Bank Challan Number/Transfer Voucher Number Date	FIWTIN_CHLNDT	DATS	8			DATUM
SECTIONCD	Section Code	FIWTIN_SECTION	CHAR	3
OLTASTDS	Oltas TDS /TCS -Income Tax	FIWTIN_OLTASTDS	CURR	15(2)
OLTASURC	Oltas TDS /TCS-Surcharge	FIWTIN_OLTASURC	CURR	15(2)
OLTASCESS	Oltas TDS / TCS - Cess	FIWTIN_OLTASCESS	CURR	15(2)
OLTASINT	Oltas TDS /TCS -Interest Amount	FIWTIN_OLTASINT	CURR	15(2)
OLTASOTH	Oltas TDS / TCS - Others (amount)	FIWTIN_OLTASOTH	CURR	15(2)
TOTDEPAMT	Total Deposit Amount	FIWTIN_TOTDEPAMT	CURR	15(2)
TOTTAXDEP	Total Tax Deposit Amount	FIWTIN_TOTTAXDEP	CURR	15(2)
SUMINCTAX	TDS / TCS -Income Tax	FIWTIN_SUMINCTAX	CURR	15(2)
SUMSURC	TDS / TCS -Surcharge	FIWTIN_SUMSURC	CURR	15(2)
SUMCESS	TDS / TCS - Cess	FIWTIN_SUMCESS	CURR	15(2)
AMTDED	Sum of Total Income Tax Deducted at Source	FIWTIN_AMTDED	CURR	15(2)
AMTINT	TDS / TCS - Interest Amount	FIWTIN_AMTINT	CURR	15(2)
AMTOTH	TDS / TCS - Others (amount)	FIWTIN_AMTOTH	CURR	15(2)
CHEQUENO	Cheque/DD Number	FIWTIN_CHEQUENO	NUMC	15
BOOKENTRY	By Book entry / Cash	FIWTIN_BOOKENTRY	CHAR	1
REMARKS	Remarks	FIWTIN_REMARKS	CHAR	14
FEE	Fee paid under section 234E	FIWTIN_FEE	CURR	15(2)
MINORCHALLAN	Minor head of Challan	FIWTIN_MINORCHALLAN	CHAR	3
WAERS	Currency Key	WAERS	CUKY	5			WAERS	FWS
FIWTIN_QDED_DET				0
RECTYPE	Record Type	FIWTIN_RECTYPE	CHAR	2
BATCHNO	Batch number	FIWTIN_BATCHNUM	NUMC	9
RECNUM	Challan Record Number	FIWTIN_RECNUM	NUMC	9
DEDRECNUM	Deductee / Party Detail Record Number	FIWTIN_CNTDEDREC	NUMC	9
MOD	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
DEDCODE	Deductee Code	FIWTIN_DEDCODE	CHAR	1
PANNO	PAN Number	FIWTIN_PANNO	CHAR	10
DEDU_NAME	Name	FIWTIN_NAME	CHAR	75
TDSAMT	Amount of Payment / Credit	FIWTIN_AMOUNT	CURR	15(2)
SUMINCTAX	TDS / TCS -Income Tax	FIWTIN_SUMINCTAX	CURR	15(2)
SUMSURC	TDS / TCS -Surcharge	FIWTIN_SUMSURC	CURR	15(2)
SUMCESS	TDS / TCS - Cess	FIWTIN_SUMCESS	CURR	15(2)
AMTDED	Sum of Total Income Tax Deducted at Source	FIWTIN_AMTDED	CURR	15(2)
TOTTAXDEP	Total Tax Deposit Amount	FIWTIN_TOTTAXDEP	CURR	15(2)
TOTPURVALUE	Amount of Payment / Credit	FIWTIN_AMOUNT	CURR	15(2)
AMOUNT	Amount of Payment / Credit	FIWTIN_AMOUNT	CURR	15(2)
AMTDATE	Date on which Amount paid /Credited	FIWTIN_AMTDATE	DATS	8			DATUM
TAXDATE	Date on which tax Deducted / Collected	FIWTIN_TAXDATE	DATS	8			DATUM
TAXRATE	Rate at which Tax Deducted / Collected	FIWTIN_TAXRATE	CHAR	7
GROSSUP	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
BOOKENTRY	By Book entry / Cash	FIWTIN_BOOKENTRY	CHAR	1
RSNCODE	Reason Code	FIWTIN_RSNCODE	CHAR	1			CHAR1
REMARKS	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
SECTIONCD	Section Code	FIWTIN_SECTION	CHAR	3
CERTINO	Certificate Number	FIWTIN_CERTINO	CHAR	20
TDSRATE	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
NATUREREM	Nature of remittance	FIWTIN_NATUREREM	CHAR	3
UNIQACKN	Unique acknowledgement	FIWTIN_UNIQACKN	CHAR	12
COUNRTY	Country	FIWTIN_COUNTRY	CHAR	3
WAERS	Currency Key	WAERS	CUKY	5			WAERS	FWS

Key field

Non-key field

How do I retrieve data from SAP structure FIWTIN_QEFILE using ABAP code?

As FIWTIN_QEFILE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FIWTIN_QEFILE as there is no data to select.

How to access SAP table FIWTIN_QEFILE

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

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

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!