/SCMTMS/D_OPTSTG - Optimizer Result for a strategy (Carrier)
Optimizer Result for a strategy (Carrier) information is stored in SAP table /SCMTMS/D_OPTSTG.
It is part of development package /SCMTMS/FO_FRGHT_AGREEMNT_BO in software component TM-FRA. This development package consists of objects that can be grouped under "Foundation BO Freight Agreement".
It is part of development package /SCMTMS/FO_FRGHT_AGREEMNT_BO in software component TM-FRA. This development package consists of objects that can be grouped under "Foundation BO Freight Agreement".
Fields for table /SCMTMS/D_OPTSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DB_KEY | NodeID | X | /BOBF/CONF_KEY | RAW | 16 | |
| ROOT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| .INCLUDE | OPTIMIZER_STRATEGY | /SCMTMS/S_OPM_STRATEGY_A | 0 | |||
| .INCLUDE | /SCMTMS/S_RFQ_ITEM_RESP_CAP | 0 | ||||
| RESP_GRO_WEI_VAL | Gross Weight | /SCMTMS/QUA_GRO_WEI_VAL | QUAN | 16 | ||
| RESP_GRO_WEI_UNI | Gross Weight Unit of Measure | /SCMTMS/QUA_GRO_WEI_UNI | UNIT | 6 | * | |
| RESP_GRO_VOL_VAL | Gross Volume | /SCMTMS/QUA_GRO_VOL_VAL | QUAN | 16 | ||
| RESP_GRO_VOL_UNI | Gross Volume Unit of Measure | /SCMTMS/QUA_GRO_VOL_UNI | UNIT | 6 | * | |
| RESP_QUA_PCS_VAL | Quantity | /SCMTMS/QUA_PCS_VAL | QUAN | 16 | ||
| RESP_QUA_PCS_UNI | Quantity Unit of Measure | /SCMTMS/QUA_PCS_UNI | UNIT | 6 | * | |
| RESP_CONT_CNT_VAL | Number of Twenty-Foot Equivalent Units | /SCMTMS/CONT_COUNT_VAL | QUAN | 16 | ||
| RESP_CONT_CNT_UNI | Number of TEU Unit of Measure | /SCMTMS/CONT_COUNT_UNI | UNIT | 6 | * | |
| RESP_DISTANCE | Transportation Distance | /SCMTMS/DISTANCE | QUAN | 16 | ||
| RESP_DISTANCE_UOM | Distance Unit of Measure | /SCMTMS/DISTANCE_UOM | UNIT | 6 | * | |
| RESP_DIMENSION | Dimension key | DIMID | CHAR | 12 | * | |
| RESP_QUANTITY | Quantity | /SCMTMS/QUANTITY | QUAN | 16 | ||
| RESP_UOM | Unit of Measure | /SCMTMS/GENERIC_UOM | UNIT | 6 | * | |
| RESP_CHARG_WEI_VAL | Chargeable Weight | /SCMTMS/QUA_CHARGEABLE_WEI_VAL | QUAN | 16 | ||
| RESP_CHARG_WEI_UNI | Chargeable Weight Unit of Measure | /SCMTMS/QUA_CHARGEABLE_WEI_UNI | UNIT | 6 | * | |
| STRATEGY | Target Share Strategy | /SCMTMS/OPM_STRATEGY | CHAR | 20 | ||
| SOLUTION_SPEND_VER_NAME | Strategy Version | /SCMTMS/SOLUTN_SPEND_VER_NAME | CHAR | 40 | ||
| CARRIER | Carrier | /SCMTMS/PTY_CARRIER | CHAR | 20 | ||
| CHARGE_TYPE | Charge Type | /SCMTMS/TRCHARG_ELMNT_TYPECD | CHAR | 30 | ||
| BUSS_SHARE | Target Share | /SCMTMS/TSP_BUSS_SHARE | DEC | 3 | ||
| REQUEST_NO | Agreement Item Number | /SCMTMS/FAG_ITEM_NO | NUMC | 20 | ||
| RESPONSE_NO | Agreement Item Number | /SCMTMS/FAG_ITEM_NO | NUMC | 20 | ||
| PAR_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| TREE_PAR_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| TRANS_RFQ_ITEMS_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| TREE_ROOT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| RATE_ID | Rate Table | /SCMTMS/TC_RATETABLE_ID | CHAR | 40 | ||
| AMOUNT | Amount | /SCMTMS/AMOUNT | CURR | 15 | ||
| CURRCODE016 | Currency | /SCMTMS/CURRENCY | CUKY | 10 | ||
| UUID026 | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| RFQ_ITEM_TYPE_CODE | RFQ Item Type Code | /SCMTMS/RFQ_ITEM_TYPE_CODE | CHAR | 8 | ||
| CR_RFQ_ITEM_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| MR_RFQ_ITEM_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| CR_RFQ_ROOT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| MR_RFQ_ROOT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| RFQ_TYPE_CODE | RFQ/Quotation Type | /SCMTMS/RFQ_TYPE_CODE | CHAR | 8 | * | |
| PREFERRED_STR | Preferred Strategy | /SCMTMS/PREFERRED_STR | CHAR | 2 | ||
| FAGRMNTID044 | Agreement | /SCMTMS/FAG_ID | CHAR | 40 | ||
| .INCLUDE | /SCMTMS/S_FAG_VSID | 0 | ||||
| FAGRMNTID045 | Agreement Version | /SCMTMS/FAG_AGREEMENT_VERSID | CHAR | 20 | ||
| NEW_FAG_OPT | Creation/Update Level | /SCMTMS/NEW_FAG_OPT | CHAR | 4 | ||
| TRGT_FAG_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| TRGT_FAG_ID | Agreement | /SCMTMS/FAG_ID | CHAR | 40 | ||
| AGREMNT_AP_LEVL | Agreement Creation Level | /SCMTMS/AGREMNT_AP_LEVL | CHAR | 4 | ||
| STR_TREE_LVL | Strategy Tree Level | /SCMTMS/STR_TREE_LEVEL | CHAR | 2 | ||
| BUSS_SHARE_FLAG | Business Share Flag | /SCMTMS/BUSINESS_SHARE_FLAG | CHAR | 2 | ||
| SET_HISTORICAL_SPEND | Historical Spend Flag | /SCMTMS/HISTORICAL_SPEND_FLAG | CHAR | 2 | ||
| SOL_SPEND_AMT | Estimated Strategy Spend | /SCMTMS/ESTIMATED_SPEND | CURR | 15 | ||
| SOL_SPEND_CURR | Currency | /SCMTMS/CURRENCY | CUKY | 10 | ||
| SOL_SPENT_V2 | CHAR | 40 | ||||
| CALCULATED_CAPACITY | Proposed Capacity Distribution | /SCMTMS/CALCULATED_CAPACITY | QUAN | 16 | ||
| CALCULATED_CAPACITY_UOM | Calculated Capacity Unit of Measure | /SCMTMS/CALCULATE_CAPACITY_UOM | UNIT | 6 | * | |
| STRATEGY_ST_CODE | Optimizer Strategy Status | /SCMTMS/STRATEGY_STATUS | CHAR | 4 | ||
| PREFERRED_STR_DATE_TS | Preferred Strategy Date (UTC) | /SCMTMS/PREFERRED_STR_DATE_TS | DEC | 8 | ||
| .INCLUDE | /SCMTMS/S_OPM_STRATEGY_LVL_5_6 | 0 | ||||
| MIN_CARR | Minimum Number of Carriers | /SCMTMS/MIN_CARRIER | INT4 | 4 | ||
| MAX_CARR | Maximum Number of Carriers | /SCMTMS/MAX_CARRIER | INT4 | 4 | ||
| ENABLE_BONUS_MALUS | Enable Bonus-Malus | /SCMTMS/ENABLE_BONUS_MALUS | CHAR | 2 | ||
| ENABLE_TRANSIT_TIME | Enable Transit Time | /SCMTMS/ENABLE_TRANSIT_TIME | CHAR | 2 | ||
| CAPACITY_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| CAP_PAR_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| MIN_SHARE | Target Share | /SCMTMS/TSP_BUSS_SHARE | DEC | 3 | ||
| MAX_SHARE | Target Share | /SCMTMS/TSP_BUSS_SHARE | DEC | 3 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |