SAP ABAP Table CRMT_IST_BW_ORDER_I (Extract Structure for BW DataSource Telco Order)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-IT (Application Component) Telecommunications
⤷ CRM_IST1_BW (Package) Telco: BW Content Developments
⤷ CRM-IT (Application Component) Telecommunications
⤷ CRM_IST1_BW (Package) Telco: BW Content Developments
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_IST_BW_ORDER_I | Table Relationship Diagram |
Short Description | Extract Structure for BW DataSource Telco Order |
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 | ORDERADM_H Data for BW DataSources | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
6 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
7 | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | CRM_PROCESS_DESCRIPTION_UC | CHAR | 40 | 0 | Transaction Description (Upper Case) | ||
8 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
9 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
10 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Transaction Category | CRMC_SUBOB_CAT | |
11 | CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
12 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
13 | CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
14 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
15 | RECORDMODE | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
16 | NUM_OF_HEAD | CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number | ||
17 | OCCURRENCE | CRMT_OCC_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
18 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
19 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
20 | OCCURR_QUOT | CRMT_QUO_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
21 | OCCURR_CONT | CRMT_CON_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
22 | REF_UPDATE | CRMT_FLG_REF_UPDATE_BW | XFELD | CHAR | 1 | 0 | Flag: Ref. Update (Extract Structure Only Partially Filled) | ||
23 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
24 | CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
25 | CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
26 | .INCLUDE | 0 | 0 | IS-T: Document Item Data for BW | |||||
27 | .INCLUDE | 0 | 0 | ORDERADM_I Data for BW DataSources | |||||
28 | ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
29 | ITEM_CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
30 | ITEM_CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
31 | ITEM_CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
32 | ITEM_CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
33 | ORDER_DATE | CRMT_OPPT_ORDER_DATE | DATUM | DATS | 8 | 0 | Posting Date | ||
34 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
35 | ITEM_OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITEM | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | * | |
36 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
37 | NUMBER_OF_I | CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
38 | BW_ASSIGN | CRMT_BW_ASSIGN | CRMT_BW_ASSIGN | CHAR | 1 | 0 | Assign BW and CO | ||
39 | ITM_USAGE | CRMT_ITEM_USAGE | CRM_ITEM_USAGE | CHAR | 2 | 0 | Usage of Higher-Level Item | ||
40 | ITM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CRM_IT_TYPE_USAGE | CHAR | 4 | 0 | Item Category Usage | * | |
41 | ALTERNATIVE | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
42 | PARENT | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
43 | ITM_BP | CRM_ISU_PARTNER_NO | CRM_ISU_PARTNER_NO | CHAR | 10 | 0 | Partner Number | ||
44 | ITEM_CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
45 | ITEM_CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
46 | ORDER_DATE_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
47 | DESCRIPTION | CRMT_PRSHTEXTX_DB | CRM_PRSHTEXT40_DB | CHAR | 40 | 0 | Product Short Text | ||
48 | PRODUCT | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 | ||
49 | NUM_OF_MAIN_I | CRM_IST_NUM_OF_MAIN_I | INT4 | INT4 | 10 | 0 | IS-T: Number of Main Items | ||
50 | .INCLUDE | 0 | 0 | IS-T: Document Flow for BW | |||||
51 | PRED_ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
52 | MKT_ELEMENT | CRM_MKTPL_MKT_PLAN_TASKID | CGPL_EXTID | CHAR | 24 | 0 | Marketing Plan Element | ||
53 | .INCLUDE | 0 | 0 | IS-T: Installation Component in the Order for BW | |||||
54 | IB_IOBJ_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
55 | IB_GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
56 | .INCLUDE | 0 | 0 | IS-T: Dates for BW | |||||
57 | BEGIN_DATE | CRMT_BEGIN_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Contract Start Date | ||
58 | ENDING_DATE | CRMT_ENDING_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Contract End Date | ||
59 | PLANNED_BEG_DATE | CRM_IST_PLANNED_FROM_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | IS-T: Contract Validity Start | ||
60 | PLANNED_END_DATE | CRM_IST_PLANNED_END_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | IS-T: Contract Validity End | ||
61 | BEGIN_TIMESLICE | CRM_IST_BEGIN_TIMESLICE | CRM_RPRTNG_DATE | DATS | 8 | 0 | IS-T: Start of Contract Time Slice | ||
62 | END_TIMESLICE | CRM_IST_END_TIMESLICE | CRM_RPRTNG_DATE | DATS | 8 | 0 | IS-T: End of Contract Time Slice | ||
63 | CANC_DATE | CRM_IST_CANC_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | IS-T: Cancellation Date | ||
64 | .INCLUDE | 0 | 0 | IS-T: Billing Data for BW | |||||
65 | BUAG_GUID | CRMT_BUAG_GUID | SYSUUID | RAW | 16 | 0 | GUID of the Business Agreement | ||
66 | .INCLUDE | 0 | 0 | IS-T: Partner Functions for BW | |||||
67 | .INCLUDE | 0 | 0 | PARTNER (General) Data for BW DataSoures | |||||
68 | SALES_EMPLOYEE | CRMT_SALES_EMPLOYEE | BU_PARTNER | CHAR | 10 | 0 | Employee | * | |
69 | PERSON_RESP | CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
70 | CONTACT_PERSON | CRMT_CONTACT_PERSON | BU_PARTNER | CHAR | 10 | 0 | Customer Contact Person | * | |
71 | SALESPARTNER | CRMT_SALESPARTNER | BU_PARTNER | CHAR | 10 | 0 | Sales Partners | * | |
72 | RESP_GROUP_RFW | CRMT_RESPONSIBLE_GROUP | BU_PARTNER | CHAR | 10 | 0 | Responsible Group | * | |
73 | PLANNING_ACCOUNT | CRMT_PLANNING_ACCOUNT | BU_PARTNER | CHAR | 10 | 0 | Planning Account | * | |
74 | .INCLUDE | 0 | 0 | PARTNER (Sales) Data for BW DataSources | |||||
75 | SOLD_TO_PARTY | CRMT_SOLD_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party | * | |
76 | SHIP_TO_PARTY | CRMT_SHIP_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Ship-To Party | * | |
77 | BILL_TO_PARTY | CRMT_BILL_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Bill-To Party | * | |
78 | PAYER | CRMT_RP_PAYER | BU_PARTNER | CHAR | 10 | 0 | Payer | * | |
79 | SOLD_FROM | CRMT_SOLD_FROM_PARTY_ID | BU_PARTNER | CHAR | 10 | 0 | Salesperson ID | * | |
80 | RESP_AT_PART | CRMT_RESPONSIBLE_AT_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Person Responsible at Partners (Channel Management) | * | |
81 | .INCLUDE | 0 | 0 | ORGMAN Data for BW DataSources | |||||
82 | SALES_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
83 | SALES_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
84 | SALES_OFFICE | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
85 | SALES_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
86 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
87 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
88 | SERVICE_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
89 | SERVICE_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
90 | PURCH_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
91 | PURCH_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
92 | PURCH_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
93 | IC_BD_CCODE | CRM_IC_BD_CCODE | BUKRS | CHAR | 4 | 0 | Company Code for a Business Transaction | * | |
94 | IC_BD_LOGSYS | CRM_IC_BD_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System for a Business Transaction | * | |
95 | .INCLUDE | 0 | 0 | Territory Data for BW Data Sources (Partner Attribute) | |||||
96 | PATH_GUID | CRMT_PATH_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Path GUID of Territory 32 | ||
97 | TERR_GUID | CRMT_TERR_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Territory GUID 32 | ||
98 | .INCLUDE | 0 | 0 | IS-T: Status for BW | |||||
99 | BWSTTELSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
100 | BWSTTELSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
101 | BWSTTELSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
102 | BWSTTELSYS3 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
103 | BWSTTELSYS4 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
104 | BWSTTELSYS5 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
105 | BWSTTECSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
106 | BWSTLOCSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
107 | .INCLUDE | 0 | 0 | IS-T: Enhancement to the Order Item for BW | |||||
108 | EXT_REF_NUMBER | IST_EXT_REF | IST_EXT_REF | CHAR | 20 | 0 | IS-T Contract Number | ||
109 | ILGUID | COMT_IL_ILGUID | SYSUUID | RAW | 16 | 0 | Internal, Unique ID of a Relationship | ||
110 | PROCESS | IST_ITEM_PROCESS | IST_ITEM_PROCESS | CHAR | 4 | 0 | Process Type | ||
111 | SCORE | IST_PROCESS_SCORE | IST_PROCESS_SCORE | NUMC | 10 | 0 | Process Score | ||
112 | SELTYPE | IST_SELECTION_TYPE | IST_SELECTION_TYPE | CHAR | 1 | 0 | Product Selection Type | ||
113 | PRCPROC | CRMT_IST_PROCESS | CRMD_IST_PROCESS | CHAR | 4 | 0 | IS-T: Pricing Process | ||
114 | .INCLUDE | 0 | 0 | IS-T: Sales Data for BW | |||||
115 | REJECTION | CRMT_REJECTION_CODE | CRM_REJECTION_CODE | CHAR | 2 | 0 | Cancellation Reason Code | * | |
116 | .INCLUDE | 0 | 0 | IS-T: Pricing Data for BW | |||||
117 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
118 | .INCLUDE | 0 | 0 | IS-T: Prices for BW | |||||
119 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
120 | NET_VALUE_MAN | CRMT_NET_VALUE_MAN | WERTV8 | CURR | 15 | 2 | Total Expected Net Value Products in Document Currency | ||
121 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
122 | NET_PRICE | CRMT_NET_PRICE | WERTV8 | CURR | 15 | 2 | Net Price | ||
123 | TAX_AMOUNT | CRMT_TAX_AMOUNT | WERTV8 | CURR | 15 | 2 | Tax amount in document currency |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_IST_BW_ORDER_I | OBJECT_TYPE | CRMC_SUBOB_CAT | SUBOBJ_CATEGORY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 500 |