/SCMTMS/D_SCHDPR

Rules to calculate departures | #masterdata | Component: Schedule
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
Column Name Description
📏 Unit of Measure (QUAN_COST_UOM):
QUAN_COST MTr-Specific Costs per Quantity
📏 Gross Weight Unit of Measure (GRO_WEI_UNI):
GRO_WEI_VAL Gross Weight
📏 Gross Volume Unit of Measure (GRO_VOL_UNI):
GRO_VOL_VAL Gross Volume
📏 Net Weight Unit of Measure (NET_WEI_UNI):
NET_WEI_VAL Net Weight
📏 Quantity Unit of Measure (QUA_PCS_UNI):
QUA_PCS_VAL Quantity
📏 Alternative Quantity 2 Unit of Measure (QUA_PCS2_UNI):
QUA_PCS2_VAL Alternative Quantity
📏 Base Unit of Measure (BASE_UOM_UNI):
BASE_UOM_VAL Base Quantity
📏 Tare Weight Unit of Measure (PKGUN_WEI_UNI):
PKGUN_WEI_VAL Tare Weight
📏 Number of TEU Unit of Measure (CONT_CNT_UNI):
CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (DG_ADR_PTS_UNI):
DG_ADR_PTS_VAL ADR 1.1.3.6 DG Exemption Points
📏 Unit of Measure of Normalized Load Consumption Quantity (NORMLOADCONSUNI):
NORMLOADCONSVAL Normalized Load Consumption Quantity
Column Name Description
VAL_FROM Schedule Validity: First Day
VAL_TO Schedule Validity: Last Day
DEPARTURE_TIME Time in Departure Rule
ARRIVAL_TIME Arrival Time in Departure Rule
CUT_OFF_TIME Cargo Cut-Off Time
DOC_CUT_OFF_TIME Document Cut-Off Time
DG_DOC_CUT_OFF_T Dangerous Goods Document Cut-Off Time
AVAIL_TIME Availability Time
_DATAAGING Data Filter Value for Data Aging
Column Name Description
FREQUENCY Departure Frequency Show values
DAY_WEEK Day of the Week Show values
MONDAY Monday Show values
TUESDAY Tuesday Show values
WEDNESDAY Wednesday Show values
THURSDAY Thursday Show values
FRIDAY Friday Show values
SATURDAY Saturday Show values
SUNDAY Sunday Show values
OPERATING_CARRIER Executing Carrier of a Schedule Show values
REF_DATA_STATUS Referenced Data Status Show values
DEL_FLAG Schedule Node Is to Be Deleted Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
RULE_ID Counter for Departure Rules INT2
MTR Means of Transport /SAPAPO/TR_TRATY
TZONE Time Zone TZNZONE
TZONE_ARR Time Zone TZNZONE
CALENDAR Factory Calendar for Schedule Departures WFCID
ARRIVAL_OFF_DAYS Schedule Arrival Offset (Days) /SCMTMS/SCH_OFFSET
TRANSIT_TIME Transit Time TSTRDURAN
VESSEL Vessel /SCMTMS/VESSEL_ID
IMO_ID IMO Ship Identification Number /SCMTMS/IMO_ID
TSP_SCAC Standard Carrier Alpha Code /SCMTMS/SCACD
VOYAGE Voyage / Train Number /SCMTMS/VOYAGE_ID
FLIGHT_NO Flight Number (Numerical) /SCMTMS/FLIGHT_NUMBER
DEP_RULE_REF Reference to a Departure Rule of Another Schedule
START_SCH_LOC_KEY NodeID /BOBF/CONF_KEY
START_LOC_UUID Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
DEST_SCH_LOC_KEY NodeID /BOBF/CONF_KEY
DEST_LOC_UUID Location GUID (004) with Conversion Exit /SCMTMS/LOCUUID
STAGE_TYPE Stage Type /SCMTMS/STAGE_TYPE
REL_CARG_CO Relative Cargo Cut-Off TSTRDURAN
CUT_OFF_DAYS Cargo Cut-Off (Offset in Days)
REL_DOC_CO Relative Document Cut-Off TSTRDURAN
DOC_CUT_OFF_DAYS Document Cut-Off (Offset in Days)
REL_DG_CO Relative Dangerous Goods Cut-Off TSTRDURAN
DG_DOC_CUT_OFF_D Dangerous Goods Documents Cut-Off (Offset in Days)
AVAIL_REL Relative Availability Time TSTRDURAN
AVAIL_DAYS Days to Availability
FIX_COST Fixed Means-of-Transport-Specific Costs SMENG13
EEW_SCH_DEP_RULE Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Airline Code