SAP ABAP Table /ISDFPS/S_BI_PLAN_PREQ (Extraction View for Planned Records and PReqs in DFPS)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/S_BI_PLAN_PREQ	Table Relationship Diagram
Short Description	Extraction View for Planned Records and PReqs in DFPS

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	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
2	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
3	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
4	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
5	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
6	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
8	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
9	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
10	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
11	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
12	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
13	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	*
14	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
15	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
16	ITEM_CS	☐	/ISDFPS/ITEM_CS	/ISDFPS/ITEM_CS	CHAR	1	0	Cross-System Item Category
17	BNFPO_CS	☐	/ISDFPS/BNFPO_CS	BNFPO	NUMC	5	0	Cross-System PReq Item	*
18	BANFN_CS	☐	/ISDFPS/BANFN_CS	BANFN	CHAR	10	0	Cross-System PReq Number
19	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	*
20	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	*
21	GMMNG	☐	GMMNG	MENG13	QUAN	13	3	PO Quantity of Purchase Requisition in POs on Hold
22	BSMNG_SND	☐	/ISDFPS/BSMNG_SND	MENG13	QUAN	13	3	PO Quantity Sender
23	PRIO_REQ	☐	/ISDFPS/PRIO_REQ	/ISDFPS/PRIO_REQ	NUMC	3	0	Requirement Priority (Obsolete)	*
24	PRIO_URG	☐	/ISDFPS/PRIO_URG	/ISDFPS/PRIO_URG	NUMC	2	0	Requirement Urgency (Obsolete)	*
25	GSFRG	☐	GSFRG	XFELD	CHAR	1	0	Overall release of purchase requisitions
26	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
27	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
28	BANPR	☐	BANPR	BANPR	CHAR	2	0	Requisition Processing State
29	MEMORY	☐	MEMBF	XFELD	CHAR	1	0	Purchase Requisition not yet Complete
30	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
31	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
32	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
33	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
34	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
35	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
36	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
37	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
38	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
39	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
40	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
41	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
42	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
43	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
44	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
45	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
46	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
47	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
48	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
49	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
50	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
51	PLANNING_GUID	☐	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
52	RECTYPE	☐	/ISDFPS/FDPMAT_RECTYPE	/ISDFPS/FDPMAT_RECTYPE	CHAR	3	0	Record Type Planning
53	FORCE_REC_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
54	FORCE_REC_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
55	PLANT_REC	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
56	STORAGE_LOC_REC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
57	HU_LOC_REC	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
58	FORCE_PROV_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
59	FORCE_PROV_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
60	PLANT_PROV	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
61	STORAGE_LOC_PROV	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
62	HU_LOC_PROV	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
63	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
64	PSPNR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
65	HU_EXID	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
66	VEPOS	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
67	PACK_MAT	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	*
68	QUPLN	☐	/ISDFPS/QUPLN	MENG13V	QUAN	13	3	Planned Quantity
69	DELIVERY_DATE	☐	/ISDFPS/DEL_DATE		DATS	8	0	Delivery Date
70	COMNT	☐	/ISDFPS/COMNT	TEXT40	CHAR	40	0	Planning Comment
71	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
72	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
73	FLAG_LOAN	☐	/ISDFPS/FLAG_LOAN	XFLAG	CHAR	1	0	Loan
74	RETURN_DATE	☐	/ISDFPS/RETURN_DATE	DATS	DATS	8	0	Return Date for Loan
75	FLAG_LOAN_RET	☐	/ISDFPS/FLAG_LOAN_RETURN	XFLAG	CHAR	1	0	Loan Return
76	RECORD_INVISIBLE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
77	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	*
78	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	*
79	PNGUID	☐	PVS_GUID	SYSUUID	RAW	16	0	Internal Identification for PVS Objects
80	FORCEM_CNT	☐	/ISDFPS/FORCEM_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
81	DGUID	☐	/ISDFPS/DGUID	SYSUUID_C	CHAR	32	0	Identifier of Relationships for Distribution
82	FLAG_EV	☐	/ISDFPS/REL_FLAG_EV	XFELD	CHAR	1	0	Relocation: Initial Supply
83	FORCE_ASGN_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
84	FORCE_ASGN_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
85	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
86	DAT_SP	☐	/ISDFPS/DAT_SP	DATUM	DATS	8	0	Collectn Pt Date
87	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
88	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	*
89	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
90	FBSTA	☐	/ISDFPS/FBSTA	/ISDFPS/FBSTA	CHAR	1	0	Relocation: Follow-On Document Status
91	FLAG_PROV	☐	/ISDFPS/FLAG_PROV		CHAR	1	0	Provisions
92	LOCATION_S_GUID	☐	/ISDFPS/LOCATION_ID	SYSUUID_C	CHAR	32	0	ISDFPS: Location ID (GUID)
93	LOCATION_D_GUID	☐	/ISDFPS/LOCATION_ID	SYSUUID_C	CHAR	32	0	ISDFPS: Location ID (GUID)
94	CREATED_ON	☐	ANDAT	DATUM	DATS	8	0	Date Record Created on
95	CREATED_BY	☐	ANNAM	USNAM	CHAR	12	0	User Who Created Record
96	CHANGED_ON	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
97	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
98	FLAG_HISTORY	☐	/ISDFPS/FLAG_HISTORY	XFELD	CHAR	1	0	Record Is Historical
99	FLAG_MAINTENANCE	☐	/ISDFPS/FLAG_MAINTENANCE	XFLAG	CHAR	1	0	Relevant to Plant Maintenance
100	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
101	FLAG_COMPLETED	☐	/ISDFPS/FLAG_PREQ_COMPLETED	XFLAG	CHAR	1	0	Completely Processed
102	FLAG_FORWARDED	☐	/ISDFPS/FLAG_PREQ_FORWARDED	XFLAG	CHAR	1	0	PReq Was Forwarded
103	FLAG_DERIVED	☐	/ISDFPS/FLAG_PREQ_DERIVED	XFLAG	CHAR	1	0	PReq Is Derived (Forwarding)
104	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
105	FLAG_RETURN	☐	/ISDFPS/FLAG_RETURN	XFLAG	CHAR	1	0	Return Delivery
106	SERNR_PREQ	☐	/ISDFPS/SERNR_PREQ	GERNR	CHAR	18	0	Serial Number
107	FLAG_SERNR_PREQ	☐	/ISDFPS/FLAG_SERNR_PREQ	XFLAG	CHAR	1	0	Serial Number PReq
108	RELSEQ_TYPE	☐	/ISDFPS/RELSEQ_TYPE	/ISDFPS/RELSEQ_TYPE	CHAR	1	0	Relocation Step Type	*
109	MPO	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
110	FORCE_REC	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
111	FORCE_PROV	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
112	FORCE_ASGN	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
113	RIC	☐	/ISDFPS/RICODE	/ISDFPS/RICODE	CHAR	6	0	Reportable Item Code	*
114	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
115	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
116	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
117	OPERATION_ID	☐	/ISDFPS/OPERATION_ID	HROBJID	NUMC	8	0	Operation/Exercise ID	*
118	CON_ID	☐	/ISDFPS/CON_ID	/ISDFPS/CON_ID	CHAR	5	0	Contingent Key
119	OBJID_COM	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
120	PROVIDER_MAT	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
121	PROVIDER_PER	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*

History

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