/SCMTMS/D_INSDET - Instructions
Instructions information is stored in SAP table /SCMTMS/D_INSDET.
It is part of development package /SCMTMS/INSTRUCTION in software component TM-CF-INS. This development package consists of objects that can be grouped under "Instructions".
It is part of development package /SCMTMS/INSTRUCTION in software component TM-CF-INS. This development package consists of objects that can be grouped under "Instructions".
Fields for table /SCMTMS/D_INSDET
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
DB_KEY | NodeID | X | /BOBF/CONF_KEY | RAW | 16 | |
PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
.INCLUDE | /SCMTMS/S_INS_DETAILS | 0 | ||||
.INCLUDE | /SCMTMS/S_INS_LEAD_ATTRIBUTES | 0 | ||||
LEAD_BO_KEY | Business Object | /BOBF/OBM_BO_KEY | RAW | 16 | ||
LEAD_ROOT_KEY | Node | /BOBF/OBM_NODE_KEY | RAW | 16 | ||
LEAD_ROOT_INST_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
LEAD_NODE_KEY | Node | /BOBF/OBM_NODE_KEY | RAW | 16 | ||
LEAD_NODE_INST_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
TYPE | Type of FWO, FWQ, or Transportation Requirement | /SCMTMS/TRQ_TYPE | CHAR | 8 | * | |
ITEM_TYPE | Item Type for Items in FWOs or FWQs | /SCMTMS/TRQ_ITEM_TYPE | CHAR | 8 | ||
ITEM_ID | Item | /SCMTMS/ITEM_ID | CHAR | 20 | ||
STAGE_ID | Transportation Stage ID | /SCMTMS/TRANSPORTATIONSTAGEID | CHAR | 20 | ||
STAGE_TYPE | Stage Type | /SCMTMS/STAGE_TYPE | CHAR | 6 | ||
SHIPPING_TYPE | Shipping Type | /SCMTMS/SHIPPING_TYPE | CHAR | 6 | ||
SERVICE_TYPE | Service Type | /SCMTMS/TRANSPSERV_REQ_CODE | CHAR | 20 | ||
FU_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
INS_SET_ID | Instruction Set | /SCMTMS/INS_SET_ID | CHAR | 20 | * | |
INS_ID | Instruction | /SCMTMS/INS_ID | CHAR | 20 | /SCMTMS/C_INS | |
INS_ROLE | Responsible Role | /SCMTMS/INS_ROLE | CHAR | 60 | * | |
INS_USER | User Responsible | /SCMTMS/INS_USER | CHAR | 24 | ||
STATUS | Instruction Status | /SCMTMS/INS_STATUS | CHAR | 2 | ||
SEQ_NUMBER | Sequence | /SCMTMS/INS_SEQ_NUMBER | NUMC | 10 | ||
NOTE | Note | /SCMTMS/INSTRUCTION_NOTE | CHAR | 2048 | ||
INS_DUMMY | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
.INCLUDE | /SCMTMS/S_INS | 0 | ||||
INS_TYPE | Instruction Type | /SCMTMS/INS_TYPE | CHAR | 4 | ||
INS_ACTIVE | Deactivate | /SCMTMS/INS_ACTIVE | CHAR | 2 | ||
INS_COMPLEXITY | Expertise Level | /SCMTMS/INS_COMPLEXITY | CHAR | 4 | ||
INS_DESCRIPTION | Instruction Description | /SCMTMS/INS_DES | CHAR | 100 | ||
.INCLUDE | /BOFU/S_ADMIN_DATA | 0 | ||||
CREATED_BY | Created By | /BOFU/USER_ID_CREATED_BY | CHAR | 24 | ||
CREATED_ON | Created on | /BOFU/TSTMP_CREATION_TIME | DEC | 8 | ||
CHANGED_BY | Changed By | /BOFU/USER_ID_CHANGED_BY | CHAR | 24 | ||
CHANGED_ON | Changed On | /BOFU/TSTMP_CHANGED_TIME | DEC | 8 | ||
.INCLUDE | /SCMTMS/INCL_EEW_INS_DETAILS | 0 | ||||
EEW_INS_DETAILS | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
.INCLUDE | /SCMTMS/S_INS_DATE_ATTRIBUTES | 0 | ||||
DUE_DATE_OFFSET | Offset Days | /SCMTMS/INS_DUE_DATE | INT1 | 1 | ||
DUE_HRS | Offset Hours | /SCMTMS/INS_DUE_HOURS | NUMC | 4 | ||
DUE_MINUTES | Offset Minutes | /SCMTMS/INS_DUE_MINS | NUMC | 4 | ||
DUE_DATE_DIR | Before/After | /SCMTMS/INS_OFFSET_DIR | CHAR | 2 | ||
DUE_DATE_REF | Reference Date | /SCMTMS/INS_DUDATE_REF | CHAR | 6 | ||
ALERT_OFFSET | Offset Days | /SCMTMS/INS_ALERT_OFFSET | INT1 | 1 | ||
ALERT_HRS | Offset Hours | /SCMTMS/INS_ALERT_HOURS | NUMC | 4 | ||
ALERT_MINUTES | Offset Minutes | /SCMTMS/INS_ALERT_MINS | NUMC | 4 | ||
ALERT_DIR | Before/After | /SCMTMS/INS_ALERT_OFFSET_DIR | CHAR | 2 | ||
RELATIVE_DATE | Select Date Type | /SCMTMS/INS_REL_DATE_FLAG | CHAR | 2 | ||
DUE_DATE | Due Date | /SCMTMS/INS_DUE_DATE_TSTAMP | DEC | 8 | ||
ALERT_DATE | Alert Date | /SCMTMS/INS_ALERT_DATE_TSTAMP | DEC | 8 | ||
COMPLETION_DATE | Completion Date | /SCMTMS/INS_COMPL_DATE_TSTAMP | DEC | 8 | ||
INS_NOTE_CHANGE | Checks If Instruction Note Is Edited | /SCMTMS/INS_NOTE_CHANGE | CHAR | 2 | ||
INS_DESCRIPTION_CHANGE | Checks If Instruction Description Is Edited | /SCMTMS/INS_DES_CHANGE | CHAR | 2 | ||
ABSOLUTE_DATE | Fixed Date Stamp | /SCMTMS/ABS_DATE_TSTAMP | DEC | 8 | ||
NOTE_TEMPLATE_ID | Note Template | /SCMTMS/INS_NOTE_TEMPLATE | CHAR | 140 | ||
INS_UPD_IDENT | Instruction Update Identity | /SCMTMS/INS_UPD_IDENT | CHAR | 2 | ||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |