/SCMTMS/D_OPTSTG

Optimizer Result for a strategy (Carrier) | #transactional | Component: Freight Agreement Management
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Currency (CURRCODE016):
AMOUNT Amount
💲 Currency (SOL_SPEND_CURR):
SOL_SPEND_AMT Estimated Strategy Spend
Column Name Description
📏 Gross Weight Unit of Measure (RESP_GRO_WEI_UNI):
RESP_GRO_WEI_VAL Gross Weight
📏 Gross Volume Unit of Measure (RESP_GRO_VOL_UNI):
RESP_GRO_VOL_VAL Gross Volume
📏 Quantity Unit of Measure (RESP_QUA_PCS_UNI):
RESP_QUA_PCS_VAL Quantity
📏 Number of TEU Unit of Measure (RESP_CONT_CNT_UNI):
RESP_CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Distance Unit of Measure (RESP_DISTANCE_UOM):
RESP_DISTANCE Transportation Distance
📏 Unit of Measure (RESP_UOM):
RESP_QUANTITY Quantity
📏 Chargeable Weight Unit of Measure (RESP_CHARG_WEI_UNI):
RESP_CHARG_WEI_VAL Chargeable Weight
📏 Calculated Capacity Unit of Measure (CALCULATED_CAPACITY_UOM):
CALCULATED_CAPACITY Proposed Capacity Distribution
Column Name Description
_DATAAGING Data Filter Value for Data Aging
Column Name Description
BUSS_SHARE Target Share Show values
RFQ_ITEM_TYPE_CODE RFQ Item Type Code Show values
NEW_FAG_OPT Creation/Update Level Show values
AGREMNT_AP_LEVL Agreement Creation Level Show values
STR_TREE_LVL Strategy Tree Level Show values
BUSS_SHARE_FLAG Business Share Flag Show values
SET_HISTORICAL_SPEND Historical Spend Flag Show values
STRATEGY_ST_CODE Optimizer Strategy Status Show values
ENABLE_BONUS_MALUS Enable Bonus-Malus Show values
ENABLE_TRANSIT_TIME Enable Transit Time Show values
MIN_SHARE Target Share Show values
MAX_SHARE Target Share Show values
Column Name Description Domain name
ROOT_KEY NodeID /BOBF/CONF_KEY
PARENT_KEY NodeID /BOBF/CONF_KEY
RESP_DIMENSION Dimension key DIMID
STRATEGY Target Share Strategy CHAR10
SOLUTION_SPEND_VER_NAME Strategy Version CHAR20
CARRIER Carrier /SCMTMS/BU_PARTNER
CHARGE_TYPE Charge Type /SCMTMS/TRCHARG_ELMNT_TYPECD
REQUEST_NO Agreement Item Number /SCMTMS/FAG_ITEM_NO
RESPONSE_NO Agreement Item Number /SCMTMS/FAG_ITEM_NO
PAR_KEY NodeID /BOBF/CONF_KEY
TREE_PAR_KEY NodeID /BOBF/CONF_KEY
TRANS_RFQ_ITEMS_KEY NodeID /BOBF/CONF_KEY
TREE_ROOT_KEY NodeID /BOBF/CONF_KEY
RATE_ID Rate Table /SCMTMS/TC_RATETABLE_ID
UUID026 Internal Universally Unique Identifier
CR_RFQ_ITEM_KEY NodeID /BOBF/CONF_KEY
MR_RFQ_ITEM_KEY NodeID /BOBF/CONF_KEY
CR_RFQ_ROOT_KEY NodeID /BOBF/CONF_KEY
MR_RFQ_ROOT_KEY NodeID /BOBF/CONF_KEY
RFQ_TYPE_CODE RFQ/Quotation Type /SCMTMS/RFQ_TYPE_CODE
PREFERRED_STR Preferred Strategy /SCMTMS/PREFERRED_STR
FAGRMNTID044 Agreement /SCMTMS/FAG_ID
FAGRMNTID045 Agreement Version
TRGT_FAG_KEY NodeID /BOBF/CONF_KEY
TRGT_FAG_ID Agreement /SCMTMS/FAG_ID
SOL_SPENT_V2 null
PREFERRED_STR_DATE_TS Preferred Strategy Date (UTC) TZNTSTMPS
MIN_CARR Minimum Number of Carriers
MAX_CARR Maximum Number of Carriers
CAPACITY_KEY NodeID /BOBF/CONF_KEY
CAP_PAR_KEY NodeID /BOBF/CONF_KEY