NJIT_PREASM_SEQ

Transparent Table Application Table

JIT S2P - Pre-Assembly Sequence Table - iPPE factory layout

NJIT_PREASM_SEQ is an SAP database table in S/4HANA. JIT S2P - Pre-Assembly Sequence Table - iPPE factory layout. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JITOutbPreAssemblySeqBasic view from EXTENSION PreAssembly - Extension
I_JITOutbPreAssemblySeqBasic view from BASIC Basic pre assembly

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY jitpreassemblyseq njit_s2p_ppe_seqid Sequence ID
KEY jitassemblylinenetwork njit_s2p_ppe_asm_line_ntwk Line Network
KEY jitassemblyline njit_s2p_ppe_asm_line Line ID
jitppesequence njit_s2p_ppe_seqid Sequence ID
planned_order plnum Planned Order
jitassemblynextline njit_s2p_ppe_asm_nextline Next Line
jittakt njit_s2p_asm_seq_takt Takt ID
jitpreviousreportingpoint njit_s2p_ppe_prev_reportingpt Prev. Rptg. Pt.
jitnextreportingpoint njit_s2p_ppe_next_reportingpt Next Rptg. Pt.
jitpreassemblystatus njit_s2p_pre_asm_status Pre Assembly Status
jitbufferindicator njit_s2p_asm_seq_buffer Buffer Ind.
jitasmreppointseqdatetime njit_s2p_asm_rep_seqdtetme Rep. DateTime
jitassemblyconfdatetime njit_s2p_asm_seq_confdtetme Conf. DateTime
jitsequencecreationdatetime njit_s2p_asm_seq_crtn_dtetme Crtn. DateTime
jitsequencelastchangedatetime njit_s2p_asm_seqlst_chg_dtetme Chd. DateTime
jitassemblylinesegment njit_s2p_ppe_asm_line_seg Line Seg
jitassemblylinebuffer njit_s2p_ppe_asm_line_buff Buffer

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.

-- JIT S2P - Pre-Assembly Sequence Table - iPPE factory layout
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NJIT_PREASM_SEQ (
    MANDT,                          -- Client [mandt]
    JITPREASSEMBLYSEQ,              -- Sequence ID [njit_s2p_ppe_seqid]
    JITASSEMBLYLINENETWORK,         -- Line Network [njit_s2p_ppe_asm_line_ntwk]
    JITASSEMBLYLINE,                -- Line ID [njit_s2p_ppe_asm_line]
    JITPPESEQUENCE,                 -- Sequence ID [njit_s2p_ppe_seqid]
    PLANNED_ORDER,                  -- Planned Order [plnum]
    JITASSEMBLYNEXTLINE,            -- Next Line [njit_s2p_ppe_asm_nextline]
    JITTAKT,                        -- Takt ID [njit_s2p_asm_seq_takt]
    JITPREVIOUSREPORTINGPOINT,      -- Prev. Rptg. Pt. [njit_s2p_ppe_prev_reportingpt]
    JITNEXTREPORTINGPOINT,          -- Next Rptg. Pt. [njit_s2p_ppe_next_reportingpt]
    JITPREASSEMBLYSTATUS,           -- Pre Assembly Status [njit_s2p_pre_asm_status]
    JITBUFFERINDICATOR,             -- Buffer Ind. [njit_s2p_asm_seq_buffer]
    JITASMREPPOINTSEQDATETIME,      -- Rep. DateTime [njit_s2p_asm_rep_seqdtetme]
    JITASSEMBLYCONFDATETIME,        -- Conf. DateTime [njit_s2p_asm_seq_confdtetme]
    JITSEQUENCECREATIONDATETIME,    -- Crtn. DateTime [njit_s2p_asm_seq_crtn_dtetme]
    JITSEQUENCELASTCHANGEDATETIME,  -- Chd. DateTime [njit_s2p_asm_seqlst_chg_dtetme]
    JITASSEMBLYLINESEGMENT,         -- Line Seg [njit_s2p_ppe_asm_line_seg]
    JITASSEMBLYLINEBUFFER,          -- Buffer [njit_s2p_ppe_asm_line_buff]
    PRIMARY KEY (MANDT, JITPREASSEMBLYSEQ, JITASSEMBLYLINENETWORK, JITASSEMBLYLINE)
);