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 Sales contract 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 |
CONTACT_PERSON |
|
CRMT_CONTACT_PERSON |
BU_PARTNER |
CHAR |
10 |
0 |
Customer Contact Person |
* |
8 |
PERSON_RESP |
|
CRMT_PERSON_RESP |
BU_PARTNER |
CHAR |
10 |
0 |
Employee Responsible |
* |
9 |
VALID_FROM |
|
CRMT_BSP_VALID_FROM |
DATUM |
DATS |
8 |
0 |
"Valid From" Date |
|
10 |
VALID_TO |
|
CRMT_BSP_VALID_TO |
DATUM |
DATS |
8 |
0 |
"Valid To" Date |
|
11 |
STATUS |
|
CRM_J_STATUS |
CRM_J_STATUS |
CHAR |
5 |
0 |
Object Status |
|
12 |
USER_STAT_PROC |
|
CRM_J_STSMA |
CRM_J_STSMA |
CHAR |
8 |
0 |
Status Profile |
* |
13 |
SALES_ORG_RESP |
|
CRMT_SALES_ORG_RESP |
HROBJEC_14 |
CHAR |
14 |
0 |
Organizational Unit (Sales) |
|
14 |
SALES_ORG |
|
CRMT_SALES_ORG |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Organization ID |
|
15 |
SALES_OFFICE |
|
CRMT_SALES_OFFICE |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Office |
|
16 |
SALES_GROUP |
|
CRMT_SALES_GROUP |
HROBJEC_14 |
CHAR |
14 |
0 |
Sales Group |
|
17 |
DIS_CHANNEL |
|
CRMT_DISTRIBUTION_CHANNEL |
CRM_DISTRIBUTION_CHANNEL |
CHAR |
2 |
0 |
Distribution Channel |
* |
18 |
DIVISION |
|
CRMT_DIVISION |
CRM_DIVISION |
CHAR |
2 |
0 |
Division |
* |
19 |
PO_NUMBER_UC |
|
CRMT_PO_NUMBER_UC |
CHAR35 |
CHAR |
35 |
0 |
Sold-to Party's External Reference No. (in Capital Letters) |
|
20 |
CURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
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 |
CANCPARTY |
|
CRMT_CANC_PARTY |
CRM_CANC_PARTY |
CHAR |
4 |
0 |
Cancelling Party |
|
29 |
CANC_REASON |
|
CRMT_SRV_CANCEL_REASON |
QCODE |
CHAR |
4 |
0 |
CRM Service : Reason for Cancellation |
* |
30 |
NUMSLSO_SUCC_CON |
|
CRMT_NUMSLSO_SUCC_CON |
INT4 |
INT4 |
10 |
0 |
No. of Sales Orders Succeeding Customer Contract |
|
31 |
PATH_ID |
|
CRMT_TERRITORY_PATH_ID |
CRM_TERRITORY_PATH_ID |
CHAR |
30 |
0 |
Territory Hierarchy ID |
|
32 |
TERR_ID |
|
CRMT_TERRITORY_ID |
CRM_TERRITORY_ID |
CHAR |
30 |
0 |
Territory ID |
|
33 |
STAT_CREDIT |
|
CRMT_STATUS_CRED |
CRMT_STATUS_CRED |
CHAR |
1 |
0 |
Credit Block on Transaction |
|
34 |
STAT_OPEN |
|
CRMT_STATUS_OPEN |
CRM_BOOLEAN |
CHAR |
1 |
0 |
Transaction is Still Open |
|
35 |
STAT_REJECTED |
|
CRMT_STATUS_REJECTED |
BOOLEAN |
CHAR |
1 |
0 |
Status: Rejected |
|
36 |
.INCLUDE |
|
|
|
|
0 |
0 |
EEW Include |
|
37 |
R_SLSCONTR_DUMMY |
|
DUMMY |
DUMMY |
CHAR |
1 |
0 |
Dummy function in length 1 |
|
38 |
.INCLUDE |
|
|
|
|
0 |
0 |
|
|
39 |
.INCLUDE |
|
|
|
|
0 |
0 |
ADVS Selection fields for Local BI Reporting |
|
40 |
USERNAME |
|
USERNAME |
USERNAME |
CHAR |
12 |
0 |
User name |
|
41 |
SELECTION_ID |
|
NUMC4 |
NUMC4 |
NUMC |
4 |
0 |
Count parameters |
|
42 |
LOG_SYSTEM |
|
LOGSYS |
LOGSYS |
CHAR |
10 |
0 |
Logical system |
* |
43 |
APP_SERVER |
|
SYHOST |
HOST_ID |
CHAR |
32 |
0 |
Application Server |
|
44 |
STATUS_COMMON |
|
CRMT_STATUS_COMMON |
|
CHAR |
13 |
0 |
General Status (User, System, Area) |
|
45 |
NUM_OF_HEAD |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
46 |
NUM_OF_CANCEL_H |
|
CRMT_NUMBER_OF_H |
INT4 |
INT4 |
10 |
0 |
Order Header Number |
|
47 |
.INCLUDE |
|
|
|
|
0 |
0 |
Field Catalog: Fields for Sales Contract Extraction Item |
|
48 |
ITEM_GUID |
|
CRMT_PROCESS_GUID_32 |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for a Transaction |
|
49 |
.INCLUDE |
|
|
|
|
0 |
0 |
Internal Structure for Sales Contract items |
|
50 |
NUMBER_INT |
|
CRMT_ITEM_NO |
CRM_ITEM_NO |
NUMC |
10 |
0 |
Item Number in Document |
|
51 |
PRODUCT_ID |
|
CRMT_ORDERED_PROD |
CRM_ORDERED_PROD |
CHAR |
54 |
0 |
Product Name Entered |
|
52 |
PRODUCT |
|
CRMT_PRODUCT_GUID_DB |
SYSUUID |
RAW |
16 |
0 |
Internal Unique ID of Product |
|
53 |
CATEGORY_GUID |
|
COMT_CATEGORY_GUID |
SYSUUID |
RAW |
16 |
0 |
Category GUID |
|
54 |
PROD_HIERARCHY |
|
CRMT_PROD_HIERARCHY |
COM_CATEGORY_ID |
CHAR |
20 |
0 |
Product Category |
|
55 |
STAT_REJECTED_I |
|
CRMT_STATUS_REJECTED |
BOOLEAN |
CHAR |
1 |
0 |
Status: Rejected |
|
56 |
STAT_CREDIT_OK_I |
|
CRMT_STATUS_CREDIT_OK |
BOOLEAN |
CHAR |
1 |
0 |
Status: Credit Ok |
|
57 |
STAT_CRDT_N_OK_I |
|
CRMT_STATUS_CREDIT_NOT_OK |
BOOLEAN |
CHAR |
1 |
0 |
Status: Credit Not Ok |
|
58 |
TARGET_VALUE |
|
CRMT_TARGET_VALUE |
WERTV10 |
CURR |
19 |
2 |
Target Value for Contracts |
|
59 |
TARGET_CURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
60 |
NET_VALUE_MAN |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|
61 |
TARGET_QUANTITY |
|
CRMT_SCHEDLIN_QUAN |
MENG13 |
QUAN |
13 |
3 |
CRM Schedule Line Quantity |
|
62 |
TARGET_UNIT |
|
CRMT_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in Which the Product Is Sold |
* |
63 |
BASE_QTY_UNIT |
|
COMT_PRODUCT_BASE_UOM |
MEINS |
UNIT |
3 |
0 |
Base Unit of Measure of Product |
* |
64 |
PROCESS_QTY_NUM |
|
CRMT_PROCESS_QTY_NUM |
CRM_PROCESS_QTY_NUM |
INT4 |
10 |
0 |
Numerator (factor) for conversion trans. quantity in BME |
|
65 |
PROCESS_QTY_DEN |
|
CRMT_PROCESS_QTY_DEN |
CRM_PROCESS_QTY_DEN |
INT4 |
10 |
0 |
Denominator (factor) for conversion trans. quantity in BME |
|
66 |
CANCPARTY_I |
|
CRMT_CANC_PARTY |
CRM_CANC_PARTY |
CHAR |
4 |
0 |
Cancelling Party |
|
67 |
CANC_REASON_I |
|
CRMT_SRV_CANCEL_REASON |
QCODE |
CHAR |
4 |
0 |
CRM Service : Reason for Cancellation |
* |
68 |
RELEASED_VALUE |
|
CRMT_CUM_VALUE |
CRM_COND_VALUE |
CURR |
19 |
2 |
Cumulative Value |
|
69 |
RELEASEDCURRENCY |
|
CRMT_CURRENCY |
WAERS |
CUKY |
5 |
0 |
Currency |
* |
70 |
RELEASEDQUANTITY |
|
CRMT_CUM_QUAN |
CRM_MENGV15 |
QUAN |
15 |
3 |
CRM Quantity for Cumulated I |
|
71 |
RELEASED_UNIT |
|
CRMT_PROCESS_QTY_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure in Which the Product Is Sold |
* |
72 |
CREATEDATDATE_I |
|
CRMT_CREATED_AT_DATE |
SYDATS |
DATS |
8 |
0 |
Transaction Was Created on This Date |
|
73 |
NUMBER_OF_I |
|
CRMT_NUMBER_OF_I |
INT4 |
INT4 |
10 |
0 |
Order Item Number |
|
74 |
NUM_OF_CANCEL_I |
|
CRMT_NUMBER_OF_I |
INT4 |
INT4 |
10 |
0 |
Order Item Number |
|
75 |
NET_VAL_MAN_CANC |
|
CRMT_NET_VALUE_MAN |
WERTV8 |
CURR |
15 |
2 |
Total Expected Net Value Products in Document Currency |
|