DOCUMENT

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 DOCUMENT (
    ACCOUNTINGDOCUMENT,
    BUSINESSPARTNERCUSTOMER,
    CADOCUMENTNUMBER,
    CASRCDOCUMENTCAT,
    CASRCDOCUMENTNUMBER,
    CASRCDOCUMENTTYPE,
    CHANGEDOCDATABASETABLEFIELD,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCOBJECT,
    CHANGEDOCOBJECTCLASS,
    CHANGEDOCTABLEKEY,
    CHANGEDOCUMENT,
    CHARACTERISTICSMETADATAUUID,
    CHARCVALUECOMBINATIONUUID,
    CLEARINGACCOUNTINGDOCUMENT,
    CN_TAXINVCUUID,
    COMPANYCODE,
    DATABASETABLE,
    DOKAR,
    DOKNR,
    DRAFTENTITYTYPE,
    FISCALYEAR,
    INSPECTITEMDOCUMENTTYPE,
    LANGUAGE,
    LEDGER,
    LEDGERFISCALYEAR,
    PRICINGDOCUMENT,
    PRICINGDOCUMENTITEM,
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    PRODALLOCATIONTIMESERIESUUID,
    PRODALLOCSQNCASSIGNMENTUUID,
    PRODUCTALLOCATIONOBJECTUUID,
    PRODUCTALLOCATIONSEQUENCEUUID,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SOURCELEDGER,
    SUPPLIERTOPARTNER,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _FISCALYEAR,
    _OPERATIONALACCTGDOCITEM,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTTYPE,
    BILLINGDOCUMENTTYPE,
    CARECONCILIATIONKEY,
    CHANGEDOCLANGUAGE,
    CHANGEDOCNEWFIELDVALUE,
    CHANGEDOCPREVIOUSFIELDVALUE,
    CHARCVALAUTHZNGROUP,
    CN_BLUEINVOICENUMBER,
    CN_GOLDENTAXSYSTEMRESULTSTRING,
    CN_GOLDENTAXSYSTEMRISKLEVEL,
    CN_INVOICELATESTPOSTINGDATE,
    CN_INVOICEPOSTINGPERIOD,
    CN_INVOICEPOSTINGTYPE,
    CN_INVOICESPECIFICELEMENT,
    CN_ISNOTTOLLTAXINVOICE,
    CN_ISNOTVEHICLETAXINVOICE,
    CN_TAXBUYERREGNNMBR,
    CN_TAXDECLNDEADLINE,
    CN_TAXDECLNMONTH,
    CN_TAXDECLNYEAR,
    CN_TAXDECLNYEARMONTH,
    CN_TAXENTITYID,
    CN_TAXINVCCODE,
    CN_TAXINVCCODENMBR,
    CN_TAXINVCCOMMENT,
    CN_TAXINVCCRCY,
    CN_TAXINVCDATE,
    CN_TAXINVCDEDUCTAMTININVCCRCY,
    CN_TAXINVCDEDUCTIONTYPE,
    CN_TAXINVCDISCNETAMTININVCCRCY,
    CN_TAXINVCDISCTAXAMTININVCCRCY,
    CN_TAXINVCGLDNTXSYSTSTS,
    CN_TAXINVCGLDNTXSYSTSTSSYNCTME,
    CN_TAXINVCINPTPROCGSTS,
    CN_TAXINVCISELECTRONIC,
    CN_TAXINVCNETAMTININVCCRCY,
    CN_TAXINVCNMBR,
    CN_TAXINVCTAXAMTININVCCRCY,
    CN_TAXINVCTOTAMTININVCCRCY,
    CN_TAXINVCTYPE,
    CN_TAXINVCVEHTOTAMTININVCCRCY,
    CN_TAXINVOICEDATASOURCE,
    CN_TAXINVOICEEXPENSEREPORTNMBR,
    CN_TAXINVOICEUSAGE,
    CN_TAXINVOICEVEHFACTORYMODEL,
    CN_TAXINVOICEVEHICLECERTNUMBER,
    CN_TAXINVOICEVEHICLEENGINENMBR,
    CN_TAXINVOICEVEHICLEINSPNUMBER,
    CN_TAXINVOICEVEHICLENUMBER,
    CN_TAXINVOICEVEHICLEPRODNPLACE,
    CN_TAXINVOICEVEHICLETONNAGE,
    CN_TAXINVOICEVEHICLETYPE,
    CN_TAXINVOICEVEHIMPORTCERTNMBR,
    CN_TAXINVOICEVEHPASSENGERLIMIT,
    CN_TAXINVOICEVEHTXNRECORDNMBR,
    CN_TAXSELLERNAME,
    CN_TAXSELLERREGNNMBR,
    COMPANYCODECURRENCY,
    CONDITIONAMOUNT,
    CONDITIONAPPLICATION,
    CONDITIONBASEAMOUNT,
    CONDITIONBASEQUANTITY,
    CONDITIONBASEVALUE,
    CONDITIONBASEVALUEISAMOUNT,
    CONDITIONBASEVALUEISQUANTITY,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCURRENCY,
    CONDITIONINACTIVEREASON,
    CONDITIONINACTIVEREASONNAME,
    CONDITIONISFORSTATISTICS,
    CONDITIONISMANUALLYCHANGED,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEISAMOUNT,
    CONDITIONRATEVALUEISNULL,
    CONDITIONRATEVALUEISRATIO,
    CONDITIONTYPE,
    CONDITIONTYPENAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREATIONUTCDATETIME,
    CUSTOMER,
    DELIVOFGOODSDESTCOUNTRY,
    DOCUMENTDATE,
    DOCUMENTHEADERTEXT,
    DOCUMENTSTATUSDESC,
    DRAFTTYPEDESCRIPTION,
    EDITINGSTATUSTEXT,
    ENQUEUEEXPIRYNOTIFICATION,
    EWMWAREHOUSE,
    FISCALPERIOD,
    INPUTFISCALYEAR,
    ISDELETED,
    ISONETIMEACCOUNT,
    ISPOSTEDONACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    NOTKEPTEXPIRY,
    NOTKEPTNOTIFICATION,
    NUMBEROFATTACHMENTS,
    ORIGINALREFERENCEDOCUMENT,
    PHYSICALINVENTORYDOCNUMBER,
    PHYSICALINVENTORYDOCYEAR,
    PLANT,
    POSTINGDATE,
    POSTINGKEY,
    PPSITEMCONDITIONSTATUS,
    PROCESSINGEXPIRYNOTIFICATION,
    PRODALLOCATIONACTIVATIONSTATUS,
    PRODALLOCCHARC01,
    PRODALLOCCHARC02,
    PRODALLOCCHARC03,
    PRODALLOCCHARC04,
    PRODALLOCCHARC05,
    PRODALLOCCHARC06,
    PRODALLOCCHARC07,
    PRODALLOCCHARC08,
    PRODALLOCCHARC09,
    PRODALLOCCHARC10,
    PRODALLOCCHARCCONSTRAINTSTATUS,
    PRODALLOCCHARCPATHDESCCOMINTID,
    PRODALLOCCHARCVALUECOMBNCMNT,
    PRODALLOCOBJECTDESCRIPTION,
    PRODALLOCORDINALNUMBERVALUE,
    PRODALLOCPERDSTARTUTCDATETIME,
    PRODALLOCPERIODENDTIMEZONE,
    PRODALLOCPERIODENDUTCDATETIME,
    PRODALLOCPERIODSTARTTIMEZONE,
    PRODUCTALLOCATIONOBJECT,
    PRODUCTALLOCATIONQUANTITY,
    PRODUCTALLOCATIONQUANTITYUNIT,
    PRODUCTALLOCATIONSEQUENCE,
    PRODUCTALLOCATIONSEQUENCEDESC,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REFERENCEDOCUMENTTYPE,
    RELATIVEENQUEUEEXPIRY,
    RELATIVEPROCESSINGEXPIRY,
    REVERSALREASON,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RU_BUDGETCLASSIFICATIONCODE,
    RU_SUPPLIERKPP,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_UNIFIEDTAXNOTICEPAYMENTVERS,
    RU_UNIFIEDTAXNOTICEPERIODCODE,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCATEGORY,
    TAXINVOICEAPPROVALNMBR,
    TAXINVOICEBUYERADDRESSPHONE,
    TAXINVOICEBUYERBANKACCOUNT,
    TAXINVOICECONFSTATUS,
    TAXINVOICEDECLARATIONTYPECODE,
    TAXINVOICEISTAXREBATE,
    TAXINVOICENUMBER,
    TAXINVOICESELLERADDRESSPHONE,
    TAXINVOICESELLERBANKACCOUNT,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    VALIDITYENDTIMEZONE,
    VALIDITYENDUTCDATETIME,
    VALIDITYSTARTTIMEZONE,
    VALIDITYSTARTUTCDATETIME,
    WAREHOUSE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BUSINESSPARTNERCUSTOMER, CADOCUMENTNUMBER, CASRCDOCUMENTCAT, CASRCDOCUMENTNUMBER, CASRCDOCUMENTTYPE, CHANGEDOCDATABASETABLEFIELD, CHANGEDOCITEMCHANGETYPE, CHANGEDOCOBJECT, CHANGEDOCOBJECTCLASS, CHANGEDOCTABLEKEY, CHANGEDOCUMENT, CHARACTERISTICSMETADATAUUID, CHARCVALUECOMBINATIONUUID, CLEARINGACCOUNTINGDOCUMENT, CN_TAXINVCUUID, COMPANYCODE, DATABASETABLE, DOKAR, DOKNR, DRAFTENTITYTYPE, FISCALYEAR, INSPECTITEMDOCUMENTTYPE, LANGUAGE, LEDGER, LEDGERFISCALYEAR, PRICINGDOCUMENT, PRICINGDOCUMENTITEM, PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP, PRODALLOCATIONTIMESERIESUUID, PRODALLOCSQNCASSIGNMENTUUID, PRODUCTALLOCATIONOBJECTUUID, PRODUCTALLOCATIONSEQUENCEUUID, PURCHASEORDER, PURCHASEORDERITEM, SOURCELEDGER, SUPPLIERTOPARTNER)
);