SAP ABAP Table /ISDFPS/MATSPPLN_EXT (Structure /isdfps/matsppln Extended by Short Texts)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-OF (Application Component) Organizational Flexibility
     ⤷ /ISDFPS/OM (Package) Organizational Management Functions

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/MATSPPLN_EXT	Table Relationship Diagram
Short Description	Structure /isdfps/matsppln Extended by Short Texts

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	470