P_KONVD_NETDRY_SELECTDATA_TF
P_KONVD_NETDRY_SELECTDATA_TF is an SAP database table in S/4HANA. It contains 48 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ACMQtyReconKonvdPrepareData | view | from | COMPOSITE | |
| P_ACMQtyReconKonvdPrepData | view_entity | from | COMPOSITE | |
| P_ACMQtyReconKonvdPrepDtForLAQ | view_entity | from | COMPOSITE | |
| P_ACMQtyReconKonvdPrepForLAQ | view_entity | from | COMPOSITE | |
| P_CASRelPrepareData | view | from | COMPOSITE | |
| P_Konvd_NetDry_Prep_Data | view | from | COMPOSITE | |
| P_Konvd_NetPosition_Prep_Data | view | from | COMPOSITE | |
| P_NetStckMTM_GetKonvdData | view | from | COMPOSITE | |
| P_NetStkMTM_GetKONVDData | view | from | COMPOSITE | |
| P_StockMTM_Delta_Data | view | inner | COMPOSITE | |
| P_VlogpKonvdData | view | from | COMPOSITE |
Fields (48)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ConditionType | ConditionType | 7 |
| KEY | PricingDocumentItem | PricingDocumentItem | 7 |
| KEY | PricingKey | PricingKey | 7 |
| KEY | SubConditionType | SubConditionType | 7 |
| KEY | VersStockRecordUUID | VersStockRecordUUID | 6 |
| ACMSourceDocument | ACMSourceDocument | 1 | |
| CmmdtyPriceExpsrMassUnit | CmmdtyPriceExpsrMassUnit | 6 | |
| CmmdtyPriceExpsrQtyInMassUnit | CmmdtyPriceExpsrQtyInMassUnit | 4 | |
| CmmdtyPriceExpsrQtyInVolUnit | CmmdtyPriceExpsrQtyInVolUnit | 4 | |
| CmmdtyPriceExpsrVolumeUnit | CmmdtyPriceExpsrVolumeUnit | 6 | |
| CommodityQuantity | CommodityQuantity | 4 | |
| CommodityQuantityInBaseUnit | CommodityQuantityInBaseUnit | 3 | |
| CommodityReferenceUnit | CommodityReferenceUnit | 3 | |
| CommodityUnit | CommodityUnit | 6 | |
| DiscPremQtyScheduleType | DiscPremQtyScheduleType | 5 | |
| DiscPremQtyScheduleUniqueID | DiscPremQtyScheduleUniqueID | 5 | |
| DiscPremQtyScheduleuuid | DiscPremQtyScheduleuuid | 3 | |
| DiscPremQtyScheduleVersion | DiscPremQtyScheduleVersion | 5 | |
| DiscPremVolSchedEvalIsRqd | DiscPremVolSchedEvalIsRqd | 4 | |
| GoodsMovementType | GoodsMovementType | 5 | |
| LoadDataCaptureEventType | LoadDataCaptureEventType | 7 | |
| LoadDataCaptureObjectID | LoadDataCaptureObjectID | 4 | |
| MaterialBaseUnit | MaterialBaseUnit | 4 | |
| MTMConditionGroup | MTMConditionGroup | 1 | |
| MTMConditionGroupCategory | MTMConditionGroupCategory | 6 | |
| MTMDataSourceType | MTMDataSourceType | 6 | |
| NetDryErrorCode | NetDryErrorCode | 5 | |
| NetPriceExpsrQtyInBaseUnit | NetPriceExpsrQtyInBaseUnit | 1 | |
| NetPriceExpsrQtyInMassUnit | NetPriceExpsrQtyInMassUnit | 2 | |
| NetPriceExpsrQtyInVolumeUnit | NetPriceExpsrQtyInVolumeUnit | 2 | |
| NetPriceExpsrQuantity | NetPriceExpsrQuantity | 2 | |
| QuantityRepositoryUUID | QuantityRepositoryUUID | 5 | |
| QuantityRepositoryVersion | QuantityRepositoryVersion | 5 | |
| QuantitySign | QuantitySign | 6 | |
| RecordIsLogicallyDeleted | RecordIsLogicallyDeleted | 5 | |
| RefDocumentYear | RefDocumentYear | 4 | |
| SourceDocument | SourceDocument | 5 | |
| SourceDocumentBusObjType | SourceDocumentBusObjType | 6 | |
| SourceDocumentIn10Characters | SourceDocumentIn10Characters | 1 | |
| SourceDocumentItem | SourceDocumentItem | 6 | |
| SourceDocumentShortNumber | SourceDocumentShortNumber | 1 | |
| SourceDocumentYear | SourceDocumentYear | 6 | |
| SourceTransacEventEndDateTime | SourceTransacEventEndDateTime | 6 | |
| SourceTransactionEventDateTime | SourceTransactionEventDateTime | 6 | |
| SplitItemLineNumber | SplitItemLineNumber | 3 | |
| StockRefDocType | StockRefDocType | 4 | |
| StockRefDocument | StockRefDocument | 5 | |
| StockRefDocumentItem | StockRefDocumentItem | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_KONVD_NETDRY_SELECTDATA_TF (
CONDITIONTYPE,
PRICINGDOCUMENTITEM,
PRICINGKEY,
SUBCONDITIONTYPE,
VERSSTOCKRECORDUUID,
ACMSOURCEDOCUMENT,
CMMDTYPRICEEXPSRMASSUNIT,
CMMDTYPRICEEXPSRQTYINMASSUNIT,
CMMDTYPRICEEXPSRQTYINVOLUNIT,
CMMDTYPRICEEXPSRVOLUMEUNIT,
COMMODITYQUANTITY,
COMMODITYQUANTITYINBASEUNIT,
COMMODITYREFERENCEUNIT,
COMMODITYUNIT,
DISCPREMQTYSCHEDULETYPE,
DISCPREMQTYSCHEDULEUNIQUEID,
DISCPREMQTYSCHEDULEUUID,
DISCPREMQTYSCHEDULEVERSION,
DISCPREMVOLSCHEDEVALISRQD,
GOODSMOVEMENTTYPE,
LOADDATACAPTUREEVENTTYPE,
LOADDATACAPTUREOBJECTID,
MATERIALBASEUNIT,
MTMCONDITIONGROUP,
MTMCONDITIONGROUPCATEGORY,
MTMDATASOURCETYPE,
NETDRYERRORCODE,
NETPRICEEXPSRQTYINBASEUNIT,
NETPRICEEXPSRQTYINMASSUNIT,
NETPRICEEXPSRQTYINVOLUMEUNIT,
NETPRICEEXPSRQUANTITY,
QUANTITYREPOSITORYUUID,
QUANTITYREPOSITORYVERSION,
QUANTITYSIGN,
RECORDISLOGICALLYDELETED,
REFDOCUMENTYEAR,
SOURCEDOCUMENT,
SOURCEDOCUMENTBUSOBJTYPE,
SOURCEDOCUMENTIN10CHARACTERS,
SOURCEDOCUMENTITEM,
SOURCEDOCUMENTSHORTNUMBER,
SOURCEDOCUMENTYEAR,
SOURCETRANSACEVENTENDDATETIME,
SOURCETRANSACTIONEVENTDATETIME,
SPLITITEMLINENUMBER,
STOCKREFDOCTYPE,
STOCKREFDOCUMENT,
STOCKREFDOCUMENTITEM,
PRIMARY KEY (CONDITIONTYPE, PRICINGDOCUMENTITEM, PRICINGKEY, SUBCONDITIONTYPE, VERSSTOCKRECORDUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA