SAP ABAP View CRMV_SRV_SOCORV (CRM Service: View for Selection of Confirmation Revenues)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CO (Application Component) Controlling
     ⤷ IAOM_CRMSERVICE_BW (Package) BW Integration for CRM Controlling

Basic Data

View Type	D	Database View
Database View	CRMV_SRV_SOCORV
Short Description	CRM Service: View for Selection of Confirmation Revenues
Root table	IAOM_EXT_OBJ_INF	General Information on External Object - See Documentation

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	IAOM_EXT_OBJ_INF	IAOM_EXT_OBJ_INF
2	IAOM_CRMSRV_EXAT
3	CRMC_IT_TYP_CO
4	CRMC_PR_TYP_CO
5	COINT_TPOST_IT
6	COINT_TPOST_HD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	COINT_TPOST_IT	MANDT	JL	EQ				0	0
2	IAOM_EXT_OBJ_INF	MANDT	JR	EQ			AND	0	0
3	COINT_TPOST_IT	GUID	JL	EQ				0	0
4	IAOM_EXT_OBJ_INF	EXT_OBJECT_ID	JR	EQ			AND	0	0
5	COINT_TPOST_IT	MANDT	JL	EQ				0	0
6	COINT_TPOST_HD	MANDT	JR	EQ			AND	0	0
7	COINT_TPOST_IT	GUID	JL	EQ				0	0
8	COINT_TPOST_HD	GUID	JR	EQ			AND	0	0
9	IAOM_EXT_OBJ_INF	MANDT	JL	EQ				0	0
10	IAOM_CRMSRV_EXAT	MANDT	JR	EQ			AND	0	0
11	IAOM_EXT_OBJ_INF	EXT_OBJECT_ID	JL	EQ				0	0
12	IAOM_CRMSRV_EXAT	EXT_OBJECT_ID	JR	EQ			AND	0	0
13	IAOM_CRMSRV_EXAT	MANDT	JL	EQ				0	0
14	CRMC_IT_TYP_CO	CLIENT	JR	EQ			AND	0	0
15	IAOM_CRMSRV_EXAT	ITM_TYPE	JL	EQ				0	0
16	CRMC_IT_TYP_CO	ITM_TYPE	JR	EQ			AND	0	0
17	IAOM_CRMSRV_EXAT	MANDT	JL	EQ				0	0
18	CRMC_PR_TYP_CO	CLIENT	JR	EQ			AND	0	0
19	IAOM_CRMSRV_EXAT	PROCESS_TYPE	JL	EQ				0	0
20	CRMC_PR_TYP_CO	PROCESS_TYPE	JR	EQ			AND	0	0
21	IAOM_EXT_OBJ_INF	BUS_SCENARIO_ID		EQ	'CRMSRV'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	IAOM_EXT_OBJ_INF	MANDT		☐	MANDT	☐	Client
2	HIGHER_LEVEL_OBJ	IAOM_EXT_OBJ_INF	HIGHER_LEVEL_OBJ		☐	IAOM_EXT_OBJECT_ID	☐	External Object Technical Key
3	REFERENCED_OBJ	IAOM_EXT_OBJ_INF	REFERENCED_OBJ		☐	IAOM_EXT_OBJECT_ID	☐	External Object Technical Key
4	PROCESS_TYPE	IAOM_CRMSRV_EXAT	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE_CO	☐	Business Transaction Type
5	ITM_TYPE	IAOM_CRMSRV_EXAT	ITM_TYPE		☐	CRMT_ITEM_TYPE_CO	☐	Item Category
6	OBJECT_TYPE_H	CRMC_PR_TYP_CO	OBJECT_TYPE		☐	CRMT_OBJECT_TYPE_CO	☐	Object Type for CRM Transaction Type/Item Category
7	OBJECT_TYPE_I	CRMC_IT_TYP_CO	OBJECT_TYPE		☐	CRMT_OBJECT_TYPE_CO	☐	Object Type for CRM Transaction Type/Item Category
8	EXT_OBJECT_ID	COINT_TPOST_IT	GUID		☐	COINT_TP_OBJECT_ID	☐	Technical Key for External Object
9	BUZEI	COINT_TPOST_IT	BUZEI		☐	TP_BUZEI	☐	Posting Row
10	KSTAR	COINT_TPOST_IT	KSTAR		☐	KSTAR	☐	Cost Element
11	BETRG	COINT_TPOST_IT	BETRG		☐	TP_BETRG	☐	Amount
12	CURRENCY	COINT_TPOST_IT	CURRENCY		☐	WAERS	☐	Currency Key
13	CHANGED_FLAG	COINT_TPOST_IT	CHANGED		☐	TP_CHANGED	☐	Changed
14	KOKRS	COINT_TPOST_HD	KOKRS		☐	KOKRS	☐	Controlling Area
15	BEMOT	COINT_TPOST_HD	BEMOT		☐	BEMOT	☐	Accounting Indicator
16	CHANGED_AT	COINT_TPOST_IT	TIMESTMP		☐	RKE_HZSTMP	☐	Time created (Greenwich Meantime)
17	BDATE	COINT_TPOST_IT	BDATE		☐	TP_DATE	☐	Billing Document or Billing Request Date

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	20130529
SAP Release Created in	2004_1_470