P_DGR_Konvd_UpdateDPQS

Column Name Description
PricingKey A key required to access versioned pricing data
PricingDocumentItem Condition item number
ConditionType Condition Type
SubConditionType The key of a sub-condition type
VersStockRecordUUID GUID assigned to the VlogP stock delta record
Column Name Description
Column Name Description
CommodityQuantityInBaseUnit null
CommodityExposureQuantity null
📏 null (CommodityExposureUnit):
CommodityQuantity null
CmmdtyPriceExpsrQtyInMassUnit null
CmmdtyPriceExpsrQtyInVolUnit null
NetPriceExpsrQtyInBaseUnit Calculated Net Quantity in Base UoM
NetPriceExpsrQuantity Net Quantity in Commodity UoM
NetPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
NetPriceExpsrQtyInVolumeUnit Open Commodity Quantity In Volume
NetExposureQuantity Commodity Quantity
Column Name Description
DailyGrainReportDate null
HistoryDPQSDate null
Column Name Description
MTMDataSourceType Type of Data Record Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
LoadDataCaptureEventType Net Dry Event Show values
RecordIsLogicallyDeleted Logically Deleted Status Show values
NetDryErrorCode Error Code Show values
DiscPremQtyScheduleType DPQS Type Show values
QuotationKeyType Quotation Key Type in Document UI (all values) Show values
LicenseStatus DGR Plant License Status Show values
Column Name Description Domain name
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
QuantitySign null
SourceDocument Document
SourceDocumentItem Source document item
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
SourceDocumentYear Material Document Year GJAHR
GoodsMovementType Movement type (inventory management) BWART
LoadDataCaptureObjectID Load Data Capture Object ID /ACCGO/D_UIS_ID
QuantityRepositoryUUID Application GUID SYSUUID_X16
QuantityRepositoryVersion Version /ACCGO/D_QREP_ID
DiscPremQtyScheduleUniqueID null
DiscPremQtyScheduleVersion null
DPQSValidityVersion Schedule Validity Version /ACCGO/D_VALIDITY_VERSION
DailyGrainReportDisplayUnit null
DailyGrainReportType null
Plant Plant WERKS
Material Material Number MATNR
StorageLocation Storage location LGORT
Commodity Commodity TBA_STOEFFCHEN
PhysicalCommodity Physical Commodity TBA_STOEFFCHEN
CompanyCode Company Code BUKRS
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
PlantGroup Plant Group /ACCGO/D_PLANT_GROUP
EndOfDayTimestamp Valid-From Timestamp TZNTSTMPS
PreviousEndOfDayTimestamp Valid-From Timestamp TZNTSTMPS
BegingingBookBalancetTimestamp Valid-From Timestamp TZNTSTMPS
MessageText null
HandleLossRsrvID HLR Event ID /ACCGO/D_HLR_EVENT_ID
HandleLossRsrvItem Item number of the SD document POSNR
HandleLossRsrvVersion Version /ACCGO/D_VERSION
VS1DPQSVersion null
VS1DPQSValidityVersion null
VS2DPQSVersion null
VS2DPQSValidityVersion null
VS3DPQSVersion null
VS3DPQSValidityVersion null
VS4DPQSVersion null
VS4DPQSValidityVersion null
VS5DPQSVersion null
VS5DPQSValidityVersion null
VS6DPQSVersion null
VS6DPQSValidityVersion null
VS7DPQSVersion null
VS7DPQSValidityVersion null
VS8DPQSVersion null
VS8DPQSValidityVersion null
Master Data Relations Join Conditions
Schedule ID
  • Schedule ID
  • Client
  • ?
  • ?
  • ?
  • P_DGR_KONVD_UPDATEDPQS.HISTORYDPQS == /ACCGO/T_DPQS_H.SCHEDULE_ID
  • P_DGR_KONVD_UPDATEDPQS.MANDT == /ACCGO/T_DPQS_H.MANDT
  • P_DGR_KONVD_UPDATEDPQS.[column in domain "/ACCGO/E_DPQS_VERSION"] == /ACCGO/T_DPQS_H.VERSION
  • P_DGR_KONVD_UPDATEDPQS.[column in domain "/ACCGO/E_VALIDITY_VERSION"] == /ACCGO/T_DPQS_H.VALIDITY_VERSION
  • P_DGR_KONVD_UPDATEDPQS.[column in domain "/ACCGO/E_SCHDL_GUID"] == /ACCGO/T_DPQS_H.SCHEDULE_GUID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
Schedule ID
  • ?
  • ?
  • ?
  • Client
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID
  • Schedule ID