CFIN_AVSI_ACCASE

Transparent Table Temporary Data
15 Fields 2 CDS Views

Supplier Invoice - 3rd Party - Account Assignment

CFIN_AVSI_ACCASE is an SAP database table in S/4HANA. Supplier Invoice - 3rd Party - Account Assignment. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CFinRpldSuplrInvcItemGLAcct view_entity from CONSUMPTION CFin Rpld Supplier Invoice Item GL Account (API)
A_CFinRpldSuplrInvcItmAcctAsgt view_entity from CONSUMPTION CFin Rpld Supplier Invoice Item Acc(API)

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY av_dbkey FINS_CFIN_AV_DBKEY DB Key
sourcesystemlogicalsystem LOGSYS Logical system
cfinrpldsupplierinvoice FINS_CFIN_AV_RPLD_SUPLR_INVC Central Finance Repl. Supplier Invoice
fiscalyear GJAHR Fiscal Year
cfinrpldsupplierinvoiceitem RBLGP Item
suplrinvcitemaccountassignment COBL_NR Seq. Number
supplierinvoiceitemamount WRBTR_CS Amount
debitcreditcode SHKZG Debit/Credit
taxcode MWSKZ Tax Code
glaccount SAKNR G/L Account
isnegativeposting XNEGP Negative Postg
documentcurrency WAERS Currency
lastchangedatetime FINS_CFIN_AV_LASTCHANGEDON Last Changed On
companycode BUKRS Company 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.

-- Supplier Invoice - 3rd Party - Account Assignment
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AVSI_ACCASE (
    MANDT,                           -- Client [MANDT]
    AV_DBKEY,                        -- DB Key [FINS_CFIN_AV_DBKEY]
    SOURCESYSTEMLOGICALSYSTEM,       -- Logical system [LOGSYS]
    CFINRPLDSUPPLIERINVOICE,         -- Central Finance Repl. Supplier Invoice [FINS_CFIN_AV_RPLD_SUPLR_INVC]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    CFINRPLDSUPPLIERINVOICEITEM,     -- Item [RBLGP]
    SUPLRINVCITEMACCOUNTASSIGNMENT,  -- Seq. Number [COBL_NR]
    SUPPLIERINVOICEITEMAMOUNT,       -- Amount [WRBTR_CS]
    DEBITCREDITCODE,                 -- Debit/Credit [SHKZG]
    TAXCODE,                         -- Tax Code [MWSKZ]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    ISNEGATIVEPOSTING,               -- Negative Postg [XNEGP]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    LASTCHANGEDATETIME,              -- Last Changed On [FINS_CFIN_AV_LASTCHANGEDON]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PRIMARY KEY (MANDT, AV_DBKEY)
);

Learn More