SAP ABAP View CRM_SRVBW_ITEM (CRM Service: BW Extraction for Process Items)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CO (Application Component) Controlling
⤷ IAOM_CRMSERVICE_BW (Package) BW Integration for CRM Controlling
⤷ CO (Application Component) Controlling
⤷ IAOM_CRMSERVICE_BW (Package) BW Integration for CRM Controlling
Basic Data
View Type | D | Database View |
Database View | CRM_SRVBW_ITEM | |
Short Description | CRM Service: BW Extraction for Process Items | |
Root table | IAOM_CRMSRV_EXAT | Ext. Attributes of an Ext. Object (Single Obj.Controlling) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | IAOM_CRMSRV_EXAT | IAOM_CRMSRV_EXAT | ||
2 | IAOM_EXT_OBJ_INF | |||
3 | IAOM_ASSIGNMENTS | |||
4 | CRMC_IT_TYP_CO |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | IAOM_EXT_OBJ_INF | MANDT | JL | EQ | 0 | 0 | ||||
2 | IAOM_CRMSRV_EXAT | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | IAOM_EXT_OBJ_INF | EXT_OBJECT_ID | JL | EQ | 0 | 0 | ||||
4 | IAOM_CRMSRV_EXAT | EXT_OBJECT_ID | JR | EQ | AND | 0 | 0 | |||
5 | IAOM_ASSIGNMENTS | MANDT | JL | EQ | 0 | 0 | ||||
6 | IAOM_CRMSRV_EXAT | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | IAOM_ASSIGNMENTS | EXT_OBJECT_ID | JL | EQ | 0 | 0 | ||||
8 | IAOM_CRMSRV_EXAT | EXT_OBJECT_ID | JR | EQ | AND | 0 | 0 | |||
9 | IAOM_CRMSRV_EXAT | MANDT | JL | EQ | 0 | 0 | ||||
10 | CRMC_IT_TYP_CO | CLIENT | JR | EQ | AND | 0 | 0 | |||
11 | IAOM_CRMSRV_EXAT | ITM_TYPE | JL | EQ | 0 | 0 | ||||
12 | CRMC_IT_TYP_CO | ITM_TYPE | JR | EQ | AND | 0 | 0 | |||
13 | IAOM_EXT_OBJ_INF | BUS_SCENARIO_ID | EQ | 'CRMSRV' | AND | 0 | 0 | |||
14 | IAOM_EXT_OBJ_INF | HIERARCHY_LEVEL | EQ | '02' | 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 | BUS_SCENARIO_ID | IAOM_EXT_OBJ_INF | BUS_SCENARIO_ID | IAOM_BS_IDENTIFICATION | Business Scenario for Which Controlling Is Performed | |||
3 | EXT_OBJECT_ID | IAOM_EXT_OBJ_INF | EXT_OBJECT_ID | IAOM_EXT_OBJECT_ID | External Object Technical Key | |||
4 | HIERARCHY_LEVEL | IAOM_EXT_OBJ_INF | HIERARCHY_LEVEL | IAOM_OBJECT_LEVEL | Hierarchy Level of Object | |||
5 | OBJECT_NO | IAOM_ASSIGNMENTS | OBJECT_NO | J_OBJNR | Object number | |||
6 | OBJECT_ID | IAOM_CRMSRV_EXAT | OBJECT_ID | CRMT_OBJECT_ID_CO | Transaction | |||
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 | ITM_TYPE | IAOM_CRMSRV_EXAT | ITM_TYPE | CRMT_ITEM_TYPE_CO | Item Category | |||
12 | OBJECT_TYPE | CRMC_IT_TYP_CO | OBJECT_TYPE | CRMT_OBJECT_TYPE_CO | Object Type for CRM Transaction Type/Item Category | |||
13 | HIGHER_LEVEL_OBJ | IAOM_EXT_OBJ_INF | HIGHER_LEVEL_OBJ | IAOM_EXT_OBJECT_ID | External Object Technical Key | |||
14 | SERVICE_TECH_ORG | IAOM_CRMSRV_EXAT | SERVICE_TECH_ORG | CRMT_SERVICE_TECH_ORG_CO | Service Technician Organization / Team | |||
15 | CATEGORY_ID | IAOM_CRMSRV_EXAT | CATEGORY_ID | COMT_CATEGORY_ID_CO_18 | Produkt Category ID | |||
16 | KUNNR | IAOM_CRMSRV_EXAT | KUNNR | KUNAG | Sold-to party | |||
Maintenance Status
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 | 20100310 |
SAP Release Created in | 2003_1_470 |