NJIT_REM_ASM_SEQ
JIT S2P - REM planned orders assembly sequence table
NJIT_REM_ASM_SEQ is an SAP database table in S/4HANA. JIT S2P - REM planned orders assembly sequence table. It contains 30 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_JITOutbRtgAssemblySeqBasic | view | from | EXTENSION | Routing Assembly - Extension |
| I_JITOutbRtgAssemblySeqBasic | view | from | BASIC | Complex Component Assembly Sequence |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | jitremsequence | njit_s2p_seqid | Sequence ID | |||
| KEY | groupnumber | plnnr | Group | |||
| KEY | plnty | plnty | Task List Type | |||
| KEY | plnal | plnal | Group Counter | |||
| plnkn | plnkn | Node | ||||
| zaehl | cim_count | Counter | ||||
| plant | werks_d | Plant | ||||
| planned_order | plnum | Planned Order | ||||
| material | matnr | Material | ||||
| jitassemblylinetype | njit_s2p_asm_seq_line_type | Line Type | ||||
| jitassemblylinecategory | njit_s2p_asm_seq_line_cat | Line Category | ||||
| jittakt | njit_s2p_asm_seq_takt | Takt ID | ||||
| jittaktoperationnumber | njit_s2p_rem_operation_number | Operation Number | ||||
| jitbufferindicator | njit_s2p_asm_seq_buffer | Buffer Ind. | ||||
| jitpreviousreportingpoint | njit_s2p_rem_prev_reportingpt | Prev. Rptg. Pt. | ||||
| jitnextreportingpoint | njit_s2p_rem_next_reportingpt | Next Rptg. Pt. | ||||
| jitassemblystatus | njit_s2p_asm_seq_status | Assy. Status | ||||
| jitproductionid | njit_production_id | Production ID | ||||
| confirmedquantity | erfmg | Quantity in UnE | ||||
| unitofmeasure | meins | Base Unit | ||||
| vplty | vplnty | Ref TList type | ||||
| vplnr | vplnnr | Ref. group | ||||
| vplal | vplnal | Ref. group cntr | ||||
| vplnkn | vplnkn | Nodes | ||||
| vzaehl | cim_count | Counter | ||||
| 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 |
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 - REM planned orders assembly sequence table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NJIT_REM_ASM_SEQ (
MANDT, -- Client [mandt]
JITREMSEQUENCE, -- Sequence ID [njit_s2p_seqid]
GROUPNUMBER, -- Group [plnnr]
PLNTY, -- Task List Type [plnty]
PLNAL, -- Group Counter [plnal]
PLNKN, -- Node [plnkn]
ZAEHL, -- Counter [cim_count]
PLANT, -- Plant [werks_d]
PLANNED_ORDER, -- Planned Order [plnum]
MATERIAL, -- Material [matnr]
JITASSEMBLYLINETYPE, -- Line Type [njit_s2p_asm_seq_line_type]
JITASSEMBLYLINECATEGORY, -- Line Category [njit_s2p_asm_seq_line_cat]
JITTAKT, -- Takt ID [njit_s2p_asm_seq_takt]
JITTAKTOPERATIONNUMBER, -- Operation Number [njit_s2p_rem_operation_number]
JITBUFFERINDICATOR, -- Buffer Ind. [njit_s2p_asm_seq_buffer]
JITPREVIOUSREPORTINGPOINT, -- Prev. Rptg. Pt. [njit_s2p_rem_prev_reportingpt]
JITNEXTREPORTINGPOINT, -- Next Rptg. Pt. [njit_s2p_rem_next_reportingpt]
JITASSEMBLYSTATUS, -- Assy. Status [njit_s2p_asm_seq_status]
JITPRODUCTIONID, -- Production ID [njit_production_id]
CONFIRMEDQUANTITY, -- Quantity in UnE [erfmg]
UNITOFMEASURE, -- Base Unit [meins]
VPLTY, -- Ref TList type [vplnty]
VPLNR, -- Ref. group [vplnnr]
VPLAL, -- Ref. group cntr [vplnal]
VPLNKN, -- Nodes [vplnkn]
VZAEHL, -- Counter [cim_count]
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]
PRIMARY KEY (MANDT, JITREMSEQUENCE, GROUPNUMBER, PLNTY, PLNAL)
);
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