/SCMTMS/D_SCHDPS - Departure Rule Stage

Departure Rule Stage information is stored in SAP table /SCMTMS/D_SCHDPS.
It is part of development package /SCMTMS/FO_SCHEDULE in software component TM-MD-TN-SCH. This development package consists of objects that can be grouped under "Foundation BO Schedule".

Fields for table /SCMTMS/D_SCHDPS

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DB_KEYNodeIDX/BOBF/CONF_KEYRAW16
ROOT_KEYNodeID/BOBF/CONF_KEYRAW16
PARENT_KEYNodeID/BOBF/CONF_KEYRAW16
.INCLUDE/SCMTMS/S_SCH_DEP_RULE_STAGE0
STAGE_SEQCounter for Location Sequence/SCMTMS/SCH_LOC_CNTINT22
STAGE_START_LOCKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
STAGE_START_LOC_REFKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
VAL_FROMSchedule Validity: First Day/SCMTMS/SCH_VAL_FIRST_DAYDATS16
VAL_TOSchedule Validity: Last Day/SCMTMS/SCH_VAL_LAST_DAYDATS16
MTRMeans of Transport/SCMTMS/TRANSMEANSTYPECODECHAR20
STAGE_TYPEStage Type/SCMTMS/STAGE_TYPECHAR6
TSPCarrier/SCMTMS/TEND_TSP_KEYRAW16
TSP_SCACStandard Carrier Alpha Code/SCMTMS/SCACDCHAR8
OPERATING_CARRIERExecuting Carrier of a Schedule/SCMTMS/SCH_OPERATING_CARRIERCHAR2
VESSELVessel/SCMTMS/VESSEL_IDCHAR70
IMO_IDIMO Ship Identification Number/SCMTMS/IMO_IDCHAR22
.INCLUDEAIR/SCMTMS/S_SCH_DEP_RULE_AIR0
AIRCRAFT_TCIATA Aircraft Type Code/SCMTMS/AIRCRAFTCODECHAR6/SCMTMS/C_AIRCR
TSP_AIRLCIATA Airline Code/SCMTMS/AIRLCCHAR6/SCMTMS/C_AIRLC
FLIGHT_NOFlight Number (Numerical)/SCMTMS/FLIGHT_NUMBERCHAR10
.INCLUDEDAYS/SCMTMS/S_WEEKDAYS0
MONDAYMonday/SCMTMS/WEEKDAY_MONDAYCHAR2
TUESDAYTuesday/SCMTMS/WEEKDAY_TUESDAYCHAR2
WEDNESDAYWednesday/SCMTMS/WEEKDAY_WEDNESDAYCHAR2
THURSDAYThursday/SCMTMS/WEEKDAY_THURSDAYCHAR2
FRIDAYFriday/SCMTMS/WEEKDAY_FRIDAYCHAR2
SATURDAYSaturday/SCMTMS/WEEKDAY_SATURDAYCHAR2
SUNDAYSunday/SCMTMS/WEEKDAY_SUNDAYCHAR2
.INCLU-DEPDEPARTURE/SCMTMS/S_SCH_DRS_TIME0
TIMEDEPTime in Departure Rule/SCMTMS/SCH_RULE_DEP_TIMETIMS12
TZONEDEPTime ZoneTIMEZONECHAR12*
OFFSET_DAYSDEPSchedule Departure Offset in Days/SCMTMS/SCH_DEP_OFFSET_DAYSINT22
STAGE_END_LOCKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
STAGE_END_LOC_REFKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
.INCLU-ARRARRIVAL/SCMTMS/S_SCH_DRS_TIME0
TIMEARRTime in Departure Rule/SCMTMS/SCH_RULE_DEP_TIMETIMS12
TZONEARRTime ZoneTIMEZONECHAR12*
OFFSET_DAYSARRSchedule Departure Offset in Days/SCMTMS/SCH_DEP_OFFSET_DAYSINT22
TRANSIT_TIMETransit Time/SCMTMS/SCH_TRANSIT_TIMEDEC6
STAY_TIMELength of Stay/SCMTMS/SCH_STAY_TIMEDEC6
.INCLUDECARGO_CO/SCMTMS/S_SCH_CARGO_CUTOFF0
REL_CARG_CORelative Cargo Cut-Off/SCMTMS/SCH_CUT_OFF_RELDEC6
CUT_OFF_DAYSCargo Cut-Off (Offset in Days)/SCMTMS/SCH_CUT_OFF_DAYSINT11
CUT_OFF_TIMECargo Cut-Off Time/SCMTMS/SCH_CUT_OFF_TIMETIMS12
.INCLUDEDOC_CO/SCMTMS/S_SCH_DOC_CUTOFF0
REL_DOC_CORelative Document Cut-Off/SCMTMS/SCH_CUT_OFF_REL_DOCDEC6
DOC_CUT_OFF_DAYSDocument Cut-Off (Offset in Days)/SCMTMS/SCH_CUT_OFF_DAYS_DOCINT11
DOC_CUT_OFF_TIMEDocument Cut-Off Time/SCMTMS/SCH_CUT_OFF_TIME_DOCTIMS12
.INCLUDEDG_DOC_CO/SCMTMS/S_SCH_DG_DOC_CUTOFF0
REL_DG_CORelative Dangerous Goods Cut-Off/SCMTMS/SCH_CUT_OFF_REL_DGDEC6
DG_DOC_CUT_OFF_DDangerous Goods Documents Cut-Off (Offset in Days)/SCMTMS/SCH_CUT_OFF_DAYS_DGDOCINT11
DG_DOC_CUT_OFF_TDangerous Goods Document Cut-Off Time/SCMTMS/SCH_CUT_OFF_TIME_DGDOCTIMS12
.INCLUDEAVAILIBILITY/SCMTMS/S_SCH_AVAILIBILITY0
AVAIL_RELRelative Availability Time/SCMTMS/SCH_AVAIL_TIME_RELDEC6
AVAIL_DAYSDays to Availability/SCMTMS/SCH_AVAIL_DAYSINT11
AVAIL_TIMEAvailability Time/SCMTMS/SCH_AVAIL_TIMETIMS12
SCH_REFSchedule Reference/SCMTMS/SCH_REFRAW16
DEP_RULE_REFNodeID/BOBF/CONF_KEYRAW16
REF_DATA_STATUSReferenced Data Status/SCMTMS/SCH_REF_DATA_STATUSCHAR2
.INCLUDE/SCMTMS/INCL_EEW_SCH_DEP_RL_ST0
EEW_SCH_DEP_RLSTDummy function in length 1DUMMYCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy