EBAN (Purchase Requisition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link EBAN to other SAP tables.
A purchase requisition is a request or instruction to Purchasing to procure a certain quantity of a material or a service so that it is available at a certain point in time. A purchase requisition is an internal document. It I not used outside the organization.
Purchase requisitions only have a line item table in SAP. There are no header details. A purchase requisition is usually followed by a purchase document (like a purchase order) in a typical MM flow.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||
|
BANFN
Purchase Requisition Number
|
BANFN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
BNFPO
Item Number of Purchase Requisition
|
BNFPO |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||
|
BSART
Purchase Requisition Document Type
|
BBSRT | T161 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
BSTYP
Purchasing Document Category
|
BSTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BSAKZ
Control indicator for purchasing document type
|
BSAKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
LOEKZ
Deletion Indicator in Purchasing Document
|
ELOEK |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
STATU
Processing status of purchase requisition
|
BANST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
ESTKZ
Creation Indicator (Purchase Requisition/Schedule Lines)
|
ESTKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
FRGKZ
Release Indicator
|
FRGKZ | T161S |
CHAR
|
1 | 0 | |||||||||||||||||||||||||
|
FRGZU
Release status
|
FRGZU |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||
|
FRGST
Release Strategy in Purchase Requisition
|
FRGST |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||
|
EKGRP
Purchasing Group
|
EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||
|
ERDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
AFNAM
Name of Requisitioner/Requester
|
AFNAM |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||
|
TXZ01
Short Text
|
TXZ01 |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||||
|
EMATN
Material Number Corresponding to Manufacturer Part Number
|
EMATN | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||||
|
WERKS
Plant
|
EWERK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
LGORT
Storage Location
|
LGORT_D | T001L |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
BEDNR
Requirement Tracking Number
|
BEDNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
MATKL
Material Group
|
MATKL | T023 |
CHAR
|
9 | 0 | |||||||||||||||||||||||||
|
RESWK
Supplying (Issuing) Plant in Stock Transport Order
|
RESWK |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
MENGE
Purchase Requisition Quantity
|
BAMNG |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
MEINS
Purchase Requisition Unit of Measure
|
BAMEI | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||||
|
BUMNG
Shortage (stock undercoverage) quantity
|
BUMNG |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
BADAT
Requisition (Request) Date
|
BADAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
LPEIN
Category of Delivery Date
|
LPEIN | TPRG |
CHAR
|
1 | 0 | |||||||||||||||||||||||||
|
LFDAT
Item Delivery Date
|
EINDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
FRGDT
Purchase Requisition Release Date
|
FRGDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
WEBAZ
Goods Receipt Processing Time in Days
|
WEBAZ |
DEC
|
3 | 0 | ||||||||||||||||||||||||||
|
PREIS
Price in Purchase Requisition
|
BAPRE |
CURR
|
11 | 2 | ||||||||||||||||||||||||||
|
PEINH
Price Unit
|
EPEIN |
DEC
|
5 | 0 | ||||||||||||||||||||||||||
|
PSTYP
Item Category in Purchasing Document
|
PSTYP | T163 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||
|
KNTTP
Account Assignment Category
|
KNTTP | T163K |
CHAR
|
1 | 0 | |||||||||||||||||||||||||
|
KZVBR
Consumption Posting
|
KZVBR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
KFLAG
Acct.asst.changeable
|
KFLAG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
VRTKZ
Distribution indicator for multiple account assignment
|
VRTKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
TWRKZ
Partial Invoice Indicator
|
TWRKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
WEPOS
Goods Receipt Indicator
|
WEPOS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
WEUNB
Goods Receipt, Non-Valuated
|
WEUNB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
REPOS
Invoice Receipt Indicator
|
REPOS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
LIFNR
Desired Vendor
|
WLIEF | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
FLIEF
Fixed Vendor
|
FLIEF | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
VRTYP
Purchasing Document Category
|
BSTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
KONNR
Number of Principal Purchase Agreement
|
KONNR | EKKO |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
KTPNR
Item Number of Principal Purchase Agreement
|
KTPNR | EKPO |
NUMC
|
5 | 0 | |||||||||||||||||||||||||
|
INFNR
Number of Purchasing Info Record
|
INFNR | EINA |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
ZUGBA
Assigned Source of Supply
|
DZUGBA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
QUNUM
Number of Quota Arrangement
|
QUNUM |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
QUPOS
Quota Arrangement Item
|
QUPOS |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||
|
DISPO
MRP Controller (Materials Planner)
|
DISPO | T024D |
CHAR
|
3 | 0 | |||||||||||||||||||||||||
|
SERNR
BOM explosion number
|
SERNR |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||
|
BVDAT
Date of last resubmission
|
BVDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
BATOL
Resubmission Interval of Purchase Requisition
|
BATOL |
DEC
|
3 | 0 | ||||||||||||||||||||||||||
|
BVDRK
Number of resubmissions
|
BVDRK |
DEC
|
7 | 0 | ||||||||||||||||||||||||||
|
EBELN
Purchase Order Number
|
BSTNR | EKKO |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
EBELP
Purchase Order Item Number
|
BSTPO | EKPO |
NUMC
|
5 | 0 | |||||||||||||||||||||||||
|
BEDAT
Purchase Order Date
|
BEDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
BSMNG
Quantity Ordered Against this Purchase Requisition
|
BSMNG |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
LBLNI
Entry Sheet Number
|
LBLNI | ESSR |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
BWTAR
Valuation Type
|
BWTAR_D | T149D |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
XOBLR
Item affects commitments
|
XOBLR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
EBAKZ
Purchase Requisition Closed
|
EBAKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
RSNUM
Number of Reservation/Dependent Requirement
|
RSNUM |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||
|
SOBKZ
Special Stock Indicator
|
SOBKZ | T148 |
CHAR
|
1 | 0 | |||||||||||||||||||||||||
|
ARSNR
Settlement reservation number
|
ARSNR |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||
|
ARSPS
Item number of the settlement reservation
|
ARSPS |
NUMC
|
4 | 0 | ||||||||||||||||||||||||||
|
FIXKZ
Purchase Requisition is Fixed
|
BAFIX |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BMEIN
Purchase Order Unit of Measure
|
BSTME | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||||
|
REVLV
Revision Level
|
REVLV |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||
|
VORAB
Advance procurement: project stock
|
VORAB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
PACKNO
Package number
|
PACKNO | ESLH |
NUMC
|
10 | 0 | |||||||||||||||||||||||||
|
KANBA
Kanban Indicator
|
KBNKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BPUEB
Adopt Requisition Price in Purchase Order
|
BPUEB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
CUOBJ
Configuration (internal object number)
|
CUOBJ |
NUMC
|
18 | 0 | ||||||||||||||||||||||||||
|
FRGGR
Release group
|
FRGGR | T16FG |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
FRGRL
Release Not Yet Completely Effected
|
FRGRL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
AKTNR
Promotion
|
WAKTION | WAKH |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
CHARG
Batch Number
|
CHARG_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
UMSOK
Special Stock Indicator for Physical Stock Transfer
|
UMSOK |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
VERID
Production Version
|
VERID |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
FIPOS
Commitment Item
|
FIPOS |
CHAR
|
14 | 0 | ||||||||||||||||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||||||||||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
KZKFG
Origin of Configuration
|
KZCUH |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
SATNR
Cross-Plant Configurable Material
|
SATNR |
CHAR
|
18 | 0 | ||||||||||||||||||||||||||
|
MNG02
Committed Quantity
|
MNG06 |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
DAT01
Committed Date
|
DAT05 |
DATS
|
8 | 0 | ||||||||||||||||||||||||||
|
ATTYP
Material Category
|
ATTYP |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
ADRNR
Manual address number in purchasing document item
|
ADRNR_MM | ADRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
ADRN2
Number of delivery address
|
ADRN2 | ADRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
KUNNR
Customer
|
EKUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
EMLIF
Vendor to be supplied/who is to receive delivery
|
EMLIF | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
LBLKZ
Subcontracting vendor
|
LBLKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
KZBWS
Valuation of Special Stock
|
KZBWS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||
|
IDNLF
Material Number Used by Vendor
|
IDNLF |
CHAR
|
35 | 0 | ||||||||||||||||||||||||||
|
GSFRG
Overall release of purchase requisitions
|
GSFRG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
MPROF
Manufacturer Part Profile
|
MPROF |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
KZFME
Units of measure usage
|
KZWSO |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||||||||||
|
TECHS
Parameter Variant/Standard Variant
|
TECHS |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||
|
MFRPN
Manufacturer Part Number
|
MFRPN |
CHAR
|
40 | 0 | ||||||||||||||||||||||||||
|
MFRNR
Number of a Manufacturer
|
MFRNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
EMNFR
External manufacturer code name or number
|
EMNFR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
FORDN
Framework Order
|
SFORDN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
FORDP
Item of framework order
|
FORDP |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||
|
PLIFZ
Planned Delivery Time in Days
|
PLIFZ |
DEC
|
3 | 0 | ||||||||||||||||||||||||||
|
BERID
MRP Area
|
BERID |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
UZEIT
Delivery Date Time-Spot
|
LZEIT |
TIMS
|
6 | 0 | ||||||||||||||||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||||||||||||||
|
MEMORY
Purchase Requisition not yet Complete
|
MEMBF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BANPR
Requisition Processing State
|
BANPR |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
RLWRT
Total value at time of release
|
RLWRT |
CURR
|
15 | 2 | ||||||||||||||||||||||||||
|
BLCKD
Purchase Requisition Blocked
|
BLCKD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
REVNO
Version number in Purchasing
|
REVNO |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||
|
BLCKT
Reason for Item Block
|
BLCKT |
CHAR
|
60 | 0 | ||||||||||||||||||||||||||
|
BESWK
Procuring Plant
|
BESWK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||||
|
EPROFILE
External Procurement Profile
|
MEPROFILE |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||
|
EPREFDOC
External Procurement Reference Document
|
EPREFDOC |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
EPREFITM
External Procurement Reference Item
|
EPREFITM |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||
|
GMMNG
PO Quantity of Purchase Requisition in POs on Hold
|
GMMNG |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
WRTKZ
Value-Based Commitment Reduction for Service Purchase Reqs
|
WRTKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
RESLO
Issuing Storage Location for Stock Transport Order
|
RESLO |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
KBLNR
Document Number for Earmarked Funds
|
KBLNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
KBLPOS
Earmarked Funds: Document Item
|
KBLPOS |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||
|
PRIO_URG
Requirement Urgency
|
PRIO_URG | PURG |
NUMC
|
2 | 0 | |||||||||||||||||||||||||
|
PRIO_REQ
Requirement Priority
|
PRIO_REQ | PREQ |
NUMC
|
3 | 0 | |||||||||||||||||||||||||
|
MEMORYTYPE
Category of Incompleteness
|
MEMORYTYPE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
ANZSN
Number of serial numbers
|
ANZSN |
INT4
|
10 | 0 | ||||||||||||||||||||||||||
|
MHDRZ
Minimum Remaining Shelf Life
|
MHDRZ |
DEC
|
4 | 0 | ||||||||||||||||||||||||||
|
IPRKZ
Period Indicator for Shelf Life Expiration Date
|
DATTP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
NODISP
Ind: Reserv. not applicable to MRP;Purc. req. not created
|
NODISP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
SRM_CONTRACT_ID
Central Contract
|
SRM_CONTRACT_ID |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
SRM_CONTRACT_ITM
Central Contract Item Number
|
SRM_CONTRACT_ITEM |
NUMC
|
10 | 0 | ||||||||||||||||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
ADVCODE
Advice Code
|
/ISDFPS/ADVCODE | /ISDFPS/ADVCODE2 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
STACODE
Status Code
|
/ISDFPS/STACODE | /ISDFPS/CSTACODE |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
BANFN_CS
Cross-System PReq Number
|
/ISDFPS/BANFN_CS |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
BNFPO_CS
Cross-System PReq Item
|
/ISDFPS/BNFPO_CS |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||
|
ITEM_CS
Cross-System Item Category
|
/ISDFPS/ITEM_CS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BSMNG_SND
PO Quantity Sender
|
/ISDFPS/BSMNG_SND |
QUAN
|
13 | 3 | ||||||||||||||||||||||||||
|
NO_MARD_DATA
No Storage Location Data Exists for Material
|
/ISDFPS/NO_MARD_DATA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
SERRU
Type of subcontracting
|
SERRU |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
DISUB_SOBKZ
Special stock indicator Subcontracting
|
DISUB_SOBKZ_LB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
DISUB_PSPNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||
|
DISUB_KUNNR
Customer Number
|
KUNNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
DISUB_VBELN
Sales and Distribution Document Number
|
VBELN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
DISUB_POSNR
Item number of the SD document
|
POSNR |
NUMC
|
6 | 0 | ||||||||||||||||||||||||||
|
DISUB_OWNER
Owner of stock
|
OWNER_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
IUID_RELEVANT
IUID-Relevant
|
IUID_RELEVANT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
OITAXFROM
Excise duty tax key for 'from' location
|
OIH_TAXFRO | OIH4 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
OIHANTYP
Excise Duty Handling Type
|
OIH_HANTYP | OIH5 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
OITAXTO
Excise duty tax key for 'to' location
|
OIH_TAXTO | OIH4 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
OITAXGRP
Excise Duty Group
|
OIH_TAXGRP | OIH2 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
OIOILCON
Oil content in a material as a percentage
|
OIH_OILCON |
DEC
|
5 | 2 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
OIINEX
Code for internal or external excise duty rate determination
|
OIH_INEX | OIH16 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||
|
OIPRICIE
ED pricing: external (indicator)
|
OIH_PRICIE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
OIO_SPROC
Supply Process
|
OIO_SPROC |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
OIO_STATUS
Supply chain status
|
OIO_SC_STATUS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
OIO_REF_BANFN
Reference requisition number
|
OIO_REF_BANFN |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||
|
OIO_REF_BNFPO
Reference requisition item
|
OIO_REF_BNFPO |
NUMC
|
5 | 0 | ||||||||||||||||||||||||||
|
OIO_HOLD
Indicator: Hold Delivery Onshore
|
OIO_HOLD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EBAN | ADRN2 | EBAN | ADRN2 |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| EBAN | ADRN2 | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| EBAN | ADRN2 | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| EBAN | ADRN2 | EBAN | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| EBAN | ADRNR | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| EBAN | ADRNR | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| EBAN | ADRNR | EBAN | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| EBAN | ADRNR | EBAN | ADRNR |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| EBAN | ADVCODE | EBAN | MANDT |
/ISDFPS/ADVCODE2
Advice Code with Document Type
|
MANDT |
| EBAN | ADVCODE | EBAN | BSART |
/ISDFPS/ADVCODE2
Advice Code with Document Type
|
BSART |
| EBAN | ADVCODE | EBAN | ADVCODE |
/ISDFPS/ADVCODE2
Advice Code with Document Type
|
ADVCODE |
| EBAN | AKTNR | EBAN | MANDT |
WAKH
Promotion Header Data, IS-R
|
MANDT |
| EBAN | AKTNR | EBAN | AKTNR |
WAKH
Promotion Header Data, IS-R
|
AKTNR |
| EBAN | BESWK | EBAN | MANDT |
T001W
Plants/Branches
|
MANDT |
| EBAN | BESWK | EBAN | BESWK |
T001W
Plants/Branches
|
WERKS |
| EBAN | BMEIN | EBAN | MANDT |
T006
Units of Measurement
|
MANDT |
| EBAN | BMEIN | EBAN | BMEIN |
T006
Units of Measurement
|
MSEHI |
| EBAN | BSART | EBAN | MANDT |
T161
Purchasing Document Types
|
MANDT |
| EBAN | BSART | EBAN | BSTYP |
T161
Purchasing Document Types
|
BSTYP |
| EBAN | BSART | EBAN | BSART |
T161
Purchasing Document Types
|
BSART |
| EBAN | BWTAR | EBAN | MANDT |
T149D
Global Valuation Types
|
MANDT |
| EBAN | BWTAR | EBAN | BWTAR |
T149D
Global Valuation Types
|
BWTAR |
| EBAN | DISPO | EBAN | WERKS |
T024D
MRP controllers
|
WERKS |
| EBAN | DISPO | EBAN | DISPO |
T024D
MRP controllers
|
DISPO |
| EBAN | DISPO | EBAN | MANDT |
T024D
MRP controllers
|
MANDT |
| EBAN | EBELN | EBAN | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| EBAN | EBELN | EBAN | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| EBAN | EBELP | EBAN | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EBAN | EBELP | EBAN | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EBAN | EBELP | EBAN | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| EBAN | EKGRP | EBAN | MANDT |
T024
Purchasing Groups
|
MANDT |
| EBAN | EKGRP | EBAN | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| EBAN | EKORG | EBAN | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| EBAN | EKORG | EBAN | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| EBAN | EMATN | EBAN | MANDT |
MARA
General Material Data
|
MANDT |
| EBAN | EMATN | EBAN | EMATN |
MARA
General Material Data
|
MATNR |
| EBAN | EMLIF | EBAN | EMLIF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EBAN | EMLIF | EBAN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EBAN | FLIEF | EBAN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EBAN | FLIEF | EBAN | FLIEF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EBAN | FRGGR | EBAN | MANDT |
T16FG
Release Groups
|
MANDT |
| EBAN | FRGGR | EBAN | FRGGR |
T16FG
Release Groups
|
FRGGR |
| EBAN | FRGKZ | EBAN | MANDT |
T161S
Release Indicator, Purchase Requisition
|
MANDT |
| EBAN | FRGKZ | EBAN | FRGKZ |
T161S
Release Indicator, Purchase Requisition
|
FRGKZ |
| EBAN | INFNR | EBAN | MANDT |
EINA
Purchasing Info Record: General Data
|
MANDT |
| EBAN | INFNR | EBAN | INFNR |
EINA
Purchasing Info Record: General Data
|
INFNR |
| EBAN | KNTTP | EBAN | KNTTP |
T163K
Account Assignment Categories in Purchasing Document
|
KNTTP |
| EBAN | KNTTP | EBAN | MANDT |
T163K
Account Assignment Categories in Purchasing Document
|
MANDT |
| EBAN | KONNR | EBAN | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| EBAN | KONNR | EBAN | KONNR |
EKKO
Purchasing Document Header
|
EBELN |
| EBAN | KTPNR | EBAN | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EBAN | KTPNR | EBAN | KONNR |
EKPO
Purchasing Document Item
|
EBELN |
| EBAN | KTPNR | EBAN | KTPNR |
EKPO
Purchasing Document Item
|
EBELP |
| EBAN | KUNNR | EBAN | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EBAN | KUNNR | EBAN | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| EBAN | LBLNI | EBAN | MANDT |
ESSR
Service Entry Sheet Header Data
|
MANDT |
| EBAN | LBLNI | EBAN | LBLNI |
ESSR
Service Entry Sheet Header Data
|
LBLNI |
| EBAN | LGORT | EBAN | WERKS |
T001L
Storage Locations
|
WERKS |
| EBAN | LGORT | EBAN | LGORT |
T001L
Storage Locations
|
LGORT |
| EBAN | LGORT | EBAN | MANDT |
T001L
Storage Locations
|
MANDT |
| EBAN | LIFNR | EBAN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EBAN | LIFNR | EBAN | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EBAN | LPEIN | EBAN | MANDT |
TPRG
Date display format
|
MANDT |
| EBAN | LPEIN | SYST | LANGU |
TPRG
Date display format
|
SPRAS |
| EBAN | LPEIN | EBAN | LPEIN |
TPRG
Date display format
|
PRGBZ |
| EBAN | MANDT | EBAN | MANDT |
T000
Clients
|
MANDT |
| EBAN | MATKL | EBAN | MANDT |
T023
Material Groups
|
MANDT |
| EBAN | MATKL | EBAN | MATKL |
T023
Material Groups
|
MATKL |
| EBAN | MATNR | EBAN | MANDT |
MARA
General Material Data
|
MANDT |
| EBAN | MATNR | EBAN | MATNR |
MARA
General Material Data
|
MATNR |
| EBAN | MEINS | EBAN | MANDT |
T006
Units of Measurement
|
MANDT |
| EBAN | MEINS | EBAN | MEINS |
T006
Units of Measurement
|
MSEHI |
| EBAN | MFRNR | EBAN | MFRNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EBAN | MFRNR | EBAN | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EBAN | OIHANTYP | EBAN | MANDT |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
MANDT |
| EBAN | OIHANTYP | EBAN | OIHANTYP |
OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
|
HANTYP |
| EBAN | OIINEX | EBAN | MANDT |
OIH16
Internal/external price conditions
|
MANDT |
| EBAN | OIINEX | EBAN | OIINEX |
OIH16
Internal/external price conditions
|
INEX |
| EBAN | OITAXFROM | EBAN | OITAXFROM |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
TAXKEY |
| EBAN | OITAXFROM | EBAN | MANDT |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
MANDT |
| EBAN | OITAXGRP | EBAN | MANDT |
OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
|
MANDT |
| EBAN | OITAXGRP | EBAN | OITAXGRP |
OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
|
TAXGRP |
| EBAN | OITAXTO | EBAN | MANDT |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
MANDT |
| EBAN | OITAXTO | EBAN | OITAXTO |
OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
|
TAXKEY |
| EBAN | PACKNO | EBAN | MANDT |
ESLH
Service Package Header Data
|
MANDT |
| EBAN | PACKNO | EBAN | PACKNO |
ESLH
Service Package Header Data
|
PACKNO |
| EBAN | PRIO_REQ | EBAN | PRIO_REQ |
PREQ
Requirement Priorities
|
PRIO_REQ |
| EBAN | PRIO_REQ | EBAN | MANDT |
PREQ
Requirement Priorities
|
MANDT |
| EBAN | PRIO_URG | EBAN | MANDT |
PURG
Requirement Urgencies
|
MANDT |
| EBAN | PRIO_URG | EBAN | PRIO_URG |
PURG
Requirement Urgencies
|
PRIO_URG |
| EBAN | PSTYP | EBAN | MANDT |
T163
Item Categories in Purchasing Document
|
MANDT |
| EBAN | PSTYP | EBAN | PSTYP |
T163
Item Categories in Purchasing Document
|
PSTYP |
| EBAN | SOBKZ | EBAN | SOBKZ |
T148
Special Stock Indicator
|
SOBKZ |
| EBAN | SOBKZ | EBAN | MANDT |
T148
Special Stock Indicator
|
MANDT |
| EBAN | SPRAS | EBAN | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| EBAN | STACODE | EBAN | MANDT |
/ISDFPS/CSTACODE
Status Code
|
MANDT |
| EBAN | STACODE | EBAN | STACODE |
/ISDFPS/CSTACODE
Status Code
|
STACODE |
| EBAN | WAERS | EBAN | MANDT |
TCURC
Currency Codes
|
MANDT |
| EBAN | WAERS | EBAN | WAERS |
TCURC
Currency Codes
|
WAERS |
| EBAN | WERKS | EBAN | WERKS |
T001W
Plants/Branches
|
WERKS |
| EBAN | WERKS | EBAN | MANDT |
T001W
Plants/Branches
|
MANDT |