V_MRP_PURCH_DOC

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_MRP_PURCH_DOC (
    MANDT,                           -- Client [MANDT]
    PURCHASINGDOC,                   -- Purchasing Doc. [EBELN]
    PURCHASINGDOCCATEGORY,           -- Doc. Category [EBSTYP]
    PURCHASINGDOCTYPE,               -- Document Type [ESART]
    CREATIONDATE,                    -- Created On [MMPUR_ERDAT]
    CREATEDBYUSER,                   -- Created By [MMPUR_ERNAM]
    PURCHASINGDOCITEM5,              -- Item [EBELP]
    PURCHASINGDOCITEM6,              -- abap.char
    PURCHASINGDOCSCHEDULELINE,       -- Schedule Line [EETEN]
    PURCHASINGDOCITEMCATEGORY,       -- Item Category [PSTYP]
    PURCHASINGDOCDELETION,           -- Del. Indicator [ELOEK]
    PURCHASINGDOCRELEASEDATE,        -- abap.numc
    PURCHASINGORGANIZATION,          -- Purchasing Org. [EKORG]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    MATERIAL,                        -- Material [MATNR]
    PLANT,                           -- Plant [EWERK]
    SUPPLYINGPLANT,                  -- Supplying Plant [RESWK]
    VENDOR,                          -- Supplier [ELIFN]
    FIXEDVENDOR,                     -- abap.char
    MATERIALIDBYVENDOR,              -- Supp. Mat. No. [IDNLF]
    INVENTORYSPECIALSTOCK,           -- Special Stock [SOBKZ]
    SALESDOCUMENT,                   -- SD Document [VBELN_CO]
    SALESDOCUMENTITEM,               -- Item [POSNR_CO]
    WBSELEMENTINTERNALID,            -- WBS Element [PS_PSP_PNR]
    PURCHASINGINFORECORD,            -- Info Record [INFNR]
    MATERIALPLANNEDDELIVERYDURN,     -- Pl. Deliv. Time [EPLIF]
    MATERIALGOODSRECEIPTDURATION,    -- GR proc. time [WEBAZ]
    MATERIALBASEUNIT,                -- Base Unit [LAGME]
    PURCHASINGDOCSCHEDULELINEDATE,   -- PurchOrderDate [ETBDT]
    REQUISITIONDATE,                 -- abap.numc
    DELIVERYDATE,                    -- Delivery Date [EINDT]
    PURCHASINGDOCUMENTISFIXED,       -- Fixing Ind. [ETFIX]
    DELIVERYDATEQUANTITYISFIXED,     -- Fixed Date [ME_FIXMG]
    DOCQTYTOBASEQTYNMRTR,            -- Equal To [UMBSZ]
    DOCQTYTOBASEQTYDNMNTR,           -- Denominator [UMBSN]
    UNDERDELIVERYTOLRLMTRATIOINPCT,  -- Underdel. Tol. [UNTTO]
    PARTIALDELIVERYISALLOWED,        -- Part. Del./Item [KZTUL]
    PURCHASINGDOCUMENTORDERQTY,      -- PO Quantity [BSTMG]
    PURCHASINGDOCORDERQTYUNIT,       -- Order Unit [BSTME]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    AMOUNTINDOCUMENTCURRENCY,        -- Net Value [BWERT]
    PRICEINDOCUMENTCURRENCY,         -- Net Price [BPREI]
    SCHEDULEDQUANTITY,               -- Scheduled Qty [ETMEN]
    GOODSRECEIPTQUANTITY,            -- Delivered [WEEMG]
    OPENQUANTITY,                    -- abap.quan
    ORDEREDQUANTITY,                 -- Order quantity [BSMNG]
    REQUESTEDGOODSISSUEDATE,         -- Goods Issue [WADAT]
    REQUESTEDLOADINGDATE,            -- Loading Date [LDDAT]
    REQUESTEDDELIVERYDATE,           -- Delivery Date [EINDT]
    PRODUCTAVAILABILITYDATE,         -- Mat.Avail.Date [MBDAT]
    PURCHASINGDOCISACKNDBYVENDOR,    -- Acknowl. Reqd. [KZABS]
    PURCHASEOUTLINEAGREEMENT,        -- Agreement [KONNR]
    PURCHASEOUTLINEAGREEMENTITEM,    -- Agreement Item [KTPNR]
    DELIVERYPRIORITY,                -- Delivery Prior. [LPRIO]
    SALESORGANIZATION,               -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [VTWEG]
    DIVISION,                        -- Division [SPART]
    DOCISSCHEDULEAGREEMENT,          -- abap.char
    DOCISPURCHASEREQUISITION,        -- abap.char
    PRIMARY KEY (MANDT)
);