ISJPINVSUMIT

Transparent Table Application Table
40 Fields 1 CDS Views

Line items for invoice summary

ISJPINVSUMIT is an SAP database table in S/4HANA. Line items for invoice summary. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Jp_InvcSmmryItem view from BASIC

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY buzei buzei Item
bstat bstat_d Document Status
invsumpayer isjpinvsumpayer Inv.Sum.Payer
pigrunit isjppigrunit Payer Group.Unit
waers waers Currency
invsumrecip isjpinvsumrecip Inv.Sum.Recipt.
grunit isjpgrunit Group.Unit
closdate isjpclosdate Clos.Date
netdt isjpnetdt Due on
minr isjpminr MI Nr.
notincl isjpnotincl Not Incl. In MI
miblock isjpmiblock MI Block
netamnt isjpnetamnt Curr.Inv.Net
taxamnt isjptaxamnt Curr.Inv.Tax
mwskz mwskz Tax Code
txdat_from fot_txdat_from Tax Rate Valid-From
creauser isjpcreauser Created By User
creadate isjpcreadate Creation Date
creatime isjpcreatime Creation Time
chanuser isjpchanuser Changed By User
chandate isjpchandate Changing Date
chantime isjpchantime Changing Time
itemcat isjpitemcat Item Category
cleardate isjpcleardate Clrg Exec Date
netamnt1 isjpnetamnt1 Net amount 1
taxamnt1 isjptaxamnt1 Tax amount 1
mwsk1 mwskx Tax Code
txdat_from1 fot_txdat_fromx Tax Rate Valid-From
netamnt2 isjpnetamnt2 Net amount 2
taxamnt2 isjptaxamnt2 Tax amount 2
mwsk2 mwskx Tax Code
txdat_from2 fot_txdat_fromx Tax Rate Valid-From
netamnt3 isjpnetamnt3 Net amount 3
taxamnt3 isjptaxamnt3 Tax amount 3
mwsk3 mwskx Tax Code
txdat_from3 fot_txdat_fromx Tax Rate Valid-From

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Line items for invoice summary
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISJPINVSUMIT (
    MANDT,        -- Client [mandt]
    BUKRS,        -- Company Code [bukrs]
    BELNR,        -- Document Number [belnr_d]
    GJAHR,        -- Fiscal Year [gjahr]
    BUZEI,        -- Item [buzei]
    BSTAT,        -- Document Status [bstat_d]
    INVSUMPAYER,  -- Inv.Sum.Payer [isjpinvsumpayer]
    PIGRUNIT,     -- Payer Group.Unit [isjppigrunit]
    WAERS,        -- Currency [waers]
    INVSUMRECIP,  -- Inv.Sum.Recipt. [isjpinvsumrecip]
    GRUNIT,       -- Group.Unit [isjpgrunit]
    CLOSDATE,     -- Clos.Date [isjpclosdate]
    NETDT,        -- Due on [isjpnetdt]
    MINR,         -- MI Nr. [isjpminr]
    NOTINCL,      -- Not Incl. In MI [isjpnotincl]
    MIBLOCK,      -- MI Block [isjpmiblock]
    NETAMNT,      -- Curr.Inv.Net [isjpnetamnt]
    TAXAMNT,      -- Curr.Inv.Tax [isjptaxamnt]
    MWSKZ,        -- Tax Code [mwskz]
    TXDAT_FROM,   -- Tax Rate Valid-From [fot_txdat_from]
    CREAUSER,     -- Created By User [isjpcreauser]
    CREADATE,     -- Creation Date [isjpcreadate]
    CREATIME,     -- Creation Time [isjpcreatime]
    CHANUSER,     -- Changed By User [isjpchanuser]
    CHANDATE,     -- Changing Date [isjpchandate]
    CHANTIME,     -- Changing Time [isjpchantime]
    ITEMCAT,      -- Item Category [isjpitemcat]
    CLEARDATE,    -- Clrg Exec Date [isjpcleardate]
    NETAMNT1,     -- Net amount 1 [isjpnetamnt1]
    TAXAMNT1,     -- Tax amount 1 [isjptaxamnt1]
    MWSK1,        -- Tax Code [mwskx]
    TXDAT_FROM1,  -- Tax Rate Valid-From [fot_txdat_fromx]
    NETAMNT2,     -- Net amount 2 [isjpnetamnt2]
    TAXAMNT2,     -- Tax amount 2 [isjptaxamnt2]
    MWSK2,        -- Tax Code [mwskx]
    TXDAT_FROM2,  -- Tax Rate Valid-From [fot_txdat_fromx]
    NETAMNT3,     -- Net amount 3 [isjpnetamnt3]
    TAXAMNT3,     -- Tax amount 3 [isjptaxamnt3]
    MWSK3,        -- Tax Code [mwskx]
    TXDAT_FROM3,  -- Tax Rate Valid-From [fot_txdat_fromx]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI)
);

Learn More