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

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