CMMFSA_D_SUBACCT

Transparent Table Application Table
25 Fields 6 CDS Views

Commodity Subaccount

CMMFSA_D_SUBACCT is an SAP database table in S/4HANA. Commodity Subaccount. It contains 25 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 (25)

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
dummy_subaccountextn CFD_DUMMY Dummy
createdbyuser CMMFSA_CREATEDBY Created By
creationdatetime CMMFSA_CREATIONDATETIME Created On
lastchangedbyuser CMMFSA_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime CMMFSA_LASTCHANGEDATETIME Last Changed On

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]
    DUMMY_SUBACCOUNTEXTN,            -- Dummy [CFD_DUMMY]
    CREATEDBYUSER,                   -- Created By [CMMFSA_CREATEDBY]
    CREATIONDATETIME,                -- Created On [CMMFSA_CREATIONDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [CMMFSA_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,              -- Last Changed On [CMMFSA_LASTCHANGEDATETIME]
    PRIMARY KEY (MANDT, COMMODITYSUBACCOUNTUUID)
);

Learn More