AVIP

Transparent Table Application Table
60 Fields 2 CDS Views

Avisposition

AVIP is an SAP database table in S/4HANA. Avisposition. It contains 60 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PaymentAdviceItem view from BASIC Payment Advice Item
P_ARBSITMPAYADVICE view inner BASIC

Fields (60)

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
abwko abwko_av Altern. Account
abwbu abwbu_av Altern. CoCode
sfeld sfeld_av Selection Field
swert swert_av Value
belnr belnr_d Document Number
xblnr xblnr1 Reference
vbeln vbeln_vf Billing Doc.
filkd filkd Branch
cpudt cpudt Entered On
gsber gsber Business Area
zuonr dzuonr Assignment
restg rstgr_ext Ext.Reason Code
sgtxt sgtxt Text
mwsts mwsts LC Tax
mwskz mwskz Tax Code
wrbtr wrbtr_av Gross Amount
nebtr nebtr_av Payment Amount
wskto wskto_av CD Amount
gjahr gjahr Fiscal Year
buzei buzei Item
abwka abwka_av Alt. Acct Type
zbdxp dzbdxp Cash Discount %
zbdxt dzbdxt Cash Disc.Days
difhw difhw Difference
diffw diffw Difference
difh2 difh2 Difference
difh3 difh3 Difference
xaktp xaktp Items Active
xakts xakts CD Active
xppmt xppmt Indicator: Partial Payments
xvort xvort Indicator: Carryforward Residual Bal. for Payt Difference?
rstgn rstgr Reason Code
waers waers Currency
scurr scurr_av Amount
sdate sdate_av Date
stype stype_av Selection Type
sprio sprio_av Sel.Priority
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
afeld afeld_av Ext. Sel. Field
liefn vbeln_vl Delivery
redat redat Invoice Date
bstnk bstnk Cust. Reference
xacon xacon On Account
astat astat_avik Payt Adv. Stat.
xamca xamca Indicator: Do Not Calculate Gross Amount if Initial?
abbtr abbtr_av Deduction amt
contr contr_av Ctrl Field
kidno kidno Payment Ref.
lbinvref lbinvref Lockbox Invoice Reference
fica_selw1 selwa_kk Field Value
fica_selt1 seltx_kk Selection Cat.
fica_opbel opbel_kk Document Number
fica_betrw_ac betrw_ac_kk Assigned Amount

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.

-- Avisposition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AVIP (
    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]
    ABWKO,          -- Altern. Account [abwko_av]
    ABWBU,          -- Altern. CoCode [abwbu_av]
    SFELD,          -- Selection Field [sfeld_av]
    SWERT,          -- Value [swert_av]
    BELNR,          -- Document Number [belnr_d]
    XBLNR,          -- Reference [xblnr1]
    VBELN,          -- Billing Doc. [vbeln_vf]
    FILKD,          -- Branch [filkd]
    CPUDT,          -- Entered On [cpudt]
    GSBER,          -- Business Area [gsber]
    ZUONR,          -- Assignment [dzuonr]
    RESTG,          -- Ext.Reason Code [rstgr_ext]
    SGTXT,          -- Text [sgtxt]
    MWSTS,          -- LC Tax [mwsts]
    MWSKZ,          -- Tax Code [mwskz]
    WRBTR,          -- Gross Amount [wrbtr_av]
    NEBTR,          -- Payment Amount [nebtr_av]
    WSKTO,          -- CD Amount [wskto_av]
    GJAHR,          -- Fiscal Year [gjahr]
    BUZEI,          -- Item [buzei]
    ABWKA,          -- Alt. Acct Type [abwka_av]
    ZBDXP,          -- Cash Discount % [dzbdxp]
    ZBDXT,          -- Cash Disc.Days [dzbdxt]
    DIFHW,          -- Difference [difhw]
    DIFFW,          -- Difference [diffw]
    DIFH2,          -- Difference [difh2]
    DIFH3,          -- Difference [difh3]
    XAKTP,          -- Items Active [xaktp]
    XAKTS,          -- CD Active [xakts]
    XPPMT,          -- Indicator: Partial Payments [xppmt]
    XVORT,          -- Indicator: Carryforward Residual Bal. for Payt Difference? [xvort]
    RSTGN,          -- Reason Code [rstgr]
    WAERS,          -- Currency [waers]
    SCURR,          -- Amount [scurr_av]
    SDATE,          -- Date [sdate_av]
    STYPE,          -- Selection Type [stype_av]
    SPRIO,          -- Sel.Priority [sprio_av]
    XREF1,          -- Reference Key 1 [xref1]
    XREF2,          -- Reference Key 2 [xref2]
    AFELD,          -- Ext. Sel. Field [afeld_av]
    LIEFN,          -- Delivery [vbeln_vl]
    REDAT,          -- Invoice Date [redat]
    BSTNK,          -- Cust. Reference [bstnk]
    XACON,          -- On Account [xacon]
    ASTAT,          -- Payt Adv. Stat. [astat_avik]
    XAMCA,          -- Indicator: Do Not Calculate Gross Amount if Initial? [xamca]
    ABBTR,          -- Deduction amt [abbtr_av]
    CONTR,          -- Ctrl Field [contr_av]
    KIDNO,          -- Payment Ref. [kidno]
    LBINVREF,       -- Lockbox Invoice Reference [lbinvref]
    FICA_SELW1,     -- Field Value [selwa_kk]
    FICA_SELT1,     -- Selection Cat. [seltx_kk]
    FICA_OPBEL,     -- Document Number [opbel_kk]
    FICA_BETRW_AC,  -- Assigned Amount [betrw_ac_kk]
    PRIMARY KEY (MANDT, BUKRS, KOART, KONTO, AVSID, AVSPO)
);

Learn More