ISJPINVSUMHD

Transparent Table Application Table
34 Fields 3 CDS Views

Invoice Summary Header

ISJPINVSUMHD is an SAP database table in S/4HANA. Invoice Summary Header. It contains 34 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_JP_InvoiceSummaryParamDetm view_entity from BASIC Invoice Summary Paramter Determination
P_Jp_InvcSmmryHeader view from BASIC
P_JP_InvcSmmryParamDetermine view_entity from BASIC

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY invsumnr ISJPINVSUMNR Inv.Sum.Nr.
KEY invsumtype ISJPINVSUMTYPE Inv.Sum.Type
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
pinr ISJPPINR Payer Inv. Nr.
netamnt ISJPNETHDAMNT Curr.Inv.Net
taxamnt ISJPTAXHDAMNT Curr.Inv.Tax
paidamnt ISJPPAIDAMNT Paid Amount
previnvamnt ISJPPREVINVAMNT Prev.Inv.Amnt.
carfwdamnt ISJPCARFWDAMNT Carry fwd Amnt
prevclosdate ISJPPREVCLOSDATE Previous Clos. Date
prevnetdt ISJPPREVNETDT Prev. Due Date
previnvsumnr ISJPPREVINVSUMNR Prev. Inv.Sum.Nr.
nextinvsumnr ISJPNEXTINVSUMNR Next. Inv.Sum.Nr.
openamnt ISJPOPENAMNT Open Amount
cleardate ISJPCLEARDATE Clrg Exec Date
cancelled ISJPCANCELLED Cancelled
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
nropenitems ISJPNROPENITEMS No of Open Items
banks BANKS Bank Ctry/Reg.
bankl BANKK Bank Key
virtacctnr ISJPVIRTACCTNR Virt.Acct.Nr.

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.

-- Invoice Summary Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISJPINVSUMHD (
    MANDT,         -- Client [MANDT]
    BUKRS,         -- Company Code [BUKRS]
    INVSUMNR,      -- Inv.Sum.Nr. [ISJPINVSUMNR]
    INVSUMTYPE,    -- Inv.Sum.Type [ISJPINVSUMTYPE]
    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]
    PINR,          -- Payer Inv. Nr. [ISJPPINR]
    NETAMNT,       -- Curr.Inv.Net [ISJPNETHDAMNT]
    TAXAMNT,       -- Curr.Inv.Tax [ISJPTAXHDAMNT]
    PAIDAMNT,      -- Paid Amount [ISJPPAIDAMNT]
    PREVINVAMNT,   -- Prev.Inv.Amnt. [ISJPPREVINVAMNT]
    CARFWDAMNT,    -- Carry fwd Amnt [ISJPCARFWDAMNT]
    PREVCLOSDATE,  -- Previous Clos. Date [ISJPPREVCLOSDATE]
    PREVNETDT,     -- Prev. Due Date [ISJPPREVNETDT]
    PREVINVSUMNR,  -- Prev. Inv.Sum.Nr. [ISJPPREVINVSUMNR]
    NEXTINVSUMNR,  -- Next. Inv.Sum.Nr. [ISJPNEXTINVSUMNR]
    OPENAMNT,      -- Open Amount [ISJPOPENAMNT]
    CLEARDATE,     -- Clrg Exec Date [ISJPCLEARDATE]
    CANCELLED,     -- Cancelled [ISJPCANCELLED]
    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]
    NROPENITEMS,   -- No of Open Items [ISJPNROPENITEMS]
    BANKS,         -- Bank Ctry/Reg. [BANKS]
    BANKL,         -- Bank Key [BANKK]
    VIRTACCTNR,    -- Virt.Acct.Nr. [ISJPVIRTACCTNR]
    PRIMARY KEY (MANDT, BUKRS, INVSUMNR, INVSUMTYPE)
);

Learn More