SAP ABAP Table CRMPHAV_BP_SPEC (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	N	Display/Maintenance Not Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client
2	SPEC_TYPE	☑	CRMPHAT_BP_SPEC_TYPE	CRMPHA_BP_SPEC_TYPE	CHAR	5	0	CRM Pharma. BP: Qualification Category	CRMPHAC_BP_SPV
3	SPEC_KEY	☑	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	CRMPHAC_BP_SPV
4	VALID_TO	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
6	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
7	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
8	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
9	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
10	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMPHAV_BP_SPEC	AUGRP	TB037	AUGRP	REF	1	CN
2	CRMPHAV_BP_SPEC	SPEC_KEY	CRMPHAC_BP_SPV	SPEC_KEY
3	CRMPHAV_BP_SPEC	SPEC_TYPE	CRMPHAC_BP_SPV	SPEC_TYPE

History

Last changed by/on	SAP	20140117
SAP Release Created in