/SCMTMS/D_SCHLOC - Location Sequence

Location Sequence information is stored in SAP table /SCMTMS/D_SCHLOC.
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_SCHLOC

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_LOCATION0
LOC_SEQCounter for Location Sequence/SCMTMS/SCH_LOC_CNTINT22
LOC_TYPELocation Type Code/SCMTMS/LOCATION_TYPE_CODECHAR8
LOC_ROLERole of the Location in a Schedule/SCMTMS/SCH_LOC_ROLECHAR4
LOC_UUIDLocation GUID (004) with Conversion Exit/SCMTMS/LOCUUIDRAW16
LOC_IDLocation/SCMTMS/LOCATION_IDCHAR40
LOG_LOCIATAInternational Air Transport Association: Location/SCMTMS/LOC_IATACODECHAR6
TSPCarrier/SCMTMS/TEND_TSP_KEYRAW16
TSP_SCACStandard Carrier Alpha Code/SCMTMS/SCACDCHAR8
OPERATING_CARRIERExecuting Carrier of a Schedule/SCMTMS/SCH_OPERATING_CARRIERCHAR2
.INCLUDEAIR/SCMTMS/S_SCH_LOCATION_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
SERVICE_STOP_INDICATORService Stop/SCMTMS/SERVICE_STOP_INDICATORCHAR2
.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
DISTANCE_KMDistances for Schedule Stages/SCMTMS/SCH_DISTDEC6
PRECISIONPrecision of Distance and Duration on Schedule Stages/SCMTMS/SCH_DDD_PRECNUMC2
TRANSIT_TIMETransit Time/SCMTMS/SCH_TRANSIT_TIMEDEC6
STAY_TIMELength of Stay/SCMTMS/SCH_STAY_TIMEDEC6
CARRIER_EXECarrier Business Partner GUID/SCMTMS/CARRIER_PARTY_KEYRAW16
CARRIER_INVCarrier Business Partner GUID/SCMTMS/CARRIER_PARTY_KEYRAW16
MOTTransportation Mode Code/SCMTMS/TRANSMODECODECHAR4
MTRMeans of Transport/SCMTMS/TRANSMEANSTYPECODECHAR20
TZONETime ZoneTIMEZONECHAR12*
ENTRY_PORTPort of Entry/SCMTMS/SCH_ENTRY_PORTCHAR2
EXIT_PORTPort of Exit/SCMTMS/SCH_EXIT_PORTCHAR2
DEL_FLAGSchedule Node Is to Be Deleted/SCMTMS/SCH_DEL_FLAGCHAR2
LOC_POSSequence Position/SCMTMS/SCH_LOC_POSCHAR2
SCH_REFSchedule Reference/SCMTMS/SCH_REFRAW16
SCH_LOC_REFKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
PRED_SCH_LOC_REFKey of Schedule Location/SCMTMS/SCH_LOC_KEYRAW16
REF_DATA_STATUSReferenced Data Status/SCMTMS/SCH_REF_DATA_STATUSCHAR2
STAGE_TYPEStage Type/SCMTMS/STAGE_TYPECHAR6/SCMTMS/C_STGTY
.INCLUDE/SCMTMS/S_SCH_LOCATION_D0
EXEC_ORG_IDPlanning and Execution Organization/SCMTMS/EXEC_ORG_IDNUMC16
ORG_INTERACTIONOrganization Interaction Status/SCMTMS/ORG_INTERACTION_STATUSCHAR4
.INCLUDE/SCMTMS/INCL_EEW_SCH_LOC0
EEW_SCH_LOCDummy function in length 1DUMMYCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy