ISJPHIERARCHY

Transparent Table Application Table
16 Fields 2 CDS Views

Customer Hierarchy For Invoice Summary

ISJPHIERARCHY is an SAP database table in S/4HANA. Customer Hierarchy For Invoice Summary. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_JP_InvcSummaryHierarchyBasic view_entity from BASIC Invoice Summary Hierarchy Basic
P_JP_invcsummaryhierarch view from BASIC Invoice Summary Customer Hierarchy

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY kunnr kunnr Customer
invsumrole isjpinvsumrole IS Role
invsumrecip isjpinvsumrecip Inv.Sum.Recipt.
invsumpayer isjpinvsumpayer Inv.Sum.Payer
pinrnr isjppinrnr No. Range PI
minrnr isjpminrnr No. Range MI
headertax isjpheadertax Calc. Tax in MI
holiduedate isjpholiduedate Move Due Date
bankcharge isjpbankcharge Bk.Chrg.: Payee
patternid isjppatternid Bk. Charge PID
banks banks Bank Ctry/Reg.
bankk bankk Bank Key
virtacctnr isjpvirtacctnr Virt.Acct.Nr.
rulezterm isjprulezterm Rule Payterm

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.

-- Customer Hierarchy For Invoice Summary
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISJPHIERARCHY (
    MANDT,        -- Client [mandt]
    BUKRS,        -- Company Code [bukrs]
    KUNNR,        -- Customer [kunnr]
    INVSUMROLE,   -- IS Role [isjpinvsumrole]
    INVSUMRECIP,  -- Inv.Sum.Recipt. [isjpinvsumrecip]
    INVSUMPAYER,  -- Inv.Sum.Payer [isjpinvsumpayer]
    PINRNR,       -- No. Range PI [isjppinrnr]
    MINRNR,       -- No. Range MI [isjpminrnr]
    HEADERTAX,    -- Calc. Tax in MI [isjpheadertax]
    HOLIDUEDATE,  -- Move Due Date [isjpholiduedate]
    BANKCHARGE,   -- Bk.Chrg.: Payee [isjpbankcharge]
    PATTERNID,    -- Bk. Charge PID [isjppatternid]
    BANKS,        -- Bank Ctry/Reg. [banks]
    BANKK,        -- Bank Key [bankk]
    VIRTACCTNR,   -- Virt.Acct.Nr. [isjpvirtacctnr]
    RULEZTERM,    -- Rule Payterm [isjprulezterm]
    PRIMARY KEY (MANDT, BUKRS, KUNNR)
);

Learn More