SAP ABAP Table CRMPHAV_FRG20_01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMPHAV_FRG20_01	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client
2	PARTNER_GUID	☑	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
3	SPEC_TYPE	☑	CRMPHAT_BP_SPEC_TYPE	CRMPHA_BP_SPEC_TYPE	CHAR	5	0	CRM Pharma. BP: Qualification Category	CRMPHAC_BP_SPV
4	HOME_SYSTEM	☑	BU_HOME_SYSTEM	LOGSYS	CHAR	10	0	Business partner: Master system of data record
5	CREATED_BY	☑	UNAME	UNAME	CHAR	12	0	User Name
6	CHANGED_BY	☑	UNAME	UNAME	CHAR	12	0	User Name
7	CREATED_ON	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8	CHANGED_ON	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	SPEC_KEY	☑	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	CRMPHAC_BP_SPV
10	VALID_TO	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	VALID_FROM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	DEFAULT_SPEC	☐	CRMPHAT_BP_DFLT_SPEC	XFELD	CHAR	1	0	Standard Indicator for Activity/Qualification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMPHAV_FRG20_01	SPEC_KEY	CRMPHAC_BP_SPV	SPEC_KEY
2	CRMPHAV_FRG20_01	SPEC_TYPE	CRMPHAC_BP_SPV	SPEC_TYPE

History

Last changed by/on	SAP	20130604
SAP Release Created in