SAP ABAP View /ISDFPS/V_BI_981 (Extraction View for FE Relocation Step MPO Assignment)

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_981
Short Description	Extraction View for FE Relocation Step MPO Assignment
Root table	HRP1981	DB Table for Infotype 1981

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRP1981	HRP1981
2	HRT1981
3	HRP1980
4	HRT1980
5	/ISDFPS/RELSEQ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRP1981	MANDT	JL	EQ				0	0
2	HRT1981	MANDT	JR	EQ			AND	0	0
3	HRP1981	TABNR	JL	EQ				0	0
4	HRT1981	TABNR	JR	EQ			AND	0	0
5	HRP1980	MANDT	JL	EQ				0	0
6	HRT1980	MANDT	JR	EQ			AND	0	0
7	HRP1980	TABNR	JL	EQ				0	0
8	HRT1980	TABNR	JR	EQ			AND	0	0
9	HRP1980	MANDT	JL	EQ				0	0
10	HRP1981	MANDT	JR	EQ			AND	0	0
11	HRP1980	OBJID	JL	EQ				0	0
12	HRP1981	OBJID	JR	EQ			AND	0	0
13	HRP1980	OTYPE	JL	EQ				0	0
14	HRP1981	OTYPE	JR	EQ			AND	0	0
15	HRP1980	PLVAR	JL	EQ				0	0
16	HRP1981	PLVAR	JR	EQ			AND	0	0
17	HRP1980	RELOC_ID	JL	EQ				0	0
18	HRP1981	RELOC_ID	JR	EQ			AND	0	0
19	HRT1980	RELOC_SEQ_ID	JL	EQ				0	0
20	HRT1981	RELOC_SEQ_ID	JR	EQ			AND	0	0
21	HRT1981	MANDT	JL	EQ				0	0
22	/ISDFPS/RELSEQ	MANDT	JR	EQ			AND	0	0
23	HRT1981	RELOC_SEQ_ID	JL	EQ				0	0
24	/ISDFPS/RELSEQ	RELOC_SEQ_ID	JR	EQ			AND	0	0
25	HRP1981	OTYPE		EQ	'O'		AND	0	0
26	HRP1981	ISTAT		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRP1981	MANDT		☐	MANDT	☐	Client
2	PLVAR	HRP1981	PLVAR		☐	PLVAR	☐	Plan Version
3	OTYPE	HRP1981	OTYPE		☐	OTYPE	☐	Object Type
4	OBJID	HRP1981	OBJID		☐	HROBJID	☐	Object ID
5	BEGDA	HRP1981	BEGDA		☐	BEGDATUM	☐	Start Date
6	ENDDA	HRP1981	ENDDA		☐	ENDDATUM	☐	End Date
7	AEDTM	HRP1981	AEDTM		☐	AEDTM	☐	Changed on
8	UNAME	HRP1981	UNAME		☐	USRNAME	☐	User Name
9	REASN	HRP1981	REASN		☐	REASN	☐	Reason
10	HISTO	HRP1981	HISTO		☐	HISTO	☐	Historical Record Flag
11	RELOC_ID	HRP1981	RELOC_ID		☐	/ISDFPS/RELOC_ID	☐	Relocation ID
12	RELOC_SEQ_ID	HRT1981	RELOC_SEQ_ID		☐	/ISDFPS/RELOC_SEQ_ID	☐	Relocation Step ID
13	PNGUID	HRT1981	PNGUID		☐	PVS_GUID	☐	Internal Identification for PVS Objects
14	FORCEM_CNT	HRT1981	FORCEM_CNT		☐	/ISDFPS/FORCEM_CNT	☐	Internal (Version) Counter
15	PNTYPE	HRT1981	PNTYPE		☐	PVS_PNODE_TYPE	☐	iPPE Node Type
16	MENGE	HRT1981	MENGE		☐	/ISDFPS/QUPLN	☐	Planned Quantity
17	MEINS	HRT1981	MEINS		☐	MEINS	☐	Base Unit of Measure
18	ROUTE	HRT1981	ROUTE		☐	ROUTE	☐	Route
19	MBDAT	HRT1981	MBDAT		☐	MBDAT	☐	Material Staging/Availability Date
20	DAT_SP	HRT1981	DAT_SP		☐	/ISDFPS/DAT_SP	☐	Collectn Pt Date
21	RELSEQ_TYPE	HRT1981	RELSEQ_TYPE		☐	/ISDFPS/RELSEQ_TYPE	☐	Relocation Step Type
22	VSBED	HRT1981	VSBED		☐	VSBED	☐	Shipping conditions
23	DGUID	HRT1981	DGUID		☐	/ISDFPS/DGUID	☐	Identifier of Relationships for Distribution
24	RELOC_GPLUS_DAY	HRT1980	RELOC_GPLUS_DAY		☐	/ISDFPS/RELOC_GPLUS_DAY	☐	Number of Days
25	RELOC_GPLUS_TIME	HRT1980	RELOC_GPLUS_TIME		☐	/ISDFPS/RELOC_GPLUS_TIME	☐	Number of Hours

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	20130529
SAP Release Created in	470