EBAN

Purchase Requisition | #transactional | #language | Component: Purchasing
Column Name Description
MANDT FK Client
BANFN Purchase Requisition Number
BNFPO Item number of purchase requisition
Column Name Description
💲 Currency Key (WAERS):
PREIS Price in Purchase Requisition
LIMIT_CONSUMPTION_VALUE Consumption Value for Limit Items
RLWRT Total value at time of release
EXPECTED_VALUE Expected Value of Overall Limit
LIMIT_AMOUNT Overall Limit
Column Name Description
📏 Purchase requisition unit of measure (MEINS):
MENGE Purchase requisition quantity
BUMNG Shortage (stock undercoverage) quantity
BSMNG Quantity ordered against this purchase requisition
MNG02 Committed Quantity
GMMNG PO Quantity of Purchase Requisition in POs on Hold
BSMNG_SND PO Quantity Sender
Column Name Description
ERDAT Last Changed On
BADAT Requisition (request) date
LFDAT Item delivery date
FRGDT Purchase Requisition Release Date
BVDAT Date of last resubmission
BEDAT Purchase Order Date
DAT01 Committed date
UZEIT Delivery Date Time-Spot
ELDAT Receipt/Requirements date
CREATIONDATE Purchasing Document Creation Date
CREATIONTIME Purchasing Document Creation Time
STARTDATE Start Date for Period of Performance
ENDDATE End Date for Period of Performance
Column Name Description
BSTYP Purchasing Document Category Show values
BSAKZ Control indicator for purchasing document type Show values
STATU Processing status of purchase requisition Show values
ESTKZ Creation indicator (purchase requisition/schedule lines) Show values
KZVBR Consumption posting Show values
KFLAG Acct.asst.modifiable Show values
VRTKZ Distribution Indicator for Multiple Account Assignment Show values
TWRKZ Partial invoice indicator Show values
WEPOS Goods Receipt Indicator Show values
WEUNB Goods Receipt, Non-Valuated Show values
REPOS Invoice receipt indicator Show values
VRTYP Purchasing Document Category Show values
ZUGBA Assigned Source of Supply Show values
XOBLR Item affects commitments Show values
EBAKZ Purchase requisition closed Show values
FIXKZ Purchase requisition is fixed Show values
VORAB Advance procurement: project stock Show values
KANBA Kanban Indicator Show values
BPUEB Use Requisition Price in Purchase Order Show values
FRGRL Release Not Yet Completely Effected Show values
KZKFG Origin of Configuration Show values
ATTYP Material Category Show values
LBLKZ Subcontracting Supplier Show values
KZBWS Valuation of Special Stock Show values
GSFRG Overall release of purchase requisitions Show values
KZFME Units of measure usage Show values
MEMORY Purchase Requisition not yet Complete Show values
BANPR Requisition Processing State Show values
BLCKD Purchase Requisition Blocked Show values
WRTKZ Value-Based Commitment Reduction for Service Purchase Reqs Show values
MEMORYTYPE Category of Incompleteness Show values
IPRKZ Period Indicator for Shelf Life Expiration Date Show values
NODISP Ind: Reserv. not applicable to MRP;Purc. req. not created Show values
EXPERT_MODE PR Created in Expert Mode Show values
CENTRAL_PURREQN_PROC Is PR relevant for Central PR Processing Show values
INDELEGATEAPPROVAL Purchase Requisition in external approval Show values
ISEOPBLOCKED Business Purpose Completed Show values
EXT_BE_PRCHANGEINDICATOR Change Indicator for PR in Central Procurement Show values
EXTAPPROVALSTATUS External Processing Status Show values
STAGINGFLDEXTAPPROVALSTATUS External Processing Status Show values
ISONBEHALFCART Shop on behalf indicator Show values
DELIVERYADDRTYPE Purchasing Delivery Address Type Show values
HASTRADECOMPLIANCEISSUE Is Purchase Requisition Blocked by Trade Compliance Show values
ISOUTLINE Is Outline Show values
OUTLINE_TYPE Outline Type Show values
ITEM_CS Cross-System Item Category Show values
NO_MARD_DATA No Storage Location Data Exists for Material Show values
ADDNS Do Not Substitute Show values
SERRU Type of subcontracting Show values
DISUB_SOBKZ Special stock indicator Subcontracting Show values
FLDLOGSDELIVISHELDONSHORE Hold On-Shore Show values
FSH_VAS_REL VAS Relevant Show values
IUID_RELEVANT IUID-Relevant Show values
Column Name Description Domain name
LOEKZ Deletion Indicator in Purchasing Document ELOEK
FRGZU Release State FRGZU
FRGST Release strategy in the purchase requisition FRGST
ERNAM Name of Person Responsible for Creating the Object USNAM
AFNAM Name of requisitioner/requester AFNAM
TXZ01 Short Text TEXT40
BEDNR Requirement Tracking Number CHAR10
RESWK Supplying (issuing) plant in case of stock transport order WERKS
WEBAZ Goods receipt processing time in days DEC3
PEINH Price unit DEC5
QUNUM Number of quota arrangement QUNUM
QUPOS Quota arrangement item NUM03
SERNR BOM explosion number SERNR
BATOL Resubmission interval of purchase requisition BATOL
BVDRK Number of resubmissions ZAEHL
RSNUM Number of reservation/dependent requirements RSNUM
ARSNR Settlement reservation number MDNUM
ARSPS Item number of the settlement reservation RSPOS
REVLV Revision Level REVLV
CUOBJ Configuration (internal object number) CUOBJ
CHARG Batch Number CHARG
UMSOK Special stock indicator for physical stock transfer SOBKZ
VERID Production Version VERID
FIPOS Commitment Item FIPOS
FISTL Funds Center FISTL
GEBER Fund BP_GEBER
SATNR Cross-Plant Configurable Material MATNR
IDNLF Material Number Used by Supplier IDNEX
MPROF Mfr part profile MPROF
TECHS Parameter Variant/Standard Variant TECHS
MFRPN Manufacturer Part Number CHAR40
EMNFR External manufacturer code name or number CHAR10
FORDN Framework Order EBELN
FORDP Item of framework order EBELP
PLIFZ Planned Delivery Time in Days DEC3
BERID MRP Area BERID
FKBER Functional Area FKBER
GRANT_NBR Grant GM_GRANT_NBR
REVNO Version number in Purchasing REVNO
BLCKT Reason for Item Block CHAR60K
EPROFILE External Procurement Profile EPROFILE
EPREFDOC External Procurement Reference Document EPREFDOC
EPREFITM External Procurement Reference Item EPREFITM
RESLO Issuing Storage Location for Stock Transport Order LGORT
KBLNR Document Number for Earmarked Funds KBLNR
KBLPOS Earmarked Funds: Document Item KBLPOS
ANZSN Number of serial numbers INT4
MHDRZ Minimum Remaining Shelf Life DEC4
SRM_CONTRACT_ID Central Contract BBP_BAPI_EBELN
SRM_CONTRACT_ITM Central Contract Item Number BBP_ITEMNO
BUDGET_PD Budget Period FM_BUDGET_PERIOD
SPE_CRM_REF_SO CRM Reference Order Number for TPOP Process /SPE/REF_VBELN_CRM
SPE_CRM_REF_ITEM CRM Reference Sales Order Item Number in TPOP Process /SPE/REF_POSNR_CRM
DUMMY_EBAN_INCL_EEW_PS Data element for purchase requisition extensibility EBAN_INCL_EEW
STORENETWORKID 128 character CHAR128
STORESUPPLIERID Character field, length 64 CHAR64
PRODUCTTYPE Product Type Group CHAR2
SERVICEPERFORMER Service Performer BU_PARTNER
EXT_REV_TMSTMP Timestamp for Revision of External Calls TZNTSTMPL
FMFGUS_KEY United States Federal Government Fields SYSUUID_22
EXTMATERIALFORPURG Material of External System MATNR
EXTFIXEDSUPPLIERFORPURG Fixed Supplier of External System LIFNR
EXTDESIREDSUPPLIERFORPURG Desired Supplier of External System LIFNR
EXTCONTRACTFORPURG Contract of External System EBELN
EXTCONTRACTITEMFORPURG Contract Item of External System EBELP
EXTINFORECORDFORPURG Info Record of External System INFNR
EXTPLANTFORPURG Plant of External System WERKS
EXTCOMPANYCODEFORPURG Company Code of External System BUKRS
EXTPURGORGFORPURG Purchasing Organization EKORG
EXTSOURCESYSTEM Communication System ID
EXT_BE_SOURCE_SYS Connected System ID
EXTDOCTYPEFORPURG PR Document Type of Connected System BSART
PURCHASEREQNITEMUNIQUEID Key to identify purchase requisition item MM_PUR_PR_ITEM_KEY
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
SDM_VERSION Version of Silent Data Migration MMPUR_SDM_VERSION
SAKTO G/L Account Number SAKNR
KOSTL Cost Center KOSTL
MWSKZ Tax on sales/purchases code MWSKZ
PARENT_ITEM_NO Parent Item No BNFPO
EXLIN Hierarchy Number EXLIN
EXSNR External Sort Number EXSNR
BANFN_CS Cross-System PReq Number BANFN
BNFPO_CS Cross-System PReq Item BNFPO
ADACN Aircraft registration number ADACN
DISUB_PSPNR Work Breakdown Structure Element (WBS Element) PS_POSNR
DISUB_KUNNR Customer Number KUNNR
DISUB_VBELN Sales and Distribution Document Number VBELN
DISUB_POSNR Item number of the SD document POSNR
DISUB_OWNER Owner of stock LIFNR
FLDLOGSSUPPLYPROCESS Supply Process FLOG_SPROC
FLDLOGSVERSION Version FLOG_VERSION
FSH_VAS_PRNT_ID Item Number of Purchasing Document EBELP
FSH_TRANSACTION Transaction Number FSH_TRANSACTION
FSH_ITEM_GROUP Item Group FSH_ITEM_GROUP
FSH_ITEM Item Number FSH_ITEM
SC_SR_ITEM_KEY Catalog Item Key
SC_CATALOGID Technical Key of a Web Service (for Example - a Catalog) BBP_WS_SERVICE_ID
SC_CATALOGITEM Catalog Item Id
SC_REQUESTOR Requestor
SC_AUTHOR Author of Requisition UNAME
SGT_SCAT Stock Segment SGT_SRCA
SGT_RCAT Requirement Segment SGT_SRCA
WRF_CHARSTC1 Characteristic Value 1 WRF_CHARSTC
WRF_CHARSTC2 Characteristic Value 2 WRF_CHARSTC
WRF_CHARSTC3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations | to Other Relations ↓ Join Conditions
Model ID Code
  • Model ID Code
  • Client
