/SCMTMS/D_CF_RT

Root Node | #transactional | Component: Forwarding Settlement
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Goods Value Currency (AMT_GDSV_CUR):
AMT_GDSV_VAL Goods Value
💲 Insurable Value Currency (AMT_INSV_CUR):
AMT_INSV_VAL Insurable Value
💲 Goods Value for Customs Currency (AMT_GDSVC_CUR):
AMT_GDSVC_VAL Goods Value for Customs
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
📏 Net Weight Unit of Measure (NET_WEI_UNI):
NET_WEI_VAL Net Weight
📏 Quantity Unit of Measure (QUA_PCS_UNI):
QUA_PCS_VAL Quantity
📏 Alternative Quantity 2 Unit of Measure (QUA_PCS2_UNI):
QUA_PCS2_VAL Alternative Quantity
📏 Base Unit of Measure (BASE_UOM_UNI):
BASE_UOM_VAL Base Quantity
📏 Tare Weight Unit of Measure (PKGUN_WEI_UNI):
PKGUN_WEI_VAL Tare Weight
📏 Number of TEU Unit of Measure (CONT_CNT_UNI):
CONT_CNT_VAL Number of Twenty-Foot Equivalent Units
📏 Unit of Measure for ADR 1.1.3.6 DG Exemption Points (DG_ADR_PTS_UNI):
DG_ADR_PTS_VAL ADR 1.1.3.6 DG Exemption Points
📏 Confirmed Gross Weight Unit of Measure (CNF_GRO_WEI_UNI):
CNF_GRO_WEI_VAL Confirmed Gross Weight
📏 Confirmed Gross Volume Unit of Measure (CNF_GRO_VOL_UNI):
CNF_GRO_VOL_VAL Confirmed Gross Volume
📏 Confirmed Quantity Unit of Measure (CNF_QUA_PCS_UNI):
CNF_QUA_PCS_VAL Confirmed Quantity
📏 Confirmed Alternative Quantity Unit of Measure (CNF_QUA_PCS2_UNI):
CNF_QUA_PCS2_VAL Confirmed Alternative Quantity
📏 Confirmed Number of TEU Unit of Measure (CNF_CONT_CNT_UNI):
CNF_CONT_CNT_VAL Confirmed Number of TEU
Column Name Description
INV_DT Posting Date
_DATAAGING Data Filter Value for Data Aging
Column Name Description
CFIR_CAT Document Category Show values
AMT_HVAL_CAR_IND High-Value Cargo Show values
LIFECYCLE Life Cycle Status of Forwarding Settlement Document Show values
BLOCK Block Status Show values
CONSISTENCY Consistency Status Show values
CONFIRMATION Confirmation Status Show values
ARCHIVING Archiving Status Show values
PPF_PROFILE_AUTO Dynamic Determination of Output Profile Show values
CTRL_INV_STATUS Influence Invoicing Status Show values
PROP_CR_AMOUNT Automatically Enter Credit Amount Show values
FWSD_CLASS FWSD Classification Show values
CREATION_METHOD Creation Method Show values
MANUALLY_CHANGED Manual Change Show values
CHANGE_PROCESS_STR Change Process Strategy for Forwarding Settlement Documents Show values
AGEABLE Business document is or was ready for data aging Show values
Column Name Description Domain name
CFIR_ID Forwarding Settlement Document /SCMTMS/CFIR_ID
LOGSYS Logical System (Receiving System) LOGSYS
SALES_ORG_ID Sales Organization HROBJID
SALES_OFF_ID Sales Office HROBJID
SALES_GROUP_ID Sales Group HROBJID
BP_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
BILL_TO_PRTY_KEY Bill-To Party /SCMTMS/BUPAUUID
PAYER_ADDRESS_ID Unique Identifier for Address (APC_V_ADDRESS_ID)
PAYER_PARTY_KEY Payer /SCMTMS/BUPAUUID
BLOCK_REASON Block Reason /SCMTMS/BLOCK_REASON_CODE
ATF_KEY NodeID
CREATED_BY Created By XUBNAME
CREATED_ON Created on /BOFU/TSTMP
CHANGED_BY Changed By XUBNAME
CHANGED_ON Changed On /BOFU/TSTMP
CFIR_EEW_ROOT Dummy function in length 1 DUMMY
PPF_PROFILE Output Profile PPFDCNTXT
PPF_PROFILE_ADD Additional Output Profile PPFDCNTXT
ARCH_RET_PERIOD Data Archiving Residence Time In Days
ARCHIVING_TIME Archiving Date /SCMTMS/TIMESTAMP
CM_REASON Reason Code /SCMTMS/CR_MEMO_REASON_CODE
REF_BO_KEY Business Object /BOBF/CONF_KEY
REF_KEY NodeID /BOBF/CONF_KEY
SETTLEMENT_GRP_ID Settlement Group /SCMTMS/SETTLEMENT_GROUP
Master Data Relations Join Conditions
Goods Value for Customs Currency
  • /SCMTMS/D_CF_RT.MANDT == TCURC.MANDT
  • /SCMTMS/D_CF_RT.AMT_GDSVC_CUR == TCURC.WAERS
Goods Value Currency
  • /SCMTMS/D_CF_RT.MANDT == TCURC.MANDT
  • /SCMTMS/D_CF_RT.AMT_GDSV_CUR == TCURC.WAERS
Insurable Value Currency
  • /SCMTMS/D_CF_RT.MANDT == TCURC.MANDT
  • /SCMTMS/D_CF_RT.AMT_INSV_CUR == TCURC.WAERS
Document Type