- 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)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Commodity Management in Logistics (LO-CMM)
- ERP Logistik Integration (LO-INT)
- Engineering Change Management (LO-ECH)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- SAP Agricultural Contract Management (LO-AGR)
- Segmentation (LO-SGT)
- Settlement Management (LO-AB)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- 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_ACMCtrNetStkFinEndOfDayQry
ACM EOD MTM for Stock Netdry and CM Fin - Qry
| view: CACMNETSTKFINEOD
| Extraction:
Not supported
| Component: Application and Call Off
Tables used:
/ACCGO/T_CAS_CAI, JEST, CMM_FINSYNC, /ACCGO/T_CAKHDR, CMM_LOGSYNC, CMM_DEND_RUN, CMM_VFIND, /ACCGO/T_UISEVNT, /ACCGO/T_UISHDR, CMM_VFINR, CMMF_SVSTATE, MARM, CMM_UOM_CONV, CMM_VLOGP, TBAC_PHYSCOMM, T006, T006A, T100
| Column Name | Description | |
|---|---|---|
| PricingKey | A key required to access versioned pricing data | |
| ACMPricingVersion | Version of an MtM Valuation Record | |
| PricingDocumentItem | Condition item number | |
| ConditionType | Condition Type | |
| SubConditionType | The key of a sub-condition type | |
| VersStockRecordUUID | GUID assigned to the VlogP stock delta record | |
| EndOfDaySnapshotDate | Snapshot Date | |
| CompanyCode | Company Code | |
| CommodityPriceExposure | Commodity Price Exposure ID | |
| CommodityExposureCategory | Exposure Category | Show values |
| CommodityPriceSubExposure | Hash key |
| Column Name | Description | |
|---|---|---|
| 💲 Statistics Currency (StatisticsCurrency): | ||
| ConditionTermValueInStstcCrcy | Value in Statistical Currency | |
| 💲 Price Currency (ConditionTermRateCurrency): | ||
| ConditionTermRate | Price | |
| 💲 Evaluation in Quotation Currency (QuotationCurrency): | ||
| RiskAnalyzerKeyFigInQtanCrcy | ContractVvalue (CV) in Quotation Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Commodity (CommodityUnit): | ||
| CommodityQuantity | Commodity Quantity | |
| CommodityQuantityInTermUnit | null | |
| GrossQuantity | Gross Quantity | |
| NetPriceExpsrQuantity | Net Quantity in Commodity UoM | |
| Column Name | Description | |
|---|---|---|
| EndOfDaySnapshotDate | Snapshot Date | |
| ValidityStartDate | Last Changed Date | |
| MaturityKeyDate | Maturity Key Date | |
| QuotationPeriodReferenceDate | Reference Date | |
| ExchRateEvaluationDate | Exchange Rate Evaluation Date | |
| DocToStstcCrcyExchRateEvalDate | Document to Statistics Currency Evaluation Date | |
| ExchRateMaturityDate | Maturity Date | |
| BasisMarketRefKeyDate | Basis Market reference maturity keydate | |
| ExposureDueDate | Date on which the exposure is due and expires | |
| ReportingDate | Reporting Date | |
| EvaluationDate | null | |
| DeliveryDate | Delivery Date | |
| ACMSnapshotDate | null |
| Column Name | Description | |
|---|---|---|
| CommodityExposureCategory | Exposure Category | Show values |
| MTMConditionGroupCategory | Categorization of Condition Group | Show values |
| PricingStatus | Future/Basis Price Fixation Status | Show values |
| MTMAdjustmentType | Type of adjustment for the MtM or TPL calculation | Show values |
| LoadDataCaptureEventType | Net Dry Event | Show values |
| NonCASPurIsRlvt | CAS Relevant | Show values |
| ConditionTermRateIsFixed | Indicates that the term is fixed | Show values |
| CashFlowDirection | Cash Flow Direction | Show values |
| TreasuryPositionLongShortCode | Code: Long or Short Position | Show values |
| CmmdtyForwardIndexTiming | Timing/Periodicity of Commodity Forward Indexes | Show values |
| MTMDataSourceType | Type of Data Record | Show values |
| HasError | Flag: Error occured | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ProfitCenter | Profit Center | PRCTR | |
| Plant | Plant | WERKS | |
| PhysicalCommodity | Physical Commodity | TBA_STOEFFCHEN | |
| Material | Material Number | MATNR | |
| OriginReferenceDocument | Root Document | CMM_MTM_OBJID | |
| SourceDocumentBusObjType | Source Document Business Object Type | ||
| SourceDocument | Source Document | CMM_MTM_OBJID | |
| SourceDocumentItem | Source Document Item | ||
| IncotermsClassification | Incoterms (Part 1) | INCO1 | |
| IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| ConditionApplication | Application | KAPPL | |
| MTMCalculationGroup | MtM Calculation Group | CMM_MTM_CGROUP | |
| DerivativeContractMaturityCode | Contract Maturity Code | TBA_CONTRACT_CODE | |
| BasisID | Basis ID | TBAC_BASIS_ID | |
| DerivativeContrSpecification | Derivative Contract Specification ID | TBA_DCSID | |
| MarketIdentifierCode | Market Identifier Code | TBA_MIC | |
| ConditionTermRateFixation | Fixation ID | ||
| ConditionTermValueInDocCrcy | Value in Document Currency | ||
| MarketToDocExchRate | Exchange Rate: Market to Document Currency | ||
| DocToStatisticalExchRate | Exchange Rate: Document to Statistics Currency | ||
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| PurchasingOrganization | Purchasing organization | EKORG | |
| MaterialGroup | Material Group | MATKL | |
| Creditor | Account Number of Supplier | LIFNR | |
| SoldToParty | Customer Number | KUNNR | |
| StorageLocation | Storage location | LGORT | |
| Batch | Batch Number | CHARG | |
| GoodsMovementType | Movement type (inventory management) | BWART | |
| ReferenceDocument | Reference document number | AWREF | |
| ReferenceDocumentItem | Predecessor Document Item | CMM_VLOGP_REF_ITEM | |
| RefDocumentYear | Material Document Year | GJAHR | |
| ConditionTermRateQuantity | Price Unit | ||
| MTMConditionGroup | MtM Condition Group | CMM_MTM_CGROUP | |
| BasisMarketRefRate | Original Basis Market reference rate | CMM_GMDA_PRICE | |
| BasisMarketRefAdjustmentSpread | Adjustment Value | CMM_GMDA_PRICE | |
| MarketToDocFrozenExchRate | Exchange Rate: Market to Document Currency at a Key Date | ||
| StockRefDocType | Reference Document (BOR) Object Type | OJ_NAME | |
| StockRefDocument | Reference Document | CMM_MTM_OBJID | |
| StockRefDocumentItem | Reference Document item | ||
| ApplicationDocument | Application Document Number | /ACCGO/D_APPLDOC | |
| ApplicationDocumentItem | Application Document Item Number | WLF_GENERIC_ITEM_NUM | |
| LDCId | Load Data Capture Object ID | /ACCGO/D_UIS_ID | |
| DiscPremCharcValsInValSchedTxt | Characteristic Values - Value Schedule | CHAR1333 | |
| DiscPremCharcValsInVolSchedTxt | Characteristic Values - Volume Schedule | CHAR1333 | |
| DPQSValueScheduleName | Value Schedule Name | /ACCGO/D_SCHEDULE_NAME | |
| DPQSVolumeScheduleName | Volume Schedule Name | /ACCGO/D_SCHEDULE_NAME | |
| MarketConditionTermRate | Market Term Rate | ||
| PremDiscRateInValSchedCrcy | P/D Rate | ||
| IncrmtlAmtInDocCrcy | Incremental Rate | ||
| PremDiscToDocExchRate | Exchange Rate: P/D Rate to Document Currency | ||
| MarketValueInStstcCurrency | Market Value in Statistical Currency | ||
| PremDiscValueInStstcCurrency | P/D Value in Statistical Currency | ||
| NetValueInStstcCurrency | Net Value in Statistical Currency | ||
| MarketValueInDocCurrency | Market Value in Document Currency | ||
| PremDiscValueInDocCurrency | P/D Value in Document Currency | ||
| NetValueInDocCurrency | Net Value in Document Currency | ||
| DiscPremQltyAdjustedVal | P/D Value in Statistical Currency | ||
| ConditionTermFactor | CPE condition type term factor | ||
| BsMktRefDrvtvContrMaturityCode | Basis Market Reference Contract Maturity Code | CMM_BAS_MKT_REF_CONTRACT_CODE | |
| MaximumVersion | Highest Version Number | CMM_MTM_VERSION | |
| TimeToMaturity | Time to Maturity | TBA_TENOR | |
| CmmdtyForwardIndexTimingText | Short Text for Fixed Values | DDTEXT | |
| FinancialInstrProductCategory | Product Category | VVSANLF | |
| FinancialAssetsMgmtProductType | Product Type | VVSART | |
| FinInstrTransactionCategory | Transaction Category | T_SFGTYP | |
| FinancialInstrumentProductType | Financial Transaction Type | T_SFHAART | |
| FinancialInstrActivityCategory | Transaction Activity Category | T_SFGZUTY | |
| OriginReferenceDocumentItem | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| OriginReferenceDocBusObjType | Root Document (BOR) Object Type | OJ_NAME | |
| DeliveryYear | Abjusted Reporting Year | ||
| DeliveryMonth | Adjusted Reporting Month | CHAR3 | |
| ExternalKeyFigureValue | External Key figures | ||
| OptionDeltaFactor | Option Delta Factor Value | CDS_OPTION_DELTA_FACTOR | |
| SystemMessageText | Message Text | NATXT | |
| Trader | Responsible Trader ID |