AVIR

Transparent Table Application Table
13 Fields 1 CDS Views

Payment Advice Subitem

AVIR is an SAP database table in S/4HANA. Payment Advice Subitem. 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.

-- Payment Advice Subitem
-- 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