EBAN

Transparent Table Application Table
238 Fields 43 CDS Views

Purchase Requisition

EBAN is an SAP database table in S/4HANA. Purchase Requisition. It contains 238 fields. 43 CDS views read from this table.

CDS Views using this table (43)

ViewTypeJoinVDMDescription
/SAPAPO/I_MM_ORDER_PREQ view left_outer eSPP: MM Purchase Requisition
ARUN_SSD_PREV view left_outer Get supply specific SO preview
ARUNI_EBAN_SEL view from Get Purchase Requisition data
Atpc_Cds_Eban view from CDS View on EBAN Table for ATP
ATPC_CDS_PREDECESSOR view inner Predecessor documents
E_Purchaserequisitionitem view from EXTENSION Purchase Requisition Item Extensibility View
Fclm_Mmdelta_Eban view from EBAN
FNDEI_EBAN_BLOCKINGINFO view from Blocking View for Table EBAN
FNDEI_EBAN_FILTER view from Filter View for table EBAN
I_AlignPurchaseRequisitionItem view from BASIC Pur Req for Alignment
I_DFS_PurRequisitionItemBasic view_entity from BASIC Purchase Requisition Item
I_DspDocFlwPurReqnAttrib view from BASIC Purchase requisition Attributes for DDF
I_ExternalRefForPurReqnItm view inner BASIC Purchase Reqn Item External Reference
I_FldLogsDocFlwPurDocs view from BASIC Field Logistics:DocFlow Purchasing Document
I_FldLogsPurchaseRequisition view_entity from BASIC Purchase Requisition Basic Data
I_PurchaseRequisitionItemBasic view from BASIC Purchase Requisition Item
I_PurchaseRequisitionItemSgmt view from BASIC Purchase Requisition Item Stock Segment for VH
I_SupDmndAllDocPurReqnBsc view from BASIC Basic View for Purchase Requisition
I_SupDmndAllDocPurReqnComp view inner BASIC View for Sub Contracting Purchase Requisition Components
I_SupDmndAllDocStkTransptReqn view from BASIC View for Stock Transport Requisition
I_SupDmndOvwPurchaseReqn view from BASIC Basic View for Purchase Requisitions
M_V_EBAN_EOP view from Relevant fields with for setting the EOP-Flag in EBAN
m_v_m2s_pr_itm view from CDS View for Purchase Requisition
m_v_pr_item_status view from CDS View for Purchase Req. Item Status
m_v_pur_req_item view from Pur. Requisition Item With Open Quantity
P_RFM_EBAN_ACCASSIGN view from BASIC
P_VarConfignPurchaseReqnItem view from BASIC
pph_e_Eban view from
pph_e_Mdua view inner
rrp_e_GiPr view inner RRP: Select Purchase Requisitions as Goods Issues
rrp_e_GrPr view inner RRP: Select Purchase Requisitions as Goods Receipts
SHSM_EBAN view from
SHSM_M_MBANA view from DDL for Search Help MBANA
SHSM_M_MBANB view from Purc Requn per Requirement Tracking No
SHSM_M_MBANC view from Purchase Requn for Procuring Plant
SHSM_M_MBAND view from Purchase Requisitions with Services
SHSM_M_MBANE view from Purchase Requn per Purchasing Group
SHSM_M_MBANG view from Purchase Requisitions per Order
SHSM_M_MBANK view from Purchase Requisitions per Cost Center
SHSM_M_MBANM view from Purchase Requisitions per Material
SHSM_M_MBANN view from Purchase Requisitions per Network
SHSM_M_MBANP view from Purchase Requisitions for Project
SHSM_M_MBANV view from Purchase Requisitions per Sales Document