SPEC2000 Priorities
Number of delivery address
  • Number of delivery address
  • ?
  • ?
  • EBAN.MANDT == ADRC.CLIENT
  • EBAN.ADRN2 == ADRC.ADDRNUMBER
  • EBAN.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • EBAN.[column in domain "AD_NATION"] == ADRC.NATION
Link to Central Address Management
  • Manual address number in purchasing document item
  • ?
  • ?
  • EBAN.MANDT == ADRC.CLIENT
  • EBAN.ADRNR == ADRC.ADDRNUMBER
  • EBAN.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • EBAN.[column in domain "AD_NATION"] == ADRC.NATION
Promotion
  • Promotion
  • Client
  • EBAN.AKTNR == WAKH.AKTNR
  • EBAN.MANDT == WAKH.MANDT
Procuring Plant
  • EBAN.MANDT == T001W.MANDT
  • EBAN.BESWK == T001W.WERKS
Purchase Order Unit of Measure
  • EBAN.MANDT == T006.MANDT
  • EBAN.BMEIN == T006.MSEHI
Purchase Requisition Document Type
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • EBAN.MANDT == T161.MANDT
  • EBAN.BSTYP == T161.BSTYP
  • EBAN.BSART == T161.BSART
Valuation Type
  • EBAN.MANDT == T149D.MANDT
  • EBAN.BWTAR == T149D.BWTAR
