1. SAP Tutorial
  2. FI Module

ISJPINVSUMHD SAP table for – Invoice Summary Header

Here we would like to draw your attention to ISJPINVSUMHD 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). ISJPINVSUMHD is a SAP standard transp table used for storing Invoice Summary Header related data in SAP. It comes under the package ID-INVSUM-JP.

SAP ISJPINVSUMHD table

Table ISJPINVSUMHD technical data

TableISJPINVSUMHD
Data storingInvoice Summary Header
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-INVSUM-JP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP ISJPINVSUMHD 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 ISJPINVSUMHD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • INVSUMNR : Invoice Summary Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INVSUMTYPE : Invoice Summary Type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • INVSUMPAYER : Invoice Summary Payer
    Its data type is CHAR (Character String) with field length 10
  • PIGRUNIT : Payer Invoice Grouping Unit
    Its data type is CHAR (Character String) with field length 20
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INVSUMRECIP : Invoice Summary Recipient
    Its data type is CHAR (Character String) with field length 10
  • GRUNIT : Grouping Unit
    Its data type is CHAR (Character String) with field length 20
  • CLOSDATE : Closing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NETDT : Due Date for Net Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PINR : Payer Invoice Number
    Its data type is CHAR (Character String) with field length 10
  • NETAMNT : Current Invoiced Net Amount
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMNT : Current Invoiced Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • PAIDAMNT : Paid Amount
    Its data type is CURR (Currency Field) with field length 15
  • PREVINVAMNT : Previous Invoiced Amount
    Its data type is CURR (Currency Field) with field length 15
  • CARFWDAMNT : Carry Forward Amount
    Its data type is CURR (Currency Field) with field length 15
  • PREVCLOSDATE : Previous Closing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PREVNETDT : Previous net due date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PREVINVSUMNR : Invoice Summary Number
    Its data type is CHAR (Character String) with field length 10
  • NEXTINVSUMNR : Invoice Summary Number
    Its data type is CHAR (Character String) with field length 10
  • OPENAMNT : Open Amount
    Its data type is CURR (Currency Field) with field length 15
  • CLEARDATE : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CANCELLED : Cancelled
    Its data type is CHAR (Character String) with field length 1
  • CREAUSER : Created By User
    Its data type is CHAR (Character String) with field length 12
  • 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
  • CHANUSER : Changed By User
    Its data type is CHAR (Character String) with field length 12
  • 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
  • NROPENITEMS : Number of Open Items
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Virtual account number data
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANKL : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • VIRTACCTNR : Virtual Account Number
    Its data type is CHAR (Character String) with field length 10

    • ISJPINVSUMHD related tables

    • ISJPPATTERN_T : Description ofr bank charge patterns
    • ISJPHIERARCHY : Customer Hierarchy For Invoice Summary
    • ISJPINVSUMIT : Line items for invoice summary
    • ISJPINVSUMHD : Invoice Summary Header
    • ISJPVIRTACCT : Virtual accounts
    • ISJPNAYOSE : Alternative Name for Payer
    • ISJPPATTERN : Bank charge pattern
    • ISJPBKCHARGE : Bank charges
    • ISJPTAXADJUST : Tax Adjustment Postings
    • ISJPPAYTERMS : Terms of payment with validity period
    • ISJPSELECTION : Selection of line items for Invoice Summary

    ISJPINVSUMHD related transaction codes under SAP package ID-INVSUM-JP

    • ISJP_VA : Maintenance of Virtual Accounts
    • ISJP_CR : Invoice Summary Processing
    • ISJP_STR : Invoice Summary Status Report
    • ISJP_SNRO : Number Range for Invoice Summary
    • ISJP_MD : Master Data for Invoice Summary
    • ISJP_PR : Invoice Summary Printing

    Related References

    Related Tutorials

    ISJPINVSUMIT SAP table for – Line items for invoice summary

    ISJPINVSUMIT table in SAP FI (Localization in FI) module. This table is used for storing data of Line items for...

    ISJPHIERARCHY SAP table for – Customer Hierarchy For Invoice Summary

    ISJPHIERARCHY table in SAP FI (Localization in FI) module. This table is used for storing data of Customer Hierarchy For...

    ISJPSELECTION SAP table for – Selection of line items for Invoice Summary

    ISJPSELECTION table in SAP FI (Localization in FI) module. This table is used for storing data of Selection of line...

    IDGT_VATH SAP table for – VAT Invoice Header

    IDGT_VATH table in SAP FI (Localization in FI) module. This table is used for storing data of VAT Invoice Header....

    ISJP_CR SAP tcode for – Invoice Summary Processing

    ISJP_CR tcode in SAP FI (Localization in FI) module. This transaction code is used for Invoice Summary Processing. See the...

    ISJP_PR SAP tcode for – Invoice Summary Printing

    ISJP_PR tcode in SAP FI (Localization in FI) module. This transaction code is used for Invoice Summary Printing. See the...

    ISJP_MD SAP tcode for – Master Data for Invoice Summary

    ISJP_MD tcode in SAP FI (Localization in FI) module. This transaction code is used for Master Data for Invoice Summary....

    «
    »