SAP TABLES | Materials Management | Purchasing(MM-PUR) SAP MM

EKPO SAP Purchasing Document Item Table








EKPO is a standard SAP Table which is used to store Purchasing Document Item information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table EKPO and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


Dictionary fields for SAP Table EKPO




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
EBELNEBELNCHAR10 EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5 Item Number of Purchasing Document
.INCLUDEEKPODATA Purchasing Document Item: Data Part
LOEKZELOEKCHAR1 Deletion Indicator in Purchasing Document
STATUASTATCHAR1 RFQ status
AEDATPAEDTDATS8 Purchasing Document Item Change Date
TXZ01TXZ01CHAR40 Short Text
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
EMATNEMATNRCHAR18 MARAMaterial NumberMATN1
BUKRSBUKRSCHAR4 T001Company Code
WERKSEWERKCHAR4 T001WPlant
LGORTLGORT_DCHAR4 T001LStorage Location
BEDNRBEDNRCHAR10 Requirement Tracking Number
MATKLMATKLCHAR9 T023Material Group
INFNRINFNRCHAR10 EINANumber of Purchasing Info RecordALPHA
IDNLFIDNLFCHAR35 Material Number Used by Vendor
KTMNGKTMNGQUAN13(3) Target Quantity
MENGEBSTMGQUAN13(3) Purchase Order Quantity
MEINSBSTMEUNIT3 T006Purchase Order Unit of MeasureCUNIT
BPRMEBBPRMUNIT3 T006Order Price Unit (Purchasing)CUNIT
BPUMZBPUMZDEC5 Numerator for Conversion of Order Price Unit into Order Unit
BPUMNBPUMNDEC5 Denominator for Conv. of Order Price Unit into Order Unit
UMREZUMBSZDEC5 Numerator for Conversion of Order Unit to Base Unit
UMRENUMBSNDEC5 Denominator for Conversion of Order Unit to Base Unit
NETPRBPREICURR11(2) Net Price in Purchasing Document (in Document Currency)
PEINHEPEINDEC5 Price Unit
NETWRBWERTCURR13(2) Net Order Value in PO Currency
BRTWRBBWERTCURR13(2) Gross order value in PO currency
AGDATANGABDATS8 Deadline for Submission of Bid/Quotation
WEBAZWEBAZDEC3 Goods Receipt Processing Time in Days
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
BONUSEBONUCHAR2 Settlement Group 1 (Purchasing)
INSMKINSMKCHAR1 Stock Type
SPINFSPINFCHAR1 Indicator: Update Info Record
PRSDRPRSDRCHAR1 Price Printout
SCHPRSCHPRCHAR1 Indicator: Estimated Price
MAHNZMAHNZDEC3 Number of Reminders/Expediters
MAHN1MAHN1DEC3 Number of Days for First Reminder/Expediter
MAHN2MAHN2DEC3 Number of Days for Second Reminder/Expediter

MAHN3MAHN3DEC3 Number of Days for Third Reminder/Expediter
UEBTOUEBTODEC3(1) Overdelivery Tolerance Limit
UEBTKUEBTKCHAR1 Indicator: Unlimited Overdelivery Allowed
UNTTOUNTTODEC3(1) Underdelivery Tolerance Limit
BWTARBWTAR_DCHAR10 T149DValuation Type
BWTTYBWTTY_DCHAR1 T149CValuation Category
ABSKZABSKZCHAR1 Rejection Indicator
AGMEMAGMEMCHAR3 TMAMInternal Comment on Quotation
ELIKZELIKZCHAR1 "Delivery Completed" Indicator
EREKZEREKZCHAR1 Final Invoice Indicator
PSTYPPSTYPCHAR1 T163Item Category in Purchasing Document
KNTTPKNTTPCHAR1 T163KAccount Assignment Category
KZVBRKZVBRCHAR1 Consumption Posting
VRTKZVRTKZCHAR1 Distribution indicator for multiple account assignment
TWRKZTWRKZCHAR1 Partial Invoice Indicator
WEPOSWEPOSCHAR1 Goods Receipt Indicator
WEUNBWEUNBCHAR1 Goods Receipt, Non-Valuated
REPOSREPOSCHAR1 Invoice Receipt Indicator
WEBREWEBRECHAR1 Indicator: GR-Based Invoice Verification
KZABSKZABSCHAR1 Order Acknowledgment Requirement
LABNRLABNRCHAR20 Order Acknowledgment Number
KONNRKONNRCHAR10 EKKONumber of Principal Purchase AgreementALPHA
KTPNRKTPNRNUMC5 EKPOItem Number of Principal Purchase Agreement
ABDATABDATDATS8 Reconciliation Date for Agreed Cumulative Quantity
ABFTZABFTZQUAN13(3) Agreed Cumulative Quantity
ETFZ1ETFZ1DEC3 Firm Zone (Go-Ahead for Production)
ETFZ2ETFZ2DEC3 Trade-Off Zone (Go-Ahead for Materials Procurement)
KZSTUMRPRECHAR1 Firm/Trade-Off Zones Binding with Regard to Mat. Planning
NOTKZNOTKZCHAR1 Exclusion in Outline Agreement Item with Material Class
LMEINLAGMEUNIT3 T006Base Unit of MeasureCUNIT
EVERSEVERSCHAR2 T027AShipping Instructions
ZWERTDZWERTCURR13(2) Target Value for Outline Agreement in Document Currency
NAVNWNAVNWCURR13(2) Non-deductible input tax
ABMNGNORAMQUAN13(3) Standard release order quantity
PRDATPREDTDATS8 Date of Price Determination
BSTYPBSTYPCHAR1 Purchasing Document Category
EFFWREFFWRCURR13(2) Effective value of item
XOBLRXOBLRCHAR1 Item affects commitments
KUNNREKUNNRCHAR10 KNA1CustomerALPHA
ADRNRADRNR_MMCHAR10 ADRCManual address number in purchasing document itemALPHA

