SAP ABAP Table /CRMBW/OLTP_EXT_SLS_ORDER (Extract Structure for OLTP Sales Order Reporting)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-ANA (Application Component) CRM Analytics
⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI
⤷ CRM-ANA (Application Component) CRM Analytics
⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI
Basic Data
Table Category | INTTAB | Structure |
Structure | /CRMBW/OLTP_EXT_SLS_ORDER | Table Relationship Diagram |
Short Description | Extract Structure for OLTP Sales Order Reporting |
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 | OBJECT_KEY | CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
2 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
3 | .INCLUDE | 0 | 0 | Extract Structure for OLTP Slaes Order internal fields | |||||
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
6 | SOLD_TO_PARTY | CRMT_SOLD_TO_PARTY_ID | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party ID | * | |
7 | PERSON_RESP | CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
8 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
9 | STATUS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
10 | USER_STAT_PROC | CRM_J_STSMA | CRM_J_STSMA | CHAR | 8 | 0 | Status Profile | * | |
11 | STAT_OPEN | CRMT_STATUS_OPEN | CRM_BOOLEAN | CHAR | 1 | 0 | Transaction is Still Open | ||
12 | SALES_ORG_RESP | CRMT_SALES_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Organizational Unit (Sales) | ||
13 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
14 | SALES_OFFICE | CRMT_SALES_OFFICE | HROBJEC_14 | CHAR | 14 | 0 | Sales Office | ||
15 | SALES_GROUP | CRMT_SALES_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Sales Group | ||
16 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
17 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
18 | PO_NUMBER_UC | CRMT_PO_NUMBER_UC | CHAR35 | CHAR | 35 | 0 | Sold-to Party's External Reference No. (in Capital Letters) | ||
19 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
20 | PO_DATE_SOLD | CRMT_PO_DATE_SOLD | DATUM | DATS | 8 | 0 | Reference Document Date | ||
21 | RESP_AT_PARTNER | CRMT_RESPONSIBLE_AT_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Person Responsible at Partners (Channel Management) | * | |
22 | CHANNEL_PARTNER | CMST_CHANNEL_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Channel Partner | * | |
23 | SOLD_TO_COUNTRY | CRMT_COUNTRY | LAND1 | CHAR | 3 | 0 | Country | * | |
24 | SOLD_TO_REGION | CRMT_REGION | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
25 | CP_PROGRAM | CHM_PARTNER_PROGRAM | CHM_PARTNER_PROGRAM | CHAR | 4 | 0 | Channel Management - Channel Partner Programm | * | |
26 | CP_TYPE | CHM_PARTNER_TYPE | CHM_PARTNER_TYPE | CHAR | 4 | 0 | Channel Management - Channel Partner Type | * | |
27 | CP_STATUS | CHM_PARTNER_STATUS | CHM_PARTNER_STATUS | CHAR | 4 | 0 | Channel Management - Channel Partner Status | * | |
28 | PATH_ID | CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
29 | TERR_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
30 | .INCLUDE | 0 | 0 | EEW Include | |||||
31 | EEW_R_SAL_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
32 | .INCLUDE | 0 | 0 | ||||||
33 | .INCLUDE | 0 | 0 | ADVS Selection fields for Local BI Reporting | |||||
34 | USERNAME | USERNAME | USERNAME | CHAR | 12 | 0 | User name | ||
35 | SELECTION_ID | NUMC4 | NUMC4 | NUMC | 4 | 0 | Count parameters | ||
36 | LOG_SYSTEM | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
37 | APP_SERVER | SYHOST | HOST_ID | CHAR | 32 | 0 | Application Server | ||
38 | STATUS_COMMON | CRMT_STATUS_COMMON | CHAR | 13 | 0 | General Status (User, System, Area) | |||
39 | NUM_OF_HEAD | CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number | ||
40 | .INCLUDE | 0 | 0 | Field Catalog: Fields for Sales order Extraction Item | |||||
41 | ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
42 | .INCLUDE | 0 | 0 | Internal Structure for Sales order items | |||||
43 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
44 | PRODUCT_ID | CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
45 | PRODUCT | CRMT_PRODUCT_GUID_DB | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
46 | CATEGORY_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
47 | PROD_HIERARCHY | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
48 | STAT_OPEN_I | CRMT_STATUS_OPEN | CRM_BOOLEAN | CHAR | 1 | 0 | Transaction is Still Open | ||
49 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
50 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
51 | QUANTITY | CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
52 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
53 | BASE_QTY_UNIT | COMT_PRODUCT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of Product | * | |
54 | PROCESS_QTY_NUM | CRMT_PROCESS_QTY_NUM | CRM_PROCESS_QTY_NUM | INT4 | 10 | 0 | Numerator (factor) for conversion trans. quantity in BME | ||
55 | PROCESS_QTY_DEN | CRMT_PROCESS_QTY_DEN | CRM_PROCESS_QTY_DEN | INT4 | 10 | 0 | Denominator (factor) for conversion trans. quantity in BME | ||
56 | BILL_VALUE | CRMT_INVOICED_VAL_OLTP | CRM_COND_VALUE | CURR | 19 | 2 | Billed Value of an Item | ||
57 | DELV_QUANTITY | CRMT_CUM_QUAN | CRM_MENGV15 | QUAN | 15 | 3 | CRM Quantity for Cumulated I | ||
58 | DELV_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
59 | BILL_QUANTITY | CRMT_CUM_QUAN | CRM_MENGV15 | QUAN | 15 | 3 | CRM Quantity for Cumulated I | ||
60 | BILL_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
61 | STAT_PART_DELV_I | CRMT_STATUS_PART_DELV | BOOLEAN | CHAR | 1 | 0 | Status: Partially Delivered | ||
62 | STAT_COMP_DELV_I | CRMT_STATUS_COMP_DELV | BOOLEAN | CHAR | 1 | 0 | Status: Completely Delivered | ||
63 | EARLCONF_DATE | CRMT_EARLIEST_CONFIRMED | CRM_RPRTNG_DATE | DATS | 8 | 0 | Earliest Confirmation Date Still Not Delivered | ||
64 | CREATEDATDATE_I | CRMT_CREATED_AT_DATE | SYDATS | DATS | 8 | 0 | Transaction Was Created on This Date | ||
65 | NUMBER_OF_I | CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
66 | O_ORDER_QUAN | CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
67 | O_ORDER_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
68 | NUM_OF_BACKORD_I | CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
69 | O_BILL_VALUE | CRMT_CUM_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Cumulative Value | ||
70 | DELV_VALUE | CRMT_CUM_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Cumulative Value | ||
71 | QUAN_BASE_UN | CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |