PURCTR_HDR_D

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.

-- I_PURCHASECONTRACTWD I_PURCHASECONTRACTWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURCTR_HDR_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PURCHASECONTRACT,                -- Purchase Contract [vdm_purchasecontract]
    PURCHASECONTRACTFOREDIT,         -- Purchase Contract [vdm_purchasecontract]
    PURCHASECONTRACTTYPE,            -- Document Type [esart]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [ebstyp]
    CREATIONDATE,                    -- Created On [mmpur_erdat]
    SUPPLIER,                        -- Supplier [md_supplier]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    DOCUMENTCURRENCY,                -- Currency [waers]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    PAYMENTTERMS,                    -- Payment Terms [farp_dzterm]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    PURCHASECONTRACTTARGETAMOUNT,    -- Target Value [ktwrt]
    VALIDITYSTARTDATE,               -- Validity Start [kdatb]
    VALIDITYENDDATE,                 -- Validity End [kdate]
    RELEASECODE,                     -- Release ind. [frgke]
    CREATEDBYUSER,                   -- Created By [mmpur_ernam]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [eloek]
    SUPPLIERADDRESSID,               -- Address Number [ad_addrnum]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [llief]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    EXCHANGERATE,                    -- Exchange Rate [fis_exchange_rate]
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [kufix]
    QUOTATIONSUBMISSIONDATE,         -- Quotation Date [ihran]
    SUPPLIERQUOTATION,               -- Quotation [angnr]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    CORRESPNCEXTERNALREFERENCE,      -- Your Reference [ihrez]
    CORRESPNCINTERNALREFERENCE,      -- Our Reference [unsez]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    SUPPLIERPHONENUMBER,             -- Supplier Phone [telfnr0]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    INCOTERMSLOCATION1IDENTIFIER,    -- Incoterm Loc. 1 ID [tminco_loc_1_id]
    INCOTERMSLOCATION2IDENTIFIER,    -- Incoterm Loc. 2 ID [tminco_loc_2_id]
    INCOTERMSDVTGLOCIDENTIFIER,      -- Deviating Loc. ID [tminco_loc_d_id]
    INCOTERMSDVTGLOCDESCRIPTION,     -- Deviating Loc. Desc. [tminco_loc_d_descr]
    INCOTERMSSUPCHNLOC1ADDLUUID,     -- Incoterm Location 1 [/scmtms/inc_loc_1_key_nc]
    INCOTERMSSUPCHNLOC2ADDLUUID,     -- Incoterm Location 2 [/scmtms/inc_loc_2_key_nc]
    INCOTERMSSUPCHNDVTGLOCADDLUUID,  -- Dev. Destination [/scmtms/inc_dv_plce_dst_key_nc]
    PURCHASINGDOCUMENTNAME,          -- Purch. Doc. Name [vdm_purgdoc_name]
    PURCHASINGDOCUMENTORIGIN,        -- Status [estak]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [meprocstate]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    PURGDOCEXTERNALREFERENCE,        -- Ext. Reference ID [mmpur_externalreferenceid]
    PURGOUTLINEAGRMTEXTSYSTID,       -- External System ID [mmpur_ext_system]
    PURGDOCEXTREFERENCENODETYPE,     -- Ext. Doc. Type [mmpur_externaldocumenttype]
    PURCHASINGDOCUMENTTYPENAME,      -- Description [batxt]
    PURCONTRCONSUMEDVAL,             -- Consumed Value [mm_pur_oa_consumed_val]
    CONTRACTEXPIRYPREDICTEDDATE,     -- Predicted Expry Date [mm_a_cntr_expiry_predict_date]
    PURCHASECONTRACTVALIDITYSTATUS,  -- Validity Status [mm_oa_validity_status]
    PURCONTRVALIDITYSTATUSNAME,      -- Validity Status [mm_oa_validity_status]
    PURCONTRSTATUSCRITICALITY,       -- Val. Status Critic. [mm_oa_validity_criticality]
    SUPPLIEROPERATIONALSCORE,        -- Operational Score [mm_a_supplier_opl_score]
    PURCONTRHASADVNCDUSRINTERFACE,   -- Advncd Pur Contr Ind [mm_oa_adv_pctr_ind]
    NUMBEROFDAYS,                    -- Number of Days [numberofdays]
    ISEXPIRED,                       -- Contract is Expired [mm_oa_iscontractexpired]
    PURCONTROUTPUTCTRLTYPE,          -- Output Control Type [mm_oa_oc_type]
    PURCONTROUTPUTCTRLSTATUS,        -- Output Control Statu [mm_oa_oc_status]
    PURCONTROUTPUTCTRLSTATUSTXT,     -- OC Status Text [mm_oa_oc_status_txt]
    PURCONTROUTPUTCTRLTIME,          -- Output Control Time [mm_oa_oc_time]
    WEIGHTEDRELEVANCE,               -- Weighted Relevance [mm_pur_oa_weighted_rel]
    CONTRACTCONSUMPTIONINPCT,        -- Consumption Pct [mmpur_oa_consumption_pct]
    PURCONTRCNSMPNCRITICALITY,       -- Val. Status Critic. [mm_oa_validity_criticality]
    PURCONTRCRITICALITYSTATUS,       -- Attention Required [mm_pur_ctr_criticality_status]
    ACCWORKFLOWAPPROVER,             -- User [mm_oa_approver_id]
    ACCWORKFLOWAPPROVERFIRSTNAME,    -- Full Name [mm_oa_approver_name]
    APPROVALSTATUSNAME,              -- Short Description [val_text]
    APPROVERUSER,                    -- Agent [sww_aagent]
    PURCONTRVALIDITYSTATUS_2,        -- Validity Status [mm_pur_ctr_validity_status]
    CREATEDBYUSERNAME,               -- Created By (User) [mm_oa_user_alias]
    ISCONTRREFOFPURREQN,             -- TRUE [boole_d]
    CHANGERECORDREFERENCEUUID,       -- UUID [sysuuid_x]
    ISPURCONTRTEMPLATE,              -- Is Contract Template [mm_oa_iscontracttemplate]
    PURGCONTRACTISINPREPARATION,     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCHASINGDOCUMENTSTATUS,        -- Short Description [val_text]
    PURCHASINGITEMHASHIERARCHY,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCONTRREWORKCOMMENTTEXT,       -- Comments to Approver [mmpur_ctr_rework_comment]
    PURCONTRAPPROVERCOMMENTTEXT,     -- Approver Comments [mmpur_ctr_approvercomment]
    PURGAGGRGDPRODCMPLNCSUPLRSTS,    -- Supplier Check Sts [mmpur_pc_total_status_pcs]
    PURGHASCATALOGRELEVANTITEMS,     -- Ctlg Item Rlvt Doc [mmpur_doc_is_catalog_relevant]
    ACTIVEPURCHASINGDOCUMENT,        -- Active Purchase Doc [ebeln_ad]
    PURGDOCCHANGEREQUESTSTATUS,      -- Change Request Stat. [cr_stat]
    PURCHASINGDOCUMENTVERSION,       -- Version [revno]
    PURGDOCISCHGVERS,                -- Checkbox [xfeld]
    PURCHASINGDOCVERSIONREASONCODE,  -- Reason [rscod]
    CHANGEREQUESTNOTE,               -- Short Description [val_text]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);