SAP ABAP Table CRMV_INDEX_JEST (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | CRMV_INDEX_JEST | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | STAT | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
3 | INACT | CRM_J_INACT | CRM_J_INACT | CHAR | 1 | 0 | Indicator: Status Is Inactive | ||
4 | HEADER | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
5 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Transaction Category | CRMC_SUBOB_CAT | |
6 | ITEM | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
7 | PARTNER_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
8 | DATE_1 | CRMT_VALID_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Dependency: Validity Start Date | ||
9 | DATE_2 | CRMT_VALID_TO | BCOS_TSTMP | DEC | 15 | 0 | Time Dependency: Validity End Date | ||
10 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
11 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | ||
12 | PO_NUMBER_UC | CRMT_PO_NUMBER_UC | CHAR35 | CHAR | 35 | 0 | Sold-to Party's External Reference No. (in Capital Letters) | ||
13 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
14 | CURR_PHASE | CRMT_CURR_PHASE | CRM_PHASE | CHAR | 3 | 0 | Sales Stage | ||
15 | IMPORTANCE | CRMT_IMPORTANCE | CRM_IMPORTANCE | CHAR | 1 | 0 | Opportunity/Lead Priority | ||
16 | PFT_0 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
17 | PFT_1 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
18 | PFT_2 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
19 | PFT_3 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
20 | PFT_4 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
21 | PFT_5 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
22 | PFT_6 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
23 | PFT_7 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
24 | PFT_8 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
25 | PFT_9 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
26 | PFT_10 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
27 | PFT_11 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
28 | PFT_12 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
29 | PFT_13 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
30 | PFT_14 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
31 | PFT_15 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
32 | PFT_16 | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
33 | PRODUCT_ID | CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
34 | CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
35 | CATALOG_ID | CRMT_CATALOG | CRM_CATALOGID | CHAR | 20 | 0 | Catalog ID from which the line was selected | ||
36 | DESCRIPT_PARTNER | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
37 | PURCH_ORG | CRMT_PURCH_ORG | HROBJEC_14 | CHAR | 14 | 0 | Purchasing Organization | ||
38 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
39 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
40 | STAT_OPEN | CRMT_STATUS_OPEN | CRM_BOOLEAN | CHAR | 1 | 0 | Transaction is Still Open | ||
41 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMV_INDEX_JEST | OBJECT_TYPE | CRMC_SUBOB_CAT | SUBOBJ_CATEGORY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |