SAP ABAP View IAOM_CRM_AUFK (View of Translator Table for CRM and AUFK)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CO (Application Component) Controlling
     ⤷ IAOM_CRMSERVICE (Package) Cost and Revenue Controlling for CRM Service

Basic Data

View Type	D	Database View
Database View	IAOM_CRM_AUFK
Short Description	View of Translator Table for CRM and AUFK
Root table	AUFK	Order master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFK	AUFK
2	IAOM_CRMSRV_EXAT
3	IAOM_ASSIGNMENTS
4	IAOM_EXT_OBJ_INF

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	IAOM_CRMSRV_EXAT	MANDT	JL	EQ				0	0
2	IAOM_ASSIGNMENTS	MANDT	JR	EQ			AND	0	0
3	IAOM_CRMSRV_EXAT	EXT_OBJECT_ID	JL	EQ				0	0
4	IAOM_ASSIGNMENTS	EXT_OBJECT_ID	JR	EQ			AND	0	0
5	IAOM_ASSIGNMENTS	MANDT	JL	EQ				0	0
6	AUFK	MANDT	JR	EQ			AND	0	0
7	IAOM_ASSIGNMENTS	OBJECT_NO	JL	EQ				0	0
8	AUFK	OBJNR	JR	EQ			AND	0	0
9	IAOM_EXT_OBJ_INF	MANDT	JL	EQ				0	0
10	IAOM_ASSIGNMENTS	MANDT	JR	EQ			AND	0	0
11	IAOM_EXT_OBJ_INF	EXT_OBJECT_ID	JL	EQ				0	0
12	IAOM_ASSIGNMENTS	EXT_OBJECT_ID	JR	EQ			AND	0	0
13	IAOM_ASSIGNMENTS	BUS_SCENARIO_ID	JL	EQ				0	0
14	IAOM_EXT_OBJ_INF	BUS_SCENARIO_ID	JR	EQ			AND	0	0
15	IAOM_ASSIGNMENTS	BUS_SCENARIO_ID		EQ	'CRMSRV'		AND	0	0
16	IAOM_EXT_OBJ_INF	USAGE_REFERENCE		NE	'C'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AUFK	MANDT		☐	MANDT	☐	Client
2	EXT_OBJECT_ID	IAOM_CRMSRV_EXAT	EXT_OBJECT_ID		☐	IAOM_EXT_OBJECT_ID	☐	External Object Technical Key
3	AUFNR	AUFK	AUFNR		☐	AUFNR	☐	Order Number
4	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
5	OBJECT_ID	IAOM_CRMSRV_EXAT	OBJECT_ID		☐	CRMT_OBJECT_ID_CO	☐	Transaction
6	PROCESS_DESCRIPT	IAOM_CRMSRV_EXAT	PROCESS_DESCRIPT		☐	CRMT_PROCESS_DESCRIPTION_CO	☐	Business Transaction Description
7	PROCESS_TYPE	IAOM_CRMSRV_EXAT	PROCESS_TYPE		☐	CRMT_PROCESS_TYPE_CO	☐	Business Transaction Type
8	SERVICE_ORG_RESP	IAOM_CRMSRV_EXAT	SERVICE_ORG_RESP		☐	CRMT_SERVICE_ORG_RESP_CO	☐	Responsible Organizational Unit (Service)
9	SERVICE_ORG	IAOM_CRMSRV_EXAT	SERVICE_ORG		☐	CRMT_SERVICE_ORG_CO	☐	Service Organization
10	NUMBER_INT	IAOM_CRMSRV_EXAT	NUMBER_INT		☐	CRMT_ITEM_NO_CO	☐	Item
11	ITEM_DESCRIPTION	IAOM_CRMSRV_EXAT	ITEM_DESCRIPTION		☐	CRMT_ITEM_DESCRIPTION_CO	☐	Description of an Item
12	ITM_TYPE	IAOM_CRMSRV_EXAT	ITM_TYPE		☐	CRMT_ITEM_TYPE_CO	☐	Item Category
13	SERVICE_TECH_ORG	IAOM_CRMSRV_EXAT	SERVICE_TECH_ORG		☐	CRMT_SERVICE_TECH_ORG_CO	☐	Service Technician Organization / Team
14	CATEGORY_ID	IAOM_CRMSRV_EXAT	CATEGORY_ID		☐	COMT_CATEGORY_ID_CO_18	☐	Produkt Category ID
15	KUNNR	IAOM_CRMSRV_EXAT	KUNNR		☐	KUNAG	☐	Sold-to party

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