/SCMTMS/D_DEMHOR - Root Node of VSR Demand Horizon profile
Root Node of VSR Demand Horizon profile information is stored in SAP table /SCMTMS/D_DEMHOR.
It is part of development package /SCMTMS/PLN_PROF_BO_SEL in software component TM-PLN-PS. This development package consists of objects that can be grouped under "Profile BO - Selection Profiles".
It is part of development package /SCMTMS/PLN_PROF_BO_SEL in software component TM-PLN-PS. This development package consists of objects that can be grouped under "Profile BO - Selection Profiles".
Fields for table /SCMTMS/D_DEMHOR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DEMAND_HORI_ID | Time-Related Selection Attributes | X | /SCMTMS/DEMAND_HORIZON_ID | CHAR | 80 | |
| DB_KEY | NodeID | X | /BOBF/CONF_KEY | RAW | 16 | |
| DEMAND_HOR_DESCR | Description | /SCMTMS/DEMAND_HORIZON_DESCRIP | CHAR | 160 | ||
| ABS_REL_DE_HORIZ | Absolute or Relative Horizon | /SCMTMS/ABS_REL_HORIZON_INDICA | CHAR | 2 | ||
| PU_IGNORE | Ignore Pick-Up for Selection | /SCMTMS/PROF_IGNORE_PU | CHAR | 2 | ||
| PU_REL_HOR_OFFS | Offset in Days for Demand Horizon (for Pick-Up) | /SCMTMS/PU_REL_HOR_OFFSET | INT2 | 2 | ||
| PU_REL_HOR_OFFSH | Additional Offset | /SCMTMS/REL_HOR_OFFSET_H | DEC | 6 | ||
| PU_REL_HOR_DURA | Pick-Up in Days | /SCMTMS/PU_REL_DURATION | INT2 | 2 | ||
| PU_REL_HOR_DUR_H | Additional Duration (hh:mm) | /SCMTMS/PU_REL_DURATION_HOURS | DEC | 6 | ||
| PU_REL_HOR_FIX_START_TIME | Fixed Start Time | /SCMTMS/FIX_HORIZON_START_TIME | TIMS | 12 | ||
| PU_REL_HOR_FIX_END_TIME | Fixed End Time | /SCMTMS/FIX_HORIZON_END_TIME | TIMS | 12 | ||
| PU_REL_HOR_DIR | Offset Direction | /SCMTMS/PU_REL_HOR_DIRECTION | CHAR | 2 | ||
| DL_IGNORE | Ignore Delivery | /SCMTMS/PROF_IGNORE_DL | CHAR | 2 | ||
| DL_REL_HOR_OFFS | Offset in Days for Demand Horizon (for Delivery) | /SCMTMS/DL_REL_HOR_OFFSET | INT2 | 2 | ||
| DL_REL_HOR_OFFSH | Additional Offset | /SCMTMS/REL_HOR_OFFSET_H | DEC | 6 | ||
| DL_REL_HOR_DURA | Delivery in Days | /SCMTMS/DL_REL_DURATION | INT2 | 2 | ||
| DL_REL_HOR_DUR_H | Additional Duration (hh:mm) | /SCMTMS/PU_REL_DURATION_HOURS | DEC | 6 | ||
| DL_REL_HOR_FIX_START_TIME | Fixed Start Time | /SCMTMS/FIX_HORIZON_START_TIME | TIMS | 12 | ||
| DL_REL_HOR_FIX_END_TIME | Fixed End Time | /SCMTMS/FIX_HORIZON_END_TIME | TIMS | 12 | ||
| DL_REL_HOR_DIR | Offset Direction | /SCMTMS/PU_REL_HOR_DIRECTION | CHAR | 2 | ||
| PU_DL_COMB | Combination of Pick-Up and Delivery Windows | /SCMTMS/PU_DL_COMBINATION | CHAR | 2 | ||
| DEMAND_HOR_CAL | Factory Calendar for Offset/Duration Calculation | /SCMTMS/PROFILE_CALENDAR | CHAR | 4 | TFACD | |
| ROUND_TO_DAY | Round Horizon to Full Days | /SCMTMS/PH_ROUND_TO_FULL_DAY | CHAR | 2 | ||
| ROUND_TZ | Time Zone for Rounding the Horizon | /SCMTMS/PH_ROUNDING_TIMEZONE | CHAR | 12 | ||
| PU_FIX_H_START | Start of the Fixed Demand Horizon for Pick-Up | /SCMTMS/PU_FIXED_HOR_START | DEC | 8 | ||
| PU_FIX_H_END | End of the Fixed Demand Horizon for Pick-Up | /SCMTMS/PU_FIXED_HOR_END | DEC | 8 | ||
| DL_FIX_H_START | Start of the Fixed Demand Horizon for Delivery | /SCMTMS/DL_FIXED_HOR_START | DEC | 8 | ||
| DL_FIX_H_END | End of the Fixed Demand Horizon for Delivery | /SCMTMS/DL_FIXED_HOR_END | DEC | 8 | ||
| USE_INDEX_TIME | Use Index Time for Selection | /SCMTMS/DEM_HOR_USEINDEXTIME | CHAR | 2 | ||
| .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 |