1. Home
  2. Resources
  3. SAP Tables
  4. ISJPVIRTACCT - Virtual accounts

SAP Table ISJPVIRTACCT

Virtual accounts

ISJPVIRTACCT (Virtual accounts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ISJPVIRTACCT to other SAP tables.

ISJPVIRTACCT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BANKS Bank country key BANKS T005 CHAR 3 0
BANKL Bank Keys BANKK BNKA CHAR 15 0
VIRTACCTNR Virtual Account Number ISJPVIRTACCTNR CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
CREADATE Creation Date ISJPCREADATE DATS 8 0
CREATIME Creation Time ISJPCREATIME TIMS 6 0
CHANDATE Changing Date ISJPCHANDATE DATS 8 0
CHANTIME Changing Time ISJPCHANTIME TIMS 6 0
SPECCASEREL Relevant for Special Cases ISJPSPECCASEREL CHAR 1 0
LOCKPERIOD Lock Period in Days ISJPLOCKPERIOD NUMC 2 0
ASSIGNBLOCK Assignment Block ISJPASSIGNBLOCK CHAR 1 0
INVSUMNR Invoice Summary Number ISJPINVSUMNR CHAR 10 0
UNLOCKFROMDATE Date for Unlocking the Virtual Account Number ISJPUNLOCKFROMDATE DATS 8 0

ISJPVIRTACCT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ISJPVIRTACCT BANKL ISJPVIRTACCT MANDT BNKA Bank master record MANDT
ISJPVIRTACCT BANKL ISJPVIRTACCT BANKS BNKA Bank master record BANKS
ISJPVIRTACCT BANKL ISJPVIRTACCT BANKL BNKA Bank master record BANKL
ISJPVIRTACCT BANKS ISJPVIRTACCT MANDT T005 Countries MANDT
ISJPVIRTACCT BANKS ISJPVIRTACCT BANKS T005 Countries LAND1
ISJPVIRTACCT MANDT ISJPVIRTACCT MANDT T000 Clients MANDT