_PURCHASECONTRACT

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 _PURCHASECONTRACT (
    _CLASSIFICATION,
    _PURCHASECONTRACTSTATUS,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    ACTIVEPURCHASINGDOCUMENT,
    BUKRS,
    COMPANYCODE,
    CONTRACTCONSUMPTIONINPCT,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    DOWNPAYMENTAMOUNT,
    DOWNPAYMENTDUEDATE,
    DOWNPAYMENTPERCENTAGEOFTOTAMT,
    DOWNPAYMENTTYPE,
    EKGRP,
    EKORG,
    EXCHANGERATE,
    EXCHANGERATEISFIXED,
    INCOTERMSVERSION,
    INTERESTCALCULATIONCODE,
    ISENDOFPURPOSEBLOCKED,
    LASTCHANGEDATETIME,
    LIFNR,
    PAYMENTTERMS,
    PPSDOCUMENTISNOVATED,
    PPSFISCALYEAR,
    PPSPURCONTRHASDWNPAYTINAMT,
    PPSPURCONTRHEADERSTATUS,
    PPSPURCONTRHIERRELORDLIMITAMT,
    PPSPURGDOCCLASSFCTNCODE,
    PPSSMARTDOCUMENTNUMBER,
    PPSSMARTNUMBERHEADER,
    PURCHASECONTRACTTARGETAMOUNT,
    PURCHASECONTRACTTYPE,
    PURCHASECONTRACTVALIDITYSTATUS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTNAME,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCHASINGPROCESSINGSTATUS,
    PURCONTRACTCONSUMPTIONINPCT,
    PURCONTRCONSUMPTIONUNIT,
    PURGDOCHDRINVCRTNTNPCT,
    RELEASECODE,
    RETENTIONTYPE,
    SUPPLIER,
    SUPPLIERPHONENUMBER,
    SUPPLIERRESPSALESPERSONNAME,
    TARGETAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WAERS
);