P_Konvd_NetDry_Prep_Data

Base View for NetDry Reports | view: PKONVDNDPREPDT | TRAN | Extraction: Not supported | Component: Application and Call Off
Tables used: /ACCGO/T_DPQS_HCMM_VLOGP
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
📏 Base Unit of Measure (MaterialBaseUnit):
CommodityQuantityInBaseUnit Quantity in Base Unit
NetPriceExpsrQtyInBaseUnit Calculated Net Quantity in Base UoM
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Commodity Quantity
NetPriceExpsrQuantity Net Quantity in Commodity UoM
📏 Unit of Measure for Commodity (CmmdtyPriceExpsrMassUnit):
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
NetPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
📏 Unit of Measure for Commodity (CmmdtyPriceExpsrVolumeUnit):
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
NetPriceExpsrQtyInVolumeUnit Open Commodity Quantity In Volume
📏 Unit of Measure for Commodity (CommodityExposureUnit):
CommodityExposureQuantity Commodity Quantity
NetExposureQuantity Commodity Quantity
Column Name Description
FromDate null
FromTime null
ToDate null
ToTime 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
Column Name Description Domain name
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
QuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem Source document item
SourceDocumentYear Material Document Year GJAHR
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
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 Schedule ID /ACCGO/D_SCHEDULE_ID
DiscPremQtyScheduleVersion Schedule Version /ACCGO/D_VERSION
NetDryReportType null
NetDryReportFromTimeStamp null
NetDryReportToTimeStamp null
Plant Plant WERKS
Material Material Number MATNR
StorageLocation Storage location LGORT
PhysicalCommodity 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
DPQSValueScheduleName DPQS Schedule Name /ACCGO/D_SCHEDULE_NAME
NonNumericAttrib1 null
NonNumericAttribValue1 null
NonNumericAttrib2 null
NonNumericAttribValue2 null
NonNumericAttrib3 null
NonNumericAttribValue3 null
NonNumericAttrib4 null
NonNumericAttribValue4 null
NonNumericAttrib5 null
NonNumericAttribValue5 null
NonNumericAttrib6 null
NonNumericAttribValue6 null
NonNumericAttrib7 null
NonNumericAttribValue7 null
NonNumericAttrib8 null
NonNumericAttribValue8 null
NonNumericAttrib9 null
NonNumericAttribValue9 null
NonNumericAttrib10 null
NonNumericAttribValue10 null
NonNumericAttribCount null
ConcatenatedNonNumericAttrib1 null
ConcatenatedNonNumericAttrib2 null
ConcatenatedNonNumericAttrib3 null
ConcatenatedNonNumericAttrib4 null
ConcatenatedNonNumericAttrib5 null
ConcatenatedNonNumericAttrib6 null
ConcatenatedNonNumericAttrib7 null
ConcatenatedNonNumericAttrib8 null
ConcatenatedNonNumericAttrib9 null
ConcatenatedNonNumericAttrib10 null
AllNonNumericAttrib null
Master Data Relations Join Conditions
Volume Schedule ID
  • Client
  • Volume Schedule ID
  • ?
  • ?
  • ?
  • P_KONVD_NETDRY_PREP_DATA.MANDT == /ACCGO/T_DPQS_H.MANDT
  • P_KONVD_NETDRY_PREP_DATA.DPQSVOLUMESCHEDULE == /ACCGO/T_DPQS_H.SCHEDULE_ID
  • P_KONVD_NETDRY_PREP_DATA.[column in domain "/ACCGO/E_VALIDITY_VERSION"] == /ACCGO/T_DPQS_H.VALIDITY_VERSION
  • P_KONVD_NETDRY_PREP_DATA.[column in domain "/ACCGO/E_SCHDL_GUID"] == /ACCGO/T_DPQS_H.SCHEDULE_GUID
  • P_KONVD_NETDRY_PREP_DATA.[column in domain "/ACCGO/E_DPQS_VERSION"] == /ACCGO/T_DPQS_H.VERSION