AVIR

Transparent Table Application Table
13 Fields 1 CDS Views

Avisunterposition

AVIR is an SAP database table in S/4HANA. Avisunterposition. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaymentAdviceSubItem view from BASIC Payment Advice SubItem

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY koart koart_av Account Type
KEY konto ktonr_av Account
KEY avsid avsid Payt Advice No.
KEY avspo avspo Payt Adv. Item
KEY avsup avsup Subitem
restn restn_av Net Deduction
restb restb_av Gross Deduction
rstgr rstgr Reason Code
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
restg rstgr_ext Ext.Reason Code

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.

-- Avisunterposition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AVIR (
    MANDT,  -- Client [mandt]
    BUKRS,  -- Company Code [bukrs]
    KOART,  -- Account Type [koart_av]
    KONTO,  -- Account [ktonr_av]
    AVSID,  -- Payt Advice No. [avsid]
    AVSPO,  -- Payt Adv. Item [avspo]
    AVSUP,  -- Subitem [avsup]
    RESTN,  -- Net Deduction [restn_av]
    RESTB,  -- Gross Deduction [restb_av]
    RSTGR,  -- Reason Code [rstgr]
    XREF1,  -- Reference Key 1 [xref1]
    XREF2,  -- Reference Key 2 [xref2]
    RESTG,  -- Ext.Reason Code [rstgr_ext]
    PRIMARY KEY (MANDT, BUKRS, KOART, KONTO, AVSID, AVSPO, AVSUP)
);

Learn More