MRP Controller
  • Plant
  • MRP Controller
  • Client
  • EBAN.WERKS == T024D.WERKS
  • EBAN.DISPO == T024D.DISPO
  • EBAN.MANDT == T024D.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • EBAN.EKGRP == T024.EKGRP
  • EBAN.MANDT == T024.MANDT
Purchasing organization
  • EBAN.MANDT == T024E.MANDT
  • EBAN.EKORG == T024E.EKORG
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • EBAN.EMATN == MARA.MATNR
  • EBAN.MANDT == MARA.MANDT
Supplier to be Supplied/Who is to Receive Delivery
  • EBAN.MANDT == LFA1.MANDT
  • EBAN.EMLIF == LFA1.LIFNR
Fixed Vendor
  • EBAN.MANDT == LFA1.MANDT
  • EBAN.FLIEF == LFA1.LIFNR
Release group
  • EBAN.MANDT == T16FG.MANDT
  • EBAN.FRGGR == T16FG.FRGGR
Release Indicator
  • EBAN.MANDT == T161S.MANDT
  • EBAN.FRGKZ == T161S.FRGKZ
Fashion Collection
  • Season Year
  • Season
  • Client
  • Fashion Collection
Season
  • Season Year
  • Season
Season Year
  • Season Year
  • Season
