FIWTQAD_CERT

Transparent Table Application Table
11 Fields 1 CDS Views

Withholding tax certificate details

FIWTQAD_CERT is an SAP database table in S/4HANA. Withholding tax certificate details. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SHSM_FIWTQAD_CERT view from

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY gjahr gjahr Fiscal Year
KEY ctnumber ctnumber WH Tax Cert. No.
KEY ebeln ebeln Purchasing Doc.
KEY lifnr lifnr Supplier
ctissuedate ctissuedate WTax Certicate Date
amnt wt_wt WTax Amt in LC
bedat ebdat Document Date
augdt augdt Clearing
canci fiwtqa_canc CtfcteCanceled

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Withholding tax certificate details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIWTQAD_CERT (
    MANDT,        -- Client [mandt]
    BUKRS,        -- Company Code [bukrs]
    GJAHR,        -- Fiscal Year [gjahr]
    CTNUMBER,     -- WH Tax Cert. No. [ctnumber]
    EBELN,        -- Purchasing Doc. [ebeln]
    LIFNR,        -- Supplier [lifnr]
    CTISSUEDATE,  -- WTax Certicate Date [ctissuedate]
    AMNT,         -- WTax Amt in LC [wt_wt]
    BEDAT,        -- Document Date [ebdat]
    AUGDT,        -- Clearing [augdt]
    CANCI,        -- CtfcteCanceled [fiwtqa_canc]
    PRIMARY KEY (MANDT, BUKRS, GJAHR, CTNUMBER, EBELN, LIFNR)
);

Learn More