EDCINGSTR2H

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.

-- Tax Authority Header Table for 2B/2A
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDCINGSTR2H (
    MANDT,                   -- Client [mandt]
    RECORD_GUID,             -- Record GUID [edc_record_guid]
    TP_GSTIN,                -- Taxpayer GSTIN [edc_in_tax_payer_gstin]
    RET_PERIOD,              -- Reporting Period [edoc_in_rep_period]
    STMT_PERIOD_2B,          -- 2B Statement Period [edc_in_stmt_period_2b]
    DOC_SECTION,             -- GSTR2A/2B Doc Sec [edc_in_doc_section_r2]
    CP_GSTIN,                -- Counter Party GSTIN [edoc_in_ctin]
    CP_NAME,                 -- Counterparty Name [edc_in_cp_name]
    CP_FILING_STATUS_R1,     -- Cp GSTR1 Filing St [edc_in_cp_filing_status_r1]
    CP_FILING_STATUS_R3B,    -- Cp GSTR3B Filing St [edc_in_cp_filing_status_r3b]
    CP_CANCELATION_DATE,     -- Cp Cancel Date [edc_in_cp_cancelation_date]
    CP_FILING_DATE_R1,       -- Cp GSTR1 Filing Date [edc_in_cp_filing_date_r1]
    CP_FILING_PERIOD_R1,     -- Cp GSTR1 Filing Pd [edc_in_cp_filing_period_r1]
    DOC_NUM,                 -- Document Number [edc_in_doc_num]
    DOC_DATE,                -- Document Date [edc_in_doc_date]
    NOTE_TYPE,               -- Cr/Dr Note Type [edc_in_note_type]
    FIN_YEAR,                -- Financial Year [edoc_in_fin_year]
    INV_TYPE,                -- Document Type [edc_in_doc_type]
    DOC_AMOUNT,              -- Document Amount [edc_in_doc_amount]
    CURRENCY_CODE,           -- Currency Code [edoc_in_currency_code]
    POS,                     -- Place of Supply [j_1ig_region]
    IS_REVERSE_CHARGE,       -- Rev Chrg Indicator [edc_in_rvchrg]
    IS_ITC_AVAILABLE,        -- ITC Avail Indicator [edc_in_itc_avail_ind]
    ITC_UNAVAIL_REASON,      -- ITC Unav Reason Cd [edc_in_itc_unavail_rsn]
    DIFF_PERCENT,            -- Differential Percent [edoc_in_diffpercen]
    IRN,                     -- Invc Reference Nmbr [edoc_in_einv_irn]
    IRN_GENDATE,             -- IRN Genaration Date [edc_in_irn_generation_date]
    IRN_SRC_TYPE,            -- IRN Source Type [edc_in_irn_source_type]
    PORT_CODE,               -- Port Code [edc_in_ship_port_code]
    REF_DOC_DATE,            -- Reference Doc Date [edc_in_ref_doc_date]
    GST_RECEIVED_DATE,       -- Received Date GST [edc_in_gst_rec_date]
    ORIGL_DOC_NUM,           -- Orig Doc Number [edc_in_origl_doc_num]
    ORIGL_DOC_DATE,          -- Original Doc Date [edc_in_origl_doc_date]
    ORIG_NOTE_TYPE,          -- Original Note Type [edc_in_origl_note_type]
    REF_DOC_NUM,             -- Reference Doc Num [edc_in_ref_doc_num]
    IS_AMENDED,              -- Amendment Indicator [edc_in_amendment_ind]
    AMENDMENT_TYPE,          -- Amendment Type [edc_in_amendment_type]
    AMENDMENT_PERIOD,        -- Amendment Rtn Period [edc_in_amendment_period]
    ORIGL_PERIOD,            -- Orig Doc Return Pd [edc_in_origl_period]
    IS_2B_EXISTS,            -- edc_in_2b_exists
    REPORTING_DATE,          -- Reporting Date [edc_in_reporting_date]
    STMT_DATE_2B,            -- 2B Statement Date [edc_in_stmt_date_2b]
    BUSINESS_PLACE,          -- Business place [bupla]
    TAX_RATE,                -- Percent [kbetr_tax]
    TAXABLE_AMOUNT,          -- Taxable Amount [edc_in_taxable_amount]
    CGST_AMOUNT,             -- CGST Amount [edc_in_cgst_amount]
    SGST_AMOUNT,             -- SGST Amount [edc_in_sgst_amount]
    IGST_AMOUNT,             -- IGST Amount [edc_in_igst_amount]
    CESS_AMOUNT,             -- Cess Amount [edc_in_cess_amount]
    IS_PEND_ACT_BLOCKED,     -- edc_in_pend_act_blocked
    SOURCE_FORM_TYPE,        -- edc_in_source_type
    INVOICE_CHECKSUM,        -- edc_in_checksum
    TAXAUTH_SOURCE_TYPE,     -- edc_in_source_type_tax
    IS_ITC_REDUCN_RQD,       -- edc_in_itc_reducn_rqd_ind
    DECLD_ITC_IGST_AMOUNT,   -- edc_in_decld_igst_amount
    DECLD_ITC_SGST_AMOUNT,   -- edc_in_decld_sgst_amount
    DECLD_ITC_CGST_AMOUNT,   -- edc_in_decld_cgst_amount
    DECLD_ITC_CESS_AMOUNT,   -- edc_in_decld_cess_amount
    IS_ITC_REDUCN_RQD_BLKD,  -- edc_in_itc_reducn_rqd_blkd_ind
    IMS_STATUS,              -- edc_in_ims_status
    ACTION_REMARKS,          -- edc_in_action_remarks
    IS_REMARKS_BLKD,         -- edc_in_is_remarks_blkd
    PRIMARY KEY (MANDT, RECORD_GUID)
);