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,           -- GSTR Doc Sec [EDC_IN_DOC_SECTION_R2]
    CP_GSTIN,              -- Counterparty 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 or 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 Generation 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,          -- Is2BPulled [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,   -- Pending Action Block [EDC_IN_PEND_ACT_BLOCKED]
    SOURCE_FORM_TYPE,      -- Source Form Type [EDC_IN_SOURCE_TYPE]
    INVOICE_CHECKSUM,      -- Checksum of Invoice [EDC_IN_CHECKSUM]
    TAXAUTH_SOURCE_TYPE,   -- TA Source Type [EDC_IN_SOURCE_TYPE_TAX]
    PRIMARY KEY (MANDT, RECORD_GUID)
);