J_1IG_INVREFNUM

Transparent Table Application Table
19 Fields 1 CDS Views

GST India: Link IRN details to Document

J_1IG_INVREFNUM is an SAP database table in S/4HANA. GST India: Link IRN details to Document. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IN_InvcRefNmbrDet view from BASIC Invoice Reference Number for GST India

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY docno j_1ig_docno Document No
KEY doc_year j_1ig_doc_year Document Fiscal Year
KEY doc_type j_1ig_doctyp Document Type
KEY odn j_1ig_odn Official Document No
KEY irn j_1ig_irn Invoice Ref. Number
KEY version j_1ig_version Version
bupla bupla Business place
odn_date j_1ig_odn_date ODN Date
ack_no j_1ig_ack_no Acknowledgement No
ack_date j_1ig_ack_date Acknowledgement Date
irn_status j_1ig_irn_status IRN Status
cancel_date j_1ig_canc_date Cancelled Date
ernam ernam Created By
erdat erdat Created On
erzet erzet Time
signed_inv j_1ig_sign_inv Signed Invoice
signed_qrcode j_1ig_sign_qrcode Signed QR Code

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 India: Link IRN details to Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1IG_INVREFNUM (
    MANDT,          -- Client [mandt]
    BUKRS,          -- Company Code [bukrs]
    DOCNO,          -- Document No [j_1ig_docno]
    DOC_YEAR,       -- Document Fiscal Year [j_1ig_doc_year]
    DOC_TYPE,       -- Document Type [j_1ig_doctyp]
    ODN,            -- Official Document No [j_1ig_odn]
    IRN,            -- Invoice Ref. Number [j_1ig_irn]
    VERSION,        -- Version [j_1ig_version]
    BUPLA,          -- Business place [bupla]
    ODN_DATE,       -- ODN Date [j_1ig_odn_date]
    ACK_NO,         -- Acknowledgement No [j_1ig_ack_no]
    ACK_DATE,       -- Acknowledgement Date [j_1ig_ack_date]
    IRN_STATUS,     -- IRN Status [j_1ig_irn_status]
    CANCEL_DATE,    -- Cancelled Date [j_1ig_canc_date]
    ERNAM,          -- Created By [ernam]
    ERDAT,          -- Created On [erdat]
    ERZET,          -- Time [erzet]
    SIGNED_INV,     -- Signed Invoice [j_1ig_sign_inv]
    SIGNED_QRCODE,  -- Signed QR Code [j_1ig_sign_qrcode]
    PRIMARY KEY (MANDT, BUKRS, DOCNO, DOC_YEAR, DOC_TYPE, ODN, IRN, VERSION)
);

Learn More