/SCMTMS/D_FAGITM

Item | #transactional | Component: Freight Agreement Management
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Currency (BUDGET_CURRENCY):
BUDGET Periodicity Budget
💲 Currency (REVENUE_CURRENCY):
REVENUE Calculated Revenue
Column Name Description
📏 Gross Weight Unit of Measure (GRO_WEI_UNI):
GRO_WEI_VAL Gross Weight
📏 Gross Volume Unit of Measure (GRO_VOL_UNI):
GRO_VOL_VAL Gross Volume
📏 Quantity Unit of Measure (QUA_PCS_UNI):
QUA_PCS_VAL Quantity
📏 Number of TEU Unit of Measure (CONT_CNT_UNI):
CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Distance Unit of Measure (DISTANCE_UOM):
DISTANCE Transportation Distance
📏 Unit of Measure (UOM):
QUANTITY Quantity
MIN_CAPACITY Quantity
📏 Chargeable Weight Unit of Measure (CHARG_WEI_UNI):
CHARG_WEI_VAL Chargeable Weight
📏 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
📏 Gross Weight Unit of Measure (CNF_GRO_WEI_UNI):
CNF_GRO_WEI_VAL Gross Weight
📏 Gross Volume Unit of Measure (CNF_GRO_VOL_UNI):
CNF_GRO_VOL_VAL Gross Volume
📏 Quantity Unit of Measure (CNF_QUA_PCS_UNI):
CNF_QUA_PCS_VAL Quantity
📏 Number of TEU Unit of Measure (CNF_CONT_CNT_UNI):
CNF_CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Distance Unit of Measure (CNF_DISTANCE_UOM):
CNF_DISTANCE Transportation Distance
📏 Unit of Measure (CNF_UOM):
CNF_QUANTITY Quantity
📏 Chargeable Weight Unit of Measure (CNF_CHARG_WEI_UNI):
CNF_CHARG_WEI_VAL Chargeable Weight
📏 Unit of measure for length, width and height (MEASUOM):
LENGTH Length
WIDTH Width
HEIGHT Height
LENGTH_PLUS_GIRTH Length + Girth
Column Name Description
VALIDITY_START Start Date of Validity
VALIDITY_END End Date of Validity
_DATAAGING Data Filter Value for Data Aging
Column Name Description
FAGIPRIOID114 Freight Agreement Item Priority Show values
PREFDTPRIOID120 Precondition User-Defined Priority Show values
PREDGGPRIOID118 Precondition Dangerous Goods Priority Show values
PREGEOPRIOID115 Transportation Network Priority Show values
PREBUYPRIOID117 Precondition Business Partner Priority Show values
PRESERPRIOID119 Precondition Services Priority Show values
PRETRMPRIOID115 Precondition Priority Show values
TCCS_ACTIONS Calculation Sheet Actions Show values
FAGUSAGEID105 Agreement Usage Show values
MOT_CAT Transportation Mode Category Show values
STAGE_CAT Stage Category Show values
TIME_DET_TYPE Time Determination Type Show values
IS_HEADER_CHARGE Boolean Variable (X = True, - = False, Space = Unknown) Show values
CUST_TMPL_IND Customizing Template Show values
WEB_TMPL_IND Master Data Template Only Show values
UNCONTROLLED Uncontrolled Transportation Show values
CONSOLIDATION Buyer's Consolidation or Shipper's Consolidation Show values
BILLING_SCHEME Settlement Basis Show values
RESPONDED Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
RESP_STATUS_CODE Item Status Show values
RFQ_ITEM_TYPE_CODE RFQ Item Type Code Show values
PERIODICITY Periodicity Show values
PRIORITY Priority Show values
AWARD_CONFIRM Confirmation by Carrier Show values
OPT_AT_CAP_LINE Individual Capacity Optimization in RFQ Show values
HAS_PREFERRED_STR Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
MANDATORY_SERVICE Mandatory Service Show values
BUSINESS_SHARE Target Share Show values
FLOW_SERVICE Propagate Services Show values
OWNERSHIP_TYPE Ownership Type Show values
EXCLUSION_RELEVANT Usage Independent (Do not Use Directly in BOs) Show values
NEW_FAG_OPT Creation/Update Level Show values
PRE_CONDITION_ROOT_PRESENT Precondition Root Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
ITEM_NO Agreement Item Number /SCMTMS/FAG_ITEM_NO
MNEMONIC Agreement Description /SCMTMS/FAG_DESCRIPTION
EEW_FAG_ITEMS Dummy function in length 1 DUMMY
TCCS_UUID Internal Universally Unique Identifier
PRECOND_UUID Internal Universally Unique Identifier
TCCS_ID Calculation Sheet /SCMTMS/TRCHARG_CALC_SHEETID
TCCS_TEMPL_WEB Calculation Sheet Template CHAR20
TCCS_TEMPL_UUID Internal Universally Unique Identifier
MOT Transportation Mode VKTRA
SHIPPING_TYPE Shipping Type /SCMTMS/SHIPPING_TYPE
TRPPRIO135_DESCR Text, 40 Characters Long TEXT40
UUID047 Internal Universally Unique Identifier
COND_TRANSRULE Name of Condition /SCMTMS/CONDITION_ID
DURATION Duration TSTRDURAN
CONDITION_ID Condition for Determining Scheduling Info /SCMTMS/CONDITION_ID
EXT_STRAT Strategy for External Delivery Date Determination CHAR10
VALIDITY_START_TS Validity Date Start (UTC) TZNTSTMPS
VALIDITY_END_TS End Date of Validity (UTC) TZNTSTMPS
PAR_KEY NodeID /BOBF/CONF_KEY
CONTRACT_BASIS Contract Basis /SCMTMS/CONTRACT_BASIS
REF_SP_KEY NodeID /BOBF/CONF_KEY
REF_SP_ITM_KEY NodeID /BOBF/CONF_KEY
SERVICE_PRODUCT_ID Service Product /SCMTMS/SERVICE_PRODUCT_ID
TSP_ID Carrier BU_PARTNER
BTD_ID Bus. Trans. Document ID /SCMTMS/BTD_ID
EXTERNAL_FA_ID External Reference Number /SCMTMS/EXT_FA_ID
TAL_GUID NodeID /BOBF/CONF_KEY
SOL_SPEND_DIMENSION Capacity Dimension /SCMTMS/SOL_SPEND_DIMENSION
MASTER_RFQ_ITEM_KEY NodeID /BOBF/CONF_KEY
RESP_SUBMIT RFQ Response Submit Timestamp (UTC) TZNTSTMPS
ITEM_EQUIP_GROUP Equipment Group /SCMB/EQUI_TYPE
ITEM_EQUIP_TYPE Equipment Type /SCMB/EQUI_CODE
GRACE_PERIOD Grace Period /SCMTMS/GRACE_PERIOD
CARRIER_NO Business Partner Number BU_PARTNER
CARRIER_UUID Business Partner /SCMTMS/BUPAUUID
DIMENSION Dimension key DIMID
MTR Means of Transport /SAPAPO/TR_TRATY
AWARD_CONFIRM_REASON Award Confirmation Reason /SCMTMS/AWARD_CONFIRM_REASON
RESP_DIMENSION Dimension key DIMID
CNF_DIMENSION Dimension key DIMID
AIRLC IATA Airline Code /SCMTMS/AIRLC
EXT_ITEM_NO External Item Number /SCMTMS/EXT_ITEM_NO
FORECAST_VERSION Forecast Analysis ID CHAR20
CRKPI_PROFILE_ID Carrier KPI Profile
CARRIER_SERVICE_CODE Carrier Service Code CHAR10
REF_AGREEMENT_UUID Internal Universally Unique Identifier
REF_AGREEMENT_ITEM_UUID Internal Universally Unique Identifier
REF_AGREEMENT_ID Agreement /SCMTMS/FAG_ID
REF_AGREEMENT_ITEM_NO Agreement Item Number /SCMTMS/FAG_ITEM_NO
CRM_OPP_ITM Opportunity Item Number /SCMTMS/FAG_ITEM_NO
CRM_OPP_ITM_GUID NodeID /BOBF/CONF_KEY
CRM_OPP Opportunity ID /SCMTMS/BTD_ID
CRM_OPP_GUID NodeID /BOBF/CONF_KEY
OPM_STRATEGY_KEY NodeID /BOBF/CONF_KEY
FAGRMNTID044_UUID NodeID /BOBF/CONF_KEY
Master Data Relations Join Conditions
Calendar for Arrivals /SCMTMS/D_FAGITM.ARRIVAL_CAL == TFACD.IDENT
Air Waybill Type
  • Air Waybill Type
  • Client
Calendar for Departures /SCMTMS/D_FAGITM.DEPARTURE_CAL == TFACD.IDENT
Dimensional Weight Profile
Exchange Rate Type
  • /SCMTMS/D_FAGITM.MANDT == TCURV.MANDT
  • /SCMTMS/D_FAGITM.EXCH_RATE_TYPE == TCURV.KURST
Item Type
Movement Type
Service Type
Stage Type
Calendar for Transits /SCMTMS/D_FAGITM.TRANSIT_CAL == TFACD.IDENT