/SCMTMS/D_PLNXSO - Schedule root

Schedule root information is stored in SAP table /SCMTMS/D_PLNXSO.
It is part of development package /SCMTMS/PLN_EXP_VSR in software component TM-PLN-EXP. This development package consists of objects that can be grouped under "VSR Explainatiion Tool (due to old naming convention *PLN* )".

Fields for table /SCMTMS/D_PLNXSO

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_PLN_EX_SCH_ROOT0
SCH_UUIDSchedule/SCMTMS/PLN_OPT_GUID_SCHEDULERAW16
SCH_IDSchedule/SCMTMS/SCH_IDCHAR80
TRM_ICONExplanation Tool: Icon for transportation mode/SCMTMS/PLN_EXP_MOT_ICONCHAR8*
SCH_CATSchedule Category/SCMTMS/SCH_CATCHAR4
SCH_TYPESchedule Type or Default Route Type/SCMTMS/SCH_TYPECHAR8
TSPNodeID/BOBF/CONF_KEYRAW16
TSPIDCarrier/SCMTMS/PTY_CARRIERCHAR20
TSP_SCACStandard Carrier Alpha Code/SCMTMS/SCACDCHAR8
FLIGHT_CODEAirline Code and Flight Number/SCMTMS/FLIGHT_CODECHAR14
SRC_TDR_NAMESource Zone/SCMTMS/TDL_UI_SOURCE_ZONECHAR40
DEST_TDR_NAMEDestination Zones/SCMTMS/TDL_UI_DEST_ZONECHAR40
SCH_REFExpl.Tool: Carrier Schedule Reference/SCMTMS/PLN_EXP_SCH_REFRAW16
LOOP_IDLoop/SCMTMS/SCH_LOOP_IDCHAR80
PRD_TRANSP_GRPTransportation Group/SCMTMS/PROD_TRANSP_GRP_CDCHAR8
DGO_INDICATORDangerous Goods/SCMTMS/SCH_DG_INDCHAR2
SHIPPING_TYPEShipping Type/SCMTMS/SHIPPING_TYPECHAR6
VAL_FROM_DATEDate/Time/SCMTMS/DATETIMEDEC8
VAL_TO_DATEDate/Time/SCMTMS/DATETIMEDEC8
.INCLUDECAPA/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*
.INCLUDE/SCMTMS/S_SCH_SETTINGS_ROOT0
REFERENCESchedule Has Reference to Other Schedule/SCMTMS/SCH_WITH_REFERENCECHAR2
CONSOLIDATIONGateway/SCMTMS/SCH_CONSOLIDATIONCHAR2
CONS_DIRECTDirect/SCMTMS/SCH_CONSOLIDATION_DIRCHAR2
SKIP_SRC_GWDo Not Use Source Gateway/SCMTMS/SCH_SKIP_SRC_GWCHAR2
SKIP_DEST_GWDo Not Use Destination Gateway/SCMTMS/SCH_SKIP_DEST_GWCHAR2
MOTTransportation Mode Code/SCMTMS/TRANSMODECODECHAR4
NR_RANGENumber Range Interval/SCMTMS/SCH_NUMBERRANGECHAR4
ORDER_INDOnly One Freight Document Is Used for One Departure/SCMTMS/SCH_ORDER_INDCHAR2
CUTOFF_REF_TYPEOffset Time Type/SCMTMS/SCH_CUTOFF_REF_TYPECHAR2
.INCLUDE/BOFU/S_ADMIN_DATA0
CREATED_BYCreated By/BOFU/USER_ID_CREATED_BYCHAR24
CREATED_ONCreated on/BOFU/TSTMP_CREATION_TIMEDEC8
CHANGED_BYChanged By/BOFU/USER_ID_CHANGED_BYCHAR24
CHANGED_ONChanged On/BOFU/TSTMP_CHANGED_TIMEDEC8
.INCLUDE/SCMTMS/INCL_EEW_PLN_EX_SCH_RO0
EEW_PLN_EX_SCHRODummy function in length 1DUMMYCHAR2
Privacy Policy