I_StkMTMWithQltyCharcsCube

Stock MTM With Quality Characteristics - Cube | view: IACMSTKQLTYCUBE | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: /ACCGO/T_CAS_CAI, JEST, /ACCGO/T_UISEVNT, /ACCGO/T_UISHDR
Column Name Description
PricingKey A key required to access versioned pricing data
Version 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 Evaluation Key Date
Column Name Description
Column Name Description
📏 Unit of Measure for Commodity (CommodityUnit):
GrossQuantity Gross Quantity
NetPriceExpsrQuantity Calculated Net Quantity in Base UoM
Column Name Description
EndOfDaySnapshotDate Evaluation Key Date
ValidityStartDate Valid-From Date
DeliveryDate Delivery Date
ExchRateEvaluationDate Exchange Rate Evaluation Date
DocToStstcCrcyExchRateEvalDate Document to Statistics Currency Evaluation Date
MaturityKeyDate Maturity Key Date
QuotationPeriodReferenceDate Reference Date
ExchRateMaturityDate Payment Date
ACMSnapshotDate null
Column Name Description
MTMDataSourceType Type of Data Record Show values
LoadDataCaptureEventType Net Dry Event Show values
IsIntercompanyTransfer Intercompany Transfer Show values
HasError Flag: Error occured Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
PricingStatus Future/Basis Price Fixation Status Show values
NonCASPurIsRlvt Checkbox Show values
Column Name Description Domain name
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
CompanyCode Company Code BUKRS
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
Creditor Account Number of Supplier LIFNR
SoldToParty Customer Number KUNNR
Material Material Number MATNR
Commodity Commodity TBA_STOEFFCHEN
PhysicalCommodity Physical Commodity TBA_STOEFFCHEN
Plant Plant WERKS
StorageLocation Storage location LGORT
Batch Batch Number CHARG
GoodsMovementType Movement type (inventory management) BWART
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem null
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
DeliveryYear Abjusted Reporting Year
DeliveryMonth Adjusted Reporting Month CHAR3
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
MarketToDocExchRate Exchange Rate: Market to Document Currency
MarketToDocFrozenExchRate Exchange Rate: Market to Document Currency at a Key Date
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
BasisID Basis ID TBAC_BASIS_ID
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
SystemMessageNumber System Message Number
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
StockRefDocument Reference Document CMM_MTM_OBJID
StockRefDocumentItem Reference Document item
RefDocumentYear null
StockRefDocType Reference Document (BOR) Object Type OJ_NAME
SplitItemLineNumber Split Line Number
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
CmmdtyTransptDriverID Driver Name /ACCGO/D_DRIVER
VehicleLicensePlateNumber License Plate Number /ACCGO/D_LICENSE_PLATE
VehicleId Vehicle Number /ACCGO/D_VEH_NO
TruckRailBargeId Truck/Rail/Barge ID /ACCGO/D_TRUCK_RAIL_BARGE_ID
CmmdtyTransptVesselID Vessel Name /ACCGO/D_VESSEL_NAME
LoadDataCaptureEventDateTime LDC Event Date Time CHAR20
MarketConditionTermRate Market Term Rate
PremDiscRateInValSchedCrcy P/D Rate
PremDiscToDocExchRate Exchange Rate: P/D Rate to Document Currency
MarketValueInStstcCurrency Market Value in Statistical Currency
PremDiscValueInStstcCurrency P/D Value in Statistical Currency
MarketValueInDocCurrency Market Value in Document Currency
PremDiscValueInDocCurrency P/D Value in Document Currency
NetValueInStstcCurrency Net Value in Statistical Currency
NetValueInDocCurrency Net Value in Document Currency
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
ConditionTermFactor Net Multiplier
IncrmtlAmtInDocCrcy Incremental Rate
DiscPremQltyAdjustedVal P/D Value in Statistical Currency
Master Data Relations Join Conditions
Mode of Transport
  • Client
  • Mode of Transport
  • I_STKMTMWITHQLTYCHARCSCUBE.MANDT == TVTR.MANDT
  • I_STKMTMWITHQLTYCHARCSCUBE.MODEOFTRANSPORT == TVTR.VKTRA