J_1IG_ISD_DISTR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FISTRPGSTR3BITEM | view | left_outer | ||
| I_IN_InputSrvcDistrBasic | view | from | BASIC | Input Service Distribution Basic CDS |
Fields (48)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA