/SCMTMS/D_FAGITM - Item
Item information is stored in SAP table /SCMTMS/D_FAGITM.
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_FAGITM
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 | ITEMS | /SCMTMS/S_FAG_ITEMS | 0 | |||
| ITEM_NO | Agreement Item Number | /SCMTMS/FAG_ITEM_NO | NUMC | 20 | ||
| MNEMONIC | Agreement Description | /SCMTMS/FAG_DESCRIPTION | CHAR | 60 | ||
| .INCLUDE | /SCMTMS/S_FAG_IPRIORITY_CODE | 0 | ||||
| FAGIPRIOID114 | Freight Agreement Item Priority | /SCMTMS/FAG_IPRIORITY_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_FDT_PRIO_CODE | 0 | ||||
| PREFDTPRIOID120 | Precondition User-Defined Priority | /SCMTMS/PRE_FDT_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_DANGG_PRIO_CODE | 0 | ||||
| PREDGGPRIOID118 | Precondition Dangerous Goods Priority | /SCMTMS/PRE_DANGG_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_GEO_PRIO_CODE | 0 | ||||
| PREGEOPRIOID115 | Transportation Network Priority | /SCMTMS/PRE_GEO_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_BUYER_PRIO_CODE | 0 | ||||
| PREBUYPRIOID117 | Precondition Business Partner Priority | /SCMTMS/PRE_BUYER_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_SERV_PRIO_CODE | 0 | ||||
| PRESERPRIOID119 | Precondition Services Priority | /SCMTMS/PRE_SERV_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_PRE_TRANSM_PRIO_CODE | 0 | ||||
| PRETRMPRIOID115 | Precondition Priority | /SCMTMS/PRE_TRANSM_PRIO_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/INCL_EEW_FAG_ITEMS | 0 | ||||
| EEW_FAG_ITEMS | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
| TCCS_UUID | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| PRECOND_UUID | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| TCCS_ID | Calculation Sheet | /SCMTMS/TRCHARG_CALC_SHEETID | CHAR | 40 | ||
| TCCS_TEMPLATE_ID | Calculation Sheet Template | /SCMTMS/TCCS_TEMPLATE | CHAR | 40 | /SCMTMS/C_TCCS | |
| TCCS_TEMPL_WEB | Calculation Sheet Template | /SCMTMS/TCCS_TEMPLATE_WEB | CHAR | 40 | ||
| TCCS_TEMPL_UUID | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| TCCS_ACTIONS | Calculation Sheet Actions | /SCMTMS/TBO_TCCS_ACTIONS | CHAR | 20 | ||
| FAGUSAGEID105 | Agreement Usage | /SCMTMS/FAG_USAGE_CODE | CHAR | 6 | ||
| MOT_CAT | Transportation Mode Category | /SCMTMS/TRMODCAT | CHAR | 2 | ||
| MOT | Transportation Mode | /SCMTMS/TRMODCODE | CHAR | 4 | ||
| SHIPPING_TYPE | Shipping Type | /SCMTMS/SHIPPING_TYPE | CHAR | 6 | ||
| DOC_CURRENCY | Document Currency | /SCMTMS/DOC_CURRENCY | CUKY | 10 | ||
| STAGE_TYPE | Stage Type | /SCMTMS/STAGE_TYPE | CHAR | 6 | /SCMTMS/C_STGTY | |
| STAGE_CAT | Stage Category | /SCMTMS/STAGE_CATEGORY | CHAR | 2 | ||
| DIM_WT_PROFILE | Dimensional Weight Profile | /SCMTMS/DIM_WEIGHT_PROFILE | CHAR | 20 | /SCMTMS/C_DIMWP | |
| EXCH_RATE_TYPE | Exchange Rate Type | /SCMTMS/EXCHANGERATETYPE | CHAR | 8 | TCURV | |
| .INCLUDE | /SCMTMS/S_FA_SERVICES | 0 | ||||
| TRPPRIO135 | Transportation Service Level - Carrier | /SCMTMS/TRANSP_SLC_CARRIER | CHAR | 4 | * | |
| TRPPRIO135_DESCR | Text, 40 Characters Long | TEXT40 | CHAR | 80 | ||
| .INCLUDE | /SCMTMS/S_COND_ROOT_UUID | 0 | ||||
| .INCLU-047 | /SCMTMS/S_UUID | 0 | ||||
| UUID047 | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| COND_TRANSRULE | Name of Condition | /SCMTMS/CONDITION_ID | CHAR | 50 | * | |
| .INCLUDE | /SCMTMS/S_SRV_SCHEDULING_INFO | 0 | ||||
| TIME_DET_TYPE | Time Determination Type | /SCMTMS/TIME_DETERM_TYPE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_SRV_SCHED_INFO_DIR | 0 | ||||
| DURATION | Duration | /SCMTMS/DURATION | DEC | 6 | ||
| DEPARTURE_CAL | Calendar for Departures | /SCMTMS/DEPARTURE_CAL | CHAR | 4 | TFACD | |
| TRANSIT_CAL | Calendar for Transits | /SCMTMS/TRANSIT_CAL | CHAR | 4 | TFACD | |
| ARRIVAL_CAL | Calendar for Arrivals | /SCMTMS/ARRIVAL_CAL | CHAR | 4 | TFACD | |
| CONDITION_ID | Condition for Determining Scheduling Info | /SCMTMS/DSO_SCHED_COND | CHAR | 50 | * | |
| EXT_STRAT | Strategy for External Delivery Date Determination | /SCMTMS/DS_EXT_PUDL_STRATEGY | CHAR | 20 | ||
| IS_HEADER_CHARGE | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
| ITEM_TYPE | Item Type | /SCMTMS/AG_ITM_TYPE_CODE | CHAR | 8 | /SCMTMS/C_AITYP | |
| VALIDITY_START | Start Date of Validity | /SCMTMS/VAL_DATE_FROM | DATS | 16 | ||
| VALIDITY_END | End Date of Validity | /SCMTMS/VAL_DATE_TO | DATS | 16 | ||
| VALIDITY_START_TS | Validity Date Start (UTC) | /SCMTMS/VALIDITY_DATE_FROM_TS | DEC | 8 | ||
| VALIDITY_END_TS | End Date of Validity (UTC) | /SCMTMS/VALIDITY_DATE_TO_TS | DEC | 8 | ||
| SERVICE_TYPE | Service Type | /SCMTMS/TRANSPSERV_REQ_CODE | CHAR | 20 | /SCMTMS/C_TSR | |
| PAR_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| CUST_TMPL_IND | Customizing Template | /SCMTMS/CUSTOMIZING_TMPL_IND | CHAR | 2 | ||
| WEB_TMPL_IND | Master Data Template Only | /SCMTMS/WEB_TMPL_IND | CHAR | 2 | ||
| CONTRACT_BASIS | Contract Basis | /SCMTMS/CONTRACT_BASIS | CHAR | 4 | * | |
| MOVEM_TYPE | Movement Type | /SCMTMS/MOVEMENT_TYPE | CHAR | 6 | /SCMTMS/C_MVMTY | |
| CONSOL_TYPE | Air Waybill Type | /SCMTMS/AIR_CONS_TYPE | CHAR | 4 | /SCMTMS/I_AFCON | |
| REF_SP_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| REF_SP_ITM_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| SERVICE_PRODUCT_ID | Service Product | /SCMTMS/SERVICE_PRODUCT_ID | CHAR | 80 | ||
| UNCONTROLLED | Uncontrolled Transportation | /SCMTMS/UNCONTROLLED_SHPMENT | CHAR | 2 | ||
| TSP_ID | Carrier | /SCMTMS/PTY_TRANS_SRV_PROVIDER | CHAR | 20 | ||
| CONSOLIDATION | Buyer's Consolidation or Shipper's Consolidation | /SCMTMS/CONSOLIDATION_TYPE | CHAR | 4 | ||
| BTD_ID | Bus. Trans. Document ID | /SCMTMS/BTD_ID | CHAR | 70 | ||
| EXTERNAL_FA_ID | External Reference Number | /SCMTMS/EXT_FA_ID | CHAR | 70 | ||
| TAL_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| BILLING_SCHEME | Settlement Basis | /SCMTMS/BILLING_SCHEME | CHAR | 20 | ||
| .INCLUDE | /SCMTMS/S_RFQ_ITEM | 0 | ||||
| SOL_SPEND_DIMENSION | Capacity Dimension | /SCMTMS/SOL_SPEND_DIMENSION | CHAR | 60 | ||
| MASTER_RFQ_ITEM_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| RESP_SUBMIT | RFQ Response Submit Timestamp (UTC) | /SCMTMS/RFQ_RESP_SUBMIT | DEC | 8 | ||
| RESPONDED | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
| RESP_STATUS_CODE | Item Status | /SCMTMS/RFQ_RESPONSE_CODE | CHAR | 4 | ||
| ITEM_EQUIP_GROUP | Equipment Group | /SCMTMS/EQUIP_GROUP | CHAR | 6 | * | |
| ITEM_EQUIP_TYPE | Equipment Type | /SCMTMS/RES_TYPE_CODE | CHAR | 20 | ||
| GRACE_PERIOD | Grace Period | /SCMTMS/GRACE_PERIOD | INT1 | 1 | ||
| CARRIER_NO | Business Partner Number | BU_PARTNER | CHAR | 20 | ||
| CARRIER_UUID | Business Partner | /SCMTMS/BUPAUUID | RAW | 16 | ||
| RFQ_ITEM_TYPE_CODE | RFQ Item Type Code | /SCMTMS/RFQ_ITEM_TYPE_CODE | CHAR | 8 | ||
| 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 | * | |
| QUA_PCS_VAL | Quantity | /SCMTMS/QUA_PCS_VAL | QUAN | 16 | ||
| QUA_PCS_UNI | Quantity Unit of Measure | /SCMTMS/QUA_PCS_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 | * | |
| DISTANCE | Transportation Distance | /SCMTMS/DISTANCE | QUAN | 16 | ||
| DISTANCE_UOM | Distance Unit of Measure | /SCMTMS/DISTANCE_UOM | UNIT | 6 | * | |
| PERIODICITY | Periodicity | /SCMTMS/RFQ_ITEM_PERIODICITY | CHAR | 2 | ||
| PRIORITY | Priority | /SCMTMS/RFQ_ITEM_PRIORITY | CHAR | 2 | ||
| DIMENSION | Dimension key | DIMID | CHAR | 12 | * | |
| QUANTITY | Quantity | /SCMTMS/QUANTITY | QUAN | 16 | ||
| MIN_CAPACITY_UOM | Unit of Measure | /SCMTMS/GENERIC_UOM | UNIT | 6 | * | |
| UOM | Unit of Measure | /SCMTMS/GENERIC_UOM | UNIT | 6 | * | |
| BUDGET | Periodicity Budget | /SCMTMS/BUDGET_AMOUNT | CURR | 15 | ||
| BUDGET_CURRENCY | Currency | /SCMTMS/CURRENCY | CUKY | 10 | ||
| MTR | Means of Transport | /SCMTMS/TRANSMEANSTYPECODE | CHAR | 20 | ||
| REVENUE | Calculated Revenue | /SCMTMS/REVENUE | CURR | 15 | ||
| MIN_CAPACITY | Quantity | /SCMTMS/QUANTITY | QUAN | 16 | ||
| REVENUE_CURRENCY | Currency | /SCMTMS/CURRENCY | CUKY | 10 | ||
| CHARG_WEI_VAL | Chargeable Weight | /SCMTMS/QUA_CHARGEABLE_WEI_VAL | QUAN | 16 | ||
| CHARG_WEI_UNI | Chargeable Weight Unit of Measure | /SCMTMS/QUA_CHARGEABLE_WEI_UNI | UNIT | 6 | * | |
| AWARD_CONFIRM | Confirmation by Carrier | /SCMTMS/AWARD_CONFIRM | CHAR | 2 | ||
| AWARD_CONFIRM_REASON | Award Confirmation Reason | /SCMTMS/AWARD_CONFIRM_REASON | CHAR | 6 | ||
| OPT_AT_CAP_LINE | Individual Capacity Optimization in RFQ | /SCMTMS/RFQ_OPT_AT_CAP_LINE | CHAR | 2 | ||
| .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 | * | |
| .INCLUDE | /SCMTMS/S_CNF_ITEM_RESP_CAP | 0 | ||||
| CNF_GRO_WEI_VAL | Gross Weight | /SCMTMS/QUA_GRO_WEI_VAL | QUAN | 16 | ||
| CNF_GRO_WEI_UNI | Gross Weight Unit of Measure | /SCMTMS/QUA_GRO_WEI_UNI | UNIT | 6 | * | |
| CNF_GRO_VOL_VAL | Gross Volume | /SCMTMS/QUA_GRO_VOL_VAL | QUAN | 16 | ||
| CNF_GRO_VOL_UNI | Gross Volume Unit of Measure | /SCMTMS/QUA_GRO_VOL_UNI | UNIT | 6 | * | |
| CNF_QUA_PCS_VAL | Quantity | /SCMTMS/QUA_PCS_VAL | QUAN | 16 | ||
| CNF_QUA_PCS_UNI | Quantity Unit of Measure | /SCMTMS/QUA_PCS_UNI | UNIT | 6 | * | |
| CNF_CONT_CNT_VAL | Number of Twenty-Foot Equivalent Units | /SCMTMS/CONT_COUNT_VAL | QUAN | 16 | ||
| CNF_CONT_CNT_UNI | Number of TEU Unit of Measure | /SCMTMS/CONT_COUNT_UNI | UNIT | 6 | * | |
| CNF_DISTANCE | Transportation Distance | /SCMTMS/DISTANCE | QUAN | 16 | ||
| CNF_DISTANCE_UOM | Distance Unit of Measure | /SCMTMS/DISTANCE_UOM | UNIT | 6 | * | |
| CNF_DIMENSION | Dimension key | DIMID | CHAR | 12 | * | |
| CNF_QUANTITY | Quantity | /SCMTMS/QUANTITY | QUAN | 16 | ||
| CNF_UOM | Unit of Measure | /SCMTMS/GENERIC_UOM | UNIT | 6 | * | |
| CNF_CHARG_WEI_VAL | Chargeable Weight | /SCMTMS/QUA_CHARGEABLE_WEI_VAL | QUAN | 16 | ||
| CNF_CHARG_WEI_UNI | Chargeable Weight Unit of Measure | /SCMTMS/QUA_CHARGEABLE_WEI_UNI | UNIT | 6 | * | |
| .INCLUDE | CARRIER_PRODUCT | /SCMTMS/S_CAR_PRDT_MASTER_DATA | 0 | |||
| .INCLUDE | /SCMTMS/S_MEASURES | 0 | ||||
| LENGTH | Length | /SCMTMS/LENGTH | QUAN | 7 | ||
| WIDTH | Width | /SCMTMS/WIDTH | QUAN | 7 | ||
| HEIGHT | Height | /SCMTMS/HEIGHT | QUAN | 7 | ||
| MEASUOM | Unit of measure for length, width and height | /SCMTMS/MEASUOM | UNIT | 6 | * | |
| LENGTH_PLUS_GIRTH | Length + Girth | /SCMTMS/LENGTH_PLUS_GIRTH | QUAN | 7 | ||
| AIRLC | IATA Airline Code | /SCMTMS/AIRLC | CHAR | 6 | ||
| HAS_PREFERRED_STR | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
| MANDATORY_SERVICE | Mandatory Service | /SCMTMS/MANDATORY_SERVICE | CHAR | 2 | ||
| BUSINESS_SHARE | Target Share | /SCMTMS/TSP_BUSS_SHARE | DEC | 3 | ||
| FLOW_SERVICE | Propagate Services | /SCMTMS/FLOW_SERVICE | CHAR | 2 | ||
| OWNERSHIP_TYPE | Ownership Type | /SCMTMS/OWNERSHIP_TYPE | CHAR | 4 | ||
| EXT_ITEM_NO | External Item Number | /SCMTMS/EXT_ITEM_NO | NUMC | 20 | ||
| FORECAST_VERSION | Forecast Analysis ID | /SCMTMS/FA_RFQ_FORECAST_VER | CHAR | 40 | ||
| CRKPI_PROFILE_ID | Carrier KPI Profile | /SCMTMS/CRKPI_PROFILE_ID | NUMC | 8 | ||
| CARRIER_SERVICE_CODE | Carrier Service Code | /SCMB/BPTM_CARRIER_SRVC_CODE | CHAR | 20 | ||
| EXCLUSION_RELEVANT | Usage Independent (Do not Use Directly in BOs) | /SCMTMS/INDICATOR | CHAR | 2 | ||
| REF_AGREEMENT_UUID | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| REF_AGREEMENT_ITEM_UUID | Internal Universally Unique Identifier | /SCMTMS/UUID_ID | RAW | 16 | ||
| REF_AGREEMENT_ID | Agreement | /SCMTMS/FAG_ID | CHAR | 40 | ||
| REF_AGREEMENT_ITEM_NO | Agreement Item Number | /SCMTMS/FAG_ITEM_NO | NUMC | 20 | ||
| CRM_OPP_ITM | Opportunity Item Number | /SCMTMS/FWAQ_OPP_ITM | NUMC | 20 | ||
| CRM_OPP_ITM_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| CRM_OPP | Opportunity ID | /SCMTMS/FWAQ_OPP_ID | CHAR | 70 | ||
| CRM_OPP_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| OPM_STRATEGY_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| FAGRMNTID044_UUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| NEW_FAG_OPT | Creation/Update Level | /SCMTMS/NEW_FAG_OPT | CHAR | 4 | ||
| PRE_CONDITION_ROOT_PRESENT | Precondition Root | /SCMTMS/PRE_ROOT_EXISTS | CHAR | 2 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 |