FIRUD_VATSUBAS

Transparent Table Customizing Table
27 Fields 1 CDS Views

VAT-Return Items: Assignment to Subscenario

FIRUD_VATSUBAS is an SAP database table in S/4HANA. VAT-Return Items: Assignment to Subscenario. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_VatSubscenarioAssignment view from BASIC VAT Return: Assignment to Subscenario

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY version j_3rvatdversion VAT Return Version
KEY sect j_3rvatdsection VAT Return Section
KEY line j_3rvatdline Line
KEY subscenario firu_vatsubsc Subscenario
vatr_total firu_vatrtotal Total Amount Source
vatr_base firu_vatrbase VAT Base Source
vatr_tax firu_vatrtax VAT Amount Source
tax_base firu_vattaxb Tax Base Source
tax_amount firu_vattaxam VAT Amount Type
sign_inver firu_vatsigninver Invert D/C Sign
cost_sp firu_vatcostsp Cost of Sales/Purch.
mrec_dt_out firu_vatmrdtout Date of Material Rec
bp_opt firu_vatbpopt Business Partner
bp_ag firu_vatbpag Bus. Partner Agent
pord_out firu_vatpordout Payment Order
gtd_out firu_vatgtdout ImCD/RNPT Option
buyer firu_vatrbuyer Real Buyer Source
sellerag firu_vatrsellag Real Seller Source
seller firu_vatrseller Seller
subagent firu_vatrsubag Subagent Source
dealtype firu_vatrdealtp Deal Type
opc_type firu_vatoptype Oper.TypeCode Org.
opc_tpin firu_vatoptpin Oper.TypeCode Person
col_num firu_vatcolnum Column Number
sel_inv_out firu_vatsinvo Seller in Inv.Output
buy_inv_out firu_vatbinvo Buyer in Inv. Output

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.

-- VAT-Return Items: Assignment to Subscenario
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_VATSUBAS (
    MANDT,        -- Client [mandt]
    VERSION,      -- VAT Return Version [j_3rvatdversion]
    SECT,         -- VAT Return Section [j_3rvatdsection]
    LINE,         -- Line [j_3rvatdline]
    SUBSCENARIO,  -- Subscenario [firu_vatsubsc]
    VATR_TOTAL,   -- Total Amount Source [firu_vatrtotal]
    VATR_BASE,    -- VAT Base Source [firu_vatrbase]
    VATR_TAX,     -- VAT Amount Source [firu_vatrtax]
    TAX_BASE,     -- Tax Base Source [firu_vattaxb]
    TAX_AMOUNT,   -- VAT Amount Type [firu_vattaxam]
    SIGN_INVER,   -- Invert D/C Sign [firu_vatsigninver]
    COST_SP,      -- Cost of Sales/Purch. [firu_vatcostsp]
    MREC_DT_OUT,  -- Date of Material Rec [firu_vatmrdtout]
    BP_OPT,       -- Business Partner [firu_vatbpopt]
    BP_AG,        -- Bus. Partner Agent [firu_vatbpag]
    PORD_OUT,     -- Payment Order [firu_vatpordout]
    GTD_OUT,      -- ImCD/RNPT Option [firu_vatgtdout]
    BUYER,        -- Real Buyer Source [firu_vatrbuyer]
    SELLERAG,     -- Real Seller Source [firu_vatrsellag]
    SELLER,       -- Seller [firu_vatrseller]
    SUBAGENT,     -- Subagent Source [firu_vatrsubag]
    DEALTYPE,     -- Deal Type [firu_vatrdealtp]
    OPC_TYPE,     -- Oper.TypeCode Org. [firu_vatoptype]
    OPC_TPIN,     -- Oper.TypeCode Person [firu_vatoptpin]
    COL_NUM,      -- Column Number [firu_vatcolnum]
    SEL_INV_OUT,  -- Seller in Inv.Output [firu_vatsinvo]
    BUY_INV_OUT,  -- Buyer in Inv. Output [firu_vatbinvo]
    PRIMARY KEY (MANDT, VERSION, SECT, LINE, SUBSCENARIO)
);

Learn More