EKKOLEKKOGCHAR4 Condition Group with Vendor
SKTOFESKTOFCHAR1 Item Does Not Qualify for Cash Discount
STAFOSTAFOCHAR6
*
Update group for statistics updateALPHA
PLIFZEPLIFDEC3 Planned Delivery Time in Days
NTGEWENTGEQUAN13(3) Net Weight
GEWEIEGEWEUNIT3 T006Unit of WeightCUNIT
TXJCDTXJCDCHAR15 TTXJTax Jurisdiction
ETDRKETDRKCHAR1 Indicator: Print-relevant schedule lines exist
SOBKZSOBKZCHAR1 T148Special Stock Indicator
ARSNRARSNRNUMC10 Settlement reservation number
ARSPSARSPSNUMC4 Item number of the settlement reservation
INSNCINSNCCHAR1 Quality inspection indicator cannot be changed
SSQSSQSSPURCHAR8 TQ08Control Key for Quality Management in Procurement
ZGTYPQZGTYPCHAR4 TQ05Certificate Type
EAN11EAN11CHAR18 International Article Number (EAN/UPC)EAN11
BSTAEBSTAECHAR4 T163LConfirmation Control Key
REVLVREVLVCHAR2 Revision LevelNUMCV
GEBERBP_GEBERCHAR10
*
Fund
FISTLFISTLCHAR16
*
Funds Center
FIPOSFIPOSCHAR14 FMFPOCommitment ItemFMCIS
KO_GSBERGSBER_GPCHAR4
*
Business area reported to the partner
KO_PARGBPARGB_GPCHAR4
*
assumed business area of the business partner
KO_PRCTRPRCTRCHAR10 CEPCProfit CenterALPHA
KO_PPRCTRPPRCTRCHAR10 CEPCPartner Profit CenterALPHA
MEPRFMEPRFCHAR1 Price Determination (Pricing) Date Control
BRGEWBRGEWQUAN13(3) Gross Weight
VOLUMVOLUMQUAN13(3) Volume
VOLEHVOLEHUNIT3 T006Volume unitCUNIT
INCO1INCO1CHAR3 TINCIncoterms (Part 1)
INCO2INCO2CHAR28 Incoterms (Part 2)
VORABVORABCHAR1 Advance procurement: project stock
KOLIFKOLIFCHAR10 LFA1Prior VendorALPHA
LTSNRLTSNRCHAR6 WYT1Vendor Subrange
PACKNOPACKNONUMC10 ESLHPackage number
FPLNRIPLNRCHAR10 Invoicing plan number
GNETWRGNETWRCURR13(2) Currently not used
STAPOSTAPOCHAR1 Item is statistical
UEBPOUEBPONUMC5 EKPOHigher-Level Item in Purchasing Documents
LEWEDLEWEDDATS8 Latest Possible Goods Receipt
EMLIFEMLIFCHAR10 LFA1Vendor to be supplied/who is to receive deliveryALPHA
LBLKZLBLKZCHAR1 Subcontracting vendor
SATNRSATNRCHAR18 MARACross-Plant Configurable MaterialMATN1
ATTYPATTYPCHAR2 Material Category
VSARTVERSARTCHAR2
*
Shipping type
HANDOVERLOCHANDOVER_LOCCHAR10 Location for a physical handover of goodsALPHA
KANBAKBNKZCHAR1 Kanban Indicator
ADRN2ADRN2CHAR10 ADRCNumber of delivery addressALPHA
CUOBJCUOBJNUMC18 Configuration (internal object number)
XERSYXERSYCHAR1 Evaluated Receipt Settlement (ERS)
EILDTEILDTDATS8 Start Date for GR-Based Settlement
DRDATDRDATDATS8 Last Transmission
DRUHRDRUHRTIMS6 Time
DRUNRDRUNRNUMC4 Sequential Number
AKTNRWAKTIONCHAR10 WAKHPromotionALPHA
ABELNABELNCHAR10 AUKOAllocation Table NumberALPHA
ABELPABELPNUMC5
*
Item number of allocation table
ANZPUANZPUQUAN13(3) Number of Points
PUNEIPUNEIUNIT3 T006Points unitCUNIT
SAISOSAISOCHAR4 T6WSPSeason Category
SAISJSAISJCHAR4 Season YearGJAHR
EBON2EBON2CHAR2 Settlement Group 2 (Rebate Settlement, Purchasing)
EBON3EBON3CHAR2 Settlement Group 3 (Rebate Settlement, Purchasing)
EBONFEBONYCHAR1 Item Relevant to Subsequent (Period-End Rebate) Settlement
MLMAACK_ML_MAACCHAR1 Material ledger activated at material level
MHDRZMHDRZDEC4 Minimum Remaining Shelf Life
ANFNRANFNRCHAR10 EKKORFQ NumberALPHA
ANFPSANFPSNUMC5 EKPOItem Number of RFQ
KZKFGKZCUHCHAR1 Origin of Configuration
USEQUUSEQUCHAR1 TMQ2Quota arrangement usage
UMSOKUMSOKCHAR1
*
Special Stock Indicator for Physical Stock Transfer
BANFNBANFNCHAR10 Purchase Requisition NumberALPHA
BNFPOBNFPONUMC5 EBANItem Number of Purchase Requisition
MTARTMTARTCHAR4 T134Material Type
UPTYPUPTYPCHAR1 TMSI1Subitem Category, Purchasing Document
UPVORUPVORCHAR1 Subitems Exist
KZWI1KZWI1CURR13(2) Subtotal 1 from pricing procedure for condition
KZWI2KZWI2CURR13(2) Subtotal 2 from pricing procedure for condition
KZWI3KZWI3CURR13(2) Subtotal 3 from pricing procedure for condition
KZWI4KZWI4CURR13(2) Subtotal 4 from pricing procedure for condition
KZWI5KZWI5CURR13(2) Subtotal 5 from pricing procedure for condition
KZWI6KZWI6CURR13(2) Subtotal 6 from pricing procedure for condition
SIKGRSIKGRCHAR3 TMSI2Processing key for sub-items
MFZHIMFZHIQUAN15(3) Maximum Cumulative Material Go-Ahead Quantity
FFZHIFFZHIQUAN15(3) Maximum Cumulative Production Go-Ahead Quantity
RETPORETPOCHAR1 Returns Item
AURELAURELCHAR1 Relevant to Allocation Table
BSGRUBSGRUCHAR3 TBSGReason for Ordering
LFRETLFRETCHAR4 TVLKDelivery Type for Returns to Vendors
MFRGRMFRGRCHAR8 TMFGMaterial freight group
NRFHGNRFHGCHAR1 Material qualifies for discount in kind
J_1BNBMJ_1BNBMCO1CHAR16 T604FBrazilian NCM Code
J_1BMATUSEJ_1BMATUSECHAR1 Usage of the material
J_1BMATORGJ_1BMATORGCHAR1 Origin of the material
J_1BOWNPROJ_1BOWNPROCHAR1 Produced in-house
J_1BINDUSTJ_1BINDUS3CHAR2 Material CFOP categoryALPHA
ABUEBABUEBCHAR4 T163PRelease Creation Profile
NLABDNLABDDATS8 Next Forecast Delivery Schedule Transmission
NFABDNFABDDATS8 Next JIT Delivery Schedule Transmission
KZBWSKZBWSCHAR1 Valuation of Special Stock
BONBABONBACURR13(2) Rebate basis 1
FABKZFABKZCHAR1 Indicator: Item Relevant to JIT Delivery Schedules
J_1AINDXPJ_1AINDXPCHAR5 J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATEPDATS8 Inflation Index Date
MPROFMPROFCHAR4
*
Manufacturer Part Profile
EGLKZEGLKZCHAR1 "Outward Delivery Completed" Indicator
KZTLFKZTULCHAR1 Partial Delivery at Item Level (Stock Transfer)
KZFMEKZWSOCHAR1 Units of measure usage
RDPRFRDPRFCHAR4 RDPRRounding Profile
TECHSTECHSCHAR12 Parameter Variant/Standard Variant
CHG_SRVCHG_SRVCHAR1 Configuration changed
CHG_FPLNRCHG_FPLNRCHAR1 No invoice for this item although not free of charge
MFRPNMFRPNCHAR40 Manufacturer Part Number
MFRNRMFRNRCHAR10 LFA1Number of a ManufacturerALPHA
EMNFREMNFRCHAR10 External manufacturer code name or number
NOVETNOVETCHAR1 Item blocked for SD delivery
AFNAMAFNAMCHAR12 Name of Requisitioner/Requester
TZONRCTSEGZONRECCHAR6
*
Time zone of recipient location
IPRKZDATTPCHAR1 Period Indicator for Shelf Life Expiration DatePERKZ
LEBRELEBRECHAR1 Indicator for Service-Based Invoice Verification
BERIDBERIDCHAR10 MDLVMRP Area
XCONDITIONSXCONDITIONSCHAR1 Conditions for item although no invoice
APOMSAPOMSCHAR1 APO as Planning System
CCOMPMMPUR_CCOMPCHAR1 Posting Logic in the Case of Stock Transfers
GRANT_NBRGM_GRANT_NBRCHAR20 GrantALPHA
FKBERFKBERCHAR16
*
Functional Area
STATUSEPSTATUCHAR1 Status of Purchasing Document Item
RESLORESLOCHAR4 T001LIssuing Storage Location for Stock Transport Order
KBLNRKBLNRCHAR10
*
Document Number for Earmarked FundsALPHA
KBLPOSKBLPOSNUMC3
*
Earmarked Funds: Document Item
WEORAWEORACHAR1 Acceptance At Origin
SRV_BAS_COMSRV_BAS_COMCHAR1 Service-Based Commitment
PRIO_URGPRIO_URGNUMC2 PURGRequirement Urgency
PRIO_REQPRIO_REQNUMC3 PREQRequirement Priority
EMPSTEMPSTCHAR25 Receiving point
DIFF_INVOICEDIFF_INVOICECHAR2 Differential Invoicing
TRMRISK_RELEVANTPUR_TRM_RISK_RELEVANCYCHAR2 Risk Relevancy in Purchasing
SPE_ABGRUABGRUCHAR2 Reason for rejection of quotations and sales orders
SPE_CRM_SO/SPE/VBELN_CRMCHAR10 CRM Sales Order Number for TPOP ProcessALPHA
SPE_CRM_SO_ITEM/SPE/POSNR_CRMNUMC6 CRM Sales Order Item Number in TPOP Process
SPE_CRM_REF_SO/SPE/REF_VBELN_CRMCHAR35 CRM Reference Order Number for TPOP ProcessALPHA
SPE_CRM_REF_ITEM/SPE/REF_POSNR_CRMCHAR6 CRM Reference Sales Order Item Number in TPOP Process
SPE_CRM_FKREL/SPE/FKREL_CRMCHAR1 Billing Relevance CRM
SPE_CHNG_SYS/SPE/INB_CHNG_SYSCHAR1 Last Changer's System Type
SPE_INSMK_SRC/SPE/INSMK_SRCCHAR1 Stock Type of Source Storage Location in STO
SPE_CQ_CTRLTYPE/SPE/CQ_CONTROL_TYPECHAR1 CQ Control Type
SPE_CQ_NOCQ/SPE/CQ_NOCQCHAR1 No Transmission of Cumulative Quantities in SA Release
REASON_CODE/SAPPSPRO/_GR_REASON_CODECHAR4 Goods Receipt Reason Code
CQU_SARCQU_SARQUAN15(3) Cumulative Goods Receipts from Redirected Purchase Orders
ANZSNANZSNINT410 Number of serial numbers
SPE_EWM_DTC/SPE/EWM_DTCCHAR1 EWM Delivery Based Tolerance Check
.INCLUDEEKPO_SRM_DATA SRM Fields in Purchase Order Item
EXLINEXLINCHAR40 Item Number Length
EXSNREXSNRNUMC5 External Sorting
EHTYPEHTYPCHAR4 TMSRM_EHTYPExternal Hierarchy Category
RETPCRETPZDEC5(2) Retention in Percent
DPTYPME_DPTYPCHAR4 Down Payment Indicator
DPPCTME_DPPCNTDEC5(2) Down Payment Percentage
DPAMTME_DPAMNTCURR11(2) Down Payment Amount in Document Currency
DPDATME_DPDDATDATS8 Due Date for Down Payment
FLS_RSTOFLS_RSTOCHAR1 Store Return with Inbound and Outbound Delivery
EXT_RFX_NUMBERME_PUR_EXT_DOC_IDCHAR35 Document Number of External Document
EXT_RFX_ITEMME_PUR_EXT_DOC_ITEM_IDCHAR10 Item Number of External Document
EXT_RFX_SYSTEMLOGSYSTEMCHAR10
*
Logical SystemALPHA
SRM_CONTRACT_IDSRM_CONTRACT_IDCHAR10 Central ContractALPHA
SRM_CONTRACT_ITMSRM_CONTRACT_ITEMNUMC10 Central Contract Item Number
BLK_REASON_IDBLK_REASON_IDCHAR4 Blocking Reason - ID
BLK_REASON_TXTBLK_REASON_TXTCHAR40 Blocking Reason - Text
ITCONSME_IR_CO_ORDERCHAR1 Real-Time Consumption Posting of Subcontracting Components
FIXMGME_FIXMGCHAR1 Delivery Date and Quantity Fixed
WABWEWABWECHAR1 Indicator for GI-based goods receipt
.INCLUDEJ_1BMM_TC_DET MM Tax Code determination
TC_AUT_DETJ_1BTC_AUT_DETCHAR2
*
Tax Code Automatically Determined
MANUAL_TC_REASONJ_1BMANUAL_TC_REASONCHAR2
*
Manual Tax Code Reason
FISCAL_INCENTIVEJ_1BFISCAL_INCENTIVE_CODECHAR4
*
Tax Incentive Type
TAX_SUBJECT_STJ_1BTC_TAX_SUBJECT_STCHAR1 Tax Subject to Substituição Tributária
FISCAL_INCENTIVE_IDJ_1BFISCAL_INCENTIVE_IDCHAR4
*
Incentive ID
/BEV1/NEGEN_ITEM/BEV1/NEGEN_ITEM_FLAGCHAR1 Indicator: Item Is Generated
/BEV1/NEDEPFREE/BEV1/NEDEPFREECHAR1 Indicator: Dependent Items Are Free of Charge
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR1 Structure Category for Material Relationship
ADVCODE/ISDFPS/ADVCODECHAR2
*
Advice Code
.APPENDEHP4_EKPODATA_BUDGET_PD Budget Period
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
.APPENDFMFG_EKPODATA Add on for Public Sector
EXCPEEXCPENUMC2 Acceptance Period
.APPENDIUID_EKPODATA IUID Append
IUID_RELEVANTIUID_RELEVANTCHAR1 IUID-Relevant
.APPENDJ_1IR_EKPO_APPEND Addition of Fields to EKPODAT -Retail Localization for India
.INCLUDEJ_1IR_MRPIND_ST Additional Filed for Retail Localization for India
MRPINDJ_1IRMRPINDCHAR1 Max. Retail Price Relevant
.APPENDOILEKPODATA Oil APPEND
.INCLUDEOIC_PIPE Origin, Destination, Trip and ex Batch No for Pipeline
OIPIPEVALOID_PIPEVCHAR1 Validation indicator for pipeline fields (X=ON, blank=OFF)
OIC_LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
.INCLUDEOIC_DEST_ORIG Destination/Origin: City,County,Region,Country + Tax
OIC_DCITYCOIC_DCITYCCHAR4 T005GDestination city code
OIC_DCOUNCOIC_DCOUNCCHAR3 T005EDestination county code
OIC_DREGIOOIC_DREGIOCHAR3 T005SDestination region
OIC_DLAND1OIC_DLAND1CHAR3 T005Destination country
OIC_OCITYCOIC_OCITYCCHAR4 T005GOrigin city code
OIC_OCOUNCOIC_OCOUNCCHAR3 T005EOrigin county code
OIC_OREGIOOIC_OREGIOCHAR3 T005SOrigin region
OIC_OLAND1OIC_OLAND1CHAR3 T005Origin country
OIC_PORGINOIC_PORGINCHAR15 Tax origin
OIC_PDESTNOIC_PDESTNCHAR15 Tax destination
OIC_PTRIPOIC_PTRIPCHAR16 Pipeline trip number (external)
OIC_PBATCHOIC_PBATCHCHAR16 Pipeline operator´s external batch number
OIC_MOTOIC_MOTCHAR2 TVTRIS-OIL MAP external details mode of transport
OIC_AORGINOIC_AORGINCHAR15 Alternate origin
OIC_ADESTNOIC_ADESTNCHAR15 Alternate destination
OIC_TRUCKNOIC_TRUCKNCHAR10 Truck number
OIA_BASELOOIA_BASELOCHAR15 Base location
OITAXFROMOIH_TAXFROCHAR2 OIH4Excise duty tax key for 'from' location
OIHANTYPOIH_HANTYPCHAR2 OIH5Excise Duty Handling Type
OIPRICIEOIH_PRICIECHAR1 ED pricing: external (indicator)
OITAXTOOIH_TAXTOCHAR2 OIH4Excise duty tax key for 'to' location
OITAXCONOIH_TAXCONCURR13(2) Excise duty tax from pricing conditions
OITAXGRPOIH_TAXGRPCHAR2 OIH2Excise Duty Group
OIOILCONOIH_OILCONDEC5(2) Oil content in a material as a percentage
OIINEXOIH_INEXCHAR2 OIH16Code for internal or external excise duty rate determination
.INCLUDEOIA_INCDAT Exchanges structure to be included in Core tables
OIEXGNUMOIA_EXGNUMCHAR10 Exchange agreement numberALPHA
OIEXGTYPOIA_EXGTYPCHAR4 TOIA2Exchange type
OIFEETOTOIA_FEETOTCURR13(2) Fee total
OIFEEDTOIA_FEEDTDATS8 Fee pricing condition date
OINETCYCOIA_NETCYCCHAR1 T008Netting cycle (FI blocking indicator)
OIFERPOIA_FERPCHAR1 Fee repricing indicator
OIFEECHOIA_FEECHCHAR1 Fee edit control
OIA_IPMVATOIA_IPMVATCHAR1 VAT on internally-posted material
OIA_SPLTIVOIA_SPLTIVCHAR1 Indicator for split invoice verification
OIVATHDMBTRCURR13(2) Amount in Local Currency
OIVATFWRBTRCURR13(2) Amount in document currency
OISBRELOIA_SBRELNUMC3 Sub product/ base product relevence indicator
OIBASPRODOIA_SBMATCHAR18
*
Base product numberMATN1
.INCLUDEOIHBEFU TRACKING FIELDS FOR 2 STEP TRANSFERS
OITRKNROIH_TRKNRCHAR10 Tracking numberALPHA
OITRKJROIH_TRKJRNUMC4 Tracking number year
OIEXTNROIH_EXTNRCHAR18 External tracking number
OIITMNROIH_ITMNRNUMC5 Tracking number item line
OIFTINDOIH_FTINDCHAR1 Final transfer indicator
OIPRIOPOIH_PRIOPCHAR1 Price options for gain calculation
OITRINDOIH_TRINDCHAR1 Transfer sign for plant-to-plant transfers
OIGHNDLOIH_GHNDLCHAR1 Gain handling
OIUMBAROIH_UMBARCHAR10 T149DValuation type of issuing location for two-step transfer
OITXCON1OIH_TXCON1CURR13(2) Excise duty tax from pricing conditions: rate 1
OITXCON2OIH_TXCON2CURR13(2) Excise duty tax from pricing conditions: rate 2
OITXCON3OIH_TXCON3CURR13(2) Excise duty tax from pricing conditions: rate 3
OITXCON4OIH_TXCON4CURR13(2) Excise duty tax from pricing conditions: rate 4
OITXCON5OIH_TXCON5CURR13(2) Excise duty tax from pricing conditions: rate 5
OITXCON6OIH_TXCON6CURR13(2) Excise duty tax from pricing conditions: rate 6
.INCLUDEOID_EX External Bill of Lading and Misc. Deliv. No
OID_EXTBOLOID_EXTBOLCHAR16 External bill of lading
OID_MISCDLOID_MISCDLCHAR16 Miscellaneous delivery number
OIMATCYCOIA_MATCYCNUMC1
*
Invoicing cycle for purchase material costs
OIEDOKOIH_EDOKCHAR1 Excise duty validation indicator
OIEDBALOIH_EDBALCHAR1 Excise duty balancing is required (indicator)
OIEDBALMOIH_EDBALMCHAR1 Excise duty balancing method indicator
.INCLUDEOIHLIC License fields for transfers
OICERTF1OIH_CERTF1CHAR15 Excise tax external license number
OIDATFM1OIH_DATFM1DATS8 Excise Duty License Valid from Date
OIDATTO1OIH_DATTO1DATS8 Valid to date for excise duty tax certificate
OIH_LICTPOIH_LICTPCHAR4 OIH20License type
OIH_LICINOIH_LICINCHAR10 OIHLExcise tax internal license numberALPHA
OIH_LCFOLOIH_LCFOLCHAR10 OIHLFollow-on license for quantity licenseALPHA
OIH_FOLQTYOIH_FOLQTYQUAN13(3) Excise Tax Follow-On License Quantity
OIEDOK_GIOIH_EDOK_GICHAR1 Excise Duty Validation Indicator for Material (STO)
OIEDBAL_GIOIH_EDBAL_GICHAR1 Excise Duty Balancing is Required for Mat. (STO)
OIEDBALM_GIOIH_EDBALM_GICHAR1 Excise Duty Balancing Method Indicator for Mat. (STO)
OIHANTYP_GIOIH_HANTYP_GICHAR2
*
Excise Duty Handling Type - Denotes Use of Material
OIINEX_GIOIH_INEX_GICHAR2
*
Code for Internal or External Excise Duty Rate Determination
OITAXGRP_GIOIH_TAXGRPCHAR2
*
Excise Duty Group
.INCLUDEOIHLIC_GI License fields for transfers to material (STO)
OICERTF1_GIOIH_CERTF1_GICHAR15 Excise Tax External License Number Used During GI (STO)
OIDATFM1_GIOIH_DATFM1_GIDATS8 Excise Duty License Valid from Date for Mat. (STO)
OIDATTO1_GIOIH_DATTO1_GIDATS8 Valid To Date for Excise Duty Tax Certificate for Mat. (STO)
OIH_LICTP_GIOIH_LICTP_GICHAR4 OIH20License Type to Material (STO)
OIH_LICIN_GIOIH_LICIN_GICHAR10 OIHLExcise Tax Internal License Number to Mat. (STO)ALPHA
OIH_LCFOL_GIOIH_LCFOL_GICHAR10 OIHLFollow-On License for Quantity License to Mat. (STO)ALPHA
OIH_FOLQTY_GIOIH_FOLQTY_GIQUAN13(3) Excise Tax Follow-On License Quantity to Mat. (STO)
ZPINNONUMC10
REFSITEWREFSITECHAR4 Reference Site For Purchasing
/SAPMP/GPOSE/SAPMP/GPOSENUMC5 Global Item Number in Purchasing Document
.APPENDADEKPO Structure for Additional Fields in SPEC 2000 Items
ANGPNANGPNNUMC6
*
Quotation Item Number (SD)
ADMOIADMOICHAR4 CSPCMOIModel ID code
ADPRIADPRICHAR3 CSPCPRIOrder priority
LPRIOLPRIONUMC2 TPRIODelivery Priority
ADACNADACNCHAR5 Aircraft registration number
AFPNRPOSNR_VANUMC6
*
Sales Document Item
BSARKBSARLCHAR4
*
Vendor confirmation type
AUDATAUDATDATS8 Document Date (Date Received/Sent)
ANGNRADSPC_ANGNRCHAR20 Quotation number
PNSTATADSPC_PNSTATCHAR1 Flag for the S1PNSTAT message
.APPENDDISUB_EKPO_DATA DI A&D SUB Enhancement of EKPO
SERRUSERRUCHAR1 Type of subcontracting
SERNPSERAILCHAR4
*
Serial Number Profile
DISUB_SOBKZDISUB_SOBKZ_LBCHAR1 Special stock indicator Subcontracting
DISUB_PSPNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP
DISUB_KUNNRKUNNRCHAR10 Customer NumberALPHA
DISUB_VBELNVBELNCHAR10
*
Sales and Distribution Document NumberALPHA
DISUB_POSNRPOSNRNUMC6
*
Item number of the SD document
DISUB_OWNEROWNER_DCHAR10
*
Owner of stockALPHA
.APPENDISAUTOLAB IS AUTOMOTIVE Enhancements in EKPO
STPACSTPACCHAR1 Activate Static Stopping of Releases
LGBZOUNLPTCHAR10
*
(Automotive) Unloading Point
LGBZO_BUNLPTCHAR10
*
(Automotive) Unloading Point
ADDRNUMAD_ADDRNUMCHAR10
*
Address numberALPHA
CONSNUMAD_CONSNUMNUMC3 Sequence Number
BORGR_MISSBORGR_MISSCHAR1 Indicator: Action at Registration
.APPENDWRF_PBAS_EKPO_ADDON_STY EKPO Enhancement Seasonal Procurement: Procurement
.INCLUDEWRF_PSCD_EKPO_ADDON_STY Enhancement of Purchasing Document Item
REF_ITEMWRF_PSCD_REF_ITEMNUMC5 Reference Item for Remaining Qty Cancellation
.INCLUDEWRF_POHF_EKPO_ADDON_STY EKPO Enhancement: PO Handling
.INCLUDEWRF_POHF_SOURCE_KEY_STY Source System and Source Key of Record
SOURCE_IDWRF_POHF_SOURCE_IDCHAR3 WRFT_POHF_SOURCEOrigin Profile
SOURCE_KEYWRF_POHF_SOURCE_KEYCHAR32 Key in Source System
PUT_BACKWRF_POHF_PUT_BACK_POGCHAR1 Indicator for Putting Back from Grouped PO Document
POL_IDWRF_POHF_POL_IDCHAR10 Order List Item NumberALPHA
.INCLUDEWRF_CONSIGNMENT Seasonal Procurement: Include for Consignment Processing
CONS_ORDERWRF_CONS_ORDERCHAR1 Purchase Order for Consignment


