SAP ABAP Table CRMT_PRP_ORG_H_DB_WRK (PRP organisational data: structure of the database buffer)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_ORG_H (Package) Organisational Data for Partner/Product Ranges (PPRs)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_ORG_H_DB_WRK	Table Relationship Diagram
Short Description	PRP organisational data: structure of the database buffer

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	.INCLUDE	☐				0	0	PRP Organisational Data
2	.INCLUDE	☐				0	0	PPR organisational data: primary key fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
5	.INCLUDE	☐				0	0	PPR Organisational Data: Fields manipulated externally
6	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	CRMC_PRP_REFTYP
7	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
8	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
9	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
10	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
11	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
12	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	CRMC_DIVISION
13	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
14	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
15	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function	CRMC_PARTNER_FCT
16	.INCLUDE	☐				0	0	PPR organisational data: fields manipulated internally
17	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
18	.INCLUDE	☐				0	0	Partner/Product Ranges (PPRs): Administrative Data
19	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
20	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
21	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
22	HISTEX	☐	COMT_HISTEX	COM_BOOLEAN	CHAR	1	0	History Exists
23	EXT_AVAILABLE	☐	CRMT_PRP_EXT_AVAILABLE	CRM_BOOLEAN	CHAR	1	0	Flag to label, if a PPR Obj. Ext. (EXT_H,EXT_I) is available
24	.INCLUDE	☐				0	0	PRP org data: dynamic fields of the database buffer
25	NOREC_FLAG	☐	CRMT_NOREC	CRM_BOOLEAN	CHAR	1	0	Entry does not Exist in Database

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_ORG_H_DB_WRK	DIS_CHANNEL	CRMC_DISTCHAN	DISTCHAN	KEY	C	CN
2	CRMT_PRP_ORG_H_DB_WRK	DIVISION	CRMC_DIVISION	DIVISION	KEY	C	CN
3	CRMT_PRP_ORG_H_DB_WRK	PARTNER_FUNCTION	CRMC_PARTNER_FCT	PARTNER_FCT	KEY	C	CN
4	CRMT_PRP_ORG_H_DB_WRK	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE	KEY	C	CN
5	CRMT_PRP_ORG_H_DB_WRK	TYPE	CRMC_PRP_REFTYP	REFERENCE_TYPE	KEY	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	20C