ISJPVIRTACCT SAP table for – Virtual accounts

Here we would like to draw your attention to ISJPVIRTACCT table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). ISJPVIRTACCT is a SAP standard transp table used for storing Virtual accounts related data in SAP. It comes under the package ID-INVSUM-JP.

SAP ISJPVIRTACCT table

Table ISJPVIRTACCT technical data

TableISJPVIRTACCT
Data storingVirtual accounts
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-INVSUM-JP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP ISJPVIRTACCT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ISJPVIRTACCT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BANKS : Bank country key
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • BANKL : Bank Keys
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • VIRTACCTNR : Virtual Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • CREADATE : Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATIME : Creation Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHANDATE : Changing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANTIME : Changing Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • .INCLU–AP : Special Case Data
  • SPECCASEREL : Relevant for Special Cases
    Its data type is CHAR (Character String) with field length 1
  • LOCKPERIOD : Lock Period in Days
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ASSIGNBLOCK : Assignment Block
    Its data type is CHAR (Character String) with field length 1
  • INVSUMNR : Invoice Summary Number
    Its data type is CHAR (Character String) with field length 10
  • UNLOCKFROMDATE : Date for Unlocking the Virtual Account Number
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8