/SCMTMS/D_FAGROT

Freight Agreement Root Node | #transactional | Component: Freight Agreement Management
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
BUDGET_AMOUNT Budget
ESTIMATED_SPEND_AMOUNT Estimated Spend
💲 Document Currency (DOC_CURRENCY):
VALUE Amount
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
📏 Number of TEU Unit of Measure (CONT_CNT_UNI):
CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 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
Column Name Description
VALIDITY_START Start Date of Validity
VALIDITY_END End Date of Validity
PUBLISH_DATE Date Published
_DATAAGING Data Filter Value for Data Aging
Column Name Description
STD_CONTRACTOR All Contractors Show values
STD_CONTRACTING All Contracting Parties Show values
FAGPRIOID104 Agreement Priority Show values
FAGUSAGEID105 Agreement Usage Show values
TIMESTAMP_RELEVANT Timestamp Relevant Show values
MUL_PTY_ALLOWED Multiple Parties Allowed Show values
TRAFFIC_DIRECT Traffic Direction Show values
MODEOFTRANSP_CAT Transportation Mode Category Show values
CUST_TMPL_IND Customizing Template Show values
WEB_TMPL_IND Master Data Template Only Show values
UNCONTROLLED Uncontrolled Transportation Show values
RESOURCE_IND Resource Show values
RFQ_ST_CODE RFQ/Quotation Status Show values
PREV_RFQ_ST_CODE RFQ/Quotation Status Show values
FAG_TEMPL_IND Agreement Template Show values
INITIATED_FROM Predecessor Document Show values
STATUS Agreement Status Show values
ARCHIVING_STATUS Archiving Status Show values
CONSISTENCY Consistency Status Show values
RATE_CHANGE_STATUS Change Request Status Show values
AGEABLE Business document is or was ready for data aging Show values
Column Name Description Domain name
FAGRMNTID044 Agreement /SCMTMS/FAG_ID
FAGRMNTID045 Agreement Version
MNEMONIC Agreement Description /SCMTMS/FAG_DESCRIPTION
CREATED_BY Created By XUBNAME
CREATED_ON Created on /BOFU/TSTMP
CHANGED_BY Changed By XUBNAME
CHANGED_ON Changed On /BOFU/TSTMP
PAR_VER_KEY NodeID /BOBF/CONF_KEY
BASE_VER_KEY NodeID /BOBF/CONF_KEY
VERSION_NO Existing Agreement Version /SCMTMS/FAG_VERSION_NO
BP_VERSION Business Partner Version
REF_FA_GUID NodeID /BOBF/CONF_KEY
REF_FA Agreement /SCMTMS/FAG_ID
REF_VER_NO Existing Agreement Version /SCMTMS/FAG_VERSION_NO
EXTERNAL_FA_ID External Reference Number /SCMTMS/EXT_FA_ID
TCCS_ID047 Calculation Sheet /SCMTMS/TRCHARG_CALC_SHEETID
TCCS_TEMPL_WEB Calculation Sheet Template CHAR20
FAGTYPE_DESC Description /SCMTMS/DESCRIPTION_S
RULE185 Calculation Sheet Determination Rule - BRFplus Standalone /SCMTMS/TARIFF_RULE185_FDT
EEW_FAG_ROOT Dummy function in length 1 DUMMY
VALIDITY_START_TS Validity Date Start (UTC) TZNTSTMPS
VALIDITY_END_TS End Date of Validity (UTC) TZNTSTMPS
TIMEZONE Time Zone TZNZONE
SHIPPING_TYPE Shipping Type /SCMTMS/SHIPPING_TYPE
MODE_OF_TRANSP Transportation Mode VKTRA
CONTRACT_BASIS Contract Basis /SCMTMS/CONTRACT_BASIS
BTD_ID External Freight Agreement /SCMTMS/EXT_FA_ID
RFQ_START RFQ Valid From TZNTSTMPS
RFQ_END RFQ Valid To TZNTSTMPS
NO_OF_STEPS Negotiation Round /SCMTMS/RFQ_NO_OF_STEPS
RFQ_TYPE_CODE RFQ/Quotation Type /SCMTMS/RFQ_TYPE_CODE
MASTER_RFQ_KEY NodeID /BOBF/CONF_KEY
RESPONSE_END RFQ Response Deadline TZNTSTMPS
RFQ_REASON_CODE Quotation Status Reason /SCMTMS/RFQ_REASON_CODE
FOLLOW_UP RFQ Follow-Up Date (UTC) TZNTSTMPS
CRKPI_PROFILE_ID Carrier KPI Profile
AWARD_CONFIRM_END Award Confirmation Deadline TZNTSTMPS
AWARD_CONFIRM_DT Award Confirmation Date TZNTSTMPS
AWARD_CONF_ROUND Award Confirmation Round for Freight Agreement RFQ /SCMTMS/AWARD_CONF_ROUND
RESPONSIBLE_PERSON Responsible Person XUBNAME
RESP_PURCHASING_ORG Responsible Purchasing Organization /SCMB/ORG_EXT_ID
LOGSYS Logical system LOGSYS
OPPR_GUID NodeID /BOBF/CONF_KEY
BASE_BTD_ID Base Business Transaction Document /SCMTMS/BTD_ID
BASE_BTD_VERSION Base Business Transaction Document Version /SCMTMS/BTD_VERSION
BASE_BTD_KEY Base Business Transaction Document Key
RFQ_UPLD_GUID NodeID /BOBF/CONF_KEY
RESP_DIMENSION Dimension key DIMID
CNF_DIMENSION Dimension key DIMID
ACCEPTED_BY Changed By XUBNAME
ACCEPTED_ON Changed On /BOFU/TSTMP
PARTNER_SCHEMA Partner Determination Profile /SCMTMS/PARTNER_SCHEMA
RESP_SUBMITTED_ON Date/Time of RFQ Response submission /BOFU/TSTMP
Master Data Relations Join Conditions
Base Document Type for Business Transaction
Agreement Determination Exclusion Rule
  • Agreement Determination Exclusion Rule
  • Client
Agreement Deactivation Reason
  • Agreement Deactivation Reason
  • Client
Dimensional Weight Profile
Agreement Type /SCMTMS/D_FAGROT.FAGTYPEID103 == /SCMTMS/C_FATYPE.CLIENT