- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Collections Management (FIN-FSCM-COL)
- Credit Management (FIN-FSCM-CR)
- Digital Payments (FIN-FSCM-DP)
- Direct Bank Communication (FIN-FSCM-BNK)
- Dispute Management (FIN-FSCM-DM)
- Financial Risk Management for Commodities (FIN-FSCM-CMM)
- One Exposure (FIN-FSCM-FQM)
- Payment Factory (FIN-FSCM-PF)
- SAP Cash Management (FIN-FSCM-CLM)
- Treasury and Risk Management (FIN-FSCM-TRM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_CommoditySubAccountTP
Commodity Subaccount
| view: CCMMDTYSUBACCTTP
| Extraction:
Not supported
| Component: Commodity Derivative Order and Trade Execution
Tables used:
BUT000, BUT100, TBAC_DCS, ADCP, ADR2, ADR6, ADRP, USR21, CMMFDCO_C_RCNT, TRFT_POS_ACCOUNT, TWPOB, CMMFSA_D_BROFIX, CMMFSA_D_BROFIX, CMMFSA_D_OFFFOOT, TBAC_PHYSCOMMT, CMMFSA_D_SUBACCT, T001, TKA02, TBAC_DCST, TBAC_MICT, CEPC, CEPC, CEPCT, TBAC_DCS_LOF, TBAC_DCS_MIC, TBAC_DCS_CTY
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical (3)
- Other (25)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| CommoditySubAccountUUID | UUID serving as key (parent key, root key) |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| CreationDateDecimalValue | Created On | |
| LastChangeDate | Last Changed On |
| Column Name | Description | |
|---|---|---|
| CmmdtySubAccountStatus | Lifecycle Status of Commodity Subaccount | Show values |
| CmmdtySubAccountIsBlocked | Commodity Subaccount Blocked for Order Creation | Show values |
| CmmdtySubAccountIsOffFootPrint | Off footprint/on footprint flag | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CommoditySubAccount | Commodity Subaccount ID | CMMFSA_SUBACCOUNTID | |
| CommoditySubAccountName | Commodity Subaccount Name | CMMFSA_SUBACCOUNTNAME | |
| CompanyCodeName | Name of Company Code or Company | TEXT25 | |
| FuturesAccountName | Futures Account Text | TPM_POS_ACC_FUT_TEXT | |
| CmmdtySubAccountStatusText | Commodity Subaccount Status Text | CMMFSA_SUBACCTSTATUSTEXT | |
| CmmdtySubAccountStatusReason | Invalidation Reason | CMMFSA_SUBACCOUNTSTATUSREASON | |
| DerivativeContrSpecName | Description of Derivative Contract Specification | TEXT40 | |
| MarketIdentifierCodeName | Market Identifier Code Description | ALLTEXT | |
| CommodityName | Commodity Description | ALLTEXT | |
| Portfolio | Portfolio | RPORTB | |
| PortfolioName | Portfolio Name | TEXT30 | |
| ProfitCenterName | Description of Profit Center | TEXT20 | |
| Counterparty | Internal Exchange Counterparty | BU_PARTNER | |
| CounterpartyFullName | null | ||
| CommodityDerivativeBroker | Commodity Derivative Broker | BU_PARTNER | |
| BusinessPartnerFullName | Commodity Derivative Broker Name | CMMFDOR_BROKERNAME | |
| ReferenceBrokerAccount | Reference Account | CMMFSA_REFERENCEBROKERACCOUNT | |
| CommoditySubAccountClearingKey | Commodity Subaccount Clearing Key | CMMFSA_SUBACCTCLEARINGKEY | |
| CreationDateTime | Timestamp of record creation | TZNTSTMPS | |
| CreatedByUserName | Created by user name | TEXT80 | |
| CreatedByUser | Created By User | USNAM | |
| LastChangeDateTime | Timestamp of last change | TZNTSTMPS | |
| CmmdtyDrvtvOrdTrdExecIsRecent | null | ||
| LastChangedByUserName | Last changed by user name | TEXT80 | |
| LastChangedByUser | Last changed by user ID | USNAM |
| Master Data Relations | Join Conditions |
|---|---|
Commodity
|
|
Company Code
| |
| Derivative Contract Specification (DCS) | C_COMMODITYSUBACCOUNTTP.MANDT == TBAC_DCS.CLIENT |
Treasury Futures Account
|
|
Market Identifier Code (MIC)
| |
Profit Center
|
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
Commodity Subaccount Clearing Account
|
|