P_Stock_Delta_DPQS_Value_O

Stock Delta DPQS Value | view: PACMSTKDPQSVALO | Extraction: Not supported | Component: SAP Agricultural Contract Management
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):
CommodityQuantity Commodity Quantity
CommodityQuantityInBaseUnit Open Commodity Quantity
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
NetPriceExpsrQuantity Calculated Net Quantity in Base UoM
GrossQuantity Gross Quantity
NetPriceExpsrQtyInBaseUnit Calculated Net Quantity in Base UoM
Column Name Description
EndOfDaySnapshotDate Evaluation Key Date
ValuationDate Evaluation Key Date
SnapshotDate0 Evaluation Key Date
SnapshotDate1 Evaluation Key Date
ValidityStartDate Valid-From Date
ValidityStartDateTime Valid-From Time
DeliveryDate Delivery Date
ExchRateEvaluationDate Exchange Rate Evaluation Date
DocToStstcCrcyExchRateEvalDate Document to Statistics Currency Evaluation Date
MarketToDocExchrateDate From Date of FX Rate
DocToStatisticalExchRateDate From Date of FX Rate
QuotationPeriodReferenceDate Reference Date
MaturityKeyDate Maturity Key Date
OldestQuotationDate Oldest Quotation Date
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
FixedExchRateDate Date when forward FX rate is frozen
ExchRateMaturityDate Payment Date
Column Name Description
DataSelectionType VLOGP Data Selection Type Show values
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
ConditionTermRateIsFixed Indicates that the term is fixed Show values
ConditionTermExchRateIsFixed Indicates that the term is fixed Show values
PricingStatus Future/Basis Price Fixation Status Show values
RecordIsLogicallyDeleted Logically Deleted Status Show values
NetDryErrorCode Error Code Show values
NonCASPurIsRlvt Checkbox Show values
Column Name Description Domain name
Scenario Scenario T_SZENARIO
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
MaximumVersion Highest Version Number CMM_MTM_VERSION
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
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
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
ConditionTermRate1 CPE Term - Rate in Term Currency(up to 14 decimals) CPE_INTERNAL_VALUE
MarketToDocExchrate1 CPE Term - Rate in Term Currency(up to 14 decimals) CPE_INTERNAL_VALUE
ConditionTermRate Price
MarketToDocExchRate Exchange Rate: Market to Document Currency
MarketToDocFrozenExchRate Exchange Rate: Market to Document Currency at a Key Date
ConditionTermRateQuantity Price Unit
ConditionTermValueInDocCrcy Value in Document Currency
ConditionTermValueInStstcCrcy Value in Statistical Currency
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
SystemMessageNumber System Message Number
BasisID Basis ID TBAC_BASIS_ID
BasisType Basis Type TBAC_BASIS_TYPE
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
QuotationPriceType Type of Price Quotation VVSKURSART
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MtmCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
BsmktRefDrvtvContrMaturityCode Basis Market Reference Contract Maturity Code CMM_BAS_MKT_REF_CONTRACT_CODE
FloatMarketToDocExchRate CPE Formula - Value in Formula Currency DF34 CPE_INTERNAL_VALUE
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
SourceDocumentYear Material Document Year GJAHR
QuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
LoadDataCaptureObjectID Load Data Capture Object ID /ACCGO/D_UIS_ID
QuantityRepositoryUUID Application GUID SYSUUID_X16
QuantityRepositoryVersion Version /ACCGO/D_QREP_ID
DiscPremQtyScheduleUniqueID Schedule ID /ACCGO/D_SCHEDULE_ID
DiscPremQtyScheduleVersion Schedule Version /ACCGO/D_VERSION
ApplicationDocument Application Document Number /ACCGO/D_APPLDOC
ApplicationDocumentItem null
LDCId Load Data Capture Object ID /ACCGO/D_UIS_ID
StockRefDocument Reference Document CMM_MTM_OBJID
StockRefDocumentItem null
RefDocumentYear null
StockRefDocType Reference Document (BOR) Object Type OJ_NAME
SplitItemLineNumber Split Line Number
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
IncrmtlRateInDocCrcy Incremental Rate
DiscPremQltyAdjustedVal P/D Value in Statistical Currency
Master Data Relations Join Conditions
Mode of Transport
  • Mode of Transport
  • Client
  • P_STOCK_DELTA_DPQS_VALUE_O.MODEOFTRANSPORT == TVTR.VKTRA
  • P_STOCK_DELTA_DPQS_VALUE_O.MANDT == TVTR.MANDT