CMMFSA_D_SUBACCT

Transparent Table Application Table
20 Fields 6 CDS Views

Commodity Subaccount

CMMFSA_D_SUBACCT is an SAP database table in S/4HANA. Commodity Subaccount. It contains 20 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_CommoditySubAccount view from EXTENSION Extension View for Commodity Sub Account
I_CmmdtyIntCounterpartySubAcct view inner BASIC Subaccounts assgn. to int. Counterparty
I_CmmdtyOrderFillPacketSubAcct view left_outer BASIC Basic View for Fill Packet Subaccount
I_CommodityOrderFill view left_outer BASIC Commodity Order Fill
I_CommodityOrderRequestFill view left_outer BASIC Basic View for Commodity Order Fill
I_CommoditySubAccount view from BASIC Commodity Subaccount

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY commoditysubaccountuuid /bobf/uuid Key
commoditysubaccount cmmfsa_subaccountid Subaccount ID
commoditysubaccountname cmmfsa_subaccountname Subaccount Name
cmmdtysubaccountstatus cmmfsa_subaccountstatus Status
cmmdtysubaccountstatusreason cmmfsa_subaccountstatusreason Invalidation Reason
cmmdtysubaccountisblocked cmmfsa_subaccountisblocked Order Create Blocked
companycode bukrs Company Code
futuresaccount cmmfsa_futuresaccount Futures Account
commodity tba_stoeffchen Commodity
marketidentifiercode cmmfsa_marketidentifercode MIC
derivativecontrspecification cmmfsa_derivativecontractspec DCS
referencebrokeraccount cmmfsa_referencebrokeraccount Reference Account
portfolio rportb Portfolio
profitcenter prctr Profit Center
counterparty cmmfsa_counterparty Int. Exch. Cntrprty
commodityderivativebroker cmmfdor_broker Broker
cmmdtysubacctclearingaccount cmmfsa_subacctclearingaccount Clearing Account
commoditysubaccountclearingkey cmmfsa_subacctclearingkey Clearing Key
succ_archive cmmfsa_archive Archive Status

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.

-- Commodity Subaccount
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMFSA_D_SUBACCT (
    MANDT,                           -- Client [mandt]
    COMMODITYSUBACCOUNTUUID,         -- Key [/bobf/uuid]
    COMMODITYSUBACCOUNT,             -- Subaccount ID [cmmfsa_subaccountid]
    COMMODITYSUBACCOUNTNAME,         -- Subaccount Name [cmmfsa_subaccountname]
    CMMDTYSUBACCOUNTSTATUS,          -- Status [cmmfsa_subaccountstatus]
    CMMDTYSUBACCOUNTSTATUSREASON,    -- Invalidation Reason [cmmfsa_subaccountstatusreason]
    CMMDTYSUBACCOUNTISBLOCKED,       -- Order Create Blocked [cmmfsa_subaccountisblocked]
    COMPANYCODE,                     -- Company Code [bukrs]
    FUTURESACCOUNT,                  -- Futures Account [cmmfsa_futuresaccount]
    COMMODITY,                       -- Commodity [tba_stoeffchen]
    MARKETIDENTIFIERCODE,            -- MIC [cmmfsa_marketidentifercode]
    DERIVATIVECONTRSPECIFICATION,    -- DCS [cmmfsa_derivativecontractspec]
    REFERENCEBROKERACCOUNT,          -- Reference Account [cmmfsa_referencebrokeraccount]
    PORTFOLIO,                       -- Portfolio [rportb]
    PROFITCENTER,                    -- Profit Center [prctr]
    COUNTERPARTY,                    -- Int. Exch. Cntrprty [cmmfsa_counterparty]
    COMMODITYDERIVATIVEBROKER,       -- Broker [cmmfdor_broker]
    CMMDTYSUBACCTCLEARINGACCOUNT,    -- Clearing Account [cmmfsa_subacctclearingaccount]
    COMMODITYSUBACCOUNTCLEARINGKEY,  -- Clearing Key [cmmfsa_subacctclearingkey]
    SUCC_ARCHIVE,                    -- Archive Status [cmmfsa_archive]
    PRIMARY KEY (MANDT, COMMODITYSUBACCOUNTUUID)
);

Learn More