VIRAINV

Transparent Table Application Table
40 Fields 1 CDS Views

RE Invoice Header

VIRAINV is an SAP database table in S/4HANA. RE Invoice Header. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_REInvoiceHeader view from BASIC RE Invoice Header

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY invguid RERAINVGUID Invoice GUID
bukrs BUKRS Company Code
invno RERAINVNO Invoice Number
fisc_year GJAHR Fiscal Year
processguid RECAPROCESSGUID Process GUID
partner BU_PARTNER Busn. Partner
addrtype REBPADDRTYPE Address Type
role REBPROLE BP Role
itemselind RERAINVITEMSELIND Selection Type
duedatefrom RERADUEDATEFROM Due From
duedateto RERADUEDATETO End Due Period
inclcleareditems RERAINVINCLCLEAREDITEMS Cleared Items
clearcredititems RERAINVCLEARCREDITITEMS Cred.Memo Items
allopenitems RERAINVALLOPENITEMS Already Invoiced
collectind RERAINVCOLLECTIND Summ.Inv.
selectprocessid RERAINVSELPROCESSID Sel. PROCESSID
customer RERACUSTOMERNO Customer
objnr RERAINVOBJNRSINGLE Object Number
objcount RERAINVOBJCOUNT No.of contracts
iscreditmemo RERAINVISCREDITMEMO Credit Memo
isminoramount RERAINVISMINORAMOUNT Trivial Amount
currency WAERS Currency
totalgrossamount RERAINVTOTALAMOUNT Invoiced Amount
totalnetamount RERAINVTOTALNETAMOUNT Net Amount
totaltaxamount RERAINVTOTALTAXAMOUNT Tax Amount
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
canceled RERAINVCANCELED Reversed
sfdocguid RECPSFDOCGUID Document GUID
printedon RERAINVPRINTEDON Printed On
printedby RERAINVPRINTEDBY Printed By
rsguid RERAINVRSGUIDSINGLE Reservation
rscount RERAINVRESCOUNT No. Reserv.

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.

-- RE Invoice Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIRAINV (
    MANDT,             -- Client [MANDT]
    INVGUID,           -- Invoice GUID [RERAINVGUID]
    BUKRS,             -- Company Code [BUKRS]
    INVNO,             -- Invoice Number [RERAINVNO]
    FISC_YEAR,         -- Fiscal Year [GJAHR]
    PROCESSGUID,       -- Process GUID [RECAPROCESSGUID]
    PARTNER,           -- Busn. Partner [BU_PARTNER]
    ADDRTYPE,          -- Address Type [REBPADDRTYPE]
    ROLE,              -- BP Role [REBPROLE]
    ITEMSELIND,        -- Selection Type [RERAINVITEMSELIND]
    DUEDATEFROM,       -- Due From [RERADUEDATEFROM]
    DUEDATETO,         -- End Due Period [RERADUEDATETO]
    INCLCLEAREDITEMS,  -- Cleared Items [RERAINVINCLCLEAREDITEMS]
    CLEARCREDITITEMS,  -- Cred.Memo Items [RERAINVCLEARCREDITITEMS]
    ALLOPENITEMS,      -- Already Invoiced [RERAINVALLOPENITEMS]
    COLLECTIND,        -- Summ.Inv. [RERAINVCOLLECTIND]
    SELECTPROCESSID,   -- Sel. PROCESSID [RERAINVSELPROCESSID]
    CUSTOMER,          -- Customer [RERACUSTOMERNO]
    OBJNR,             -- Object Number [RERAINVOBJNRSINGLE]
    OBJCOUNT,          -- No.of contracts [RERAINVOBJCOUNT]
    ISCREDITMEMO,      -- Credit Memo [RERAINVISCREDITMEMO]
    ISMINORAMOUNT,     -- Trivial Amount [RERAINVISMINORAMOUNT]
    CURRENCY,          -- Currency [WAERS]
    TOTALGROSSAMOUNT,  -- Invoiced Amount [RERAINVTOTALAMOUNT]
    TOTALNETAMOUNT,    -- Net Amount [RERAINVTOTALNETAMOUNT]
    TOTALTAXAMOUNT,    -- Tax Amount [RERAINVTOTALTAXAMOUNT]
    RERF,              -- Entered By [RERF]
    DERF,              -- First Enterd On [DERF]
    TERF,              -- Time [TERF]
    REHER,             -- Source.In.Entry [REHER]
    RBEAR,             -- Last Changed By [RBEAR]
    DBEAR,             -- Last Edited On [DBEAR]
    TBEAR,             -- Last Edited At [TBEAR]
    RBHER,             -- Editing Source [RBHER]
    CANCELED,          -- Reversed [RERAINVCANCELED]
    SFDOCGUID,         -- Document GUID [RECPSFDOCGUID]
    PRINTEDON,         -- Printed On [RERAINVPRINTEDON]
    PRINTEDBY,         -- Printed By [RERAINVPRINTEDBY]
    RSGUID,            -- Reservation [RERAINVRSGUIDSINGLE]
    RSCOUNT,           -- No. Reserv. [RERAINVRESCOUNT]
    PRIMARY KEY (MANDT, INVGUID)
);

Learn More