/SCMTMS/D_SF_ROT

Transparent Table Application Table
63 Fields 2 CDS Views

Table for Root Node

/SCMTMS/D_SF_ROT is an SAP database table in S/4HANA. Table for Root Node. It contains 63 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SupplierFreightInvoiceReq view from BASIC Supplier Freight Invoice Request
P_SupFrtInReqTrnChgItElmEnrcd view inner BASIC

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
sfir_id /SCMTMS/SFIR_ID Freight SD
sfir_type /SCMTMS/SFIR_TYPE FSD Type
sfir_category /SCMTMS/SFIR_CATEGORY FSD Category
creation_type /SCMTMS/SFIR_CREATE_TYPE Document Source
logsys /SCMTMS/LOGSYS_SENDING Logical Syst. (Send)
bill_from_party /SCMTMS/BUPAUUID Business Partner
tsp_uuid /SCMTMS/BUPAUUID Business Partner
tsp_id /SCMTMS/PTY_CARRIER Carrier
payee_id /SCMTMS/BUPAUUID Business Partner
erp_comp_org_id /SCMB/COMPANY_ORG Company Org.
purch_org_id /SCMTMS/PURCH_ORG_ID Purch. Organization
purch_grp_id /SCMTMS/PURCH_GRP_ID Purchasing Group
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On
block_reason /SCMTMS/BLOCK_REASON_CODE Block Reason
sfir_eew_root DUMMY Dummy function in length 1
lifecycle /SCMTMS/SFIR_LC_STATUS FSD Status
block /SCMTMS/BLOCK_STATUS Block Status
consistency /SCMTMS/CONSISTENCY_STATUS Consistency Status
archiving /SCMTMS/ARCHIVING_STATUS_CODE Archiving Status
confirmation /SCMTMS/SFIR_CONFIRM_STATUS FSD Conf Status
wfl_status /SCMTMS/INV_WFL_STATUS Workflow Status
invdisp_confirmation /SCMTMS/DISP_CONF_STATUS Action Status
carinv_disp_res_status /SCMTMS/TOR_INVDISP_RES_STS Dispute Case Status
inv_dt /SCMTMS/INVDT Posting Date
ppf_profile /SCMTMS/PPF_PROFILE Output Profile
ppf_profile_add /SCMTMS/PPF_PROFILE_ADD Add. Output Profile
ppf_profile_auto /SCMTMS/PPF_PROFILE_AUTO Dyn. Det. of Output
arch_ret_period /SCMTMS/ARCH_RETENTION_PERIOD Arch. Residence
archiving_time /SCMTMS/ARCH_DATETIME Archiving Date
ctrl_inv_status /SCMTMS/CTRL_INV_STATUS Influence Inv. Sts
prop_cr_amount /SCMTMS/PROP_CR_AMOUNT Auto Credit Amt
cm_reason /SCMTMS/CR_MEMO_REASON_CODE Reason Code
inv_disp_rsn /SCMTMS/INV_DISP_RSN_CODE Dispute Case Reason
invdisp_res_status /SCMTMS/INV_DISPUTE_RES_STATUS Dispute Item Status
witem_id SWW_WIID Work Item ID
carrier_invoice_key /BOBF/CONF_KEY NodeID
carrier_inv_id /SCMTMS/CARRIER_INVOICE_ID Carrier Reference
manually_unblcked BOOLE_D TRUE
ref_bo_key /BOBF/OBM_BO_KEY Business Object
ref_key /BOBF/CONF_KEY NodeID
creation_method /SCMTMS/CREATION_METHOD Creation Method
manually_changed /SCMTMS/MANUALLY_CHANGED Manual Change
change_process_str /SCMTMS/CHNG_PROC_STR_SFIR Change Process Strategy
ageable /BOFU/AGEABLE Doc.Ageable
lean_posting BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
cncl_post_date /SCMTMS/CANCEL_POSTING_DATE Cancel Posting Date
purch_company_code /SCMTMS/PURCH_COMPANY_CODE Procuring Comp. Cde
purch_company_org_id /SCMTMS/PURCH_COMPANY_ORG_ID Purchasing Comp.Org.
ext_disp_ref /SCMTMS/CARRIER_DISPUTE_ID Ext Disp reference
creation_date_ext /SCMTMS/CREATION_DATE_EXT Doc. creation date
is_rel_to_comm /SCMTMS/IS_REL_TO_COMM Is relevant to notify carrier
ext_recipient_system /SCMTMS/LOGSYS_RECEIVING Logical Syst. (Rec.)
is_reversal_doc BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
net_inv_amount /SCMTMS/SFIR_INV_AMOUNT Verified Invoice Amt
inv_amount_curr /SCMTMS/SFIR_INV_ITEM_CURR Invoicing Crcy
zterm DZTERM Pyt Terms
document_date /SCMTMS/DOC_DATE Document Date
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Table for Root Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/D_SF_ROT (
    MANDT,                   -- Client [MANDT]
    DB_KEY,                  -- NodeID [/BOBF/CONF_KEY]
    SFIR_ID,                 -- Freight SD [/SCMTMS/SFIR_ID]
    SFIR_TYPE,               -- FSD Type [/SCMTMS/SFIR_TYPE]
    SFIR_CATEGORY,           -- FSD Category [/SCMTMS/SFIR_CATEGORY]
    CREATION_TYPE,           -- Document Source [/SCMTMS/SFIR_CREATE_TYPE]
    LOGSYS,                  -- Logical Syst. (Send) [/SCMTMS/LOGSYS_SENDING]
    BILL_FROM_PARTY,         -- Business Partner [/SCMTMS/BUPAUUID]
    TSP_UUID,                -- Business Partner [/SCMTMS/BUPAUUID]
    TSP_ID,                  -- Carrier [/SCMTMS/PTY_CARRIER]
    PAYEE_ID,                -- Business Partner [/SCMTMS/BUPAUUID]
    ERP_COMP_ORG_ID,         -- Company Org. [/SCMB/COMPANY_ORG]
    PURCH_ORG_ID,            -- Purch. Organization [/SCMTMS/PURCH_ORG_ID]
    PURCH_GRP_ID,            -- Purchasing Group [/SCMTMS/PURCH_GRP_ID]
    CREATED_BY,              -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,              -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,              -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,              -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    BLOCK_REASON,            -- Block Reason [/SCMTMS/BLOCK_REASON_CODE]
    SFIR_EEW_ROOT,           -- Dummy function in length 1 [DUMMY]
    LIFECYCLE,               -- FSD Status [/SCMTMS/SFIR_LC_STATUS]
    BLOCK,                   -- Block Status [/SCMTMS/BLOCK_STATUS]
    CONSISTENCY,             -- Consistency Status [/SCMTMS/CONSISTENCY_STATUS]
    ARCHIVING,               -- Archiving Status [/SCMTMS/ARCHIVING_STATUS_CODE]
    CONFIRMATION,            -- FSD Conf Status [/SCMTMS/SFIR_CONFIRM_STATUS]
    WFL_STATUS,              -- Workflow Status [/SCMTMS/INV_WFL_STATUS]
    INVDISP_CONFIRMATION,    -- Action Status [/SCMTMS/DISP_CONF_STATUS]
    CARINV_DISP_RES_STATUS,  -- Dispute Case Status [/SCMTMS/TOR_INVDISP_RES_STS]
    INV_DT,                  -- Posting Date [/SCMTMS/INVDT]
    PPF_PROFILE,             -- Output Profile [/SCMTMS/PPF_PROFILE]
    PPF_PROFILE_ADD,         -- Add. Output Profile [/SCMTMS/PPF_PROFILE_ADD]
    PPF_PROFILE_AUTO,        -- Dyn. Det. of Output [/SCMTMS/PPF_PROFILE_AUTO]
    ARCH_RET_PERIOD,         -- Arch. Residence [/SCMTMS/ARCH_RETENTION_PERIOD]
    ARCHIVING_TIME,          -- Archiving Date [/SCMTMS/ARCH_DATETIME]
    CTRL_INV_STATUS,         -- Influence Inv. Sts [/SCMTMS/CTRL_INV_STATUS]
    PROP_CR_AMOUNT,          -- Auto Credit Amt [/SCMTMS/PROP_CR_AMOUNT]
    CM_REASON,               -- Reason Code [/SCMTMS/CR_MEMO_REASON_CODE]
    INV_DISP_RSN,            -- Dispute Case Reason [/SCMTMS/INV_DISP_RSN_CODE]
    INVDISP_RES_STATUS,      -- Dispute Item Status [/SCMTMS/INV_DISPUTE_RES_STATUS]
    WITEM_ID,                -- Work Item ID [SWW_WIID]
    CARRIER_INVOICE_KEY,     -- NodeID [/BOBF/CONF_KEY]
    CARRIER_INV_ID,          -- Carrier Reference [/SCMTMS/CARRIER_INVOICE_ID]
    MANUALLY_UNBLCKED,       -- TRUE [BOOLE_D]
    REF_BO_KEY,              -- Business Object [/BOBF/OBM_BO_KEY]
    REF_KEY,                 -- NodeID [/BOBF/CONF_KEY]
    CREATION_METHOD,         -- Creation Method [/SCMTMS/CREATION_METHOD]
    MANUALLY_CHANGED,        -- Manual Change [/SCMTMS/MANUALLY_CHANGED]
    CHANGE_PROCESS_STR,      -- Change Process Strategy [/SCMTMS/CHNG_PROC_STR_SFIR]
    AGEABLE,                 -- Doc.Ageable [/BOFU/AGEABLE]
    LEAN_POSTING,            -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CNCL_POST_DATE,          -- Cancel Posting Date [/SCMTMS/CANCEL_POSTING_DATE]
    PURCH_COMPANY_CODE,      -- Procuring Comp. Cde [/SCMTMS/PURCH_COMPANY_CODE]
    PURCH_COMPANY_ORG_ID,    -- Purchasing Comp.Org. [/SCMTMS/PURCH_COMPANY_ORG_ID]
    EXT_DISP_REF,            -- Ext Disp reference [/SCMTMS/CARRIER_DISPUTE_ID]
    CREATION_DATE_EXT,       -- Doc. creation date [/SCMTMS/CREATION_DATE_EXT]
    IS_REL_TO_COMM,          -- Is relevant to notify carrier [/SCMTMS/IS_REL_TO_COMM]
    EXT_RECIPIENT_SYSTEM,    -- Logical Syst. (Rec.) [/SCMTMS/LOGSYS_RECEIVING]
    IS_REVERSAL_DOC,         -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    NET_INV_AMOUNT,          -- Verified Invoice Amt [/SCMTMS/SFIR_INV_AMOUNT]
    INV_AMOUNT_CURR,         -- Invoicing Crcy [/SCMTMS/SFIR_INV_ITEM_CURR]
    ZTERM,                   -- Pyt Terms [DZTERM]
    DOCUMENT_DATE,           -- Document Date [/SCMTMS/DOC_DATE]
    _DATAAGING,              -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More