SAP ABAP View J_7L_FPL_MANDATE (REA: Attributes of FostPlus mandators)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

View Type	D	Database View
Database View	J_7L_FPL_MANDATE
Short Description	REA: Attributes of FostPlus mandators
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1
2	KNVK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	KNVK	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	KNVK	KUNNR	JR	EQ			AND	0	0
5	KNA1	LOEVM		EQ	' '		AND	0	0
6	KNVK	LOEVM		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNA1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNA1	KUNNR		☐	KUNNR	☐	Customer Number
3	PARNR	KNVK	PARNR		☐	PARNR	☐	Number of contact person
4	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
5	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
6	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
7	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
8	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
9	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
10	LNGMANNR	KNVK	NAMEV		☐	NAMEV_VP	☐	First name
11	DAEINDOVERNAME	KNVK	ABTPA		☐	ABTEI_PA	☐	Contact person's department at customer
12	DADTVERZONDEN	KNVK	TELF1		☐	TELF1	☐	First telephone number
13	DASTARTDT	KNVK	GBDAT		☐	GBDAT	☐	Date of Birth
14	BLN	KNVK	PARAU		☐	PARAU	☐	Notes about contact person
15	LIDNRFOSTPLUS	KNVK	TITEL_AP		☐	TITEL_AP	☐	Title of contact person (description of function)
16	SORTL	KNVK	SORTL		☐	SORTL	☐	Sort field

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