RF07

Transparent Table Customizing Table
55 Fields 2 CDS Views

Withholding tax in Italy : Modello 770 - additional data

RF07 is an SAP database table in S/4HANA. Withholding tax in Italy : Modello 770 - additional data. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_IT_StRpWhldgTaxItemAddlData view_entity from BASIC Italy WHT CU Additional Data
P_IT_StRpWhldgTaxItemAddlData view_entity from BASIC Italy WHT CU - Additional Data

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY gjahr GJAHR Fiscal Year
KEY lifnr LIFNR Supplier
caus CAUS Payment reason
nassc NASSC Annual amount
cdinail CDINAIL Number of INAIL
dtiniz DTINIZ INAIL Start Date
dtfine DTFINE INIAL ending date
cdcomu CDCOMU Municipal Code
rep_lifnr REP_LIFNR Foreign represent.
regio_sf REGIO_SF Region code
scexemp_fl SCFL Social Contribution Exemption
p_heir P_HEIR Heir
ex_events EX_EVENTS Exceptional events
p_cost P_COST Expenses Ref
p_tax P_TAX WH Amt Reimbursed
p_dubank P_DUBANK Amt before bank.
p_pabank P_PABANK Amt after bank.
income_rec INCOME_REC Total Income
taxcode TAXCODE Tax Code
taxbase TAX_BASE Tax Base
wtax WTAX WH Tax Amt
taxdedu TAXDEDU Tax amount
sutax SUTAX WH amt sus
regwtax REGWTAX Reg WH tax
regtax REGTAX Add.Reg tax
suregtax SUREGTAX Sus Reg amount
it_code FIWTIT_CODE Code
it_foreign_country FIWTIT_FOREIGN_COUNTRY ForeignCountry/Reg
it_bytax FIWTIT_BYTAX Amt withheld as tax
it_deemed FIWTIT_DEEMED WH amount suspended
it_returnedamt FIWTIT_AMOUNTS_RETURNED Amounts Ret
it_addwhtamt FIWTIT_ADDWHTAMT Reg WH tax
it_addtaxamt FIWTIT_ADDTAXAMT Add.Reg tax
it_addsusamt FIWTIT_ADDSUSAMT Sus Reg amount
it_prevyear FIWTIT_PREVYEAR Previous Year
it_prevbaseamt FIWTIT_PREVBASE Prev. Base amount
it_prevtaxamt FIWTIT_PREVTAX Prev. Tax amount
addmultitle FIWTIT_MULTITLE Municipal Title
addmultax FIWTIT_MULTAX Municipal Tax
addmulsusp FIWTIT_MULSUSP Municipal Suspended
multitle FIWTIT_MULTITLE Municipal Title
multax FIWTIT_MULTAX Municipal Tax
mulsusp FIWTIT_MULSUSP Municipal Suspended
bpcatgry FIITWT_BP_CATEGORY Special Category
delidnum FIITWT_DEL_ID_NUMBER Delivery id Number
cunumber FIITWT_PROG_CU_NUMBER Progressive CU Num
advance FIWTIT_ADVANCE Advance payment
othcamt FIWTIT_OTH_CONTAMT Amnt. for Oth. Cont.
othcdue FIWTIT_OTH_CONTDUE Contribution Due
othcpaid FIWTIT_OTH_CONTPAID Other Cont. Paid
ssivcatg FIWTIT_SSI_VCODE SSI code to vendor
vendrepr FIAPWTIT_TAX_REPR Vend. Tax Rep.
deductible_amount FIWTIT_DEDUCTIBLE_AMT Amount of Deductible

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 in Italy : Modello 770 - additional data
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RF07 (
    MANDT,               -- Client [MANDT]
    BUKRS,               -- Company Code [BUKRS]
    GJAHR,               -- Fiscal Year [GJAHR]
    LIFNR,               -- Supplier [LIFNR]
    CAUS,                -- Payment reason [CAUS]
    NASSC,               -- Annual amount [NASSC]
    CDINAIL,             -- Number of INAIL [CDINAIL]
    DTINIZ,              -- INAIL Start Date [DTINIZ]
    DTFINE,              -- INIAL ending date [DTFINE]
    CDCOMU,              -- Municipal Code [CDCOMU]
    REP_LIFNR,           -- Foreign represent. [REP_LIFNR]
    REGIO_SF,            -- Region code [REGIO_SF]
    SCEXEMP_FL,          -- Social Contribution Exemption [SCFL]
    P_HEIR,              -- Heir [P_HEIR]
    EX_EVENTS,           -- Exceptional events [EX_EVENTS]
    P_COST,              -- Expenses Ref [P_COST]
    P_TAX,               -- WH Amt Reimbursed [P_TAX]
    P_DUBANK,            -- Amt before bank. [P_DUBANK]
    P_PABANK,            -- Amt after bank. [P_PABANK]
    INCOME_REC,          -- Total Income [INCOME_REC]
    TAXCODE,             -- Tax Code [TAXCODE]
    TAXBASE,             -- Tax Base [TAX_BASE]
    WTAX,                -- WH Tax Amt [WTAX]
    TAXDEDU,             -- Tax amount [TAXDEDU]
    SUTAX,               -- WH amt sus [SUTAX]
    REGWTAX,             -- Reg WH tax [REGWTAX]
    REGTAX,              -- Add.Reg tax [REGTAX]
    SUREGTAX,            -- Sus Reg amount [SUREGTAX]
    IT_CODE,             -- Code [FIWTIT_CODE]
    IT_FOREIGN_COUNTRY,  -- ForeignCountry/Reg [FIWTIT_FOREIGN_COUNTRY]
    IT_BYTAX,            -- Amt withheld as tax [FIWTIT_BYTAX]
    IT_DEEMED,           -- WH amount suspended [FIWTIT_DEEMED]
    IT_RETURNEDAMT,      -- Amounts Ret [FIWTIT_AMOUNTS_RETURNED]
    IT_ADDWHTAMT,        -- Reg WH tax [FIWTIT_ADDWHTAMT]
    IT_ADDTAXAMT,        -- Add.Reg tax [FIWTIT_ADDTAXAMT]
    IT_ADDSUSAMT,        -- Sus Reg amount [FIWTIT_ADDSUSAMT]
    IT_PREVYEAR,         -- Previous Year [FIWTIT_PREVYEAR]
    IT_PREVBASEAMT,      -- Prev. Base amount [FIWTIT_PREVBASE]
    IT_PREVTAXAMT,       -- Prev. Tax amount [FIWTIT_PREVTAX]
    ADDMULTITLE,         -- Municipal Title [FIWTIT_MULTITLE]
    ADDMULTAX,           -- Municipal Tax [FIWTIT_MULTAX]
    ADDMULSUSP,          -- Municipal Suspended [FIWTIT_MULSUSP]
    MULTITLE,            -- Municipal Title [FIWTIT_MULTITLE]
    MULTAX,              -- Municipal Tax [FIWTIT_MULTAX]
    MULSUSP,             -- Municipal Suspended [FIWTIT_MULSUSP]
    BPCATGRY,            -- Special Category [FIITWT_BP_CATEGORY]
    DELIDNUM,            -- Delivery id Number [FIITWT_DEL_ID_NUMBER]
    CUNUMBER,            -- Progressive CU Num [FIITWT_PROG_CU_NUMBER]
    ADVANCE,             -- Advance payment [FIWTIT_ADVANCE]
    OTHCAMT,             -- Amnt. for Oth. Cont. [FIWTIT_OTH_CONTAMT]
    OTHCDUE,             -- Contribution Due [FIWTIT_OTH_CONTDUE]
    OTHCPAID,            -- Other Cont. Paid [FIWTIT_OTH_CONTPAID]
    SSIVCATG,            -- SSI code to vendor [FIWTIT_SSI_VCODE]
    VENDREPR,            -- Vend. Tax Rep. [FIAPWTIT_TAX_REPR]
    DEDUCTIBLE_AMOUNT,   -- Amount of Deductible [FIWTIT_DEDUCTIBLE_AMT]
    PRIMARY KEY (MANDT, BUKRS, GJAHR, LIFNR)
);

Learn More