SAP ABAP Table S021 (SFIS: Order Item Data for Material)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S021	Table Relationship Diagram
Short Description	SFIS: Order Item Data for Material

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	*
11	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
15	DFZEH	☐	DFZEH	EINHEIT	UNIT	3	0	Unit of measure for execution time
16	KEINH	☐	CY_KEINH	MEINS	UNIT	3	0	Unit of of measure for displaying capacity requirements	T006
17	ERDAT	☐	AUFERFDAT	DATUM	DATS	8	0	Created on
18	FTRMP	☐	CO_FTRMP	DATUM	DATS	8	0	Planned release date
19	FTRMS	☐	CO_FTRMS	DATUM	DATS	8	0	Scheduled release date
20	FTRMI	☐	CO_FTRMI	DATUM	DATS	8	0	Actual release date
21	GSTRP	☐	CO_GSTRP	DATUM	DATS	8	0	Basic start date
22	GSTRS	☐	CO_GSTRS	DATUM	DATS	8	0	Scheduled start
23	GSTRI	☐	CO_GSTRI	DATUM	DATS	8	0	Actual start date
24	GLTRP	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
25	GLTRS	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
26	GLTRI	☐	CO_GLTRI	DATUM	DATS	8	0	Actual finish date
27	PGMNG	☐	GSMNG	MENG13	QUAN	13	3	Total planned order quantity
28	PSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
29	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
30	PAMNG	☐	AVMNG	MENG13	QUAN	13	3	Fixed quantity of scrap from production
31	PSAMG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
32	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
33	S_DFZ	☐	S_DFZ	DAUER_6_1V	QUAN	7	1	Target execution time
34	I_DFZ	☐	I_DFZ	DAUER_6_1V	QUAN	7	1	Actual execution time
35	KSUMS	☐	MC_KSUMS	DAUER_6_1V	QUAN	7	1	Total target capacity requirements

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S021	KEINH	T006	MSEHI	KEY	1	CN
2	S021	MANDT	T000	MANDT	KEY	1	CN
3	S021	MATNR	MARA	MATNR	KEY	1	CN
4	S021	PERIV	T009	PERIV	REF	C	CN
5	S021	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in