PURORDTP_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_PURCHASEORDERTP I_PURCHASEORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURORDTP_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PURCHASEORDER,                   -- Purchase Order [vdm_purchaseorder]
    PURCHASEORDERTYPE,               -- PO Type [mm_purchaseordertype]
    PURCHASEORDERTYPENAME,           -- Description [batxt]
    PURCHASEORDERSUBTYPE,            -- Control [bsakz]
    PURCHASINGDOCUMENTORIGIN,        -- Status [estak]
    CREATEDBYUSER,                   -- Created By [ernam]
    CREATEDBYUSERFULLNAME,           -- Description [vdm_userdescription]
    CREATIONDATE,                    -- Created On [erdat]
    PURCHASEORDERDATE,               -- PO Date [bedat]
    VALIDITYSTARTDATE,               -- Validity Start [kdatb]
    VALIDITYENDDATE,                 -- Validity End [kdate]
    LANGUAGE,                        -- Language [spras]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [eloek]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    PURCHASINGPROCESSINGSTATUS,      -- Proc. State [meprocstate]
    PURCHASINGCOMPLETENESSSTATUS,    -- Incomplete [memer]
    PURCHASINGRELEASESTRATEGY,       -- Rel. Strategy [frgsx]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    SUPPLIER,                        -- Supplier [md_supplier]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    SUPPLIERPHONENUMBER,             -- Telephone [telf0]
    SUPPLYINGSUPPLIER,               -- Goods Supplier [llief]
    SUPPLYINGPLANT,                  -- Supplying Plant [reswk]
    CORRESPNCEXTERNALREFERENCE,      -- Your Reference [ihrez]
    CORRESPNCINTERNALREFERENCE,      -- Our Reference [unsez]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    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]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    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]
    ISINTRASTATREPORTINGRELEVANT,    -- Intrastat rel. [intra_rel]
    ISINTRASTATREPORTINGEXCLUDED,    -- exclude Intra [intra_excl]
    PURCHASINGDOCUMENTCONDITION,     -- Doc. Condition [knumv]
    PRICINGPROCEDURE,                -- Procedure [kalsm_d]
    DOCUMENTCURRENCY,                -- Currency [waers]
    EXCHANGERATE,                    -- Exchange Rate [wkurs]
    EXCHANGERATEFOREDIT,             -- abap.char
    EXCHANGERATEISFIXED,             -- Fixed Exch.Rate [kufix]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    PURCHASEORDERNETAMOUNT,          -- Net Value [mm_pur_order_tot_net_amount]
    MANUALSUPPLIERADDRESSID,         -- Address Number [ad_addrnum]
    SUPPLIERADDRESSID,               -- Address Number [ad_addrnum]
    PURCHASECONTRACT,                -- Agreement [konnr]
    REQUESTFORQUOTATION,             -- Bid invitation [ausch]
    SUPPLIERQUOTATIONEXTERNALID,     -- Quotation [angnr]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    PODRAFTISREVERTED,               -- PO Draft is Reverted in Case of Rollback [podraftisreverted]
    PURCHASEORDERHASCOMMITMENTITEM,  -- Purchase Order has Commitment Items [purchaseorderhascommitmentitem]
    POREWORKCOMMENTTEXT,             -- abap.sstring
    PURGAGGRGDPRODCMPLNCSUPLRSTS,    -- Supplier Check Sts [mmpur_pc_total_status_pcs]
    PURGAGGRGDPRODMARKETABILITYSTS,  -- Prod. Marktablty Sts [mmpur_pc_total_status_pma]
    PURGAGGRGDSFTYDATASHEETSTATUS,   -- Sfty Data Sheet Sts [mmpur_pc_total_status_sds]
    PURGPRODCMPLNCTOTDNGRSGOODSSTS,  -- Dangerous Goods Sts [mmpur_pc_total_status_dg]
    PURCHASINGHASITEMHIERARCHY,      -- Has Item Hierarchy [mm_pur_has_item_hierarchy]
    APPROVALSTATUS,                  -- Approval Status [purchaseorderapprovalstatus]
    APPROVALSTATUSNAME,              -- Approval Status [mm_approval_status]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PURCHASINGPROCESSINGSTATUSNAME,  -- Short Description [val_text]
    MSGONGOODSRECEIPTISREQUESTED,    -- GR Message [weakt]
    PRIMARY KEY (MANDT, DRAFTUUID)
);