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.sstr
    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]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_EKPO_INCL_EEW_PS,          -- Ext. Include [EKPO_INCL_EEW]
    PRIMARY KEY (MANDT, DRAFTUUID)
);