1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Survey Details PDO Database Structure |
|
2 |
CLIENT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
* |
3 |
GUID |
|
/SAPSRM/SURVEY_GUID |
UUID |
RAW |
16 |
0 |
Survey Guid |
|
4 |
OBJECT_ID |
|
/SAPSRM/OBJECT_ID |
CRM_OBJECT_ID |
CHAR |
10 |
0 |
Object ID - Procurement Document Number |
|
5 |
NAME |
|
/SAPSRM/SURVEY_NAME |
TEXT40 |
CHAR |
40 |
0 |
Survey Name |
|
6 |
DESCRIPTION |
|
/SAPSRM/SURVEY_DESCRIPTION |
|
STRG |
0 |
0 |
Description of a SRM Survey |
|
7 |
SURVEY_PKG_GUID |
|
/SAPSRM/SURVEY_PKG_GUID |
UUID |
RAW |
16 |
0 |
Survey Package GUID |
|
8 |
STATUS |
|
/SAPSRM/SURVEY_STATUS |
/SAPSRM/SURVEY_STATUS |
CHAR |
5 |
0 |
Survey Status |
|
9 |
QSTN_GUID |
|
/SAPSRM/QSTN_GUID |
UUID |
RAW |
16 |
0 |
GUID of a questionnaire object |
|
10 |
UWS_SURVEY_ID |
|
UXB_ID |
UXB_ID |
CHAR |
64 |
0 |
Object ID |
|
11 |
EVAL_CATEGORY |
|
/SAPSRM/SURVEY_EVAL_CAT |
/SAPSRM/SURVEY_EVAL_CAT |
CHAR |
4 |
0 |
Survey Evaluation Category |
|
12 |
EVAL_AREA |
|
/SAPSRM/SURVEY_EVAL_AREA |
/SAPSRM/SURVEY_EVAL_AREA |
CHAR |
4 |
0 |
Survey Evaluation Area |
|
13 |
SURVEY_MANAGER |
|
/SAPSRM/SURVEY_MANAGER |
BU_PARTNER |
CHAR |
10 |
0 |
Survey Owner |
* |
14 |
ASSISTANT |
|
/SAPSRM/ASSISTANT |
BU_PARTNER |
CHAR |
10 |
0 |
Assistant |
* |
15 |
EVAL_START_DATE |
|
/SAPSRM/SURVEY_EVAL_PRD_START |
DATE |
DATS |
8 |
0 |
Start of Survey Evaluation Period |
|
16 |
EVAL_END_DATE |
|
/SAPSRM/SURVEY_EVAL_PRD_END |
DATE |
DATS |
8 |
0 |
End of Survey Evaluation Period |
|
17 |
SURVEY_DEADLINE |
|
/SAPSRM/SURVEY_DEADLINE |
DATE |
DATS |
8 |
0 |
Survey Deadline |
|
18 |
CREATED_AT |
|
COMT_CREATED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Created At (Output in User Time Zone) |
|
19 |
CREATED_BY |
|
CRMT_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
User that Created the Transaction |
|
20 |
CHANGED_AT |
|
COMT_CHANGED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Changed At (Output in User Time Zone) |
|
21 |
CHANGED_BY |
|
CRMT_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Transaction Last Changed By |
|
22 |
.INCLU-_PT |
|
|
|
|
0 |
0 |
Survey Participant PDO Get Data Structure |
|
23 |
CLIENT_PT |
|
MANDT |
MANDT |
CLNT |
3 |
0 |
Client |
* |
24 |
GUID_PT |
|
/SAPSRM/SURVEY_PRTCPNT_GUID |
UUID |
RAW |
16 |
0 |
Participant GUID |
|
25 |
OBJECT_ID_PT |
|
/SAPSRM/SURVEY_PRTCPNT_ID |
|
CHAR |
10 |
0 |
ID of an SRM Survey Participant |
|
26 |
LASTNAME_PT |
|
/SAPSRM/SURVEY_PRTCPNT_LASTNAM |
NAME |
CHAR |
35 |
0 |
Survey Participant Last Name |
|
27 |
FIRSTNAME_PT |
|
/SAPSRM/SURVEY_PRTCPNT_FIRSTNA |
NAME |
CHAR |
35 |
0 |
Survey Participant First Name |
|
28 |
EMAIL_PT |
|
/SAPSRM/SURVEY_PRTCPNT_MAIL |
AD_SMTPADR |
CHAR |
241 |
0 |
Survey Participant email address |
|
29 |
PREF_LANGUAGE_PT |
|
/SAPSRM/SURVEY_PRTCPNT_LANGU |
LANGU |
LANG |
1 |
0 |
Survey Participant Language |
|
30 |
EVAL_CATEGORY_PT |
|
/SAPSRM/SURVEY_EVAL_CAT |
/SAPSRM/SURVEY_EVAL_CAT |
CHAR |
4 |
0 |
Survey Evaluation Category |
|
31 |
PHONE_PT |
|
/SAPSRM/SURVEY_PRTCPNT_PHONE |
CHAR30 |
CHAR |
30 |
0 |
Survey Participant telephone number |
|
32 |
PLANT_PT |
|
/SAPSRM/SURVEY_PRTCPNT_PLANT |
WERKS |
CHAR |
4 |
0 |
Survey Participant Plant/Location |
* |
33 |
ROLE_PT |
|
/SAPSRM/SURVEY_PRTCPNT_ROLE |
TEXT35 |
CHAR |
35 |
0 |
Survey Participant Role |
|
34 |
PTYPE_PT |
|
/SAPSRM/SURVEY_PARTICIPANT_TYP |
/SAPSRM/SURVEY_PARTICIPANT_TYP |
CHAR |
1 |
0 |
Type of a Participant of a SRM Survey |
|
35 |
SUPPLIER_ID_PT |
|
/SAPSRM/SURVEY_SUPPLIER_ID |
BU_PARTNER |
CHAR |
10 |
0 |
ID of an SRM Supplier |
* |
36 |
SURVEY_GUID_PT |
|
/SAPSRM/SURVEY_GUID |
UUID |
RAW |
16 |
0 |
Survey Guid |
|
37 |
PARMAS_GUID_PT |
|
/SAPSRM/SURVEY_PARMAS_GUID |
UUID |
RAW |
16 |
0 |
Survey Participant Master Guid |
|
38 |
UWS_REC_ID_PT |
|
UXP_GUID |
|
CHAR |
32 |
0 |
GUID |
|
39 |
CREATED_AT_PT |
|
COMT_CREATED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Created At (Output in User Time Zone) |
|
40 |
CREATED_BY_PT |
|
CRMT_CREATED_BY |
UNAME |
CHAR |
12 |
0 |
User that Created the Transaction |
|
41 |
CHANGED_AT_PT |
|
COMT_CHANGED_AT_USR |
COM_TSTMP |
DEC |
15 |
0 |
Changed At (Output in User Time Zone) |
|
42 |
CHANGED_BY_PT |
|
CRMT_CHANGED_BY |
UNAME |
CHAR |
12 |
0 |
Transaction Last Changed By |
|