SAP ABAP View V_PA45_DLART_TXT (Display view for the loan type texts for each employee)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-XX (Application Component) Payroll: General Parts
     ⤷ PCLO (Package) HR-PY: International Loan Functions

Basic Data

View Type	D	Database View
Database View	V_PA45_DLART_TXT
Short Description	Display view for the loan type texts for each employee
Root table	PA0045	HR Master Record: Infotype 0045 (Company Loans)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PA0045	PA0045
2	T591A
3	T591S

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T591A	MANDT	JL	EQ				0	0
2	PA0045	MANDT	JR	EQ			AND	0	0
3	T591A	SUBTY	JL	EQ				0	0
4	PA0045	DLART	JR	EQ			AND	0	0
5	T591A	MANDT	JL	EQ				0	0
6	T591S	MANDT	JR	EQ			AND	0	0
7	T591A	INFTY	JL	EQ				0	0
8	T591S	INFTY	JR	EQ			AND	0	0
9	T591A	SUBTY	JL	EQ				0	0
10	T591S	SUBTY	JR	EQ			AND	0	0
11	T591A	INFTY		EQ	'0045'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PA0045	MANDT		☐	MANDT	☐	Client
2	PERNR	PA0045	PERNR		☐	PERSNO	☐	Personnel number
3	SUBTY	PA0045	SUBTY		☐	SUBTY	☐	Subtype
4	OBJPS	PA0045	OBJPS		☐	OBJPS	☐	Object Identification
5	SPRPS	PA0045	SPRPS		☐	SPRPS	☐	Lock Indicator for HR Master Data Record
6	ENDDA	PA0045	ENDDA		☐	ENDDA	☐	End Date
7	BEGDA	PA0045	BEGDA		☐	BEGDA	☐	Start Date
8	SEQNR	PA0045	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
9	INFTY	T591S	INFTY		☐	INFTY	☐	Infotype
10	SPRSL	T591S	SPRSL		☐	SPRAS	☐	Language Key
11	STEXT	T591S	STEXT		☐	SBTTX	☐	Name of Subtype
12	DLART	PA0045	DLART		☐	DLART	☐	Loan type
13	DARBT	PA0045	DARBT		☐	DARB1	☐	Loan amount granted
14	DBTCU	PA0045	DBTCU		☐	WAERS	☐	Currency Key

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