SAP table ISJPINVSUMIT (Line items for invoice summary)

SAP table ISJPINVSUMIT has 5 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BSTAT Document Status CHAR 1 0 BSTAT_D
INVSUMPAYER Invoice Summary Payer CHAR 10 0 ISJPINVSUMPAYER
PIGRUNIT Payer Invoice Grouping Unit CHAR 20 0 ISJPPIGRUNIT
WAERS Currency Key CUKY 5 0 WAERS
INVSUMRECIP Invoice Summary Recipient CHAR 10 0 ISJPINVSUMRECIP
GRUNIT Grouping Unit CHAR 20 0 ISJPGRUNIT
CLOSDATE Closing Date DATS 8 0 ISJPCLOSDATE
NETDT Due Date for Net Payment DATS 8 0 ISJPNETDT
MINR Monthly Invoice Number CHAR 10 0 ISJPMINR
NOTINCL Not Included In The Monthly Invoice CHAR 1 0 ISJPNOTINCL
MIBLOCK Monthly Invoice Block CHAR 1 0 ISJPMIBLOCK
X Blocked
NETAMNT Current Invoiced Net Amount CURR 23 2 ISJPNETAMNT
TAXAMNT Current Invoiced Tax Amount CURR 23 2 ISJPTAXAMNT
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
CREAUSER Created By User CHAR 12 0 ISJPCREAUSER
CREADATE Creation Date DATS 8 0 ISJPCREADATE
CREATIME Creation Time TIMS 6 0 ISJPCREATIME
CHANUSER Changed By User CHAR 12 0 ISJPCHANUSER
CHANDATE Changing Date DATS 8 0 ISJPCHANDATE
CHANTIME Changing Time TIMS 6 0 ISJPCHANTIME
ITEMCAT Item category CHAR 2 0 ISJPITEMCAT
Standard item
IS Invoice summary standard
TA Tax adjustment
CLEARDATE Clearing Date DATS 8 0 ISJPCLEARDATE
NETAMNT1 Net amount 1 for multiple tax code breakdown CURR 23 2 ISJPNETAMNT1
TAXAMNT1 Tax amount 1 for multiple tax code breakdown CURR 23 2 ISJPTAXAMNT1
MWSK1 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
NETAMNT2 Net amount 2 formultiple tax code breakdown CURR 23 2 ISJPNETAMNT2
TAXAMNT2 Tax amount 2 for multiple tax code breakdown CURR 23 2 ISJPTAXAMNT2
MWSK2 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
NETAMNT3 Net amount 3 for multiple tax code breakdown CURR 23 2 ISJPNETAMNT3
TAXAMNT3 Tax amount 3 for multiple tax code breakdown CURR 23 2 ISJPTAXAMNT3
MWSK3 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX