SAP ABAP Table /ISDFPS/MATSPPLN (Materials Planned for Force Element)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-OF-FDP (Application Component) Structures Workbench
     ⤷ /ISDFPS/FDP (Package) Armed Forces and Deployment Planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/ISDFPS/MATSPPLN	Table Relationship Diagram
Short Description	Materials Planned for Force Element

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PLANNING_GUID	☑	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
3	RECTYPE	☐	/ISDFPS/FDPMAT_RECTYPE	/ISDFPS/FDPMAT_RECTYPE	CHAR	3	0	Record Type Planning
4	FORCE_REC_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
5	FORCE_REC_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
6	PLANT_REC	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
7	STORAGE_LOC_REC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
8	HU_LOC_REC	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
9	FORCE_PROV_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
10	FORCE_PROV_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
11	PLANT_PROV	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	STORAGE_LOC_PROV	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
13	HU_LOC_PROV	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
16	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
17	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
18	HU_EXID	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
19	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
20	PACK_MAT	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	*
21	QUPLN	☐	/ISDFPS/QUPLN	MENG13V	QUAN	13	3	Planned Quantity
22	DELIVERY_DATE	☐	/ISDFPS/DEL_DATE		DATS	8	0	Delivery Date
23	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
24	COMNT	☐	/ISDFPS/COMNT	TEXT40	CHAR	40	0	Planning Comment
25	REF_GUID	☐	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
26	REF_TYPE	☐	/ISDFPS/MATPLN_REFTYPE	/ISDFPS/MATPLN_REF	CHAR	2	0	Type of Reference Relationship
27	REF_GUID2	☐	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
28	REF_TYPE2	☐	/ISDFPS/MATPLN_REFTYPE	/ISDFPS/MATPLN_REF	CHAR	2	0	Type of Reference Relationship
29	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
30	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
31	FLAG_LOAN	☐	/ISDFPS/FLAG_LOAN	XFLAG	CHAR	1	0	Loan
32	RETURN_DATE	☐	/ISDFPS/RETURN_DATE	DATS	DATS	8	0	Return Date for Loan
33	FLAG_LOAN_RET	☐	/ISDFPS/FLAG_LOAN_RETURN	XFLAG	CHAR	1	0	Loan Return
34	RECORD_INVISIBLE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
35	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	*
36	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	*
37	.INCLUDE	☐				0	0	Material Planning Append for Provisions
38	PNGUID	☐	PVS_GUID	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
39	FORCEM_CNT	☐	/ISDFPS/FORCEM_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
40	DGUID	☐	/ISDFPS/DGUID	SYSUUID_C	CHAR	32	0	Identifier of Relationships for Distribution
41	FLAG_EV	☐	/ISDFPS/REL_FLAG_EV	XFELD	CHAR	1	0	Relocation: Initial Supply
42	FORCE_ASGN_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
43	FORCE_ASGN_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
44	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
45	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
46	DAT_SP	☐	/ISDFPS/DAT_SP	DATUM	DATS	8	0	Collectn Pt Date
47	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
48	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	*
49	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
50	APPLOBJ_TYPE	☐	PVS_APPLOBJ_TYPE	PVS_APPLOBJ_TYPE	CHAR	4	0	Application Object Type for iPPE
51	FBSTA	☐	/ISDFPS/FBSTA	/ISDFPS/FBSTA	CHAR	1	0	Relocation: Follow-On Document Status
52	PNAME	☐	PVS_PNODE	PVS_PNODE	CHAR	40	0	iPPE Node Description
53	FLAG_PROV	☐	/ISDFPS/FLAG_PROV		CHAR	1	0	Provisions
54	LOCATION_S_GUID	☐	/ISDFPS/LOCATION_ID	SYSUUID_C	CHAR	32	0	ISDFPS: Location ID (GUID)
55	LOCATION_D_GUID	☐	/ISDFPS/LOCATION_ID	SYSUUID_C	CHAR	32	0	ISDFPS: Location ID (GUID)
56	CREATED_ON	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
57	CREATED_BY	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
58	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
59	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
60	FLAG_HISTORY	☐	/ISDFPS/FLAG_HISTORY	XFELD	CHAR	1	0	Record Is Historical
61	FLAG_MAINTENANCE	☐	/ISDFPS/FLAG_MAINTENANCE	XFLAG	CHAR	1	0	Relevant to Plant Maintenance
62	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
63	FLAG_COMPLETED	☐	/ISDFPS/FLAG_PREQ_COMPLETED	XFLAG	CHAR	1	0	Completely Processed
64	FLAG_FORWARDED	☐	/ISDFPS/FLAG_PREQ_FORWARDED	XFLAG	CHAR	1	0	PReq Was Forwarded
65	FLAG_DERIVED	☐	/ISDFPS/FLAG_PREQ_DERIVED	XFLAG	CHAR	1	0	PReq Is Derived (Forwarding)
66	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
67	FLAG_WB	☐	/ISDFPS/FLAG_WORKBENCH	XFLAG	CHAR	1	0	Planned Record Created in Workbench
68	FLAG_SUBITEM	☐	/ISDFPS/FLAG_SUBITEM	XFLAG	CHAR	1	0	Subitem
69	FLAG_RETURN	☐	/ISDFPS/FLAG_RETURN	XFLAG	CHAR	1	0	Return Delivery
70	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
71	FLAG_RES_FWD	☐	/ISDFPS/FLAG_RES_FWD	XFLAG	CHAR	1	0	Forwarded Reservation
72	SERNR_PREQ	☐	/ISDFPS/SERNR_PREQ	GERNR	CHAR	18	0	Serial Number
73	FLAG_SERNR_PREQ	☐	/ISDFPS/FLAG_SERNR_PREQ	XFLAG	CHAR	1	0	Serial Number PReq
74	RELSEQ_TYPE	☐	/ISDFPS/RELSEQ_TYPE	/ISDFPS/RELSEQ_TYPE	CHAR	1	0	Relocation Step Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/MATSPPLN	CLIENT	T000	MANDT	KEY	1	CN
2	/ISDFPS/MATSPPLN	MATNR	MARA	MATNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C0