MMPUR_EXT_EBAN

Transparent Table Application Table
123 Fields 3 CDS Views

Maintain Extracted Back-end Requisitions

MMPUR_EXT_EBAN is an SAP database table in S/4HANA. Maintain Extracted Back-end Requisitions. It contains 123 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_PrmtHbRpldPurchaseReqnItem view from EXTENSION Extensibility view for C_ExtPurchaseRequisitionItem
I_PrmtHbRpldPurchaseReqnItem view from BASIC Basic View for Ext Pur Req Item Rplctd
I_ProcmtHubPurReqnItem view from BASIC Basic view for Ext Pur Req Item

Fields (123)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchaserequisition BANFN Purchase Req.
KEY purchaserequisitionitem BNFPO Requisn. item
KEY extsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
purchaserequisitiontype BBSRT Document Type
isdeleted ELOEK Del. Indicator
processingstatus BANST Processing stat
purchasinggroup EKGRP Purch. Group
createdbyuser ERNAM Created By
lastchangeddate AEDAT Changed On
requisitionername AFNAM Requisitioner
purchaserequisitionitemtext TXZ01 Short Text
material MATNR Material
plant EWERK Plant
requirementtracking BEDNR Tracking Number
materialgroup MATKL Material Group
supplyingplant RESWK Supplying Plant
requestedquantity BAMNG Quantity
baseunit BAMEI Unit of Measure
creationdate BADAT Requisn Date
deliverydate EINDT Delivery Date
materialgoodsreceiptduration WEBAZ GR proc. time
purchaserequisitionprice BAPRE Valuation Price
purchasingdocumentitemcategory PSTYP Item Category
accountassignmentcategory KNTTP Acct Assgmt Cat
goodsreceiptisexpected WEPOS Goods Receipt
invoiceisexpected REPOS Invoice Receipt
supplier WLIEF Desired Vendor
fixedsupplier FLIEF Fixed Vendor
purchasecontract KONNR Agreement
purchasecontractitem KTPNR Agreement Item
purchasinginforecord INFNR Info Record
mrpcontroller DISPO MRP Controller
isclosed EBAKZ Closed
goodsreceiptisnonvaluated WEUNB GR Non-Valuated
purchaserequisitionisfixed BAFIX "Fixed" ind.
materialrevisionlevel REVLV Revision Level
purchaseorderpricetype BPUEB PO price
batch CHARG_D Batch
purreqnitemcurrency WAERS Currency
suppliermaterialnumber IDNLF Supp. Mat. No.
materialplanneddeliverydurn PLIFZ Pl. Deliv. Time
ispurreqnblocked BLCKD Blocking Ind.
producttype PRODUCT_TYPE Product Type Group
purreqnorigin ESTKZ Creation ind.
purchaserequisitionreleasedate FRGDT Release Date
purreqnpricequantity PEINH Price unit
purchasingorganization EKORG Purchasing Org.
serviceperformer SERVICEPERFORMER Service Performer
isonbehalfcart MMPUR_REQ_D_SOB Shop On Behalf Ind.
itemdeliveryaddressid ADRN2 Address
manualdeliveryaddressid ADRNR Address
purreqnreleasestatus BANPR Proc.state
manufacturermaterial EMATN MPN: Material
storagelocation LGORT_D Location
delivdatecategory LPEIN Delivery Date
multipleacctassgmtdistribution VRTKZ Distribution
partialinvoicedistribution TWRKZ Partial invoice
sourceofsupplyisassigned DZUGBA Assigned
purchasingdocument EBELN Purchasing Doc.
purchasingdocumentitem EBELP Item
orderedquantity BSMNG Order quantity
releaseisnotcompleted FRGRL Subj.to Release
subcontractor EMLIF Supplier
language SPRAS Language
itemnetamount RLWRT Tot. val. rel.
purreqncmpltnscat MEMORYTYPE Incompl. Cat.
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
purreqnssprequestor MMPUR_REQ_D_REQUESTOR Requestor
purreqnsspauthor MMPUR_REQ_D_AUTHOR Author
desiredsuppliername NAME1 Name 1
fixedsuppliername NAME1 Name 1
lastextractiontimestamp TIMESTAMP Time Stamp
companycode BUKRS Company Code
quotaarrangement QUNUM Quota arr.
quotaarrangementitem QUPOS Quota arr. item
purchasingdocumentorderdate BEDAT PO Date
serviceentrysheet LBLNI Entry Sheet
servicepackage PACKNO Package number
plndorderreplnmtelmnttype KBNKZ Kanban Indicat.
commitmentitem FIPOS Commitment item
fundscenter FISTL Funds Center
fund BP_GEBER Fund
crossplantconfigurableproduct SATNR Cross-plant CM
customer KUNNR Customer
supplierissubcontractor LBLKZ SC Supplier
manufacturerpartnmbr MFRPN Mfr Part Number
manufacturer MFRNR Manufacturer
issuingstoragelocation RESLO Iss. Stor. Loc.
numberofserialnumbers ANZSN No.serial no.
itmaffectscommitment XOBLR Commitments
odrunit BMEIN Unit of measure
commitedqty MNG02 Scrap
commiteddate DAT01 Finish date
extmanufacturer EMNFR External manuf.
purreqnitemblockingreason BLCKT Blocking Text
procuringplant BESWK Procuring Plant
poholdqtyinpr GMMNG PO Qty on Hold
requrgency PRIO_URG Reqmt Urgency
reqpriority PRIO_REQ Reqmt Priority
consumptionposting KZVBR Consumption
shelflifeexpiration DATTP Period Ind.
purchasedoccat BSTYP Doc. Category
performanceperiodstartdate MMPUR_SERVPROC_PERIOD_START Start Date
performanceperiodenddate MMPUR_SERVPROC_PERIOD_END End Date
expectedoveralllimitamount COMMITMENT Expected Value
overalllimitamount SUMLIMIT Overall Limit
hasattachment BOOLE_D TRUE
hasnote BOOLE_D TRUE
purreqnhasdelegateapproval MMPUR_INDELEGATEAPPROVAL PurReq Ext. approval
dummy_eban_incl_eew_ps EBAN_INCL_EEW PR Ext Include
userdescription AD_NAMTEXT Full Name
dummy_ext_eban_incl_eew_es CFD_DUMMY Dummy
purchasereqnitemuniqueid PURGDOCNODEUNIQUEID Purch. Doc. ID
ext_be_src_sys MMPUR_D_SOURCE_SYS Connected System ID
prmthbpurreqnitmcatalogid BBP_WS_SERVICE_ID Web Service ID
procmthubpurgobjctrlind BSAKZ Control
central_purreqn_proc MMPUR_PR_CEN_PURREQN_PROC_MODE Is Central PR Procg.
procmthubprpsdfllwondoc EBELN Purchasing Doc.
procmthubprpsdfllwondoccat EBSTYP Doc. Category
matgrp_rcmd_status MMPUR_PR_MATGRP_RCMD_STAT MatGrp Rcmdn Status
be_navigation_target MMPUR_BE_NAVIGATION_TARGET Navigation target
purreqndescription PURREQNDESCRIPTION PurReqn Description

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]
    HASATTACHMENT,                   -- TRUE [BOOLE_D]
    HASNOTE,                         -- TRUE [BOOLE_D]
    PURREQNHASDELEGATEAPPROVAL,      -- PurReq Ext. approval [MMPUR_INDELEGATEAPPROVAL]
    DUMMY_EBAN_INCL_EEW_PS,          -- PR Ext Include [EBAN_INCL_EEW]
    USERDESCRIPTION,                 -- Full Name [AD_NAMTEXT]
    DUMMY_EXT_EBAN_INCL_EEW_ES,      -- Dummy [CFD_DUMMY]
    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]
    BE_NAVIGATION_TARGET,            -- Navigation target [MMPUR_BE_NAVIGATION_TARGET]
    PURREQNDESCRIPTION,              -- PurReqn Description [PURREQNDESCRIPTION]
    PRIMARY KEY (MANDT, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, EXTSOURCESYSTEM)
);

Learn More