J_3RS_IMNT_ITEM

Transparent Table Application Table
13 Fields 1 CDS Views

Import Notification Items

J_3RS_IMNT_ITEM is an SAP database table in S/4HANA. Import Notification Items. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_ImportNotifItmBasic view from BASIC Basic Interface view for Import Notification Item

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY import_notification j_3rs_imnt_int_num Imp Notif Int Number
KEY import_notification_item j_3rs_imnt_posnr Import Notif Item
billing_document vbeln_vf Billing Doc.
billing_document_item posnr_vf Item
delivery_document vbeln_vl Delivery
delivery_document_item posnr_vl Item
issue_date j_3rs_imnt_issue_date Goods Issue Date
material matnr Material
unit_of_measure meins Base Unit
quantity j_3rs_imnt_quant Imprt Notif Item Qty
import_notification_ref j_3rs_imnt_int_num_ref Import Notif. Ref.
import_notification_item_ref j_3rs_imnt_posnr_ref ImportNotif Item Ref

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 Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RS_IMNT_ITEM (
    MANDT,                         -- Client [mandt]
    IMPORT_NOTIFICATION,           -- Imp Notif Int Number [j_3rs_imnt_int_num]
    IMPORT_NOTIFICATION_ITEM,      -- Import Notif Item [j_3rs_imnt_posnr]
    BILLING_DOCUMENT,              -- Billing Doc. [vbeln_vf]
    BILLING_DOCUMENT_ITEM,         -- Item [posnr_vf]
    DELIVERY_DOCUMENT,             -- Delivery [vbeln_vl]
    DELIVERY_DOCUMENT_ITEM,        -- Item [posnr_vl]
    ISSUE_DATE,                    -- Goods Issue Date [j_3rs_imnt_issue_date]
    MATERIAL,                      -- Material [matnr]
    UNIT_OF_MEASURE,               -- Base Unit [meins]
    QUANTITY,                      -- Imprt Notif Item Qty [j_3rs_imnt_quant]
    IMPORT_NOTIFICATION_REF,       -- Import Notif. Ref. [j_3rs_imnt_int_num_ref]
    IMPORT_NOTIFICATION_ITEM_REF,  -- ImportNotif Item Ref [j_3rs_imnt_posnr_ref]
    PRIMARY KEY (MANDT, IMPORT_NOTIFICATION, IMPORT_NOTIFICATION_ITEM)
);

Learn More