/SCMTMS/D_FAGROT - Freight Agreement Root Node
Freight Agreement Root Node information is stored in SAP table /SCMTMS/D_FAGROT.
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_FAGROT
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 | |
| .INCLUDE | ROOT | /SCMTMS/S_FAG_ROOT | 0 | |||
| .INCLUDE | /SCMTMS/S_FAG_ID | 0 | ||||
| FAGRMNTID044 | Agreement | /SCMTMS/FAG_ID | CHAR | 40 | ||
| .INCLUDE | /SCMTMS/S_FAG_VSID | 0 | ||||
| FAGRMNTID045 | Agreement Version | /SCMTMS/FAG_AGREEMENT_VERSID | CHAR | 20 | ||
| MNEMONIC | Agreement Description | /SCMTMS/FAG_DESCRIPTION | CHAR | 60 | ||
| .INCLUDE | S_ADMIN_DATA | /BOFU/S_ADMIN_DATA | 0 | |||
| CREATED_BY | Created By | /BOFU/USER_ID_CREATED_BY | CHAR | 24 | ||
| CREATED_ON | Created on | /BOFU/TSTMP_CREATION_TIME | DEC | 8 | ||
| CHANGED_BY | Changed By | /BOFU/USER_ID_CHANGED_BY | CHAR | 24 | ||
| CHANGED_ON | Changed On | /BOFU/TSTMP_CHANGED_TIME | DEC | 8 | ||
| PAR_VER_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| BASE_VER_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| VERSION_NO | Existing Agreement Version | /SCMTMS/FAG_VERSION_NO | NUMC | 8 | ||
| BP_VERSION | Business Partner Version | /SCMTMS/PARTY_VERSION | CHAR | 160 | ||
| REF_FA_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| REF_FA | Agreement | /SCMTMS/FAG_ID | CHAR | 40 | ||
| REF_VER_NO | Existing Agreement Version | /SCMTMS/FAG_VERSION_NO | NUMC | 8 | ||
| EXTERNAL_FA_ID | External Reference Number | /SCMTMS/EXT_FA_ID | CHAR | 70 | ||
| STD_CONTRACTOR | All Contractors | /SCMTMS/FAG_STANDARD_CONTRCTOR | CHAR | 2 | ||
| STD_CONTRACTING | All Contracting Parties | /SCMTMS/FAG_STANDARD_CONTRACT | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_FAG_PRIORITY_CODE | 0 | ||||
| FAGPRIOID104 | Agreement Priority | /SCMTMS/FAG_PRIORITY_CODE | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_FAG_USAGE_CODE | 0 | ||||
| FAGUSAGEID105 | Agreement Usage | /SCMTMS/FAG_USAGE_CODE | CHAR | 6 | ||
| .INCLUDE | /SCMTMS/S_FAG_CATEGORY_CODE | 0 | ||||
| FAGCATEID111 | Agreement Category | /SCMTMS/FAG_CATEGORY_CODE | CHAR | 8 | ||
| FAGTYPEID103 | Agreement Type | /SCMTMS/FAG_TYPE_CODE | CHAR | 8 | /SCMTMS/C_FATYPE | |
| TCCS_ID047 | 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 | ||
| FAGTYPE_DESC | Description | /SCMTMS/DESCRIPTION_S | CHAR | 80 | ||
| DEACT_REASON | Agreement Deactivation Reason | /SCMTMS/DEACTIVATION_REASON | CHAR | 8 | /SCMTMS/C_FADE | |
| CONDITION_DEF_ID | Agreement Determination Exclusion Rule | /SCMTMS/FAG_RULE157_BADI | CHAR | 40 | /SCMTMS/C_RUL157 | |
| RULE185 | Calculation Sheet Determination Rule - BRFplus Standalone | /SCMTMS/TARIFF_RULE185_FDT | CHAR | 40 | * | |
| .INCLUDE | S_EXTENSION | /SCMTMS/INCL_EEW_FAG_ROOT | 0 | |||
| EEW_FAG_ROOT | Dummy function in length 1 | DUMMY | CHAR | 2 | ||
| 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 | ||
| TIMEZONE | Time Zone | /SCMTMS/TZONE | CHAR | 12 | * | |
| TIMESTAMP_RELEVANT | Timestamp Relevant | /SCMTMS/TIMESTAMP_RELEVANT | CHAR | 2 | ||
| DIM_WT_PROFILE | Dimensional Weight Profile | /SCMTMS/DIM_WEIGHT_PROFILE | CHAR | 20 | /SCMTMS/C_DIMWP | |
| DOC_CURRENCY | Document Currency | /SCMTMS/DOC_CURRENCY | CUKY | 10 | ||
| MUL_PTY_ALLOWED | Multiple Parties Allowed | /SCMTMS/TCC_MULTI_PTY_ALLOWED | CHAR | 2 | ||
| SHIPPING_TYPE | Shipping Type | /SCMTMS/SHIPPING_TYPE | CHAR | 6 | ||
| TRAFFIC_DIRECT | Traffic Direction | /SCMTMS/TRAFFIC_DIRECTION | CHAR | 6 | ||
| MODE_OF_TRANSP | Transportation Mode | /SCMTMS/TRMODCODE | CHAR | 4 | ||
| MODEOFTRANSP_CAT | Transportation Mode Category | /SCMTMS/TRMODCAT | CHAR | 2 | ||
| 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 | * | |
| UNCONTROLLED | Uncontrolled Transportation | /SCMTMS/UNCONTROLLED_SHPMENT | CHAR | 2 | ||
| BTD_ID | External Freight Agreement | /SCMTMS/EXT_FAG_ID | CHAR | 70 | ||
| RESOURCE_IND | Resource | /SCMTMS/RESOURCE_INDICATOR | CHAR | 2 | ||
| .INCLUDE | /SCMTMS/S_RFQ_ROOT | 0 | ||||
| RFQ_START | RFQ Valid From | /SCMTMS/RFQ_START | DEC | 8 | ||
| RFQ_END | RFQ Valid To | /SCMTMS/RFQ_END | DEC | 8 | ||
| NO_OF_STEPS | Negotiation Round | /SCMTMS/RFQ_NO_STEPS | NUMC | 10 | ||
| RFQ_TYPE_CODE | RFQ/Quotation Type | /SCMTMS/RFQ_TYPE_CODE | CHAR | 8 | * | |
| MASTER_RFQ_KEY | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| RFQ_ST_CODE | RFQ/Quotation Status | /SCMTMS/RFQ_STATUS_CODE | CHAR | 4 | ||
| RESPONSE_END | RFQ Response Deadline | /SCMTMS/RFQ_RESP_END | DEC | 8 | ||
| RFQ_REASON_CODE | Quotation Status Reason | /SCMTMS/RFQ_REASON_CODE | CHAR | 4 | * | |
| FOLLOW_UP | RFQ Follow-Up Date (UTC) | /SCMTMS/RFQ_FOLLOW_UP | DEC | 8 | ||
| CRKPI_PROFILE_ID | Carrier KPI Profile | /SCMTMS/CRKPI_PROFILE_ID | NUMC | 8 | ||
| PREV_RFQ_ST_CODE | RFQ/Quotation Status | /SCMTMS/RFQ_STATUS_CODE | CHAR | 4 | ||
| AWARD_CONFIRM_END | Award Confirmation Deadline | /SCMTMS/RFQ_AWARD_CONFIRM_END | DEC | 8 | ||
| AWARD_CONFIRM_DT | Award Confirmation Date | /SCMTMS/AWARD_CONFIRM_DT | DEC | 8 | ||
| AWARD_CONF_ROUND | Award Confirmation Round for Freight Agreement RFQ | /SCMTMS/AWARD_CONF_ROUND | NUMC | 8 | ||
| PUBLISH_DATE | Date Published | /SCMTMS/PUBLISH_DATE | DATS | 16 | ||
| BUDGET_AMOUNT | Budget | /SCMTMS/RFQ_BUDGET_AMOUNT | CURR | 16 | ||
| RESPONSIBLE_PERSON | Responsible Person | /SCMTMS/RESPONSIBLE_PERSON | CHAR | 24 | ||
| RESP_PURCHASING_ORG | Responsible Purchasing Organization | /SCMTMS/RESP_PURCHASE_ORG | CHAR | 40 | ||
| ESTIMATED_SPEND_AMOUNT | Estimated Spend | /SCMTMS/ESTIMATED_SPEND_AMOUNT | CURR | 16 | ||
| FAG_TEMPL_IND | Agreement Template | /SCMTMS/FAG_TEMPL_IND | CHAR | 2 | ||
| VALUE | Amount | /SCMTMS/AMOUNT | CURR | 15 | ||
| LOGSYS | Logical system | LOGSYS | CHAR | 20 | * | |
| OPPR_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| .INCLUDE | /SCMTMS/S_BASE_DOCUMENT | 0 | ||||
| BASE_BTD_TCO | Base Document Type for Business Transaction | /SCMTMS/BASE_BTD_TCO | CHAR | 10 | /SCMTMS/C_BTDTY | |
| BASE_BTD_ID | Base Business Transaction Document | /SCMTMS/BASE_BTD_ID | CHAR | 70 | ||
| BASE_BTD_VERSION | Base Business Transaction Document Version | /SCMTMS/BASE_BTD_VERSION | CHAR | 64 | ||
| BASE_BTD_KEY | Base Business Transaction Document Key | /SCMTMS/BASE_BTD_KEY | RAW | 16 | ||
| RFQ_UPLD_GUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| INITIATED_FROM | Predecessor Document | /SCMTMS/INTIATED_FROM | CHAR | 4 | ||
| 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 | * | |
| 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 | * | |
| .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 | * | |
| ACCEPTED_BY | Changed By | /BOFU/USER_ID_CHANGED_BY | CHAR | 24 | ||
| ACCEPTED_ON | Changed On | /BOFU/TSTMP_CHANGED_TIME | DEC | 8 | ||
| PARTNER_SCHEMA | Partner Determination Profile | /SCMTMS/PARTNER_SCHEMA | CHAR | 8 | ||
| RESP_SUBMITTED_ON | Date/Time of RFQ Response submission | /SCMTMS/RESP_SUBMITTED_ON | DEC | 8 | ||
| .INCLUDE | ROOT_STATUS | /SCMTMS/S_FAG_ROOT_STATUS | 0 | |||
| STATUS | Agreement Status | /SCMTMS/FAG_ROOT_STATUS | CHAR | 4 | ||
| ARCHIVING_STATUS | Archiving Status | /SCMTMS/ARCHIVING_STATUS_CODE | CHAR | 4 | ||
| CONSISTENCY | Consistency Status | /SCMTMS/CONSISTENCY_STATUS | CHAR | 4 | ||
| RATE_CHANGE_STATUS | Change Request Status | /SCMTMS/RATE_CHANGE_STATUS | CHAR | 4 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 | ||
| AGEABLE | Business document is or was ready for data aging | /BOFU/AGEABLE | CHAR | 2 |