ISJPVIRTACCT

Transparent Table Application Table
14 Fields 2 CDS Views

Virtual accounts

ISJPVIRTACCT is an SAP database table in S/4HANA. Virtual accounts. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_JP_InvcSummaryVirtualAccount view from BASIC Invoice Summary Virtual Account
SHSM_VIRTACCT view from

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY banks BANKS Bank Ctry/Reg.
KEY bankl BANKK Bank Key
KEY virtacctnr ISJPVIRTACCTNR Virt.Acct.Nr.
bukrs BUKRS Company Code
creadate ISJPCREADATE Creation Date
creatime ISJPCREATIME Creation Time
chandate ISJPCHANDATE Changing Date
chantime ISJPCHANTIME Changing Time
speccaserel ISJPSPECCASEREL Spec. Cases Rel.
lockperiod ISJPLOCKPERIOD Lock Period
assignblock ISJPASSIGNBLOCK Assign.Block
invsumnr ISJPINVSUMNR Inv.Sum.Nr.
unlockfromdate ISJPUNLOCKFROMDATE Reuse from Date

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.

-- Virtual accounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISJPVIRTACCT (
    MANDT,           -- Client [MANDT]
    BANKS,           -- Bank Ctry/Reg. [BANKS]
    BANKL,           -- Bank Key [BANKK]
    VIRTACCTNR,      -- Virt.Acct.Nr. [ISJPVIRTACCTNR]
    BUKRS,           -- Company Code [BUKRS]
    CREADATE,        -- Creation Date [ISJPCREADATE]
    CREATIME,        -- Creation Time [ISJPCREATIME]
    CHANDATE,        -- Changing Date [ISJPCHANDATE]
    CHANTIME,        -- Changing Time [ISJPCHANTIME]
    SPECCASEREL,     -- Spec. Cases Rel. [ISJPSPECCASEREL]
    LOCKPERIOD,      -- Lock Period [ISJPLOCKPERIOD]
    ASSIGNBLOCK,     -- Assign.Block [ISJPASSIGNBLOCK]
    INVSUMNR,        -- Inv.Sum.Nr. [ISJPINVSUMNR]
    UNLOCKFROMDATE,  -- Reuse from Date [ISJPUNLOCKFROMDATE]
    PRIMARY KEY (MANDT, BANKS, BANKL, VIRTACCTNR)
);

Learn More