SAP ABAP Table /ISDFPS/FDPDASLD_INP_0110 (Plan Materials (at Material Level))

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	INTTAB	Structure
Structure	/ISDFPS/FDPDASLD_INP_0110	Table Relationship Diagram
Short Description	Plan Materials (at Material Level)

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	FORCE_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
2	FORCE_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
3	FORCENAME	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
4	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
5	PLANT_TEXT	☐	NAME1	TEXT30	CHAR	30	0	Name
6	STORAGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
7	STOR_LOC_T	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
8	HU_LOC	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	T001L
9	FORCE_PROV_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
10	FORCE_PROV_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
11	FORCE_PROV_NAME	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
12	PLANT_PROV	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	PLANT_PROV_TEXT	☐	NAME1	TEXT30	CHAR	30	0	Name
14	STORAGE_LOC_PROV	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
15	STOR_LOC_PROV_T	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
16	HU_LOC_PROV	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
17	PNAME	☐	PVS_PNODE	PVS_PNODE	CHAR	40	0	iPPE Node Description
18	PNTEXT	☐	PVS_PNODETX	TEXT60	CHAR	60	0	Short Text for iPPE Node
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
20	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
21	BATCH_TEXT	☐	KZTXT_BATCH	TEXT40	CHAR	40	0	Short text for batch
22	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
23	PSPNR_TEXT	☐	/ISDFPS/TEXT40	ALLTEXT	CHAR	40	0	Text
24	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
25	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
26	PACK_MAT	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	*
27	HU_EXID	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
28	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
29	DELIVERY_DATE	☐	/ISDFPS/DEL_DATE		DATS	8	0	Delivery Date
30	QUPLN	☐	/ISDFPS/QUPLN	MENG13V	QUAN	13	3	Planned Quantity
31	QBLOCK	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
32	QTRANS	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
33	QQUAL	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
34	COMNT	☐	/ISDFPS/COMNT	TEXT40	CHAR	40	0	Planning Comment
35	VALID_FROM	☐	/ISDFPS/BEGDAT	DATS	DATS	8	0	Valid from
36	VALID_TO	☐	/ISDFPS/ENDDAT	DATS	DATS	8	0	Valid to
37	MATPLN_CNT	☐	/ISDFPS/MATPLN_CNT		NUMC	8	0	Internal (Version) Counter for Material Plans
38	PROV_LEVEL	☐	TDEPTH	DEC5	DEC	5	0	Technical Depth of Structure
39	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
40	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
41	FLAG_LOAN	☐	/ISDFPS/FLAG_LOAN	XFLAG	CHAR	1	0	Loan
42	RETURN_DATE	☐	/ISDFPS/DEL_DATE		DATS	8	0	Delivery Date
43	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
44	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	/ISDFPS/ADVCODE2
45	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	/ISDFPS/CSTACODE
46	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
47	FLAG_LOAN_RET	☐	/ISDFPS/FLAG_LOAN_RETURN	XFLAG	CHAR	1	0	Loan Return
48	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	/ISDFPS/REL
49	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	/ISDFPS/RELSEQ
50	FLAG_TEMPLATE	☐	/ISDFPS/FLAG_TEMPLATE	XFLAG	CHAR	1	0	Template Row
51	RELSEQ_TYPE	☐	/ISDFPS/RELSEQ_TYPE	/ISDFPS/RELSEQ_TYPE	CHAR	1	0	Relocation Step Type	*
52	FLAG_MAINTENANCE	☐	/ISDFPS/FLAG_MAINTENANCE	XFLAG	CHAR	1	0	Relevant to Plant Maintenance
53	FLAG_COMPLETED	☐	/ISDFPS/FLAG_PREQ_COMPLETED	XFLAG	CHAR	1	0	Completely Processed
54	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
55	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
56	FLAG_DERIVED	☐	/ISDFPS/FLAG_PREQ_DERIVED	XFLAG	CHAR	1	0	PReq Is Derived (Forwarding)
57	FLAG_FORWARDED	☐	/ISDFPS/FLAG_PREQ_FORWARDED	XFLAG	CHAR	1	0	PReq Was Forwarded
58	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
59	OBJID_COM	☐	/ISDFPS/OBJID_COM	HROBJID	NUMC	8	0	Force Provider	*
60	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
61	FLAG_RETURN	☐	/ISDFPS/FLAG_RETURN	XFLAG	CHAR	1	0	Return Delivery
62	SERNR_PREQ	☐	/ISDFPS/SERNR_PREQ	GERNR	CHAR	18	0	Serial Number
63	FLAG_SERNR_PREQ	☐	/ISDFPS/FLAG_SERNR_PREQ	XFLAG	CHAR	1	0	Serial Number PReq
64	REF_GUID2	☐	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
65	REF_TYPE2	☐	/ISDFPS/MATPLN_REFTYPE	/ISDFPS/MATPLN_REF	CHAR	2	0	Type of Reference Relationship
66	LINECOUNT	☐	INT4	INT4	INT4	10	0	Natural number
67	PREQ_NO_REF	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
68	PREQ_ITEM_REF	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
69	EXTERN	☐	EXTNL	XFELD	CHAR	1	0	Indicator for External Procurement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/FDPDASLD_INP_0110	ADVCODE	/ISDFPS/ADVCODE2	ADVCODE
2	/ISDFPS/FDPDASLD_INP_0110	BATCH	MCH1	CHARG
3	/ISDFPS/FDPDASLD_INP_0110	DISPO	T024D	DISPO
4	/ISDFPS/FDPDASLD_INP_0110	EKGRP	T024	EKGRP
5	/ISDFPS/FDPDASLD_INP_0110	HU_LOC	T001L	LGORT
6	/ISDFPS/FDPDASLD_INP_0110	PLANT_PROV	T001W	WERKS
7	/ISDFPS/FDPDASLD_INP_0110	PRIO_URG	PURG	PRIO_URG
8	/ISDFPS/FDPDASLD_INP_0110	PSPNR	PRPS	PSPNR
9	/ISDFPS/FDPDASLD_INP_0110	RELOC_ID	/ISDFPS/REL	RELOC_ID
10	/ISDFPS/FDPDASLD_INP_0110	RELOC_SEQ_ID	/ISDFPS/RELSEQ	RELOC_SEQ_ID
11	/ISDFPS/FDPDASLD_INP_0110	STACODE	/ISDFPS/CSTACODE	STACODE
12	/ISDFPS/FDPDASLD_INP_0110	STORAGE_LOC	T001L	LGORT
13	/ISDFPS/FDPDASLD_INP_0110	STORAGE_LOC_PROV	T001L	LGORT

History

Last changed by/on	SAP	20110901
SAP Release Created in	10A