SAP ABAP Table CRMPHAM_BP_FRG50 (CRM Pharma BP: assigned DEA schedules)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH-BP (Application Component) Business Partner
     ⤷ CRMPHA_BUPA_FRG050 (Package) CRM Pharma BP: DEA Scehdules

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMPHAM_BP_FRG50	Table Relationship Diagram
Short Description	CRM Pharma BP: assigned DEA schedules

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	.INCLUDE	☑				0	0	CRM Pharma. DEA schedule BP Key
3	PARTNER_GUID	☑	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	.INCLUDE	☐				0	0	BP Management Data for Instances of Sub-Objects
5	HOME_SYSTEM	☐	BU_HOME_SYSTEM	LOGSYS	CHAR	10	0	Business partner: Master system of data record	*
6	.INCLUDE	☐				0	0	Management Data for Data Records of a Table
7	CREATED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
8	CHANGED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
9	CREATED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	CHANGED_ON	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	.INCLUDE	☐				0	0	CRM Pharma BP: assigned DEA schedules
12	DEA_SCHED1	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
13	DEA_SCHED2	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
14	DEA_SCHED3	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
15	DEA_SCHED4	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
16	DEA_SCHED5	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
17	DEA_SCHED6	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
18	DEA_SCHED7	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
19	DEA_SCHED8	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
20	DEA_SCHED9	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED
21	DEA_SCHED10	☐	CRMPHAT_DEA_SCHEDULE_KEY	CRMPHARM_DEA_SCHEDULE	CHAR	2	0	DEA drug schedule key	CRMPHA_DEA_SCHED

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMPHAM_BP_FRG50	CLIENT	T000	MANDT	KEY	1	CN
2	CRMPHAM_BP_FRG50	DEA_SCHED1	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
3	CRMPHAM_BP_FRG50	DEA_SCHED10	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
4	CRMPHAM_BP_FRG50	DEA_SCHED2	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
5	CRMPHAM_BP_FRG50	DEA_SCHED3	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
6	CRMPHAM_BP_FRG50	DEA_SCHED4	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
7	CRMPHAM_BP_FRG50	DEA_SCHED5	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
8	CRMPHAM_BP_FRG50	DEA_SCHED6	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
9	CRMPHAM_BP_FRG50	DEA_SCHED7	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
10	CRMPHAM_BP_FRG50	DEA_SCHED8	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN
11	CRMPHAM_BP_FRG50	DEA_SCHED9	CRMPHA_DEA_SCHED	DEA_SCHEDULE	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	400