MMPUR_EXT_EBAN

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.

-- Maintain Extracted Back-end Requisitions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EBAN (
    MANDT,                           -- Client [mandt]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    EXTSOURCESYSTEM,                 -- Connected System ID [mmpur_d_source_sys]
    PURCHASEREQUISITIONTYPE,         -- Document Type [bbsrt]
    ISDELETED,                       -- Del. Indicator [eloek]
    PROCESSINGSTATUS,                -- Processing stat [banst]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    CREATEDBYUSER,                   -- Created By [ernam]
    LASTCHANGEDDATE,                 -- Changed On [aedat]
    REQUISITIONERNAME,               -- Requisitioner [afnam]
    PURCHASEREQUISITIONITEMTEXT,     -- Short Text [txz01]
    MATERIAL,                        -- Material [matnr]
    PLANT,                           -- Plant [ewerk]
    REQUIREMENTTRACKING,             -- Tracking Number [bednr]
    MATERIALGROUP,                   -- Material Group [matkl]
    SUPPLYINGPLANT,                  -- Supplying Plant [reswk]
    REQUESTEDQUANTITY,               -- Quantity [bamng]
    BASEUNIT,                        -- Unit of Measure [bamei]
    CREATIONDATE,                    -- Requisn Date [badat]
    DELIVERYDATE,                    -- Delivery Date [eindt]
    MATERIALGOODSRECEIPTDURATION,    -- GR proc. time [webaz]
    PURCHASEREQUISITIONPRICE,        -- Valuation Price [bapre]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [pstyp]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    GOODSRECEIPTISEXPECTED,          -- Goods Receipt [wepos]
    INVOICEISEXPECTED,               -- Invoice Receipt [repos]
    SUPPLIER,                        -- Desired Vendor [wlief]
    FIXEDSUPPLIER,                   -- Fixed Vendor [flief]
    PURCHASECONTRACT,                -- Agreement [konnr]
    PURCHASECONTRACTITEM,            -- Agreement Item [ktpnr]
    PURCHASINGINFORECORD,            -- Info Record [infnr]
    MRPCONTROLLER,                   -- MRP Controller [dispo]
    ISCLOSED,                        -- Closed [ebakz]
    GOODSRECEIPTISNONVALUATED,       -- GR Non-Valuated [weunb]
    PURCHASEREQUISITIONISFIXED,      -- "Fixed" ind. [bafix]
    MATERIALREVISIONLEVEL,           -- Revision Level [revlv]
    PURCHASEORDERPRICETYPE,          -- PO price [bpueb]
    BATCH,                           -- Batch [charg_d]
    PURREQNITEMCURRENCY,             -- Currency [waers]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [idnlf]
    MATERIALPLANNEDDELIVERYDURN,     -- Pl. Deliv. Time [plifz]
    ISPURREQNBLOCKED,                -- Blocking Ind. [blckd]
    PRODUCTTYPE,                     -- Product Type Group [product_type]
    PURREQNORIGIN,                   -- Creation ind. [estkz]
    PURCHASEREQUISITIONRELEASEDATE,  -- Release Date [frgdt]
    PURREQNPRICEQUANTITY,            -- Price unit [peinh]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    SERVICEPERFORMER,                -- Service Performer [serviceperformer]
    ISONBEHALFCART,                  -- Shop On Behalf Ind. [mmpur_req_d_sob]
    ITEMDELIVERYADDRESSID,           -- Address [adrn2]
    MANUALDELIVERYADDRESSID,         -- Address [adrnr]
    PURREQNRELEASESTATUS,            -- Proc.state [banpr]
    MANUFACTURERMATERIAL,            -- MPN: Material [ematn]
    STORAGELOCATION,                 -- Location [lgort_d]
    DELIVDATECATEGORY,               -- Delivery Date [lpein]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [vrtkz]
    PARTIALINVOICEDISTRIBUTION,      -- Partial invoice [twrkz]
    SOURCEOFSUPPLYISASSIGNED,        -- Assigned [dzugba]
    PURCHASINGDOCUMENT,              -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTITEM,          -- Item [ebelp]
    ORDEREDQUANTITY,                 -- Order quantity [bsmng]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    SUBCONTRACTOR,                   -- Supplier [emlif]
    LANGUAGE,                        -- Language [spras]
    ITEMNETAMOUNT,                   -- Tot. val. rel. [rlwrt]
    PURREQNCMPLTNSCAT,               -- Incompl. Cat. [memorytype]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [eopblocked]
    PURREQNSSPREQUESTOR,             -- Requestor [mmpur_req_d_requestor]
    PURREQNSSPAUTHOR,                -- Author [mmpur_req_d_author]
    DESIREDSUPPLIERNAME,             -- Name 1 [name1]
    FIXEDSUPPLIERNAME,               -- Name 1 [name1]
    LASTEXTRACTIONTIMESTAMP,         -- Time Stamp [timestamp]
    COMPANYCODE,                     -- Company Code [bukrs]
    QUOTAARRANGEMENT,                -- Quota arr. [qunum]
    QUOTAARRANGEMENTITEM,            -- Quota arr. item [qupos]
    PURCHASINGDOCUMENTORDERDATE,     -- PO Date [bedat]
    SERVICEENTRYSHEET,               -- Entry Sheet [lblni]
    SERVICEPACKAGE,                  -- Package number [packno]
    PLNDORDERREPLNMTELMNTTYPE,       -- Kanban Indicat. [kbnkz]
    COMMITMENTITEM,                  -- Commitment item [fipos]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUND,                            -- Fund [bp_geber]
    CROSSPLANTCONFIGURABLEPRODUCT,   -- Cross-plant CM [satnr]
    CUSTOMER,                        -- Customer [kunnr]
    SUPPLIERISSUBCONTRACTOR,         -- SC Supplier [lblkz]
    MANUFACTURERPARTNMBR,            -- Mfr Part Number [mfrpn]
    MANUFACTURER,                    -- Manufacturer [mfrnr]
    ISSUINGSTORAGELOCATION,          -- Iss. Stor. Loc. [reslo]
    NUMBEROFSERIALNUMBERS,           -- No.serial no. [anzsn]
    ITMAFFECTSCOMMITMENT,            -- Commitments [xoblr]
    ODRUNIT,                         -- Unit of measure [bmein]
    COMMITEDQTY,                     -- Scrap [mng02]
    COMMITEDDATE,                    -- Finish date [dat01]
    EXTMANUFACTURER,                 -- External manuf. [emnfr]
    PURREQNITEMBLOCKINGREASON,       -- Blocking Text [blckt]
    PROCURINGPLANT,                  -- Procuring Plant [beswk]
    POHOLDQTYINPR,                   -- PO Qty on Hold [gmmng]
    REQURGENCY,                      -- Reqmt Urgency [prio_urg]
    REQPRIORITY,                     -- Reqmt Priority [prio_req]
    CONSUMPTIONPOSTING,              -- Consumption [kzvbr]
    SHELFLIFEEXPIRATION,             -- Period Ind. [dattp]
    PURCHASEDOCCAT,                  -- Doc. Category [bstyp]
    PERFORMANCEPERIODSTARTDATE,      -- Start Date [mmpur_servproc_period_start]
    PERFORMANCEPERIODENDDATE,        -- End Date [mmpur_servproc_period_end]
    EXPECTEDOVERALLLIMITAMOUNT,      -- Expected Value [commitment]
    OVERALLLIMITAMOUNT,              -- Overall Limit [sumlimit]
    PURCONTRACTFOROVERALLLIMIT,      -- Contract For Limit [ctr_for_limit]
    PURCONTRACTITEMFOROVERALLLIMIT,  -- PurCon Itm for Limit [ctr_item_for_limit]
    PRMTHBCONSUMPTIONLIMITAMOUNT,    -- Consumption Value [mmpur_req_lmt_cnsmpn_value]
    PRMTHBITEMISLIMIT,               -- TRUE [boole_d]
    PRMTHBLIMITITEMCURRENCY,         -- Currency [waers]
    HASATTACHMENT,                   -- TRUE [boole_d]
    HASNOTE,                         -- TRUE [boole_d]
    PURREQNHASDELEGATEAPPROVAL,      -- PurReq Ext. approval [mmpur_indelegateapproval]
    MMPUR_PR_EXT_SOURCING_STATUS,    -- mmpur_pr_ext_sourcing_status
    USERDESCRIPTION,                 -- Full Name [ad_namtext]
    PURCHASEREQNITEMUNIQUEID,        -- Purch. Doc. ID [purgdocnodeuniqueid]
    EXT_BE_SRC_SYS,                  -- Connected System ID [mmpur_d_source_sys]
    PRMTHBPURREQNITMCATALOGID,       -- Web Service ID [bbp_ws_service_id]
    PROCMTHUBPURGOBJCTRLIND,         -- Control [bsakz]
    CENTRAL_PURREQN_PROC,            -- Is Central PR Procg. [mmpur_pr_cen_purreqn_proc_mode]
    PROCMTHUBPRPSDFLLWONDOC,         -- Purchasing Doc. [ebeln]
    PROCMTHUBPRPSDFLLWONDOCCAT,      -- Doc. Category [ebstyp]
    MATGRP_RCMD_STATUS,              -- MatGrp Rcmdn Status [mmpur_pr_matgrp_rcmd_stat]
    PURREQNDESCRIPTION,              -- PurReqn Description [purreqndescription]
    GLOBALTEAMID,                    -- Global Team ID [rsm_de_global_team_id]
    PRIMARY KEY (MANDT, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, EXTSOURCESYSTEM)
);