J_3RS_IMNT_HDR

Transparent Table Application Table
15 Fields 1 CDS Views

Import Notification Header

J_3RS_IMNT_HDR is an SAP database table in S/4HANA. Import Notification Header. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_ImportNotifHeaderBasic view from BASIC Basic Interface view for Import Notification Header

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY import_notification J_3RS_IMNT_INT_NUM Imp Notif Int Number
external_number J_3RS_IMNT_EXT_NUM Imp Notif Ext Number
registration_date J_3RS_IMNT_REG_DATE Registration Date
confirmation_date J_3RS_IMNT_EXP_CONF_DATE Export Confirm Date
company_code BUKRS Company Code
buyer KUNNR Customer
consignee KUNNR Customer
seller_data_section J_3RS_SELLER_DATA_SECTION Seller Data Section
contract_number J_3RF_INTCNTNUM Int. Contract Number
dummy J_3RS_IMNT_DUMMY Dummy ImpNotificatn
created_by USNAM User Name
changed_by USNAM User Name
created_at TIMESTAMP Time Stamp
changed_at TIMESTAMP Time Stamp

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.

-- Import Notification Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RS_IMNT_HDR (
    MANDT,                -- Client [MANDT]
    IMPORT_NOTIFICATION,  -- Imp Notif Int Number [J_3RS_IMNT_INT_NUM]
    EXTERNAL_NUMBER,      -- Imp Notif Ext Number [J_3RS_IMNT_EXT_NUM]
    REGISTRATION_DATE,    -- Registration Date [J_3RS_IMNT_REG_DATE]
    CONFIRMATION_DATE,    -- Export Confirm Date [J_3RS_IMNT_EXP_CONF_DATE]
    COMPANY_CODE,         -- Company Code [BUKRS]
    BUYER,                -- Customer [KUNNR]
    CONSIGNEE,            -- Customer [KUNNR]
    SELLER_DATA_SECTION,  -- Seller Data Section [J_3RS_SELLER_DATA_SECTION]
    CONTRACT_NUMBER,      -- Int. Contract Number [J_3RF_INTCNTNUM]
    DUMMY,                -- Dummy ImpNotificatn [J_3RS_IMNT_DUMMY]
    CREATED_BY,           -- User Name [USNAM]
    CHANGED_BY,           -- User Name [USNAM]
    CREATED_AT,           -- Time Stamp [TIMESTAMP]
    CHANGED_AT,           -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, IMPORT_NOTIFICATION)
);

Learn More