| 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 |
|