J_1IG_ISD_DISTR

Transparent Table Application Table
48 Fields 2 CDS Views

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)
);

Learn More