/SCMTMS/D_SF_ROT

Table for Root Node | #transactional | Component: Freight Settlement
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
💲 Invoicing Currency (INV_AMOUNT_CURR):
NET_INV_AMOUNT Verified Invoice Amount
Column Name Description
Column Name Description
INV_DT Posting Date
CNCL_POST_DATE Cancellation posting date
CREATION_DATE_EXT Document creation date in external system
_DATAAGING Data Filter Value for Data Aging
Column Name Description
SFIR_CATEGORY Freight Settlement Document Category Show values
CREATION_TYPE Source of Business Document Show values
LIFECYCLE Life Cycle Status of Freight Settlement Document Show values
BLOCK Block Status Show values
CONSISTENCY Consistency Status Show values
ARCHIVING Archiving Status Show values
CONFIRMATION Confirmation Status Show values
WFL_STATUS Workflow Status Show values
INVDISP_CONFIRMATION Action Status Show values
CARINV_DISP_RES_STATUS Dispute Case 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
INVDISP_RES_STATUS Dispute Item Status Show values
MANUALLY_UNBLCKED Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CREATION_METHOD Creation Method Show values
MANUALLY_CHANGED Manual Change Show values
CHANGE_PROCESS_STR Change Process Strategy Show values
AGEABLE Business document is or was ready for data aging Show values
LEAN_POSTING Boolean Variable (X = True, - = False, Space = Unknown) Show values
IS_REL_TO_COMM Is relevant to notify carrier Show values
Column Name Description Domain name
SFIR_ID Freight Settlement Document /SCMTMS/SFIR_ID
LOGSYS Logical System (Sending System) LOGSYS
BILL_FROM_PARTY Business Partner /SCMTMS/BUPAUUID
TSP_UUID Business Partner /SCMTMS/BUPAUUID
TSP_ID Carrier /SCMTMS/BU_PARTNER
PAYEE_ID Business Partner /SCMTMS/BUPAUUID
ERP_COMP_ORG_ID Company Organization NUM08
CREATED_BY Created By XUBNAME
CREATED_ON Created on /BOFU/TSTMP
CHANGED_BY Changed By XUBNAME
CHANGED_ON Changed On /BOFU/TSTMP
BLOCK_REASON Block Reason /SCMTMS/BLOCK_REASON_CODE
SFIR_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
WITEM_ID Work item ID SWW_WIID
CARRIER_INVOICE_KEY NodeID /BOBF/CONF_KEY
CARRIER_INV_ID Carrier Reference /SCMTMS/CARRIER_INVOICE_ID
REF_BO_KEY Business Object /BOBF/CONF_KEY
REF_KEY NodeID /BOBF/CONF_KEY
PURCH_COMPANY_CODE Company Code Procuring the Transportation Service BUKRS
PURCH_COMPANY_ORG_ID Company Organization Purchasing the Transportation Service HROBJID
EXT_DISP_REF External Dispute reference
EXT_RECIPIENT_SYSTEM Logical System (Receiving System) LOGSYS
ZTERM Terms of payment key ZTERM
Master Data Relations Join Conditions
Purchasing Group
  • ?
  • ?
  • Client
  • Purchasing Group
  • /SCMTMS/D_SF_ROT.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_SF_ROT.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_SF_ROT.MANDT == PLOGI.MANDT
  • /SCMTMS/D_SF_ROT.PURCH_GRP_ID == PLOGI.OBJID
Purchasing Organization
  • ?
  • ?
  • Client
  • Purchasing Organization
  • /SCMTMS/D_SF_ROT.[column in domain "OTYPE"] == PLOGI.OTYPE
  • /SCMTMS/D_SF_ROT.[column in domain "PLVAR"] == PLOGI.PLVAR
  • /SCMTMS/D_SF_ROT.MANDT == PLOGI.MANDT
  • /SCMTMS/D_SF_ROT.PURCH_ORG_ID == PLOGI.OBJID
Type
  • Type
  • Client