/SCMTMS/D_PLNXFO - Freight Order
Freight Order information is stored in SAP table /SCMTMS/D_PLNXFO.
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* )".
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_PLNXFO
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 | |
| PARENT_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| .INCLUDE | NODE_DATA | /SCMTMS/S_PLN_EX_FOR | 0 | |||
| FOR_UUID | Document GUID | /SCMTMS/PLN_OPT_GUID_DOCUMENT | RAW | 16 | ||
| FOR_ID | Document ID | /SCMTMS/PLN_OPT_EXP_DOC_ID | CHAR | 40 | ||
| CAT | Business Document Category | /SCMTMS/TOR_CATEGORY | CHAR | 4 | ||
| TYPE | Business Document Type | /SCMTMS/TOR_TYPE | CHAR | 8 | ||
| TU_CAT | Transportation Unit Category | /SCMTMS/TOR_TU_CAT | CHAR | 2 | ||
| CONTEXT | Order is context | /SCMTMS/PLN_CD_FLAG | CHAR | 2 | ||
| SOURCE_LOC | Source Location | /SCMTMS/PLN_OPT_GUID_ST_LOC | RAW | 16 | ||
| TARGET_LOC | Destination Location | /SCMTMS/PLN_OPT_GUID_END_LOC | RAW | 16 | ||
| MTR | Means of Transport | /SCMTMS/TRANSMEANSTYPECODE | CHAR | 20 | ||
| VEHICLE_UUID | Resource or Equipment Type | /SCMTMS/PLN_OPT_EXP_RES_KEY | RAW | 16 | ||
| VEHICLE_ID | Resource | /SCMTMS/PLN_EXP_RES_NAME | CHAR | 80 | ||
| .INCLUDE | DAT | /SCMTMS/S_PLN_EX_TOR_PUDL | 0 | |||
| REQ_PU_FR | Requested Pick-Up Start Date/Time | /SCMTMS/PLN_OPT_TST_REQ_PU_ST | DEC | 8 | ||
| REQ_PU_TO | Requested Pick-Up End Date/Time | /SCMTMS/PLN_OPT_TST_REQ_PU_EN | DEC | 8 | ||
| ACC_PU_FR | Acceptable Pick-Up Start Date/Time | /SCMTMS/PLN_OPT_TST_ACC_PU_ST | DEC | 8 | ||
| ACC_PU_TO | Acceptable Pick-Up End Date/Time | /SCMTMS/PLN_OPT_TST_ACC_PU_EN | DEC | 8 | ||
| REQ_DL_FR | Requested Delivery Start Date/Time | /SCMTMS/PLN_OPT_TST_REQ_DL_ST | DEC | 8 | ||
| REQ_DL_TO | Requested Delivery End Date/Time | /SCMTMS/PLN_OPT_TST_REQ_DL_EN | DEC | 8 | ||
| ACC_DL_FR | Acceptable Delivery Start Date/Time | /SCMTMS/PLN_OPT_TST_ACC_DL_ST | DEC | 8 | ||
| ACC_DL_TO | Acceptable Delivery End Date/Time | /SCMTMS/PLN_OPT_TST_ACC_DL_EN | DEC | 8 | ||
| .INCLUDE | QTY | /SCMTMS/S_QUANTITIES | 0 | |||
| GRO_WEI_VAL | Gross Weight | /SCMTMS/QUA_GRO_WEI_VAL | QUAN | 16 | ||
| GRO_WEI_UNI | Gross Weight Unit of Measure | /SCMTMS/QUA_GRO_WEI_UNI | UNIT | 6 | * | |
| GRO_VOL_VAL | Gross Volume | /SCMTMS/QUA_GRO_VOL_VAL | QUAN | 16 | ||
| GRO_VOL_UNI | Gross Volume Unit of Measure | /SCMTMS/QUA_GRO_VOL_UNI | UNIT | 6 | * | |
| NET_WEI_VAL | Net Weight | /SCMTMS/QUA_NET_WEI_VAL | QUAN | 16 | ||
| NET_WEI_UNI | Net Weight Unit of Measure | /SCMTMS/QUA_NET_WEI_UNI | UNIT | 6 | * | |
| QUA_PCS_VAL | Quantity | /SCMTMS/QUA_PCS_VAL | QUAN | 16 | ||
| QUA_PCS_UNI | Quantity Unit of Measure | /SCMTMS/QUA_PCS_UNI | UNIT | 6 | * | |
| QUA_PCS2_VAL | Alternative Quantity | /SCMTMS/QUA_PCS2_VAL | QUAN | 16 | ||
| QUA_PCS2_UNI | Alternative Quantity 2 Unit of Measure | /SCMTMS/QUA_PCS2_UNI | UNIT | 6 | * | |
| BASE_UOM_VAL | Base Quantity | /SCMTMS/QUA_BASE_UOM_VAL | QUAN | 16 | ||
| BASE_UOM_UNI | Base Unit of Measure | /SCMTMS/QUA_BASE_UOM_UNI | UNIT | 6 | * | |
| PKGUN_WEI_VAL | Tare Weight | /SCMTMS/QUA_PACK_UNL_WEI_VAL | QUAN | 16 | ||
| PKGUN_WEI_UNI | Tare Weight Unit of Measure | /SCMTMS/QUA_PACK_UNL_WEI_UNI | UNIT | 6 | * | |
| CONT_CNT_VAL | Number of Twenty-Foot Equivalent Units | /SCMTMS/CONT_COUNT_VAL | QUAN | 16 | ||
| CONT_CNT_UNI | Number of TEU Unit of Measure | /SCMTMS/CONT_COUNT_UNI | UNIT | 6 | * | |
| DG_ADR_PTS_VAL | ADR 1.1.3.6 DG Exemption Points | /SCMTMS/DG_ADR_POINTS_VAL | QUAN | 16 | ||
| DG_ADR_PTS_UNI | Unit of Measure for ADR 1.1.3.6 DG Exemption Points | /SCMTMS/DG_ADR_POINTS_UNI | UNIT | 6 | * | |
| NORMLOADCONSVAL | Normalized Load Consumption Quantity | /SCMTMS/TOR_NORMLOADCONSVAL | QUAN | 16 | ||
| NORMLOADCONSUOM | Unit of Measure of Normalized Load Consumption Quantity | /SCMTMS/TOR_NORMLOADCONSUNI | UNIT | 6 | * |