SAP ABAP View /ISDFPS/V_BI_FE (Extraction View for Force Element)

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

View Type	D	Database View
Database View	/ISDFPS/V_BI_FE
Short Description	Extraction View for Force Element
Root table	HRP1000	Infotype 1000 DB Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRP1000	HRP1000
2	/ISDFPS/FORCE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRP1000	MANDT	JL	EQ				0	0
2	/ISDFPS/FORCE	MANDT	JR	EQ			AND	0	0
3	HRP1000	OBJID	JL	EQ				0	0
4	/ISDFPS/FORCE	OBJID	JR	EQ			AND	0	0
5	HRP1000	OTYPE	JL	EQ				0	0
6	/ISDFPS/FORCE	OTYPE	JR	EQ			AND	0	0
7	HRP1000	PLVAR	JL	EQ				0	0
8	/ISDFPS/FORCE	PLVAR	JR	EQ			AND	0	0
9	HRP1000	OTYPE		EQ	'O'		AND	0	0
10	HRP1000	ISTAT		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRP1000	MANDT		☐	MANDT	☐	Client
2	FORCE_ID	/ISDFPS/FORCE	FORCE_ID		☐	/ISDFPS/FORCE_ID	☐	Internal Key for Force Element
3	BEGDA	HRP1000	BEGDA		☐	BEGDATUM	☐	Start Date
4	ENDDA	HRP1000	ENDDA		☐	ENDDATUM	☐	End Date
5	ISTAT	HRP1000	ISTAT		☐	ISTAT_D	☐	Planning Status
6	FORCE_CNT	/ISDFPS/FORCE	FORCE_CNT		☐	/ISDFPS/FORCE_CNT	☐	Internal (Version) Counter
7	PLVAR	/ISDFPS/FORCE	PLVAR		☐	PLVAR	☐	Plan Version
8	OTYPE	/ISDFPS/FORCE	OTYPE		☐	OTYPE	☐	Object Type
9	OBJID	/ISDFPS/FORCE	OBJID		☐	HROBJID	☐	Object ID
10	PSPNR	/ISDFPS/FORCE	PSPNR		☐	/ISDFPS/PS_POSNR	☐	WBS Element
11	WERKS_S	/ISDFPS/FORCE	WERKS_S		☐	WERKS_D	☐	Plant
12	BERID_S	/ISDFPS/FORCE	BERID_S		☐	/ISDFPS/BERID_S	☐	MRP Stock Area
13	ACNTABLE_S	/ISDFPS/FORCE	ACNTABLE_S		☐	/ISDFPS/ACNTABLE_S	☐	Accountable
14	WERKS_P	/ISDFPS/FORCE	WERKS_P		☐	WERKS_D	☐	Plant
15	BERID_P	/ISDFPS/FORCE	BERID_P		☐	/ISDFPS/BERID_P	☐	Provisions MRP Area
16	ACNTABLE_P	/ISDFPS/FORCE	ACNTABLE_P		☐	/ISDFPS/ACNTABLE_P	☐	Stockholding
17	MATSTAT	/ISDFPS/FORCE	MATSTAT		☐	/ISDFPS/FORCE_MATSTAT	☐	Initial Supply Status
18	EKORG	/ISDFPS/FORCE	EKORG		☐	EKORG	☐	Purchasing organization
19	EKGRP	/ISDFPS/FORCE	EKGRP		☐	EKGRP	☐	Purchasing group
20	LGORTACNT	/ISDFPS/FORCE	LGORTACNT		☐	LGORT_D	☐	Storage location
21	PROVIDER_MAT	/ISDFPS/FORCE	PROVIDER_MAT		☐	/ISDFPS/PROVIDER_MAT	☐	Initial Supplier of Materials
22	PROVIDER_PER	/ISDFPS/FORCE	PROVIDER_PER		☐	/ISDFPS/PROVIDER_PER	☐	Initial Supplier of Personnel
23	TSTAT	/ISDFPS/FORCE	TSTAT		☐	/ISDFPS/FORCE_TSTAT	☐	Technical Status
24	READINESS_MAT	/ISDFPS/FORCE	READINESS_MAT		☐	/ISDFPS/STATUS_MAT	☐	Level of Readiness (Material)
25	READINESS_PERS	/ISDFPS/FORCE	READINESS_PERS		☐	/ISDFPS/STATUS_PERS	☐	Level of Readiness (Personnel)
26	READINESS_TRAI	/ISDFPS/FORCE	READINESS_TRAI		☐	/ISDFPS/STATUS_TRAI	☐	Level of Readiness (Training)
27	PRIO	/ISDFPS/FORCE	PRIO		☐	PRIO_ORG	☐	Organizational Priority
28	TIMSTMP	/ISDFPS/FORCE	TIMSTMP		☐	/ISDFPS/TIMSTMP	☐	Time Stamp with Format (YYYYMMDDhhmmss)
29	LOGLEV	/ISDFPS/FORCE	LOGLEV		☐	/ISDFPS/LOGLEV	☐	Logistics Level
30	CREADAT	/ISDFPS/FORCE	CREADAT		☐	/ISDFPS/CREADAT	☐	Date of Application
31	CREABY	/ISDFPS/FORCE	CREABY		☐	/ISDFPS/CREABY	☐	Created by
32	CHNGDAT	/ISDFPS/FORCE	CHNGDAT		☐	/ISDFPS/CHNGDAT	☐	Last Changed on
33	CHNGBY	/ISDFPS/FORCE	CHNGBY		☐	/ISDFPS/CHNGBY	☐	Last Changed by
34	LOGSYS	/ISDFPS/FORCE	LOGSYS		☐	/ISDFPS/LOGSYS	☐	Logical System

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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