FIWTQAD_CERT SAP (Withholding tax certificate details) Table details
Dictionary Type: Table
Description: Withholding tax certificate details
Description: Withholding tax certificate details
Table field list including key, data, relationships and ABAP select examples
FIWTQAD_CERT is a standard SAP Table which is used to store Withholding tax certificate details data and is available within R/3 SAP systems depending on the version and release level.
The FIWTQAD_CERT table consists of various fields, each holding specific information or linking keys about Withholding tax certificate details data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), CTNUMBER (Withholding Tax Certificate Number), EBELN (Purchasing Document Number).. 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: 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 FIWTQAD_CERT table 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| CTNUMBER | Withholding Tax Certificate Number | CTNUMBER | CHAR | 10 | CHAR10 | ||||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
| CTISSUEDATE | Issue or Print Date of Withholding Tax Certificate | CTISSUEDATE | DATS | 8 | DATUM | ||||
| AMNT | Withholding tax amount (in local currency) | WT_WT | CURR | 15(2) | WERTV8 | ||||
| BEDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
| AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
| CANCI | Certificate Canceled | FIWTQA_CANC | CHAR | 1 | FIWTQA_CANC |
| Key field | Non-key field |
How do I retrieve data from SAP table FIWTQAD_CERT using ABAP code
The following ABAP code Example will allow you to do a basic selection on FIWTQAD_CERT to SELECT all data from the tableDATA: WA_FIWTQAD_CERT TYPE FIWTQAD_CERT.
SELECT SINGLE *
FROM FIWTQAD_CERT
INTO CORRESPONDING FIELDS OF WA_FIWTQAD_CERT
WHERE...
How to access SAP table FIWTQAD_CERT
Within an ECC or HANA version of SAP you can also view further information about FIWTQAD_CERT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects