J_3RS_IMNT_HDR

Transparent Table Application Table
11 Fields 1 CDS Views

Import Notification Header

J_3RS_IMNT_HDR is an SAP database table in S/4HANA. Import Notification Header. It contains 11 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 (11)

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

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]
    PRIMARY KEY (MANDT, IMPORT_NOTIFICATION)
);

Learn More