Key field
Non-key field


RELATIONS BETWEEN EKPO AND OTHER TABLES


BKPF-Accounting Document Header
     BSET-Tax Data Document Segment
     BSEG-Accounting Document Segment
          BSEC-One-Time Account Data Document Segment
          EKKO-Purchasing Document Header
               EKPO-Purchasing Document Item
                    EKBE-Purchasing Document History


EKDY-Dummy Table for Database EBM
     EKKO-Purchasing Document Header
          EKPO-Purchasing Document Item
               EKET-Scheduling Agreement Schedule Lines
               MARA-General Material Data
               EKKN-Account Assignment in Purchasing Document
               EKBE-History per Purchasing Document
     EBAN-Purchase Requisition
          EBKN-Purchase Requisition Account Assignment


EKKO-Purchasing Document Header
     EKPO-Purchasing Document Item
          EKBE-History per Purchasing Document
          EKBZ-History per Purchasing Document: Delivery Costs
          EKAB-Release (Order) Documentation
     EKKN-Account Assignment in Purchasing Document
     EKET-Scheduling Agreement Schedule Lines
     ESSR-Service Entry Sheet Header Data
     ESKN-Account Assignment in Service Package
     A019-Contract Header
     A016-Contract Item
     A068-Outline Agreement Item: Plant-Dependent
     KONM-Conditions (1-Dimensional Quantity Scale)
     KONW-Conditions (1-Dimensional Value Scale)
     KONP-Conditions (Item)
     KONH-Conditions (Header)
     KONV-Conditions (Transaction Data)
     STXH-STXD SAPscript Text File Header
          STXL-STXD SAPscript Text File Lines
     CDHDR-Change Document Header
          CDPOS-Change Document Items
     EIKP-Foreign Trade: Export/Import: Header Data
          EIPO-Foreign Trade: Export/Import: Item Data
     NAST-Message Status
     EKUB-Index for Stock Transport Orders for Material
     EKPV-SD-Specific Data f. Stock Transfer for Purch. Doc.
     RESB-Reservation/Dependent Requirements
     EKES-Vendor Confirmations
     EKPA-Partner Roles in Purchasing
     EKBEH-Order History, Scheduling Agreement (Reorganized)
     EKBZH-Delivery Costs History, Sched. Agreement (Reorg)
     EKETH-Scheduling Agreement Schedule Lines (Reorganized)
     EKEK-Scheduling Agreement Release History, Header
     EKEH-Scheduling Agreement Release History, Sched. Lines