Fashion Theme
  • Season
  • Fashion Collection
  • Fashion Theme
  • Client
  • Season Year
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • EBAN.INFNR == EINA.INFNR
  • EBAN.MANDT == EINA.MANDT
Account Assignment Category
  • EBAN.MANDT == T163K.MANDT
  • EBAN.KNTTP == T163K.KNTTP
Customer
  • EBAN.MANDT == KNA1.MANDT
  • EBAN.KUNNR == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant
  • EBAN.LGORT == T001L.LGORT
  • EBAN.MANDT == T001L.MANDT
  • EBAN.WERKS == T001L.WERKS
Desired Vendor
  • EBAN.MANDT == LFA1.MANDT
  • EBAN.LIFNR == LFA1.LIFNR
Delivery Priority
  • EBAN.MANDT == TPRIO.MANDT
  • EBAN.LPRIO == TPRIO.LPRIO
Client EBAN.MANDT == T000.MANDT
Material Group
  • EBAN.MANDT == T023.MANDT
  • EBAN.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • EBAN.MATNR == MARA.MATNR
  • EBAN.MANDT == MARA.MANDT
Purchase requisition unit of measure
  • EBAN.MANDT == T006.MANDT
  • EBAN.MEINS == T006.MSEHI
Manufacturer number
  • EBAN.MANDT == LFA1.MANDT
  • EBAN.MFRNR == LFA1.LIFNR
Package number
  • EBAN.MANDT == ESLH.MANDT
  • EBAN.PACKNO == ESLH.PACKNO
Requirement Priority
  • Requirement Priority
  • Client
  • EBAN.PRIO_REQ == PREQ.PRIO_REQ
  • EBAN.MANDT == PREQ.MANDT
Requirement Urgency
  • Requirement Urgency
  • Client
  • EBAN.PRIO_URG == PURG.PRIO_URG
  • EBAN.MANDT == PURG.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • EBAN.PSTYP == T163.PSTYP
  • EBAN.MANDT == T163.MANDT
Special Stock Indicator
  • EBAN.MANDT == T148.MANDT
  • EBAN.SOBKZ == T148.SOBKZ
Language Key EBAN.SPRAS == T002.SPRAS
Status Code
  • Status Code
  • Client
Currency Key
  • EBAN.MANDT == TCURC.MANDT
  • EBAN.WAERS == TCURC.WAERS
Plant
  • EBAN.MANDT == T001W.MANDT
  • EBAN.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Advice Code
  • Purchase Requisition Document Type
  • Advice Code
Category of delivery date
  • Category of delivery date
  • Client
  • ?
  • EBAN.LPEIN == TPRG.PRGBZ
  • EBAN.MANDT == TPRG.MANDT
  • EBAN.[column in domain "SPRAS"] == TPRG.SPRAS