Fields (238)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY banfn BANFN Purchase Req.
KEY bnfpo BNFPO Requisn. item
bsart BBSRT Document Type
bstyp BSTYP Doc. Category
bsakz BSAKZ Control
loekz ELOEK Del. Indicator
statu BANST Processing stat
estkz ESTKZ Creation ind.
frgkz FRGKZ Release ind.
frgzu FRGZU Release State
frgst FRGST Rel. strategy
ekgrp EKGRP Purch. Group
ernam ERNAM Created By
erdat AEDAT Changed On
afnam AFNAM Requisitioner
txz01 TXZ01 Short Text
matnr MATNR Material
ematn EMATN MPN: Material
werks EWERK Plant
lgort LGORT_D Location
bednr BEDNR Tracking Number
matkl MATKL Material Group
reswk RESWK Supplying Plant
menge BAMNG Quantity
meins BAMEI Unit of Measure
bumng BUMNG Shortage
badat BADAT Requisn Date
lpein LPEIN Delivery Date
lfdat EINDT Delivery Date
frgdt FRGDT Release Date
webaz WEBAZ GR proc. time
preis BAPRE Valuation Price
peinh EPEIN Price Unit
pstyp PSTYP Item Category
knttp KNTTP Acct Assgmt Cat
kzvbr KZVBR Consumption
kflag KFLAG Modifiable
vrtkz VRTKZ Distribution
twrkz TWRKZ Partial invoice
wepos WEPOS Goods Receipt
weunb WEUNB GR Non-Valuated
repos REPOS Invoice Receipt
lifnr WLIEF Desired Vendor
flief FLIEF Fixed Vendor
ekorg EKORG Purchasing Org.
vrtyp BSTYP Doc. Category
konnr KONNR Agreement
ktpnr KTPNR Agreement Item
infnr INFNR Info Record
zugba DZUGBA Assigned
qunum QUNUM Quota arr.
qupos QUPOS Quota arr. item
dispo DISPO MRP Controller
sernr SERNR BOM expl.number
bvdat BVDAT Last resubmiss.
batol BATOL Resubmission
bvdrk BVDRK No. resubmiss.
ebeln BSTNR Purchase order
ebelp BSTPO Item
bedat BEDAT PO Date
bsmng BSMNG Order quantity
limit_consumption_value MMPUR_REQ_LMT_CNSMPN_VALUE Consumption Value
lblni LBLNI Entry Sheet
bwtar BWTAR_D Valuation Type
xoblr XOBLR Commitments
ebakz EBAKZ Closed
rsnum RSNUM Reservation
sobkz SOBKZ Special Stock
arsnr ARSNR Settle.reser.No
arsps ARSPS Settle.item no.
fixkz BAFIX "Fixed" ind.
bmein BSTME Order Unit
revlv REVLV Revision Level
vorab VORAB Advance proc.
packno PACKNO Package number
kanba KBNKZ Kanban Indicat.
bpueb BPUEB PO price
cuobj CUOBJ Int. object no.
frggr FRGGR Release group
frgrl FRGRL Subj.to Release
aktnr WAKTION Promotion
charg CHARG_D Batch
umsok UMSOK Sp.ind.st.tfr.
verid VERID Prod. Version
fipos FIPOS Commitment item
fistl FISTL Funds Center
geber BP_GEBER Fund
kzkfg KZCUH Origin of config
satnr SATNR Cross-plant CM
mng02 MNG06 Committed Qty
dat01 DAT05 Committed date
attyp ATTYP Matl Category
adrnr ADRNR_MM Address
adrn2 ADRN2 Address
kunnr EKUNNR Customer
emlif EMLIF Supplier
lblkz LBLKZ SC Supplier
kzbws KZBWS Valuation
waers WAERS Currency
idnlf IDNLF Supp. Mat. No.
gsfrg GSFRG Overall req. rel.
mprof MPROF Mfr Part Profile
kzfme KZWSO Units meas. use
spras SPRAS Language
techs TECHS StandardVariant
mfrpn MFRPN Mfr Part Number
mfrnr MFRNR Manufacturer
emnfr EMNFR External manuf.
fordn SFORDN Framework Order
fordp FORDP Frwrk. ord. item
plifz PLIFZ Pl. Deliv. Time
berid BERID MRP Area
uzeit LZEIT Time
fkber FKBER Functional Area
grant_nbr GM_GRANT_NBR Grant
memory MEMBF Incomplete
banpr BANPR Proc.state
rlwrt RLWRT Tot. val. rel.
blckd BLCKD Blocking Ind.
revno REVNO Version
blckt BLCKT Blocking Text
beswk BESWK Procuring Plant
eprofile MEPROFILE Procurement prof.
eprefdoc EPREFDOC External doc.
eprefitm EPREFITM External item
gmmng GMMNG PO Qty on Hold
wrtkz WRTKZ Reduce Com. (Value)
reslo RESLO Iss. Stor. Loc.
kblnr KBLNR Earmarked Funds
kblpos KBLPOS Document Item
prio_urg PRIO_URG Reqmt Urgency
prio_req PRIO_REQ Reqmt Priority
memorytype MEMORYTYPE Incompl. Cat.
anzsn ANZSN No.serial no.
mhdrz MHDRZ Rem. Shelf Life
iprkz DATTP Period Ind.
nodisp NODISP Res./Purc. req.
srm_contract_id SRM_CONTRACT_ID Central Contract
srm_contract_itm SRM_CONTRACT_ITEM Cent. Contract Item
budget_pd FM_BUDGET_PERIOD Budget Period
eldat DAT00 Planned dates
expert_mode MMPUR_PR_SSP_EXPERT_MODE PR in Expert Mode
central_purreqn_proc MMPUR_PR_CEN_PURREQN_PROC_MODE Is Central PR Procg.
spe_crm_ref_so /SPE/REF_VBELN_CRM CRM Ref Order
spe_crm_ref_item /SPE/REF_POSNR_CRM CRM Rf Item No
indelegateapproval MMPUR_INDELEGATEAPPROVAL PurReq Ext. approval
dummy_eban_incl_eew_ps EBAN_INCL_EEW PR Ext Include
storenetworkid CHAR128 128 character
storesupplierid CHAR64 Character field, length 64
creationdate ME_PDI_CREATIONDATE Creation Date
creationtime ME_PDI_CREATIONTIME Creation Time
producttype PRODUCT_TYPE Product Type Group
serviceperformer SERVICEPERFORMER Service Performer
iseopblocked EOPBLOCKED Busin. Purp. Cmpltd.
ext_rev_tmstmp MM_EXT_REV_TMSTMP External Revision
fmfgus_key FMFG_US_KEY US Govt
startdate MMPUR_SERVPROC_PERIOD_START Start Date
enddate MMPUR_SERVPROC_PERIOD_END End Date
extmaterialforpurg MM_PUR_HUB_MATNR Material
extfixedsupplierforpurg MM_PUR_HUB_FLIEF Fixed Supplier
extdesiredsupplierforpurg MM_PUR_HUB_WLIEF Desired Supplier
extcontractforpurg MM_PUR_HUB_KONNR Contract
extcontractitemforpurg MM_PUR_HUB_KTPNR Contract Item
extinforecordforpurg MM_PUR_HUB_INFNR Info Record
extplantforpurg MM_PUR_HUB_WERKS Plant
extstoragelocationforpurg MM_PUR_HUB_LGORT Storage Location
extcompanycodeforpurg MM_PUR_HUB_BUKRS Company Code
extpurgorgforpurg MM_PUR_HUB_EKORG Purch. Organization
extsourcesystem MMPUR_D_COMM_SYS Comm. System
ext_be_source_sys MMPUR_D_SOURCE_SYS Connected System ID
ext_be_prchangeindicator MM_PUR_HUB_CHGIND PR Change Indicator
extdoctypeforpurg MM_PUR_HUB_REQ_DOC_TYPE PR DocTyp of ConnSys
iscrreplicationbeforeapproval MMPUR_PR_CEN_REQN_REPL_BFR_APP Is Rplctn Bfr Apprvl
mmpur_pr_cen_reqn_app_rpld_pr MMPUR_PR_CEN_REQN_APP_RPLD_PR Approval Sts. in Hub
extapprovalstatus MMPUR_REQ_EXTAPPRVLSTS Ext Prcsng. Status
stagingfldextapprovalstatus MMPUR_REQ_STAGING_EXTAPPRVLSTS Intmd Ext Apprvl Sts
purchasereqnitemuniqueid MM_PUR_PR_ITEM_KEY PR Item
lastchangedatetime TIMESTAMPL Time Stamp
isonbehalfcart MMPUR_REQ_D_SOB Shop On Behalf Ind.
sdm_version MMPUR_SDM_VERSION SDM Version
sakto SAKNR G/L Account
kostl KOSTL Cost Center
expected_value COMMITMENT Expected Value
limit_amount SUMLIMIT Overall Limit
contract_for_limit CTR_FOR_LIMIT Contract For Limit
deliveryaddrtype PURDELIVERYADDRTYPE Delivery Addr Type
mwskz MWSKZ Tax Code
pfmtransdatafootprintuuid PFMTRANSDATAFOOTPRINTUUID Transaction Data Footprint
hastradecomplianceissue MMPUR_PR_HAS_TRADE_COMPLIANCE Is Blkd by TrdCmplnc
purreqndescription PURREQNDESCRIPTION PurReqn Description
isoutline MMPUR_REQ_IS_OUTLINE Is Outline
parent_item_no MMPUR_REQ_PARENT_ITEM_NO Parent Item No
outline_type MMPUR_REQ_OUTLINE_TYPE Outline Type
exlin EXLIN Hierarchy Number
exsnr EXSNR External Sort No.
advcode /ISDFPS/ADVCODE Advice Code
stacode /ISDFPS/STACODE StatusCode
banfn_cs /ISDFPS/BANFN_CS CS PReq
bnfpo_cs /ISDFPS/BNFPO_CS CS PReqItm
item_cs /ISDFPS/ITEM_CS CS Item Cat.
bsmng_snd /ISDFPS/BSMNG_SND PO Qty Sender
no_mard_data /ISDFPS/NO_MARD_DATA No SLoc Data
admoi ADMOI Model ID Code
adpri ADPRI Order Priority
lprio LPRIO Delivery Prior.
adacn ADACN AircraftReg.No.
addns ADDNS DoNotSub
serru SERRU Subcon. type
disub_sobkz DISUB_SOBKZ_LB Sp. stock
disub_pspnr PS_PSP_PNR WBS Element
disub_kunnr KUNNR Customer
disub_vbeln VBELN SD Document
disub_posnr POSNR Item
disub_owner OWNER_D Owner of stock
fldlogssupplyprocess FLOG_SPROC Supply Process
fldlogsdelivisheldonshore FLOG_HOLD Hold On-Shore
fldlogsversion FLOG_VERSION Version
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
fsh_vas_rel FSH_VAS_REL VAS Relevant
fsh_vas_prnt_id EBELP Item
fsh_transaction FSH_TRANSACTION Transaction Number
fsh_item_group FSH_ITEM_GROUP Item Group
fsh_item FSH_ITEM Item Number
iuid_relevant IUID_RELEVANT IUID-Relevant
sc_sr_item_key MMPUR_CAT_D_ITM_KEY Catalog Item Key
sc_catalogid BBP_WS_SERVICE_ID Web Service ID
sc_catalogitem MMPUR_REQ_D_CATALOGITEM Catalog Item
sc_requestor MMPUR_REQ_D_REQUESTOR Requestor
sc_author MMPUR_REQ_D_AUTHOR Author
sgt_scat SGT_SCAT Stock Segment
sgt_rcat SGT_RCAT Req. Segment
wrf_charstc1 WRF_CHARSTC1 Characteristic 1
wrf_charstc2 WRF_CHARSTC2 Characteristic 2
wrf_charstc3 WRF_CHARSTC3 Characteristic 3

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.

