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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);