/SCMTMS/D_SCHDPR - Rules to calculate departures

Rules to calculate departures information is stored in SAP table /SCMTMS/D_SCHDPR.
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_SCHDPR

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DB_KEYNodeIDX/BOBF/CONF_KEYRAW16
PARENT_KEYNodeID/BOBF/CONF_KEYRAW16
.INCLUDE/SCMTMS/S_SCH_DEP_RULES0
RULE_IDCounter for Departure Rules/SCMTMS/SCH_DEP_RULE_IDINT22
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*
TZONETime ZoneTIMEZONECHAR12*
TZONE_ARRTime ZoneTIMEZONECHAR12*
CALENDARFactory Calendar for Schedule Departures/SCMTMS/SCH_DEP_RULE_CALENDARCHAR4*
FREQUENCYDeparture Frequency/SCMTMS/SCH_FREQUENCYCHAR2
DAY_WEEKDay of the Week/SCMTMS/SCH_WEEKDAYCHAR2
.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
DEPARTURE_TIMETime in Departure Rule/SCMTMS/SCH_RULE_DEP_TIMETIMS12
ARRIVAL_TIMEArrival Time in Departure Rule/SCMTMS/SCH_RULE_ARRIVAL_TIMETIMS12
ARRIVAL_OFF_DAYSSchedule Arrival Offset (Days)/SCMTMS/SCH_ARRIVAL_OFFSET_DAYINT22
TRANSIT_TIMETransit Time/SCMTMS/SCH_TRANSIT_TIMEDEC6
VESSELVessel/SCMTMS/VESSEL_IDCHAR70
IMO_IDIMO Ship Identification Number/SCMTMS/IMO_IDCHAR22
TSP_SCACStandard Carrier Alpha Code/SCMTMS/SCACDCHAR8
OPERATING_CARRIERExecuting Carrier of a Schedule/SCMTMS/SCH_OPERATING_CARRIERCHAR2
VOYAGEVoyage / Train Number/SCMTMS/VOYAGE_IDCHAR20
.INCLUDEAIR/SCMTMS/S_SCH_DEP_RULE_AIR0
AIRCRAFT_TCIATA Aircraft Type Code/SCMTMS/AIRCRAFTCODECHAR6*
TSP_AIRLCIATA Airline Code/SCMTMS/AIRLCCHAR6/SCMTMS/C_AIRLC
FLIGHT_NOFlight Number (Numerical)/SCMTMS/FLIGHT_NUMBERCHAR10
DEP_RULE_REFReference to a Departure Rule of Another Schedule/SCMTMS/SCH_RULE_REFRAW16
REF_DATA_STATUSReferenced Data Status/SCMTMS/SCH_REF_DATA_STATUSCHAR2
START_SCH_LOC_KEYNodeID/BOBF/CONF_KEYRAW16
START_LOC_UUIDLocation GUID (004) with Conversion Exit/SCMTMS/LOCUUIDRAW16
DEST_SCH_LOC_KEYNodeID/BOBF/CONF_KEYRAW16
DEST_LOC_UUIDLocation GUID (004) with Conversion Exit/SCMTMS/LOCUUIDRAW16
STAGE_TYPEStage Type/SCMTMS/STAGE_TYPECHAR6
.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
.INCLUDECOSTS/SCMTMS/S_SCH_COSTS0
QUAN_COSTMTr-Specific Costs per Quantity/SCMTMS/SCH_VSR_QUAN_COSTQUAN16
QUAN_COST_UOMUnit of Measure/SCMTMS/MEASUREUNITUNIT6*
FIX_COSTFixed Means-of-Transport-Specific Costs/SCMTMS/VSR_COST_FIXDEC7
.INCLUDECAPA/SCMTMS/S_SCH_QUANTITIES0
.INCLUDE/SCMTMS/S_QUANTITIES0
GRO_WEI_VALGross Weight/SCMTMS/QUA_GRO_WEI_VALQUAN16
GRO_WEI_UNIGross Weight Unit of Measure/SCMTMS/QUA_GRO_WEI_UNIUNIT6*
GRO_VOL_VALGross Volume/SCMTMS/QUA_GRO_VOL_VALQUAN16
GRO_VOL_UNIGross Volume Unit of Measure/SCMTMS/QUA_GRO_VOL_UNIUNIT6*
NET_WEI_VALNet Weight/SCMTMS/QUA_NET_WEI_VALQUAN16
NET_WEI_UNINet Weight Unit of Measure/SCMTMS/QUA_NET_WEI_UNIUNIT6*
QUA_PCS_VALQuantity/SCMTMS/QUA_PCS_VALQUAN16
QUA_PCS_UNIQuantity Unit of Measure/SCMTMS/QUA_PCS_UNIUNIT6*
QUA_PCS2_VALAlternative Quantity/SCMTMS/QUA_PCS2_VALQUAN16
QUA_PCS2_UNIAlternative Quantity 2 Unit of Measure/SCMTMS/QUA_PCS2_UNIUNIT6*
BASE_UOM_VALBase Quantity/SCMTMS/QUA_BASE_UOM_VALQUAN16
BASE_UOM_UNIBase Unit of Measure/SCMTMS/QUA_BASE_UOM_UNIUNIT6*
PKGUN_WEI_VALTare Weight/SCMTMS/QUA_PACK_UNL_WEI_VALQUAN16
PKGUN_WEI_UNITare Weight Unit of Measure/SCMTMS/QUA_PACK_UNL_WEI_UNIUNIT6*
CONT_CNT_VALNumber of Twenty-Foot Equivalent Units/SCMTMS/CONT_COUNT_VALQUAN16
CONT_CNT_UNINumber of TEU Unit of Measure/SCMTMS/CONT_COUNT_UNIUNIT6*
DG_ADR_PTS_VALADR 1.1.3.6 DG Exemption Points/SCMTMS/DG_ADR_POINTS_VALQUAN16
DG_ADR_PTS_UNIUnit of Measure for ADR 1.1.3.6 DG Exemption Points/SCMTMS/DG_ADR_POINTS_UNIUNIT6*
NORMLOADCONSVALNormalized Load Consumption Quantity/SCMTMS/TOR_NORMLOADCONSVALQUAN16
NORMLOADCONSUNIUnit of Measure of Normalized Load Consumption Quantity/SCMTMS/TOR_NORMLOADCONSUNIUNIT6*
DEL_FLAGSchedule Node Is to Be Deleted/SCMTMS/SCH_DEL_FLAGCHAR2
.INCLUDE/SCMTMS/INCL_EEW_SCH_DEP_RULE0
EEW_SCH_DEP_RULEDummy function in length 1DUMMYCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy