PURCTR_ITM_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_PURCHASECONTRACTITEMWD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURCTR_ITM_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                 -- Key [/bobf/uuid]
    PURCHASECONTRACTITEM,            -- Item [vdm_purchasecontractitem]
    PURCHASECONTRACT,                -- Purchase Contract [vdm_purchasecontract]
    PURCHASECONTRACTITEMFOREDIT,     -- Item [vdm_purchasecontractitem]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASECONTRACTTYPE,            -- Document Type [esart]
    MATERIAL,                        -- Material [matnr]
    PURCHASECONTRACTITEMTEXT,        -- Short Text [txz01]
    CONTRACTNETPRICEAMOUNT,          -- Net Price [bprei]
    ORDERPRICEUNIT,                  -- Order Price Un. [bbprm]
    VOLUMEUNIT,                      -- Volume Unit [voleh]
    ORDERQUANTITYUNIT,               -- Order Unit [bstme]
    MATERIALGROUP,                   -- Material Group [matkl]
    CUSTOMER,                        -- Customer [ekunnr]
    SUBCONTRACTOR,                   -- Supplier [emlif]
    REFERENCEDELIVERYADDRESSID,      -- Reference Address [mm_oa_ref_address]
    MANUALDELIVERYADDRESSID,         -- Address [adrnr_mm]
    PLANT,                           -- Plant [ewerk]
    STORAGELOCATION,                 -- Storage Location [vdm_storage_location]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    GOODSRECEIPTISEXPECTED,          -- Goods Receipt [wepos]
    ISTOBEACCEPTEDATORIGIN,          -- Origin Accept. [weora]
    NETPRICEQUANTITY,                -- Price Unit [vdm_price_unit]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [vrtkz]
    PARTIALINVOICEDISTRIBUTION,      -- Partial invoice [twrkz]
    TARGETQUANTITY,                  -- Target Quantity [ktmng]
    TARGETAMOUNT,                    -- Target Value [dzwert]
    DOCUMENTCURRENCY,                -- Currency [waers]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Qty Conversion [bpumn]
    ORDPRCUNITTOORDERUNITDNMNTRUOM,  -- Order Unit [bstme]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Qty. Conv. Numerator [mm_oa_conv_unit_nmrtr]
    ORDPRCUNITTOORDERUNITNMRTRUOM,   -- Order Price Un. [bbprm]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [pstyp]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [idnlf]
    EVALDRCPTSETTLMTISALLOWED,       -- ERS [xersy]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [untto]
    PRICEISTOBEPRINTED,              -- Print Price [prsdr]
    CONFIRMATIONCONTROL,             -- Conf. Control [bstae]
    SUPPLIERCONFIRMATIONCONTROLKEY,  -- Conf. Control [bstae]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [uebto]
    UNLIMITEDOVERDELIVERYISALLOWED,  -- Unlimited [uebtk]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    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]
    INVOICEISEXPECTED,               -- Invoice Receipt [repos]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [webre]
    PURGDOCPRICEDATE,                -- Price Date [predt]
    ISINFORECORDUPDATED,             -- InfoUpdate [spinf]
    SUPPLIERSUBRANGE,                -- Suppl. Subrange [ltsnr]
    PURCHASINGINFORECORD,            -- Info Record [infnr]
    RELEASEORDERQUANTITYUNIT,        -- Order Unit [bstme]
    PURGDOCRELEASEORDERQUANTITY,     -- Rel. order qty. [noram]
    PURGDOCORDERACKNNUMBER,          -- Order Acknowl. [labnr]
    PURGDOCESTIMATEDPRICE,           -- Estimated Price [schpr]
    ISINFOATREGISTRATION,            -- InfoAtReg. [mm_oa_infoatregn]
    NODAYSREMINDER1,                 -- 1st Rem./Exped. [mahn1]
    NODAYSREMINDER2,                 -- 2nd Rem./Exped. [mahn2]
    NODAYSREMINDER3,                 -- 3rd Rem./Exped. [mahn3]
    PLANNEDDELIVERYDURATIONINDAYS,   -- Pl. Deliv. Time [eplif]
    STOCKTYPE,                       -- Stock Type [insmk]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TAXDETERMINATIONDATE,            -- Tax Date [txdat]
    REQUIREMENTTRACKING,             -- Tracking Number [bednr]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [kzabs]
    SHIPPINGINSTRUCTION,             -- Shipping Instr. [evers]
    GOODSRECEIPTISNONVALUATED,       -- GR Non-Valuated [weunb]
    SERVICEPERFORMER,                -- Service Performer [serviceperformer]
    PRODUCTTYPE,                     -- Product Type Group [product_type]
    MATERIALTYPE,                    -- Material Type [mtart]
    FORMATTEDPURCHASECONTRACTITEM,   -- Char15 [char15]
    PURCHASECONTRACTITEMFORMATTED,   -- Char15 [char15]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    PURCHASINGCONTRACTDELETIONCODE,  -- Del. Indicator [eloek]
    TEXTISDELETED,                   -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    OUTLINEAGRMTITMBLOCKEDTEXT,      -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PURCONTRACTITMREPLNMTELMNTTYPE,  -- Kanban Indicat. [kbnkz]
    PURCHASINGPARENTITEM,            -- H-Lev. Item [uebpo]
    ISSTATISTICALITEM,               -- Statistical [stapo]
    PURCHASINGPARENTITEMFOREDIT,     -- H-Lev. Item [uebpo]
    HIERARCHYNODE,                   -- Hier.node [rsnodeext]
    HIERARCHYPARENTNODE,             -- Hier.node [rsnodeext]
    HIERARCHYLEVEL,                  -- abap.int4
    HIERARCHYNODESUBTREESIZE,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.sstring
    HIERARCHYNODEORDINALNUMBER,      -- abap.int8
    ISOUTLINE,                       -- Item Set [mmpur_is_itemset]
    PURGCONFIGURABLEITEMNUMBER,      -- Hierarchy Number [exlin]
    PURGDOCAGGRGDSUBITEMCATEGORY,    -- Sub-items [upvor]
    PURGEXTERNALSORTNUMBER,          -- External Sort No. [exsnr]
    PURGPRODCMPLNCSUPPLIERSTATUS,    -- Supplier Check Sts [mmpur_pc_status_pcs]
    PURCHASINGISCATALOGRELEVANT,     -- Ctlg Item Indicator [mmpur_doc_item_is_catalog_rlvt]
    PURGDOCEXTERNALITEMCATEGORY,     -- Item Category [epstp]
    PURGDOCITEMCATEGORYNAME,         -- Text for ItCat. [ptext_d]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);