SAP ABAP Table /CRMBW/OLTP_EXT_SLS_QUOT_VDM (Extract Structure for OLTP Sales Quotation data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-ANA-OR (Application Component) Interactive Reporting
⤷
/CRMBW/OP_REPORTING_VDM (Package) Operational (Interactive) Reporting (HANA VDM based)

⤷

⤷

Basic Data
Table Category | INTTAB | Structure |
Structure | /CRMBW/OLTP_EXT_SLS_QUOT_VDM |
![]() |
Short Description | Extract Structure for OLTP Sales Quotation data |
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 | ![]() |
CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
2 | ![]() |
CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
3 | ![]() |
CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
4 | ![]() |
CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
5 | ![]() |
CRMT_SOLD_TO_PARTY_ID | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party ID | * | |
6 | ![]() |
CRMT_CONTACT_PERSON | BU_PARTNER | CHAR | 10 | 0 | Customer Contact Person | * | |
7 | ![]() |
CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
8 | ![]() |
CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
9 | ![]() |
CRMT_BSP_VALID_FROM | DATUM | DATS | 8 | 0 | "Valid From" Date | ||
10 | ![]() |
CRMT_BSP_VALID_TO | DATUM | DATS | 8 | 0 | "Valid To" Date | ||
11 | ![]() |
CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
12 | ![]() |
CRMT_SALES_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Organizational Unit (Sales) | ||
13 | ![]() |
CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
14 | ![]() |
CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
15 | ![]() |
CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
16 | ![]() |
CRMT_PO_NUMBER_UC | CHAR35 | CHAR | 35 | 0 | Sold-to Party's External Reference No. (in Capital Letters) | ||
17 | ![]() |
CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
18 | ![]() |
CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
19 | ![]() |
CRMT_PO_DATE_SOLD | DATUM | DATS | 8 | 0 | Reference Document Date | ||
20 | ![]() |
CRMT_RESPONSIBLE_AT_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Person Responsible at Partners (Channel Management) | * | |
21 | ![]() |
CMST_CHANNEL_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Channel Partner | * | |
22 | ![]() |
CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
23 | ![]() |
CRMT_COUNTRY | LAND1 | CHAR | 3 | 0 | Country | * | |
24 | ![]() |
CRMT_REGION | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
25 | ![]() |
CHM_PARTNER_PROGRAM | CHM_PARTNER_PROGRAM | CHAR | 4 | 0 | Channel Management - Channel Partner Programm | * | |
26 | ![]() |
CHM_PARTNER_TYPE | CHM_PARTNER_TYPE | CHAR | 4 | 0 | Channel Management - Channel Partner Type | * | |
27 | ![]() |
CHM_PARTNER_STATUS | CHM_PARTNER_STATUS | CHAR | 4 | 0 | Channel Management - Channel Partner Status | * | |
28 | ![]() |
CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
29 | ![]() |
CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
30 | ![]() |
CRMT_OR_INFOTYPE | CHAR | 30 | 0 | Report Area | |||
31 | ![]() |
CRMT_STATUS_COMMON | CHAR | 13 | 0 | General Status (User, System, Area) | |||
32 | ![]() |
CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number | ||
33 | ![]() |
CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
34 | ![]() |
CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
35 | ![]() |
CRMT_PRODUCT_GUID_DB | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
36 | ![]() |
CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
37 | ![]() |
CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
38 | ![]() |
CRMT_STATUS_ACCEPTED | BOOLEAN | CHAR | 1 | 0 | Status Accepted | ||
39 | ![]() |
CRMT_STATUS_OPEN | CRM_BOOLEAN | CHAR | 1 | 0 | Transaction is Still Open | ||
40 | ![]() |
CRMT_STATUS_REJECTED | BOOLEAN | CHAR | 1 | 0 | Status: Rejected | ||
41 | ![]() |
CRMT_STATUS_CREDIT_OK | BOOLEAN | CHAR | 1 | 0 | Status: Credit Ok | ||
42 | ![]() |
CRMT_STATUS_CREDIT_NOT_OK | BOOLEAN | CHAR | 1 | 0 | Status: Credit Not Ok | ||
43 | ![]() |
CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
44 | ![]() |
CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
45 | ![]() |
CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
46 | ![]() |
CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
47 | ![]() |
CRMT_PROCESS_QTY_NUM | CRM_PROCESS_QTY_NUM | INT4 | 10 | 0 | Numerator (factor) for conversion trans. quantity in BME | ||
48 | ![]() |
CRMT_PROCESS_QTY_DEN | CRM_PROCESS_QTY_DEN | INT4 | 10 | 0 | Denominator (factor) for conversion trans. quantity in BME | ||
49 | ![]() |
COMT_PRODUCT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of Product | * | |
50 | ![]() |
CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
51 | ![]() |
CRMT_CREATED_AT_DATE | SYDATS | DATS | 8 | 0 | Transaction Was Created on This Date | ||
52 | ![]() |
CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
53 | ![]() |
RSCALYEAR | GJAHR | NUMC | 4 | 0 | Calendar year | ||
54 | ![]() |
RSCALQUART | RSCALQUART | NUMC | 5 | 0 | Calendar year / quarter | ||
55 | ![]() |
RSCALMONTH | RSCALMONTH | NUMC | 6 | 0 | Calendar year / month | ||
56 | ![]() |
RSCALWEEK | RSCALWEEK | NUMC | 6 | 0 | Calendar year / week | ||
57 | ![]() |
RSCALDAY | DATUM | DATS | 8 | 0 | Calendar day | ||
58 | ![]() |
/CRMBW/OLTP_VDM_NV_AQI_DC | CURR | 15 | 2 | Net Value of Accepted Quotation Items (Document Currency) | |||
59 | ![]() |
/CRMBW/OLTP_VDM_NV_EQI_DC | CURR | 15 | 2 | Net Value of Expired Quotation Items (Document Currency) | |||
60 | ![]() |
/CRMBW/OLTP_VDM_NV_OQI_DC | CURR | 15 | 2 | Net Value of Open Quotation Items (Document Currency) | |||
61 | ![]() |
/CRMBW/OLTP_VDM_NV_RQI_DC | CURR | 15 | 2 | Net Value of Rejected Quotation Items (Document Currency) | |||
62 | ![]() |
/CRMBW/OLTP_VDM_NV_QUOI_DC | CURR | 15 | 2 | Net Value Quotation Items (Document Currency) | |||
63 | ![]() |
/CRMBW/OLTP_VDM_GR_QUOI_DC | CURR | 15 | 2 | Gross Value Quotation Items (Document Currency) | |||
64 | ![]() |
/CRMBW/OLTP_VDM_NETVAQI | CURR | 15 | 2 | Net Value of Accepted Quotation Items | |||
65 | ![]() |
/CRMBW/OLTP_VDM_NETVEQI | CURR | 15 | 2 | Net Value of Expired Quotation Items | |||
66 | ![]() |
/CRMBW/OLTP_VDM_NETVOQI | CURR | 15 | 2 | Net Value of Open Quotation Items | |||
67 | ![]() |
/CRMBW/OLTP_VDM_NETRQI | CURR | 15 | 2 | Net Value of Rejected Quotation Items | |||
68 | ![]() |
/CRMBW/OLTP_VDM_NUMAQI | INT4 | INT4 | 10 | 0 | No. of Accepted Quotation Items | ||
69 | ![]() |
/CRMBW/OLTP_VDM_NUMEQI | INT4 | INT4 | 10 | 0 | No. of Expired Quotation Items | ||
70 | ![]() |
/CRMBW/OLTP_VDM_NUMOQI | INT4 | INT4 | 10 | 0 | No. of Open Quotation Items | ||
71 | ![]() |
/CRMBW/OLTP_VDM_NUMTRQI | INT4 | INT4 | 10 | 0 | No. of Rejected Quotation Items | ||
72 | ![]() |
/CRMBW/OLTP_VDM_QUOT_IS_ACCEP | BOOLEAN | CHAR | 1 | 0 | Quotation is Accepted (all Quotation Items are Accepted) | ||
73 | ![]() |
CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
74 | ![]() |
/CRMBW/OLTP_VDM_SEL_GUID_CHAR | CHAR | 32 | 0 | Selection GUID as char | |||
75 | ![]() |
CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 703 |