QSTRE

Transparent Table Temporary Data
40 Fields 1 CDS Views

FI/HR Withholding Tax Report for Spain

QSTRE is an SAP database table in S/4HANA. FI/HR Withholding Tax Report for Spain. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ES_WithholdingTaxItem view_entity from BASIC Withholding Tax Item in table QSTRE

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY buzei BUZEI Item
KEY gjahr GJAHR Fiscal Year
dather QSDATHER Data Origin
fprcd FPRCD Prov. Tax Code
qsrep QSREP Recipient Code
qekar QEKAR Income Type
kzdpc QSKZDPC Ind. Donativos/Pag
stecd STCD1 Tax Number 1
stceg STCEG VAT Reg. No.
name1 CHAR40 Char
name2 NAME2_GP Name 2
ort01 ORT01_GP City
pstlz PSTLZ Postal Code
stras STRAS_GP Street
gbdat GBDAT_Q Date of Birth
gbort GBORT_Q Place of birth
gbpro GBPRO_Q Native Region
sexkz SEXKZ Sex
stkzn STKZN Natural person
regio REGIO Region
qland QLAND WTax C/R Key
qproz QPROZ Percentage Subject to Tax
budat BUDAT Posting Date
qsskz QSSKZ WTax Code
qsznr QSZNR Exemption No.
wrbtr WRBTR Amount
dmbtr DMBTR Amount in LC
qsshb QSSHB WTax Base
qsshh QSSHH WTax Base
qbshb QBSHB Withholding Tax
qbshh QBSHH Withholding Tax
qsfbt QSFBT WTax-Exempt
qsfbh QSFBH Wthld Tx Exmpt Amt
kursf KURSF Exchange rate
waerq QSWAERS Curr.fr Wth.Tax.Rep
nohij NOHIJ No.children
land1 LAND1 Country/Reg.

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.

-- FI/HR Withholding Tax Report for Spain
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QSTRE (
    MANDT,   -- Client [MANDT]
    BUKRS,   -- Company Code [BUKRS]
    BELNR,   -- Document Number [BELNR_D]
    BUZEI,   -- Item [BUZEI]
    GJAHR,   -- Fiscal Year [GJAHR]
    DATHER,  -- Data Origin [QSDATHER]
    FPRCD,   -- Prov. Tax Code [FPRCD]
    QSREP,   -- Recipient Code [QSREP]
    QEKAR,   -- Income Type [QEKAR]
    KZDPC,   -- Ind. Donativos/Pag [QSKZDPC]
    STECD,   -- Tax Number 1 [STCD1]
    STCEG,   -- VAT Reg. No. [STCEG]
    NAME1,   -- Char [CHAR40]
    NAME2,   -- Name 2 [NAME2_GP]
    ORT01,   -- City [ORT01_GP]
    PSTLZ,   -- Postal Code [PSTLZ]
    STRAS,   -- Street [STRAS_GP]
    GBDAT,   -- Date of Birth [GBDAT_Q]
    GBORT,   -- Place of birth [GBORT_Q]
    GBPRO,   -- Native Region [GBPRO_Q]
    SEXKZ,   -- Sex [SEXKZ]
    STKZN,   -- Natural person [STKZN]
    REGIO,   -- Region [REGIO]
    QLAND,   -- WTax C/R Key [QLAND]
    QPROZ,   -- Percentage Subject to Tax [QPROZ]
    BUDAT,   -- Posting Date [BUDAT]
    QSSKZ,   -- WTax Code [QSSKZ]
    QSZNR,   -- Exemption No. [QSZNR]
    WRBTR,   -- Amount [WRBTR]
    DMBTR,   -- Amount in LC [DMBTR]
    QSSHB,   -- WTax Base [QSSHB]
    QSSHH,   -- WTax Base [QSSHH]
    QBSHB,   -- Withholding Tax [QBSHB]
    QBSHH,   -- Withholding Tax [QBSHH]
    QSFBT,   -- WTax-Exempt [QSFBT]
    QSFBH,   -- Wthld Tx Exmpt Amt [QSFBH]
    KURSF,   -- Exchange rate [KURSF]
    WAERQ,   -- Curr.fr Wth.Tax.Rep [QSWAERS]
    NOHIJ,   -- No.children [NOHIJ]
    LAND1,   -- Country/Reg. [LAND1]
    PRIMARY KEY (MANDT, BUKRS, BELNR, BUZEI, GJAHR)
);

Learn More