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 19 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 (19)

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
dummy_fld_njit_ppe_asm_seq CFD_DUMMY Dummy

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]
    DUMMY_FLD_NJIT_PPE_ASM_SEQ,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, JITPREASSEMBLYSEQ, JITASSEMBLYLINENETWORK, JITASSEMBLYLINE)
);