KONVD

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 KONVD (
    CONDITIONTYPE,
    EVALUATIONDATE,
    MATERIAL,
    NETDRYREPMEASURENAME,
    PLANT,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    STORAGELOCATION,
    SUBCONDITIONTYPE,
    VERSSTOCKRECORDUUID,
    ACMSOURCEDOCUMENT,
    ALLNONNUMERICATTRIB,
    APPLICATIONDOCUMENT,
    APPLICATIONITEMCATEGORY,
    BEGINGINGBOOKBALANCETTIMESTAMP,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    COMMENTS,
    COMMODITY,
    COMMODITYEXPOSUREQUANTITY,
    COMMODITYEXPOSUREUNIT,
    COMMODITYQUANTITY,
    COMMODITYQUANTITYINBASEUNIT,
    COMMODITYUNIT,
    COMPANYCODE,
    CONCATENATEDNONNUMERICATTRIB1,
    CONCATENATEDNONNUMERICATTRIB10,
    CONCATENATEDNONNUMERICATTRIB2,
    CONCATENATEDNONNUMERICATTRIB3,
    CONCATENATEDNONNUMERICATTRIB4,
    CONCATENATEDNONNUMERICATTRIB5,
    CONCATENATEDNONNUMERICATTRIB6,
    CONCATENATEDNONNUMERICATTRIB7,
    CONCATENATEDNONNUMERICATTRIB8,
    CONCATENATEDNONNUMERICATTRIB9,
    DAILYGRAINREPORTDATE,
    DAILYGRAINREPORTDISPLAYUNIT,
    DAILYGRAINREPORTTYPE,
    DISCPREMQTYSCHEDULETYPE,
    DISCPREMQTYSCHEDULEUNIQUEID,
    DISCPREMQTYSCHEDULEVERSION,
    DISCPREMVOLSCHEDEVALISRQD,
    DISPLAYVIEW,
    DPQSVALUESCHEDULENAME,
    DPQSVOLUMESCHEDULENAME,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTFROMDATE,
    ENDOFDAYSNAPSHOTTODATE,
    ENDOFDAYTIMESTAMP,
    ERRORCOUNTER,
    FROMDATE,
    FROMTIME,
    GOODSMOVEMENTTYPE,
    HANDLELOSSRSRVID,
    HANDLELOSSRSRVITEM,
    HANDLELOSSRSRVVERSION,
    LICENSESTATUS,
    LOADDATACAPTUREEVENTTYPE,
    LOADDATACAPTUREOBJECTID,
    MATERIALBASEUNIT,
    MESSAGETEXT,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    NETDRYERRORCODE,
    NETDRYREPMEASURETYPE,
    NETDRYREPMEASUREUNIT,
    NETDRYREPORTFROMTIMESTAMP,
    NETDRYREPORTTOTIMESTAMP,
    NETEXPOSUREQUANTITY,
    NETPRICEEXPSRQTYINBASEUNIT,
    NETPRICEEXPSRQTYINMASSUNIT,
    NETPRICEEXPSRQTYINVOLUMEUNIT,
    NETPRICEEXPSRQUANTITY,
    NONNUMERICATTRIB1,
    NONNUMERICATTRIB10,
    NONNUMERICATTRIB2,
    NONNUMERICATTRIB3,
    NONNUMERICATTRIB4,
    NONNUMERICATTRIB5,
    NONNUMERICATTRIB6,
    NONNUMERICATTRIB7,
    NONNUMERICATTRIB8,
    NONNUMERICATTRIB9,
    NONNUMERICATTRIBCOUNT,
    NONNUMERICATTRIBVALUE1,
    NONNUMERICATTRIBVALUE10,
    NONNUMERICATTRIBVALUE2,
    NONNUMERICATTRIBVALUE3,
    NONNUMERICATTRIBVALUE4,
    NONNUMERICATTRIBVALUE5,
    NONNUMERICATTRIBVALUE6,
    NONNUMERICATTRIBVALUE7,
    NONNUMERICATTRIBVALUE8,
    NONNUMERICATTRIBVALUE9,
    PHYSICALCOMMODITY,
    PHYSICALCOMMODITYUNIT,
    PLANTGROUP,
    PREVIOUSENDOFDAYTIMESTAMP,
    PREVIOUSVERSSTOCKRECORDUUID,
    QTYREPOSITORYATTRIBUTEUNIT,
    QTYREPOSITORYROUNDEDATTRVALUE,
    QUANTITYREPOSITORYUUID,
    QUANTITYREPOSITORYVERSION,
    QUANTITYSIGN,
    QUOTATIONKEYTYPE,
    RECORDISLOGICALLYDELETED,
    REFDOCUMENTYEAR,
    RUNNINGINVENTORYDOCBUSOBJTYPE,
    RUNNINGINVENTORYDOCUMENT,
    RUNNINGINVENTORYDOCUMENTITEM,
    RUNNINGINVENTORYFROMDATETIME,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTSHORTNUMBER,
    SOURCEDOCUMENTYEAR,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATE,
    SOURCETRANSACTIONEVENTDATETIME,
    STOCKREFDOCTYPE,
    STOCKREFDOCUMENT,
    STOCKREFDOCUMENTITEM,
    TODATE,
    TOTIME,
    PRIMARY KEY (CONDITIONTYPE, EVALUATIONDATE, MATERIAL, NETDRYREPMEASURENAME, PLANT, PRICINGDOCUMENTITEM, PRICINGKEY, STORAGELOCATION, SUBCONDITIONTYPE, VERSSTOCKRECORDUUID)
);