SAP ABAP View /ISDFPS/V_ADDR (Address View for Search Help /ISDFPS/ADDR)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-MM (Application Component) Materials Management
     ⤷ /ISDFPS/MM (Package) SDP BW Enhancements in Materials Management

Basic Data

View Type	D	Database View
Database View	/ISDFPS/V_ADDR
Short Description	Address View for Search Help /ISDFPS/ADDR
Root table	ADRC	Addresses (Business Address Services)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ADRC	ADRC
2	HRP1952
3	HRP1000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRC	CLIENT	JL	EQ				0	0
2	HRP1952	MANDT	JR	EQ			AND	0	0
3	ADRC	ADDRNUMBER	JL	EQ				0	0
4	HRP1952	ADDRNUMBER	JR	EQ			AND	0	0
5	HRP1952	MANDT	JL	EQ				0	0
6	HRP1000	MANDT	JR	EQ			AND	0	0
7	HRP1952	PLVAR	JL	EQ				0	0
8	HRP1000	PLVAR	JR	EQ			AND	0	0
9	HRP1952	OTYPE	JL	EQ				0	0
10	HRP1000	OTYPE	JR	EQ			AND	0	0
11	HRP1952	OBJID	JL	EQ				0	0
12	HRP1000	OBJID	JR	EQ			AND	0	0
13	ADRC	ADDR_GROUP		EQ	'DFP1'		AND	0	0
14	HRP1952	PLVAR		EQ	'01'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ADRC	CLIENT		☐	MANDT	☐	Client
2	PLVAR	HRP1952	PLVAR		☐	PLVAR	☐	Plan Version
3	OTYPE	HRP1952	OTYPE		☐	OTYPE	☐	Object Type
4	OBJID	HRP1952	OBJID		☐	HROBJID	☐	Object ID
5	SUBTY	HRP1952	SUBTY		☐	SUBTYP	☐	Subtype
6	ISTAT	HRP1952	ISTAT		☐	ISTAT_D	☐	Planning Status
7	BEGDA	HRP1952	BEGDA		☐	BEGDATUM	☐	Start Date
8	ENDDA	HRP1952	ENDDA		☐	ENDDATUM	☐	End Date
9	VARYF	HRP1952	VARYF		☐	VARYF	☐	Variation Field for File PLOG
10	SEQNR	HRP1952	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
11	ADDRNUMBER	ADRC	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
12	DATE_FROM	ADRC	DATE_FROM		☐	AD_DATE_FR	☐	Valid-from date - in current Release only 00010101 possible
13	NATION	ADRC	NATION		☐	AD_NATION	☐	Version ID for International Addresses
14	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
15	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
16	NAME_TEXT	ADRC	NAME_TEXT		☐	AD_NAMETXT	☐	Converted name field (with form of address)
17	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
18	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
19	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
20	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
21	ADDR_GROUP	ADRC	ADDR_GROUP		☐	AD_GROUP	☐	Address Group (Key) (Business Address Services)
22	SORT1	ADRC	SORT1		☐	AD_SORT1	☐	Search Term 1
23	SORT2	ADRC	SORT2		☐	AD_SORT2	☐	Search Term 2
24	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
25	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
26	MC_STREET	ADRC	MC_STREET		☐	AD_MC_STRT	☐	Street name in upper case for search help
27	K_BEGDA	HRP1000	BEGDA		☐	BEGDATUM	☐	Start Date
28	K_ENDDA	HRP1000	ENDDA		☐	ENDDATUM	☐	End Date
29	K_LANGU	HRP1000	LANGU		☐	LANGU	☐	Language Key
30	K_SEQNR	HRP1000	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
31	K_ISTAT	HRP1000	ISTAT		☐	ISTAT_D	☐	Planning Status
32	SHORT	HRP1000	SHORT		☐	SHORT_D	☐	Object Abbreviation
33	STEXT	HRP1000	STEXT		☐	STEXT	☐	Object Name
34	MC_SHORT	HRP1000	MC_SHORT		☐	HR_MCSHORT	☐	Object Abbreviation
35	MC_STEXT	HRP1000	MC_STEXT		☐	HR_MCSTEXT	☐	Name
36	MC_SEARK	HRP1000	MC_SEARK		☐	HR_MCSEARK	☐	Search Term

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