AVIP

Transparent Table Application Table
60 Fields 2 CDS Views

Payment Advice Line Item

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

-- Payment Advice Line Item
-- 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