NJIT_PREASM_SEQ
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_JITOutbPreAssemblySeqBasic | view | from | EXTENSION | PreAssembly - Extension |
| I_JITOutbPreAssemblySeqBasic | view | from | BASIC | Basic pre assembly |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA