SAP ABAP Table SPJINF (Sequencing: transfer structure for order information)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-FLW-SEQ (Application Component) Sequencing
     ⤷ LASP (Package) Application Development R/3 Logistics Automotive Sequencing

Basic Data

Table Category	INTTAB	Structure
Structure	SPJINF	Table Relationship Diagram
Short Description	Sequencing: transfer structure for order information

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
2	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
3	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
4	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
5	PSTTR	☐	PSTTR	DATUM	DATS	8	0	Order start date in planned order
6	TERST	☐	TERST	DATUM	DATS	8	0	Start date for production
7	PSTTI	☐	PSTTI	UZEIT	TIMS	6	0	Start Time of Planned Order
8	PEDTR	☐	PEDTR	DATUM	DATS	8	0	Order finish date in the planned order
9	TERED	☐	TERED	DATUM	DATS	8	0	Finish date for production
10	PEDTI	☐	PEDTI	UZEIT	TIMS	6	0	End Time of Planned Order
11	TRMKZ	☐	TRMFL	XFELD	CHAR	1	0	Scheduling indicator
12	GSBTR	☐	SPJBTER	SP_JBTER	CHAR	10	0	Confirmation date with text
13	SEQNR	☐	CY_SEQNR	CY_SEQNR	NUMC	14	0	Seq. number order
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
15	GSMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
16	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	PLWRK	☐	PLWRK	WERKS	CHAR	4	0	Planning Plant	*
18	PAART	☐	PAART	PAART	CHAR	4	0	Order type
19	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
20	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
21	PERTR	☐	PERTR	DATUM	DATS	8	0	Planned opening date in planned order
22	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
23	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
24	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
25	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
26	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
27	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
28	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
29	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
30	PKUNM	☐	PKNUM	PKNUM	CHAR	7	0	Control cycle number	*
31	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
32	PKKEY	☐	PKKEY	PKKEY	NUMC	10	0	Identification Number	*
33	PKBST	☐	PKBST	PKBST	CHAR	1	0	Kanban status
34	SAEDT	☐	SAEDT	DATUM	DATS	8	0	Date of last change
35	SAEUZ	☐	SAEUZ	UZEIT	TIMS	6	0	Time of the last status change

History

Last changed by/on	SAP	20110901
SAP Release Created in