APPL

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 APPL (
    APPLICATIONDOCUMENT,
    APPLICATIONDOCUMENTITEM,
    APPLICATIONNAME,
    QUANTITYHISTORYSEQUENCENUMBER,
    ACTIONDATETIME,
    APPLICATIONDOCUMENTTYPE,
    APPLICATIONID,
    APPLICATIONITEMCATEGORY,
    APPLICATIONSTATUS,
    APPLICATIONSTATUSOBJECT,
    APPLICATIONUUID,
    APPLICATIONVERSION,
    APPLITEMAPPLIEDDATE,
    APPLITEMAPPLIEDDATETIME,
    APPLITEMCANCELLEDDATE,
    APPLITEMCANCELLEDDATETIME,
    APPLITEMCHANGEDONDATE,
    APPLITEMCHANGEDONDATETIME,
    APPLITEMCREATEDONDATE,
    APPLITEMCREATEDONDATETIME,
    APPLITEMSETTLEMENTDATE,
    APPLITEMSETTLEMENTDATETIME,
    BEGINGINGBOOKBALANCETTIMESTAMP,
    COMMODITYBASEUNIT,
    COMMODITYQUANTITYINBASEUNIT,
    COMPANYCODE,
    CONTRACTCOMMODITYITEM,
    CONTRACTISCONFIRMATIONRELEVANT,
    CONTRACTITEM,
    CONTRACTMATERIAL,
    CONTRACTNUMBER,
    CONTRACTPLANT,
    CONTRACTQTYCANCELLATIONUUID,
    CONTRACTSTATUS,
    CONTRACTTYPE,
    CP_CLASSIFICATION,
    CREDITOR,
    DAILYGRAINREPORTDATE,
    DAILYGRAINREPORTDISPLAYUNIT,
    DAILYGRAINREPORTTYPE,
    DEN_CONV,
    DISCPREMQTYSCHEDULEUNIQUEID,
    DISCPREMQTYSCHEDULEVERSION,
    DPQSHISTORYDATE,
    DPQSVALIDITYVERSION,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYTIMESTAMP,
    EVALUATIONDATE,
    ISSUBSTITUTEDRECORD,
    ITEMGUID,
    LOADDATACAPTUREAPPLINSTRUCTION,
    LOADDATACAPTUREOBJECTID,
    LOADDATAOBJECTTYPE,
    LOADDATAOBJECTUUID,
    MATERIAL,
    MATERIALGROUP,
    NUM_CONV,
    OBLIGATIONTYPE,
    PARENTITEM,
    PARTNER,
    PARTNER_GUID,
    PHYSICALCOMMODITY,
    PLANT,
    PLANTGROUP,
    POSTINGDATE,
    PREVIOUSENDOFDAYTIMESTAMP,
    QTYHISTORYPARENTSEQUENCENUMBER,
    QTYHISTORYVALIDITYENDDATE,
    QTYHISTORYVALIDITYENDTMSTP,
    QTYHISTORYVALIDITYSTARTDATE,
    QTYHISTORYVALIDITYSTARTTMSTP,
    QUANTITYHISTORYCHILDITEM,
    QUANTITYHISTORYPARENTITEM,
    QUANTITYREPOSITORYUUID,
    QUANTITYREPOSITORYVERSION,
    ROOTITEM,
    SETTLEMENTSTATUS,
    SETTLEMENTSTATUSOBJECT,
    SETTLEMENTTYPE,
    SETTLEMENTUNITUUID,
    SETTLMTDOC,
    SETTLMTDOCYEAR,
    SIDE,
    STATUSCODE,
    STATUSTMSTP,
    STORAGEAGREEMENT,
    STORAGEAGREEMENTITEM,
    STORAGEENDDATE,
    STORAGELOCATION,
    STORAGEQUANTITY,
    STORAGEQUANTITYBASEUNIT,
    STORAGEQUANTITYINBASEUOM,
    STORAGEQUANTITYUNIT,
    STORAGESTARTDATE,
    STTLINVOICEPAYMENTDATETIME,
    SUBITEM,
    SUBSTITUTEDMATERIAL,
    SUBSTITUTEDPLANT,
    TOTALNUMBEROFSTORAGEDAYS,
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    VENDOR,
    WAREHOUSEENDDATE,
    WAREHOUSERECEIPTEDQUANTITY,
    WAREHOUSERECEIPTEDQUANTITYUNIT,
    WAREHOUSERECEIPTNO,
    WAREHOUSERECEIPTTYPE,
    WAREHOUSESTARTDATE,
    PRIMARY KEY (APPLICATIONDOCUMENT, APPLICATIONDOCUMENTITEM, APPLICATIONNAME, QUANTITYHISTORYSEQUENCENUMBER)
);