AVIK

Transparent Table Application Table
53 Fields 4 CDS Views

Aviskopf

AVIK is an SAP database table in S/4HANA. Aviskopf. It contains 53 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Farvd_Pyadv_Hdr view from Payment Advice Header
I_PaymentAdvice view from BASIC Payment Advice Header
P_ARBSITMPAYADVICE view from BASIC
P_PaymentAdviceHeader view from BASIC

Fields (53)

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.
xausg xausg_av Outgoing Payt
vblnr vblnr Payment Doc.No.
eikto eikto Acct at Cust.
waers waers Currency
zaldt dzaldt Payment Date
rwbtr rwbtr_av Payment Amount
rwskt rwskt Cash Discount Amount
wefae wefae BoE Due Date
rzawe rzawe Payment Method
zbnkl dzbnkl Bank number
zbnkn dzbnkn Payee acct no.
ernam ernam Created By
erdat erdat Created On
aedat aedat Changed On
aenam aenam Changed By
avtxt avtxt_avik Adv.Header Text
avsrt avsrt Payt Adv. Type
tcode tcode_avik Transaction
cputm cputm Entered at
astat astat_avik Payt Adv. Stat.
xacon xacon_avik Pmt on Acct Pst
xkeep xkeep_avik Hold Payt Adv.
xuniq xuniq_avik Specific Account?
vrsdg vrsdg Rsn Code Conv.
sregl sregl Selection Rule
xbenr awkey Reference Key
xbtyp awtyp Ref. procedure
vgref refbk Bank Reference
pakoa koart_av Account Type
pakto ktonr_av Account
bvdat bvdat_eb Bank Pstng Date
butim butim_eb Value Date Time
spesk spesk_eb AC Fees
vorgc vorgc_eb Bus Trans Code
texts texts_eb Text Key
zbnks pabks_eb Part. Ctry/Rgn
zbswi paswi_eb Partner SWIFT
kursf kursf_eb Exchange Rate
jpdat jpdat_eb Date in Japan
chect chect Check number
xconf xconf_avik Payment Confirmed
avrt2 avsrt Payt Adv. Type
zbprn partn_eb BusPartner
valut valut Value date
lastchangedatetime timestampl Time Stamp
fica_apbel apbel_kk Usage Doc.
fica_vkont vkont_av_kk Contract Acct
fica_avkey avkey_kk Payment Advice Note

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.

-- Aviskopf
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AVIK (
    MANDT,               -- Client [mandt]
    BUKRS,               -- Company Code [bukrs]
    KOART,               -- Account Type [koart_av]
    KONTO,               -- Account [ktonr_av]
    AVSID,               -- Payt Advice No. [avsid]
    XAUSG,               -- Outgoing Payt [xausg_av]
    VBLNR,               -- Payment Doc.No. [vblnr]
    EIKTO,               -- Acct at Cust. [eikto]
    WAERS,               -- Currency [waers]
    ZALDT,               -- Payment Date [dzaldt]
    RWBTR,               -- Payment Amount [rwbtr_av]
    RWSKT,               -- Cash Discount Amount [rwskt]
    WEFAE,               -- BoE Due Date [wefae]
    RZAWE,               -- Payment Method [rzawe]
    ZBNKL,               -- Bank number [dzbnkl]
    ZBNKN,               -- Payee acct no. [dzbnkn]
    ERNAM,               -- Created By [ernam]
    ERDAT,               -- Created On [erdat]
    AEDAT,               -- Changed On [aedat]
    AENAM,               -- Changed By [aenam]
    AVTXT,               -- Adv.Header Text [avtxt_avik]
    AVSRT,               -- Payt Adv. Type [avsrt]
    TCODE,               -- Transaction [tcode_avik]
    CPUTM,               -- Entered at [cputm]
    ASTAT,               -- Payt Adv. Stat. [astat_avik]
    XACON,               -- Pmt on Acct Pst [xacon_avik]
    XKEEP,               -- Hold Payt Adv. [xkeep_avik]
    XUNIQ,               -- Specific Account? [xuniq_avik]
    VRSDG,               -- Rsn Code Conv. [vrsdg]
    SREGL,               -- Selection Rule [sregl]
    XBENR,               -- Reference Key [awkey]
    XBTYP,               -- Ref. procedure [awtyp]
    VGREF,               -- Bank Reference [refbk]
    PAKOA,               -- Account Type [koart_av]
    PAKTO,               -- Account [ktonr_av]
    BVDAT,               -- Bank Pstng Date [bvdat_eb]
    BUTIM,               -- Value Date Time [butim_eb]
    SPESK,               -- AC Fees [spesk_eb]
    VORGC,               -- Bus Trans Code [vorgc_eb]
    TEXTS,               -- Text Key [texts_eb]
    ZBNKS,               -- Part. Ctry/Rgn [pabks_eb]
    ZBSWI,               -- Partner SWIFT [paswi_eb]
    KURSF,               -- Exchange Rate [kursf_eb]
    JPDAT,               -- Date in Japan [jpdat_eb]
    CHECT,               -- Check number [chect]
    XCONF,               -- Payment Confirmed [xconf_avik]
    AVRT2,               -- Payt Adv. Type [avsrt]
    ZBPRN,               -- BusPartner [partn_eb]
    VALUT,               -- Value date [valut]
    LASTCHANGEDATETIME,  -- Time Stamp [timestampl]
    FICA_APBEL,          -- Usage Doc. [apbel_kk]
    FICA_VKONT,          -- Contract Acct [vkont_av_kk]
    FICA_AVKEY,          -- Payment Advice Note [avkey_kk]
    PRIMARY KEY (MANDT, BUKRS, KOART, KONTO, AVSID)
);

Learn More