J_1IG_ISD_DISTR

Transparent Table Application Table

GST IN: ISD Distribution Details

J_1IG_ISD_DISTR is an SAP database table in S/4HANA. GST IN: ISD Distribution Details. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FISTRPGSTR3BITEM view left_outer
I_IN_InputSrvcDistrBasic view from BASIC Input Service Distribution Basic CDS

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY belnr belnr_d Document Number
KEY blart blart Document Type
KEY buzei buzei Item
KEY gjahr gjahr Fiscal Year
KEY bukrs bukrs Company Code
KEY isd_bupla bupla Business place
KEY rec_bupla bupla Business place
isd_cgst fwste_cs Amount
isd_cgst_con kschl Condition Type
isd_cgst_hkont hkont G/L Acct
isd_sgst fwste_cs Amount
isd_sgst_con kschl Condition Type
isd_sgst_hkont hkont G/L Acct
isd_ugst fwste_cs Amount
isd_ugst_con kschl Condition Type
isd_ugst_hkont hkont G/L Acct
isd_igst fwste_cs Amount
isd_igst_con kschl Condition Type
isd_igst_hkont hkont G/L Acct
isd_cess fwste_cs Amount
isd_cess_con kschl Condition Type
isd_cess_hkont hkont G/L Acct
rec_cgst fwste_cs Amount
rec_cgst_con kschl Condition Type
rec_sgst fwste_cs Amount
rec_sgst_con kschl Condition Type
rec_ugst fwste_cs Amount
rec_ugst_con kschl Condition Type
rec_igst fwste_cs Amount
rec_igst_con kschl Condition Type
rec_cess fwste_cs Amount
rec_cess_con kschl Condition Type
isd_mwskz mwskz Tax Code
waers waers Currency
budat budat Posting Date
rec_belnr belnr_d Document Number
invoiced boole_d TRUE
hsn_sac j_1ig_hsn_sac HSN/SAC Code
numerator j_1ig_tod Turn-over
denominator j_1ig_tod Turn-over
non_deduct boole_d TRUE
doc_type j_1ig_isd_doc Doc. Type
ernam ernam Created By
erdat erdat Created On
changed_by ernam Created By
changed_on erdat Created On
rec_gjahr gjahr Fiscal Year

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.

-- GST IN: ISD Distribution Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1IG_ISD_DISTR (
    MANDT,           -- Client [mandt]
    BELNR,           -- Document Number [belnr_d]
    BLART,           -- Document Type [blart]
    BUZEI,           -- Item [buzei]
    GJAHR,           -- Fiscal Year [gjahr]
    BUKRS,           -- Company Code [bukrs]
    ISD_BUPLA,       -- Business place [bupla]
    REC_BUPLA,       -- Business place [bupla]
    ISD_CGST,        -- Amount [fwste_cs]
    ISD_CGST_CON,    -- Condition Type [kschl]
    ISD_CGST_HKONT,  -- G/L Acct [hkont]
    ISD_SGST,        -- Amount [fwste_cs]
    ISD_SGST_CON,    -- Condition Type [kschl]
    ISD_SGST_HKONT,  -- G/L Acct [hkont]
    ISD_UGST,        -- Amount [fwste_cs]
    ISD_UGST_CON,    -- Condition Type [kschl]
    ISD_UGST_HKONT,  -- G/L Acct [hkont]
    ISD_IGST,        -- Amount [fwste_cs]
    ISD_IGST_CON,    -- Condition Type [kschl]
    ISD_IGST_HKONT,  -- G/L Acct [hkont]
    ISD_CESS,        -- Amount [fwste_cs]
    ISD_CESS_CON,    -- Condition Type [kschl]
    ISD_CESS_HKONT,  -- G/L Acct [hkont]
    REC_CGST,        -- Amount [fwste_cs]
    REC_CGST_CON,    -- Condition Type [kschl]
    REC_SGST,        -- Amount [fwste_cs]
    REC_SGST_CON,    -- Condition Type [kschl]
    REC_UGST,        -- Amount [fwste_cs]
    REC_UGST_CON,    -- Condition Type [kschl]
    REC_IGST,        -- Amount [fwste_cs]
    REC_IGST_CON,    -- Condition Type [kschl]
    REC_CESS,        -- Amount [fwste_cs]
    REC_CESS_CON,    -- Condition Type [kschl]
    ISD_MWSKZ,       -- Tax Code [mwskz]
    WAERS,           -- Currency [waers]
    BUDAT,           -- Posting Date [budat]
    REC_BELNR,       -- Document Number [belnr_d]
    INVOICED,        -- TRUE [boole_d]
    HSN_SAC,         -- HSN/SAC Code [j_1ig_hsn_sac]
    NUMERATOR,       -- Turn-over [j_1ig_tod]
    DENOMINATOR,     -- Turn-over [j_1ig_tod]
    NON_DEDUCT,      -- TRUE [boole_d]
    DOC_TYPE,        -- Doc. Type [j_1ig_isd_doc]
    ERNAM,           -- Created By [ernam]
    ERDAT,           -- Created On [erdat]
    CHANGED_BY,      -- Created By [ernam]
    CHANGED_ON,      -- Created On [erdat]
    REC_GJAHR,       -- Fiscal Year [gjahr]
    PRIMARY KEY (MANDT, BELNR, BLART, BUZEI, GJAHR, BUKRS, ISD_BUPLA, REC_BUPLA)
);