-- Purchase Requisition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EBAN (
    MANDT,                          -- Client [MANDT]
    BANFN,                          -- Purchase Req. [BANFN]
    BNFPO,                          -- Requisn. item [BNFPO]
    BSART,                          -- Document Type [BBSRT]
    BSTYP,                          -- Doc. Category [BSTYP]
    BSAKZ,                          -- Control [BSAKZ]
    LOEKZ,                          -- Del. Indicator [ELOEK]
    STATU,                          -- Processing stat [BANST]
    ESTKZ,                          -- Creation ind. [ESTKZ]
    FRGKZ,                          -- Release ind. [FRGKZ]
    FRGZU,                          -- Release State [FRGZU]
    FRGST,                          -- Rel. strategy [FRGST]
    EKGRP,                          -- Purch. Group [EKGRP]
    ERNAM,                          -- Created By [ERNAM]
    ERDAT,                          -- Changed On [AEDAT]
    AFNAM,                          -- Requisitioner [AFNAM]
    TXZ01,                          -- Short Text [TXZ01]
    MATNR,                          -- Material [MATNR]
    EMATN,                          -- MPN: Material [EMATN]
    WERKS,                          -- Plant [EWERK]
    LGORT,                          -- Location [LGORT_D]
    BEDNR,                          -- Tracking Number [BEDNR]
    MATKL,                          -- Material Group [MATKL]
    RESWK,                          -- Supplying Plant [RESWK]
    MENGE,                          -- Quantity [BAMNG]
    MEINS,                          -- Unit of Measure [BAMEI]
    BUMNG,                          -- Shortage [BUMNG]
    BADAT,                          -- Requisn Date [BADAT]
    LPEIN,                          -- Delivery Date [LPEIN]
    LFDAT,                          -- Delivery Date [EINDT]
    FRGDT,                          -- Release Date [FRGDT]
    WEBAZ,                          -- GR proc. time [WEBAZ]
    PREIS,                          -- Valuation Price [BAPRE]
    PEINH,                          -- Price Unit [EPEIN]
    PSTYP,                          -- Item Category [PSTYP]
    KNTTP,                          -- Acct Assgmt Cat [KNTTP]
    KZVBR,                          -- Consumption [KZVBR]
    KFLAG,                          -- Modifiable [KFLAG]
    VRTKZ,                          -- Distribution [VRTKZ]
    TWRKZ,                          -- Partial invoice [TWRKZ]
    WEPOS,                          -- Goods Receipt [WEPOS]
    WEUNB,                          -- GR Non-Valuated [WEUNB]
    REPOS,                          -- Invoice Receipt [REPOS]
    LIFNR,                          -- Desired Vendor [WLIEF]
    FLIEF,                          -- Fixed Vendor [FLIEF]
    EKORG,                          -- Purchasing Org. [EKORG]
    VRTYP,                          -- Doc. Category [BSTYP]
    KONNR,                          -- Agreement [KONNR]
    KTPNR,                          -- Agreement Item [KTPNR]
    INFNR,                          -- Info Record [INFNR]
    ZUGBA,                          -- Assigned [DZUGBA]
    QUNUM,                          -- Quota arr. [QUNUM]
    QUPOS,                          -- Quota arr. item [QUPOS]
    DISPO,                          -- MRP Controller [DISPO]
    SERNR,                          -- BOM expl.number [SERNR]
    BVDAT,                          -- Last resubmiss. [BVDAT]
    BATOL,                          -- Resubmission [BATOL]
    BVDRK,                          -- No. resubmiss. [BVDRK]
    EBELN,                          -- Purchase order [BSTNR]
    EBELP,                          -- Item [BSTPO]
    BEDAT,                          -- PO Date [BEDAT]
    BSMNG,                          -- Order quantity [BSMNG]
    LIMIT_CONSUMPTION_VALUE,        -- Consumption Value [MMPUR_REQ_LMT_CNSMPN_VALUE]
    LBLNI,                          -- Entry Sheet [LBLNI]
    BWTAR,                          -- Valuation Type [BWTAR_D]
    XOBLR,                          -- Commitments [XOBLR]
    EBAKZ,                          -- Closed [EBAKZ]
    RSNUM,                          -- Reservation [RSNUM]
    SOBKZ,                          -- Special Stock [SOBKZ]
    ARSNR,                          -- Settle.reser.No [ARSNR]
    ARSPS,                          -- Settle.item no. [ARSPS]
    FIXKZ,                          -- "Fixed" ind. [BAFIX]
    BMEIN,                          -- Order Unit [BSTME]
    REVLV,                          -- Revision Level [REVLV]
    VORAB,                          -- Advance proc. [VORAB]
    PACKNO,                         -- Package number [PACKNO]
    KANBA,                          -- Kanban Indicat. [KBNKZ]
    BPUEB,                          -- PO price [BPUEB]
    CUOBJ,                          -- Int. object no. [CUOBJ]
    FRGGR,                          -- Release group [FRGGR]
    FRGRL,                          -- Subj.to Release [FRGRL]
    AKTNR,                          -- Promotion [WAKTION]
    CHARG,                          -- Batch [CHARG_D]
    UMSOK,                          -- Sp.ind.st.tfr. [UMSOK]
    VERID,                          -- Prod. Version [VERID]
    FIPOS,                          -- Commitment item [FIPOS]
    FISTL,                          -- Funds Center [FISTL]
    GEBER,                          -- Fund [BP_GEBER]
    KZKFG,                          -- Origin of config [KZCUH]
    SATNR,                          -- Cross-plant CM [SATNR]
    MNG02,                          -- Committed Qty [MNG06]
    DAT01,                          -- Committed date [DAT05]
    ATTYP,                          -- Matl Category [ATTYP]
    ADRNR,                          -- Address [ADRNR_MM]
    ADRN2,                          -- Address [ADRN2]
    KUNNR,                          -- Customer [EKUNNR]
    EMLIF,                          -- Supplier [EMLIF]
    LBLKZ,                          -- SC Supplier [LBLKZ]
    KZBWS,                          -- Valuation [KZBWS]
    WAERS,                          -- Currency [WAERS]
    IDNLF,                          -- Supp. Mat. No. [IDNLF]
    GSFRG,                          -- Overall req. rel. [GSFRG]
    MPROF,                          -- Mfr Part Profile [MPROF]
    KZFME,                          -- Units meas. use [KZWSO]
    SPRAS,                          -- Language [SPRAS]
    TECHS,                          -- StandardVariant [TECHS]
    MFRPN,                          -- Mfr Part Number [MFRPN]
    MFRNR,                          -- Manufacturer [MFRNR]
    EMNFR,                          -- External manuf. [EMNFR]
    FORDN,                          -- Framework Order [SFORDN]
    FORDP,                          -- Frwrk. ord. item [FORDP]
    PLIFZ,                          -- Pl. Deliv. Time [PLIFZ]
    BERID,                          -- MRP Area [BERID]
    UZEIT,                          -- Time [LZEIT]
    FKBER,                          -- Functional Area [FKBER]
    GRANT_NBR,                      -- Grant [GM_GRANT_NBR]
    MEMORY,                         -- Incomplete [MEMBF]
    BANPR,                          -- Proc.state [BANPR]
    RLWRT,                          -- Tot. val. rel. [RLWRT]
    BLCKD,                          -- Blocking Ind. [BLCKD]
    REVNO,                          -- Version [REVNO]
    BLCKT,                          -- Blocking Text [BLCKT]
    BESWK,                          -- Procuring Plant [BESWK]
    EPROFILE,                       -- Procurement prof. [MEPROFILE]
    EPREFDOC,                       -- External doc. [EPREFDOC]
    EPREFITM,                       -- External item [EPREFITM]
    GMMNG,                          -- PO Qty on Hold [GMMNG]
    WRTKZ,                          -- Reduce Com. (Value) [WRTKZ]
    RESLO,                          -- Iss. Stor. Loc. [RESLO]
    KBLNR,                          -- Earmarked Funds [KBLNR]
    KBLPOS,                         -- Document Item [KBLPOS]
    PRIO_URG,                       -- Reqmt Urgency [PRIO_URG]
    PRIO_REQ,                       -- Reqmt Priority [PRIO_REQ]
    MEMORYTYPE,                     -- Incompl. Cat. [MEMORYTYPE]
    ANZSN,                          -- No.serial no. [ANZSN]
    MHDRZ,                          -- Rem. Shelf Life [MHDRZ]
    IPRKZ,                          -- Period Ind. [DATTP]
    NODISP,                         -- Res./Purc. req. [NODISP]
    SRM_CONTRACT_ID,                -- Central Contract [SRM_CONTRACT_ID]
    SRM_CONTRACT_ITM,               -- Cent. Contract Item [SRM_CONTRACT_ITEM]
    BUDGET_PD,                      -- Budget Period [FM_BUDGET_PERIOD]
    ELDAT,                          -- Planned dates [DAT00]
    EXPERT_MODE,                    -- PR in Expert Mode [MMPUR_PR_SSP_EXPERT_MODE]
    CENTRAL_PURREQN_PROC,           -- Is Central PR Procg. [MMPUR_PR_CEN_PURREQN_PROC_MODE]
    SPE_CRM_REF_SO,                 -- CRM Ref Order [/SPE/REF_VBELN_CRM]
    SPE_CRM_REF_ITEM,               -- CRM Rf Item No [/SPE/REF_POSNR_CRM]
    INDELEGATEAPPROVAL,             -- PurReq Ext. approval [MMPUR_INDELEGATEAPPROVAL]
    DUMMY_EBAN_INCL_EEW_PS,         -- PR Ext Include [EBAN_INCL_EEW]
    STORENETWORKID,                 -- 128 character [CHAR128]
    STORESUPPLIERID,                -- Character field, length 64 [CHAR64]
    CREATIONDATE,                   -- Creation Date [ME_PDI_CREATIONDATE]
    CREATIONTIME,                   -- Creation Time [ME_PDI_CREATIONTIME]
    PRODUCTTYPE,                    -- Product Type Group [PRODUCT_TYPE]
    SERVICEPERFORMER,               -- Service Performer [SERVICEPERFORMER]
    ISEOPBLOCKED,                   -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    EXT_REV_TMSTMP,                 -- External Revision [MM_EXT_REV_TMSTMP]
    FMFGUS_KEY,                     -- US Govt [FMFG_US_KEY]
    STARTDATE,                      -- Start Date [MMPUR_SERVPROC_PERIOD_START]
    ENDDATE,                        -- End Date [MMPUR_SERVPROC_PERIOD_END]
    EXTMATERIALFORPURG,             -- Material [MM_PUR_HUB_MATNR]
    EXTFIXEDSUPPLIERFORPURG,        -- Fixed Supplier [MM_PUR_HUB_FLIEF]
    EXTDESIREDSUPPLIERFORPURG,      -- Desired Supplier [MM_PUR_HUB_WLIEF]
    EXTCONTRACTFORPURG,             -- Contract [MM_PUR_HUB_KONNR]
    EXTCONTRACTITEMFORPURG,         -- Contract Item [MM_PUR_HUB_KTPNR]
    EXTINFORECORDFORPURG,           -- Info Record [MM_PUR_HUB_INFNR]
    EXTPLANTFORPURG,                -- Plant [MM_PUR_HUB_WERKS]
    EXTSTORAGELOCATIONFORPURG,      -- Storage Location [MM_PUR_HUB_LGORT]
    EXTCOMPANYCODEFORPURG,          -- Company Code [MM_PUR_HUB_BUKRS]
    EXTPURGORGFORPURG,              -- Purch. Organization [MM_PUR_HUB_EKORG]
    EXTSOURCESYSTEM,                -- Comm. System [MMPUR_D_COMM_SYS]
    EXT_BE_SOURCE_SYS,              -- Connected System ID [MMPUR_D_SOURCE_SYS]
    EXT_BE_PRCHANGEINDICATOR,       -- PR Change Indicator [MM_PUR_HUB_CHGIND]
    EXTDOCTYPEFORPURG,              -- PR DocTyp of ConnSys [MM_PUR_HUB_REQ_DOC_TYPE]
    ISCRREPLICATIONBEFOREAPPROVAL,  -- Is Rplctn Bfr Apprvl [MMPUR_PR_CEN_REQN_REPL_BFR_APP]
    MMPUR_PR_CEN_REQN_APP_RPLD_PR,  -- Approval Sts. in Hub [MMPUR_PR_CEN_REQN_APP_RPLD_PR]
    EXTAPPROVALSTATUS,              -- Ext Prcsng. Status [MMPUR_REQ_EXTAPPRVLSTS]
    STAGINGFLDEXTAPPROVALSTATUS,    -- Intmd Ext Apprvl Sts [MMPUR_REQ_STAGING_EXTAPPRVLSTS]
    PURCHASEREQNITEMUNIQUEID,       -- PR Item [MM_PUR_PR_ITEM_KEY]
    LASTCHANGEDATETIME,             -- Time Stamp [TIMESTAMPL]
    ISONBEHALFCART,                 -- Shop On Behalf Ind. [MMPUR_REQ_D_SOB]
    SDM_VERSION,                    -- SDM Version [MMPUR_SDM_VERSION]
    SAKTO,                          -- G/L Account [SAKNR]
    KOSTL,                          -- Cost Center [KOSTL]
    EXPECTED_VALUE,                 -- Expected Value [COMMITMENT]
    LIMIT_AMOUNT,                   -- Overall Limit [SUMLIMIT]
    CONTRACT_FOR_LIMIT,             -- Contract For Limit [CTR_FOR_LIMIT]
    DELIVERYADDRTYPE,               -- Delivery Addr Type [PURDELIVERYADDRTYPE]
    MWSKZ,                          -- Tax Code [MWSKZ]
    PFMTRANSDATAFOOTPRINTUUID,      -- Transaction Data Footprint [PFMTRANSDATAFOOTPRINTUUID]
    HASTRADECOMPLIANCEISSUE,        -- Is Blkd by TrdCmplnc [MMPUR_PR_HAS_TRADE_COMPLIANCE]
    PURREQNDESCRIPTION,             -- PurReqn Description [PURREQNDESCRIPTION]
    ISOUTLINE,                      -- Is Outline [MMPUR_REQ_IS_OUTLINE]
    PARENT_ITEM_NO,                 -- Parent Item No [MMPUR_REQ_PARENT_ITEM_NO]
    OUTLINE_TYPE,                   -- Outline Type [MMPUR_REQ_OUTLINE_TYPE]
    EXLIN,                          -- Hierarchy Number [EXLIN]
    EXSNR,                          -- External Sort No. [EXSNR]
    ADVCODE,                        -- Advice Code [/ISDFPS/ADVCODE]
    STACODE,                        -- StatusCode [/ISDFPS/STACODE]
    BANFN_CS,                       -- CS PReq [/ISDFPS/BANFN_CS]
    BNFPO_CS,                       -- CS PReqItm [/ISDFPS/BNFPO_CS]
    ITEM_CS,                        -- CS Item Cat. [/ISDFPS/ITEM_CS]
    BSMNG_SND,                      -- PO Qty Sender [/ISDFPS/BSMNG_SND]
    NO_MARD_DATA,                   -- No SLoc Data [/ISDFPS/NO_MARD_DATA]
    ADMOI,                          -- Model ID Code [ADMOI]
    ADPRI,                          -- Order Priority [ADPRI]
    LPRIO,                          -- Delivery Prior. [LPRIO]
    ADACN,                          -- AircraftReg.No. [ADACN]
    ADDNS,                          -- DoNotSub [ADDNS]
    SERRU,                          -- Subcon. type [SERRU]
    DISUB_SOBKZ,                    -- Sp. stock [DISUB_SOBKZ_LB]
    DISUB_PSPNR,                    -- WBS Element [PS_PSP_PNR]
    DISUB_KUNNR,                    -- Customer [KUNNR]
    DISUB_VBELN,                    -- SD Document [VBELN]
    DISUB_POSNR,                    -- Item [POSNR]
    DISUB_OWNER,                    -- Owner of stock [OWNER_D]
    FLDLOGSSUPPLYPROCESS,           -- Supply Process [FLOG_SPROC]
    FLDLOGSDELIVISHELDONSHORE,      -- Hold On-Shore [FLOG_HOLD]
    FLDLOGSVERSION,                 -- Version [FLOG_VERSION]
    FSH_SEASON_YEAR,                -- Season Year [FSH_SAISJ]
    FSH_SEASON,                     -- Season [FSH_SAISO]
    FSH_COLLECTION,                 -- Collection [FSH_COLLECTION]
    FSH_THEME,                      -- Theme [FSH_THEME]
    FSH_VAS_REL,                    -- VAS Relevant [FSH_VAS_REL]
    FSH_VAS_PRNT_ID,                -- Item [EBELP]
    FSH_TRANSACTION,                -- Transaction Number [FSH_TRANSACTION]
    FSH_ITEM_GROUP,                 -- Item Group [FSH_ITEM_GROUP]
    FSH_ITEM,                       -- Item Number [FSH_ITEM]
    IUID_RELEVANT,                  -- IUID-Relevant [IUID_RELEVANT]
    SC_SR_ITEM_KEY,                 -- Catalog Item Key [MMPUR_CAT_D_ITM_KEY]
    SC_CATALOGID,                   -- Web Service ID [BBP_WS_SERVICE_ID]
    SC_CATALOGITEM,                 -- Catalog Item [MMPUR_REQ_D_CATALOGITEM]
    SC_REQUESTOR,                   -- Requestor [MMPUR_REQ_D_REQUESTOR]
    SC_AUTHOR,                      -- Author [MMPUR_REQ_D_AUTHOR]
    SGT_SCAT,                       -- Stock Segment [SGT_SCAT]
    SGT_RCAT,                       -- Req. Segment [SGT_RCAT]
    WRF_CHARSTC1,                   -- Characteristic 1 [WRF_CHARSTC1]
    WRF_CHARSTC2,                   -- Characteristic 2 [WRF_CHARSTC2]
    WRF_CHARSTC3,                   -- Characteristic 3 [WRF_CHARSTC3]
    PRIMARY KEY (MANDT, BANFN, BNFPO)
);

Learn More