NJIT_PPE_ASM_SEQ

Transparent Table Application Table
24 Fields 2 CDS Views

JIT S2P - Assembly Sequence Table - iPPE factory layout

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JITOutbPPEAssemblySeqBasic view from EXTENSION PPE Assembly - Extension
I_JITOutbPPEAssemblySeqBasic view from BASIC PPE Assembly Sequence Basic

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY jitppesequence NJIT_S2P_PPE_SEQID Sequence ID
KEY jitassemblylinenetwork NJIT_S2P_PPE_ASM_LINE_NTWK Line Network
jitppesubsequence NJIT_S2P_PPE_ASM_SUBSQNC Sub Sequence
plant WERKS_D Plant
planned_order PLNUM Planned Order
vehicleidentificationnumber VLC_VHVIN VIN
jitassemblylinetype NJIT_S2P_ASM_SEQ_LINE_TYPE Line Type
jitassemblylinecategory NJIT_S2P_ASM_SEQ_LINE_CAT Line Category
jitassemblyline NJIT_S2P_PPE_ASM_LINE Line ID
jitassemblynextline NJIT_S2P_PPE_ASM_NEXTLINE Next Line
jittakt NJIT_S2P_ASM_SEQ_TAKT Takt ID
jitbufferindicator NJIT_S2P_ASM_SEQ_BUFFER Buffer Ind.
jitpreviousreportingpoint NJIT_S2P_PPE_PREV_REPORTINGPT Prev. Rptg. Pt.
jitnextreportingpoint NJIT_S2P_PPE_NEXT_REPORTINGPT Next Rptg. Pt.
jitassemblystatus NJIT_S2P_ASM_SEQ_STATUS Assy. Status
jitassemblylinesegment NJIT_S2P_PPE_ASM_LINE_SEG Line Seg
jitassemblylinebuffer NJIT_S2P_PPE_ASM_LINE_BUFF Buffer
jitseqsplitdirection NJIT_S2P_ASM_LINE_DIRECTION Split Direction
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
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 - 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_PPE_ASM_SEQ (
    MANDT,                          -- Client [MANDT]
    JITPPESEQUENCE,                 -- Sequence ID [NJIT_S2P_PPE_SEQID]
    JITASSEMBLYLINENETWORK,         -- Line Network [NJIT_S2P_PPE_ASM_LINE_NTWK]
    JITPPESUBSEQUENCE,              -- Sub Sequence [NJIT_S2P_PPE_ASM_SUBSQNC]
    PLANT,                          -- Plant [WERKS_D]
    PLANNED_ORDER,                  -- Planned Order [PLNUM]
    VEHICLEIDENTIFICATIONNUMBER,    -- VIN [VLC_VHVIN]
    JITASSEMBLYLINETYPE,            -- Line Type [NJIT_S2P_ASM_SEQ_LINE_TYPE]
    JITASSEMBLYLINECATEGORY,        -- Line Category [NJIT_S2P_ASM_SEQ_LINE_CAT]
    JITASSEMBLYLINE,                -- Line ID [NJIT_S2P_PPE_ASM_LINE]
    JITASSEMBLYNEXTLINE,            -- Next Line [NJIT_S2P_PPE_ASM_NEXTLINE]
    JITTAKT,                        -- Takt ID [NJIT_S2P_ASM_SEQ_TAKT]
    JITBUFFERINDICATOR,             -- Buffer Ind. [NJIT_S2P_ASM_SEQ_BUFFER]
    JITPREVIOUSREPORTINGPOINT,      -- Prev. Rptg. Pt. [NJIT_S2P_PPE_PREV_REPORTINGPT]
    JITNEXTREPORTINGPOINT,          -- Next Rptg. Pt. [NJIT_S2P_PPE_NEXT_REPORTINGPT]
    JITASSEMBLYSTATUS,              -- Assy. Status [NJIT_S2P_ASM_SEQ_STATUS]
    JITASSEMBLYLINESEGMENT,         -- Line Seg [NJIT_S2P_PPE_ASM_LINE_SEG]
    JITASSEMBLYLINEBUFFER,          -- Buffer [NJIT_S2P_PPE_ASM_LINE_BUFF]
    JITSEQSPLITDIRECTION,           -- Split Direction [NJIT_S2P_ASM_LINE_DIRECTION]
    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]
    DUMMY_FLD_NJIT_PPE_ASM_SEQ,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, JITPPESEQUENCE, JITASSEMBLYLINENETWORK)
);

Learn More