EKKO-Purchasing Document Header
     EKPO-Purchasing Document Item
          EKKN-Account Assignment in Purchasing Document
          EKES-Vendor Confirmations
          EKAB-Release Documentation
          EKBZ-History per Purchasing Document: Delivery Costs
          EKBE-History per Purchasing Document
          EKEK-Header Data for Scheduling Agreement Releases
               EKEH-Scheduling Agreement Release Documentation
          EKET-Scheduling Agreement Schedule Lines
          T160T-Description of Selection Parameters
          RESB-Reservation/Dependent Requirements
          PRPS-PSP (Project Structure Plan) Element Master Data


ARKOPF-Archiving run header data
     VSKOPF-Version: Header - general data for a
          RSTHIE-BRST structure of the hierarchy table
               PSDYRH-LDB PSJ: Dummy structure under RSTHIE
          PROJ-Project definition
               PSDYPD-LDB PSJ: Dummy structure under PROJ
          VBAK-Sales Document: Header Data
               VBUK-Sales Doc.: Header Status and Administrative Data
               VBKD-Sales Document: Business Data
               VBAP-Sales Document: Item Data
                    VBUP-Sales Document: Item Status
                    VBKDPO-Sales document: Business item data (POSNR > 0)
                         FPLA-Billing plan
                              FPLT-Billing Plan: Dates
                    PSDYVB-LDB PSJ: Dummy structure under VBAP
               PSDYVK-LDB PSJ: Dummy structure under VBAK
          PRPS_R-Project Hierarchy Reporting Structure
               PRTE-Scheduling Data for Project Item
               PSMLST-Milestone I/O Table
               PSTX-PS Texts (Header)
               PLAF-Planned order
               PSMERK_PRPS-Characteristics for Summarization for WBS Elements
                    KBED04-Capacity Requirement Recs for Planned Orders (LDB)
                    RESB04-Reservation/dependent reqs for plan order (LDB)
               PSDYPR-LDB PSJ: Dummy structure under PRPS_R
          AUFK-Order master data
               AFKO-Order Header Data PP Orders
                    AFPO-Order Item
                    AFFL-Work order sequence
                         ACT01-Activity for LDB 01
                              AFAB01-Network Relationship (for LDB) - 01
                              MLSTD-Milestone I/O Table
                              PSTX1-PS Texts (Header) for Activity (1)
                              AFFH01-Order PRT Data (for LDB) - 01
                              KBED01-Capacity Requirement Records (for LDB) - 01
                                   KBEZ-Additional data for table KBED (for ind.req/split)
                                        KPER-Additional data for KBEZ (person split in days)
                                   AFRU02-Order Confirmations (for LDB) -02
                              RESB01-Reservation/Dependent Requirement for LDB-01
                                   PSDYOK-LDB PSJ: Dummy structure under RESB01
                              AFRU01-Order Confirmations (for LDB) - 01
                              PSMERK_ACT-Charactersitics for Summarization for Activity
                              PSDYNV-LDB PSJ: Dummy structure under ACT01
               AFIH-Maintenance order header
               PSDYNP-LDB PSJ: Dummy structure under AUFK
          IMTP-Investment programs
               IMPR-Investment Program Positions
                    PSDYIP-LDB PSJ: Dummy structure under IMPR
               PSDYPG-LDB PSJ: Dummy structure under IMTP
          PEGOB-Peg (master data of the CO object)
               PEGQTY-Assigned pegging object quantities
               PSDYPEG-LDB PSJ: Dummy Structure Under PEGOB
          ELM_PS-Additional data for hierarchy nodes (LDB PSJ)
               JSTO-Status object information
                    PSTAT-Condensed status display
                    JCDO-Change Documents for Status Object (Table JSTO)
                    JEST-Individual Status per Object
                         JCDS-Change docs. for system/user status (table JEST)
               ONR00-General Object Number
                    RPSCO1-Summarization Table for Project Reporting
                    RPSQT-Summarization table for project reporting (quants)
                    EV_PARAM-Object parameters for earned value analysis
                    EV_POC-Earned value analysis: percentage of completion
                    EV_VAL-Earned value analysis: earned value
                    COBRA-Settlement Rule for Order Settlement
                         COBRB-Distribution rules for sett. rule for order sett.
                    BPHI1-Cross-hierarchy data Control
                    BPTR1-Object Data Control
                         BPGE1-Totals record total value Control
                              BPVG1-Table Generated for View BPVG1
                              BKHS1-Header - Unit Costing (Control + Totals)
                                   HEAD10-SAPscript: Text Header
                                        LINE10-SAPscript: Text Lines
                                   BKHT1-Texts for CKHS
                                   BKIS1-Individual calculation/verification item gen.
                                        BKIT1-Texts for CKIS
                                   BKIP1-Periodic Values for Unit Costing Item
                         BPJA1-Totals record for total year value Control
                              BPVJ1-Table Generated for View BPVJ1
                              BKHS2-Header - Unit Costing (Control + Totals)
                                   HEAD20-SAPscript: Text Header
                                        LINE20-SAPscript: Text Lines
                                   BKHT2-Texts for CKHS
                                   BKIS2-Individual calculation/verification item gen.
                                        BKIT2-Texts for CKIS
                                   BKIP2-Periodic Values for Unit Costing Item
                         BPPE1-Totals Record for Period Values Control
                              BPVP1-Table Generated for View BPVP1
                         BPIG1-Budget Object Index (Overall Budget)
                         BPIJ1-Budget Object Index (Annual Budget)
                    COKA1-CO Object: Cost Element Control Data
                    COKP1-CO Object: Primary Planning Control Data
                         HEAD11-SAPscript: Text Header
                              LINE11-SAPscript: Text Lines
                         CKHS1-Header - Unit Costing (Control + Totals)
                              CKHT1-Texts for CKHS
                              HEAD12-SAPscript: Text Header
                                   LINE12-SAPscript: Text Lines
                              CKIS1-Individual calculation/verification item gen.
                                   CKIT1-Texts for CKIS
                              CKIP1-Periodic Values for Unit Costing Item
                    COSP1-CO Object: Cost Totals for External Postings
                         COVP11-CO object: Line items with doc. header (by period)
                              COEPD11-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR11-CO Object: Valuated Line Item Settlement
                         COVJ11-CO object: Line items with doc header (by year)
                         COVO1-CO Object: Open Items for Line Items (w/o doc.Hdr)
                    COSPD1-CO object: External cost totals - calculated
                    COSPP-Transfer of Order in the COSP Table to the Project
                    COKS1-CO Object: Control Data for Secondary Planning
                         HEAD13-SAPscript: Text Header
                              LINE13-SAPscript: Text Lines
                    COSS1-CO Object: Cost Totals for Internal Postings
                         COVP12-CO object: Line items with doc. header (by period)
                              COEPD12-CO object: Unvaluated ln. item settlement w/status
                                   COEPBR12-CO Object: Valuated Line Item Settlement
                         COVJ12-CO object: Line items with doc header (by year)
                         COVO12-CO object: Fxd price agreement commitment ln items
                    COSSD1-CO object: Internal cost totals - calculated
                    COSSP-Transfer of the Order COSS Table to the Project
                    COKR1-CO Object: Control Data for Statistical Key Figs
                         HEAD14-SAPscript: Text Header
                              LINE14-SAPscript: Text Lines
                    COSR1-CO Object: Statistical Key Figure Totals
                         COVPR1-CO object: Stat. key figure line items by period
                         COVJR1-CO object: Line items stat. key figures (by year)
                    COSL1-CO Object: Activity Type Totals
                         COVPL1-CO object: Activity type line items by period
                         COVJL1-CO object: Line items for acty types (by year)
                    COSLD-CO object: Activity type sums - calculated
                    COSB1-CO Object: Total Variances/Results Analyses
                         COVPB1-CO object: Variance/accrual line items by period
                    COSBD1-CO object: Sums of variance/accrual - calculated
                    ANIA1-Depr. simulation for invest. projects
                         ANIB1-Invest. projects: Depr. simulation analysis report
                    ANLI1-Link table for capital investment measure -> AuC
                    FMSU1-FM totals records for financial data
                         COVFP1-CO object: Financial data line items with doc. hdr
                    TPI031-CO Objects: Date of Last Interest Run
               EKKO-Purchasing Document Header
                    EKPO-Purchasing Document Item
                         EKET-Scheduling Agreement Schedule Lines
                         EKKN-Account Assignment in Purchasing Document
                         EKBE-Purchasing Document History
               EBAN-Purchase requisition
                    EBKN-Purchase Requisition Account Assignment
               FPLAPS-Billing plan for PSP network plan
                    FPLTPS-Billing plan for PSP/network (dates)
               LIKP-SD Document: Delivery Header Data
                    LIPS-SD document: Delivery: Item data
               PSMERK-Characteristics for summarization wo.classificatn
               DRAD-Document-object link