NJIT_CALL_D_CMAT

Transparent Table Application Table

Just-In-Time Request: Components - #GENERATED#

NJIT_CALL_D_CMAT is an SAP database table in S/4HANA. Just-In-Time Request: Components - #GENERATED#. It contains 34 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
E_JITCompMatl view from EXTENSION Extension view for component material
E_JITInbCallComponent view_entity from EXTENSION JIT Inbound Call Component - Extension
E_JITOutbCallComponent view_entity from EXTENSION Component material - Extension
E_JITOutbCallStockTransfer view from EXTENSION Extensibility view for Stock Transfer
I_JITCallCompMaterialBasic view_entity from BASIC JIT Call Components
I_JITInbCallCompMatlBySemKey view_entity from BASIC Inbound Just In Time Call Component Material by Semantic Key
I_JITInbCallComponent view_entity from BASIC JIT Inbound Call Component
I_JITOutbCallCompMatl view from BASIC JIT Call Components Outbound
I_JITOutbCallCompMatlData view from BASIC Basic view for JIT Call Component Matl
I_JITOutbCallComponent view_entity from BASIC JIT Outbound Call Component

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
int_call_num NJIT_INT_CALL_NUM JIT Call Number
comp_grp_num NJIT_COMP_GRP_NUM Component Group No.
call_item_num NJIT_CALL_ITEM_NUM Call Item Number
matnr MATNR Material
kdmat KDMAT Customer Mat.
ext_call_item_num NJIT_EXT_CALL_ITEM_NUM Extl Call Item No.
vbeln VBELN_VA Sales Document
posnr POSNR_VA Item
spart SPART Division
requested_quantity NJIT_REQ_QUAN Requested Quantity
delivered_quantity NJIT_DELIV_QUAN Delivered Quantity
meins MEINS Base Unit
missing_parts NJIT_MISSING_PARTS Missing Part
referencecmatuuid NJIT_REFERENCECMATUUID Ref Comp Mat UUID
_dataaging DATA_TEMPERATURE Data Aging
dummy_njit_compmat_incl_eew_ps NJIT_CALL_INCL_EEW Extensibility
transferred_quantity NJIT_TRNSFR_QTY Transferred Qty
minimum_quantity NJIT_MIN_QTY Minimum Qty
picked_quantity NJIT_PICKED_QTY Picked Quantity
open_quantity NJIT_OPEN_QTY Open Qty
dummy_s2p_cmat_incl_eew_ps CFD_DUMMY Dummy
stk_trnsfr_stat NJIT_STK_TRNSFR_STAT Stock Trnsfr Status
int_stat NJIT_INT_STAT Intl Proc. Status
int_stat_updated_on NJIT_INT_STAT_UPDATED_ON Int Status Updtd On
pick_stat NJIT_PICKING_STATUS Picking Status
deliv_stat NJIT_DELIVERY_STATUS Delivery Status
jitcallcompmatlbackflushtype NJIT_BFLUSH_TYPE BackFlush Type
jitcallcompmatlbackflushstatus NJIT_BFLUSH_STATUS BackFlush Status
variancereasoncode CO_AGRND Reason
jitcallcompbackflushstsupdtdon NJIT_BFLUSH_STATUS_UPDATED_ON BFlsh Status Updt On

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.

-- Just-In-Time Request: Components - #GENERATED#
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NJIT_CALL_D_CMAT (
    MANDT,                           -- Client [MANDT]
    DB_KEY,                          -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,                        -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,                      -- NodeID [/BOBF/CONF_KEY]
    INT_CALL_NUM,                    -- JIT Call Number [NJIT_INT_CALL_NUM]
    COMP_GRP_NUM,                    -- Component Group No. [NJIT_COMP_GRP_NUM]
    CALL_ITEM_NUM,                   -- Call Item Number [NJIT_CALL_ITEM_NUM]
    MATNR,                           -- Material [MATNR]
    KDMAT,                           -- Customer Mat. [KDMAT]
    EXT_CALL_ITEM_NUM,               -- Extl Call Item No. [NJIT_EXT_CALL_ITEM_NUM]
    VBELN,                           -- Sales Document [VBELN_VA]
    POSNR,                           -- Item [POSNR_VA]
    SPART,                           -- Division [SPART]
    REQUESTED_QUANTITY,              -- Requested Quantity [NJIT_REQ_QUAN]
    DELIVERED_QUANTITY,              -- Delivered Quantity [NJIT_DELIV_QUAN]
    MEINS,                           -- Base Unit [MEINS]
    MISSING_PARTS,                   -- Missing Part [NJIT_MISSING_PARTS]
    REFERENCECMATUUID,               -- Ref Comp Mat UUID [NJIT_REFERENCECMATUUID]
    _DATAAGING,                      -- Data Aging [DATA_TEMPERATURE]
    DUMMY_NJIT_COMPMAT_INCL_EEW_PS,  -- Extensibility [NJIT_CALL_INCL_EEW]
    TRANSFERRED_QUANTITY,            -- Transferred Qty [NJIT_TRNSFR_QTY]
    MINIMUM_QUANTITY,                -- Minimum Qty [NJIT_MIN_QTY]
    PICKED_QUANTITY,                 -- Picked Quantity [NJIT_PICKED_QTY]
    OPEN_QUANTITY,                   -- Open Qty [NJIT_OPEN_QTY]
    DUMMY_S2P_CMAT_INCL_EEW_PS,      -- Dummy [CFD_DUMMY]
    STK_TRNSFR_STAT,                 -- Stock Trnsfr Status [NJIT_STK_TRNSFR_STAT]
    INT_STAT,                        -- Intl Proc. Status [NJIT_INT_STAT]
    INT_STAT_UPDATED_ON,             -- Int Status Updtd On [NJIT_INT_STAT_UPDATED_ON]
    PICK_STAT,                       -- Picking Status [NJIT_PICKING_STATUS]
    DELIV_STAT,                      -- Delivery Status [NJIT_DELIVERY_STATUS]
    JITCALLCOMPMATLBACKFLUSHTYPE,    -- BackFlush Type [NJIT_BFLUSH_TYPE]
    JITCALLCOMPMATLBACKFLUSHSTATUS,  -- BackFlush Status [NJIT_BFLUSH_STATUS]
    VARIANCEREASONCODE,              -- Reason [CO_AGRND]
    JITCALLCOMPBACKFLUSHSTSUPDTDON,  -- BFlsh Status Updt On [NJIT_BFLUSH_STATUS_UPDATED_ON]
    PRIMARY KEY (MANDT, DB_KEY)
);