1. SAP Tutorial
  2. FI Module

ISJPINVSUMIT SAP table for – Line items for invoice summary

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

SAP ISJPINVSUMIT table

Table ISJPINVSUMIT technical data

TableISJPINVSUMIT
Data storingLine items for invoice summary
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-INVSUM-JP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP ISJPINVSUMIT 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 ISJPINVSUMIT 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
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • BSTAT : Document Status
    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
  • MINR : Monthly Invoice Number
    Its data type is CHAR (Character String) with field length 10
  • NOTINCL : Not Included In The Monthly Invoice
    Its data type is CHAR (Character String) with field length 1
  • MIBLOCK : Monthly Invoice Block
    Its data type is CHAR (Character String) with field length 1
  • NETAMNT : Current Invoiced Net Amount
    Its data type is CURR (Currency Field) with field length 13
  • TAXAMNT : Current Invoiced Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • 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
  • ITEMCAT : Item category
    Its data type is CHAR (Character String) with field length 2
  • CLEARDATE : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NETAMNT1 : Net amount 1 for multiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • TAXAMNT1 : Tax amount 1 for multiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWSK1 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2
  • NETAMNT2 : Net amount 2 formultiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • TAXAMNT2 : Tax amount 2 for multiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWSK2 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2
  • NETAMNT3 : Net amount 3 for multiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • TAXAMNT3 : Tax amount 3 for multiple tax code breakdown
    Its data type is CURR (Currency Field) with field length 13
  • MWSK3 : Tax Code for Distribution
    Its data type is CHAR (Character String) with field length 2

    • ISJPINVSUMIT related tables

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

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

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

    Related References

    Related Tutorials

    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...

    ISJPINVSUMHD SAP table for – Invoice Summary Header

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

    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...

    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....

    ISJP_SNRO SAP tcode for – Number Range for Invoice Summary

    ISJP_SNRO tcode in SAP FI (Localization in FI) module. This transaction code is used for Number Range for Invoice Summary....

    «
    »