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

EKPO SAP Purchasing Document Item Table and data







EKPO is a standard SAP Table which is used to store Purchasing Document Item data and 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 SAP EKPO Table and the data within it using relevant 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


SAP EKPO Table fields within data Dictionary




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
EBELNEBELNCHAR10EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5Item Number of Purchasing Document
.INCLUDEEKPODATAPurchasing Document Item: Data Part
LOEKZELOEKCHAR1Deletion Indicator in Purchasing Document
STATUASTATCHAR1RFQ status
AEDATPAEDTDATS8Purchasing Document Item Change Date
TXZ01TXZ01CHAR40Short Text
MATNRMATNRCHAR18MARAMaterial NumberMATN1
EMATNEMATNRCHAR18MARAMaterial NumberMATN1
BUKRSBUKRSCHAR4T001Company Code
WERKSEWERKCHAR4T001WPlant
LGORTLGORT_DCHAR4T001LStorage Location
BEDNRBEDNRCHAR10Requirement Tracking Number
MATKLMATKLCHAR9T023Material Group
INFNRINFNRCHAR10EINANumber of Purchasing Info RecordALPHA
IDNLFIDNLFCHAR35Material Number Used by Vendor
KTMNGKTMNGQUAN13(3)Target Quantity
MENGEBSTMGQUAN13(3)Purchase Order Quantity
MEINSBSTMEUNIT3T006Purchase Order Unit of MeasureCUNIT
BPRMEBBPRMUNIT3T006Order Price Unit (Purchasing)CUNIT
BPUMZBPUMZDEC5Numerator for Conversion of Order Price Unit into Order Unit
BPUMNBPUMNDEC5Denominator for Conv. of Order Price Unit into Order Unit
UMREZUMBSZDEC5Numerator for Conversion of Order Unit to Base Unit
UMRENUMBSNDEC5Denominator for Conversion of Order Unit to Base Unit
NETPRBPREICURR11(2)Net Price in Purchasing Document (in Document Currency)
PEINHEPEINDEC5Price Unit
NETWRBWERTCURR13(2)Net Order Value in PO Currency
BRTWRBBWERTCURR13(2)Gross order value in PO currency
AGDATANGABDATS8Deadline for Submission of Bid/Quotation
WEBAZWEBAZDEC3Goods Receipt Processing Time in Days
MWSKZMWSKZCHAR2T007ATax on sales/purchases code
BONUSEBONUCHAR2Settlement Group 1 (Purchasing)
INSMKINSMKCHAR1Stock Type
SPINFSPINFCHAR1Indicator: Update Info Record
PRSDRPRSDRCHAR1Price Printout
SCHPRSCHPRCHAR1Indicator: Estimated Price
MAHNZMAHNZDEC3Number of Reminders/Expediters
MAHN1MAHN1DEC3Number of Days for First Reminder/Expediter
MAHN2MAHN2DEC3Number of Days for Second Reminder/Expediter

MAHN3MAHN3DEC3Number of Days for Third Reminder/Expediter
UEBTOUEBTODEC3(1)Overdelivery Tolerance Limit
UEBTKUEBTKCHAR1Indicator: Unlimited Overdelivery Allowed
UNTTOUNTTODEC3(1)Underdelivery Tolerance Limit
BWTARBWTAR_DCHAR10T149DValuation Type
BWTTYBWTTY_DCHAR1T149CValuation Category
ABSKZABSKZCHAR1Rejection Indicator
AGMEMAGMEMCHAR3TMAMInternal Comment on Quotation
ELIKZELIKZCHAR1"Delivery Completed" Indicator
EREKZEREKZCHAR1Final Invoice Indicator
PSTYPPSTYPCHAR1T163Item Category in Purchasing Document
KNTTPKNTTPCHAR1T163KAccount Assignment Category
KZVBRKZVBRCHAR1Consumption Posting
VRTKZVRTKZCHAR1Distribution indicator for multiple account assignment
TWRKZTWRKZCHAR1Partial Invoice Indicator
WEPOSWEPOSCHAR1Goods Receipt Indicator
WEUNBWEUNBCHAR1Goods Receipt, Non-Valuated
REPOSREPOSCHAR1Invoice Receipt Indicator
WEBREWEBRECHAR1Indicator: GR-Based Invoice Verification
KZABSKZABSCHAR1Order Acknowledgment Requirement
LABNRLABNRCHAR20Order Acknowledgment Number
KONNRKONNRCHAR10EKKONumber of Principal Purchase AgreementALPHA
KTPNRKTPNRNUMC5EKPOItem Number of Principal Purchase Agreement
ABDATABDATDATS8Reconciliation Date for Agreed Cumulative Quantity
ABFTZABFTZQUAN13(3)Agreed Cumulative Quantity
ETFZ1ETFZ1DEC3Firm Zone (Go-Ahead for Production)
ETFZ2ETFZ2DEC3Trade-Off Zone (Go-Ahead for Materials Procurement)
KZSTUMRPRECHAR1Firm/Trade-Off Zones Binding with Regard to Mat. Planning
NOTKZNOTKZCHAR1Exclusion in Outline Agreement Item with Material Class
LMEINLAGMEUNIT3T006Base Unit of MeasureCUNIT
EVERSEVERSCHAR2T027AShipping Instructions
ZWERTDZWERTCURR13(2)Target Value for Outline Agreement in Document Currency
NAVNWNAVNWCURR13(2)Non-deductible input tax
ABMNGNORAMQUAN13(3)Standard release order quantity
PRDATPREDTDATS8Date of Price Determination
BSTYPBSTYPCHAR1Purchasing Document Category
EFFWREFFWRCURR13(2)Effective value of item
XOBLRXOBLRCHAR1Item affects commitments
KUNNREKUNNRCHAR10KNA1CustomerALPHA
ADRNRADRNR_MMCHAR10ADRCManual address number in purchasing document itemALPHA

EKKOLEKKOGCHAR4Condition Group with Vendor
SKTOFESKTOFCHAR1Item Does Not Qualify for Cash Discount
STAFOSTAFOCHAR6
*
Update group for statistics updateALPHA
PLIFZEPLIFDEC3Planned Delivery Time in Days
NTGEWENTGEQUAN13(3)Net Weight
GEWEIEGEWEUNIT3T006Unit of WeightCUNIT
TXJCDTXJCDCHAR15TTXJTax Jurisdiction
ETDRKETDRKCHAR1Indicator: Print-relevant schedule lines exist
SOBKZSOBKZCHAR1T148Special Stock Indicator
ARSNRARSNRNUMC10Settlement reservation number
ARSPSARSPSNUMC4Item number of the settlement reservation
INSNCINSNCCHAR1Quality inspection indicator cannot be changed
SSQSSQSSPURCHAR8TQ08Control Key for Quality Management in Procurement
ZGTYPQZGTYPCHAR4TQ05Certificate Type
EAN11EAN11CHAR18International Article Number (EAN/UPC)EAN11
BSTAEBSTAECHAR4T163LConfirmation Control Key
REVLVREVLVCHAR2Revision LevelNUMCV
GEBERBP_GEBERCHAR10
*
Fund
FISTLFISTLCHAR16
*
Funds Center
FIPOSFIPOSCHAR14FMFPOCommitment ItemFMCIS
KO_GSBERGSBER_GPCHAR4
*
Business area reported to the partner
KO_PARGBPARGB_GPCHAR4
*
assumed business area of the business partner
KO_PRCTRPRCTRCHAR10CEPCProfit CenterALPHA
KO_PPRCTRPPRCTRCHAR10CEPCPartner Profit CenterALPHA
MEPRFMEPRFCHAR1Price Determination (Pricing) Date Control
BRGEWBRGEWQUAN13(3)Gross Weight
VOLUMVOLUMQUAN13(3)Volume
VOLEHVOLEHUNIT3T006Volume unitCUNIT
INCO1INCO1CHAR3TINCIncoterms (Part 1)
INCO2INCO2CHAR28Incoterms (Part 2)
VORABVORABCHAR1Advance procurement: project stock
KOLIFKOLIFCHAR10LFA1Prior VendorALPHA
LTSNRLTSNRCHAR6WYT1Vendor Subrange
PACKNOPACKNONUMC10ESLHPackage number
FPLNRIPLNRCHAR10Invoicing plan number
GNETWRGNETWRCURR13(2)Currently not used
STAPOSTAPOCHAR1Item is statistical
UEBPOUEBPONUMC5EKPOHigher-Level Item in Purchasing Documents
LEWEDLEWEDDATS8Latest Possible Goods Receipt
EMLIFEMLIFCHAR10LFA1Vendor to be supplied/who is to receive deliveryALPHA
LBLKZLBLKZCHAR1Subcontracting vendor
SATNRSATNRCHAR18MARACross-Plant Configurable MaterialMATN1
ATTYPATTYPCHAR2Material Category
VSARTVERSARTCHAR2
*
Shipping type
HANDOVERLOCHANDOVER_LOCCHAR10Location for a physical handover of goodsALPHA
KANBAKBNKZCHAR1Kanban Indicator
ADRN2ADRN2CHAR10ADRCNumber of delivery addressALPHA
CUOBJCUOBJNUMC18Configuration (internal object number)
XERSYXERSYCHAR1Evaluated Receipt Settlement (ERS)
EILDTEILDTDATS8Start Date for GR-Based Settlement
DRDATDRDATDATS8Last Transmission
DRUHRDRUHRTIMS6Time
DRUNRDRUNRNUMC4Sequential Number
AKTNRWAKTIONCHAR10WAKHPromotionALPHA
ABELNABELNCHAR10AUKOAllocation Table NumberALPHA
ABELPABELPNUMC5
*
Item number of allocation table
ANZPUANZPUQUAN13(3)Number of Points
PUNEIPUNEIUNIT3T006Points unitCUNIT
SAISOSAISOCHAR4T6WSPSeason Category
SAISJSAISJCHAR4Season YearGJAHR
EBON2EBON2CHAR2Settlement Group 2 (Rebate Settlement, Purchasing)
EBON3EBON3CHAR2Settlement Group 3 (Rebate Settlement, Purchasing)
EBONFEBONYCHAR1Item Relevant to Subsequent (Period-End Rebate) Settlement
MLMAACK_ML_MAACCHAR1Material ledger activated at material level
MHDRZMHDRZDEC4Minimum Remaining Shelf Life
ANFNRANFNRCHAR10EKKORFQ NumberALPHA
ANFPSANFPSNUMC5EKPOItem Number of RFQ
KZKFGKZCUHCHAR1Origin of Configuration
USEQUUSEQUCHAR1TMQ2Quota arrangement usage
UMSOKUMSOKCHAR1
*
Special Stock Indicator for Physical Stock Transfer
BANFNBANFNCHAR10Purchase Requisition NumberALPHA
BNFPOBNFPONUMC5EBANItem Number of Purchase Requisition
MTARTMTARTCHAR4T134Material Type
UPTYPUPTYPCHAR1TMSI1Subitem Category, Purchasing Document
UPVORUPVORCHAR1Subitems 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
SIKGRSIKGRCHAR3TMSI2Processing key for sub-items
MFZHIMFZHIQUAN15(3)Maximum Cumulative Material Go-Ahead Quantity
FFZHIFFZHIQUAN15(3)Maximum Cumulative Production Go-Ahead Quantity
RETPORETPOCHAR1Returns Item
AURELAURELCHAR1Relevant to Allocation Table
BSGRUBSGRUCHAR3TBSGReason for Ordering
LFRETLFRETCHAR4TVLKDelivery Type for Returns to Vendors
MFRGRMFRGRCHAR8TMFGMaterial freight group
NRFHGNRFHGCHAR1Material qualifies for discount in kind
J_1BNBMJ_1BNBMCO1CHAR16T604FBrazilian NCM Code
J_1BMATUSEJ_1BMATUSECHAR1Usage of the material
J_1BMATORGJ_1BMATORGCHAR1Origin of the material
J_1BOWNPROJ_1BOWNPROCHAR1Produced in-house
J_1BINDUSTJ_1BINDUS3CHAR2Material CFOP categoryALPHA
ABUEBABUEBCHAR4T163PRelease Creation Profile
NLABDNLABDDATS8Next Forecast Delivery Schedule Transmission
NFABDNFABDDATS8Next JIT Delivery Schedule Transmission
KZBWSKZBWSCHAR1Valuation of Special Stock
BONBABONBACURR13(2)Rebate basis 1
FABKZFABKZCHAR1Indicator: Item Relevant to JIT Delivery Schedules
J_1AINDXPJ_1AINDXPCHAR5J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATEPDATS8Inflation Index Date
MPROFMPROFCHAR4
*
Manufacturer Part Profile
EGLKZEGLKZCHAR1"Outward Delivery Completed" Indicator
KZTLFKZTULCHAR1Partial Delivery at Item Level (Stock Transfer)
KZFMEKZWSOCHAR1Units of measure usage
RDPRFRDPRFCHAR4RDPRRounding Profile
TECHSTECHSCHAR12Parameter Variant/Standard Variant
CHG_SRVCHG_SRVCHAR1Configuration changed
CHG_FPLNRCHG_FPLNRCHAR1No invoice for this item although not free of charge
MFRPNMFRPNCHAR40Manufacturer Part Number
MFRNRMFRNRCHAR10LFA1Number of a ManufacturerALPHA
EMNFREMNFRCHAR10External manufacturer code name or number
NOVETNOVETCHAR1Item blocked for SD delivery
AFNAMAFNAMCHAR12Name of Requisitioner/Requester
TZONRCTSEGZONRECCHAR6
*
Time zone of recipient location
IPRKZDATTPCHAR1Period Indicator for Shelf Life Expiration DatePERKZ
LEBRELEBRECHAR1Indicator for Service-Based Invoice Verification
BERIDBERIDCHAR10MDLVMRP Area
XCONDITIONSXCONDITIONSCHAR1Conditions for item although no invoice
APOMSAPOMSCHAR1APO as Planning System
CCOMPMMPUR_CCOMPCHAR1Posting Logic in the Case of Stock Transfers
GRANT_NBRGM_GRANT_NBRCHAR20GrantALPHA
FKBERFKBERCHAR16
*
Functional Area
STATUSEPSTATUCHAR1Status of Purchasing Document Item
RESLORESLOCHAR4T001LIssuing Storage Location for Stock Transport Order
KBLNRKBLNRCHAR10
*
Document Number for Earmarked FundsALPHA
KBLPOSKBLPOSNUMC3
*
Earmarked Funds: Document Item
WEORAWEORACHAR1Acceptance At Origin
SRV_BAS_COMSRV_BAS_COMCHAR1Service-Based Commitment
PRIO_URGPRIO_URGNUMC2PURGRequirement Urgency
PRIO_REQPRIO_REQNUMC3PREQRequirement Priority
EMPSTEMPSTCHAR25Receiving point
DIFF_INVOICEDIFF_INVOICECHAR2Differential Invoicing
TRMRISK_RELEVANTPUR_TRM_RISK_RELEVANCYCHAR2Risk Relevancy in Purchasing
.INCLUDE/SPE/TPOP_CRM_DATACRM data for TPOP process
SPE_ABGRUABGRUCHAR2Reason for rejection of quotations and sales orders
SPE_CRM_SO/SPE/VBELN_CRMCHAR10CRM Sales Order Number for TPOP ProcessALPHA
SPE_CRM_SO_ITEM/SPE/POSNR_CRMNUMC6CRM Sales Order Item Number in TPOP Process
SPE_CRM_REF_SO/SPE/REF_VBELN_CRMCHAR35CRM Reference Order Number for TPOP ProcessALPHA
SPE_CRM_REF_ITEM/SPE/REF_POSNR_CRMCHAR6CRM Reference Sales Order Item Number in TPOP Process
SPE_CRM_FKREL/SPE/FKREL_CRMCHAR1Billing Relevance CRM
SPE_CHNG_SYS/SPE/INB_CHNG_SYSCHAR1Last Changer's System Type
SPE_INSMK_SRC/SPE/INSMK_SRCCHAR1Stock Type of Source Storage Location in STO
SPE_CQ_CTRLTYPE/SPE/CQ_CONTROL_TYPECHAR1CQ Control Type
SPE_CQ_NOCQ/SPE/CQ_NOCQCHAR1No Transmission of Cumulative Quantities in SA Release
REASON_CODE/SAPPSPRO/_GR_REASON_CODECHAR4Goods Receipt Reason Code
CQU_SARCQU_SARQUAN15(3)Cumulative Goods Receipts from Redirected Purchase Orders
ANZSNANZSNINT410Number of serial numbers
SPE_EWM_DTC/SPE/EWM_DTCCHAR1EWM Delivery Based Tolerance Check
.INCLUDEEKPO_SRM_DATASRM Fields in Purchase Order Item
EXLINEXLINCHAR40Item Number Length
EXSNREXSNRNUMC5External Sorting
EHTYPEHTYPCHAR4TMSRM_EHTYPExternal Hierarchy Category
RETPCRETPZDEC5(2)Retention in Percent
DPTYPME_DPTYPCHAR4Down Payment Indicator
DPPCTME_DPPCNTDEC5(2)Down Payment Percentage
DPAMTME_DPAMNTCURR11(2)Down Payment Amount in Document Currency
DPDATME_DPDDATDATS8Due Date for Down Payment
FLS_RSTOFLS_RSTOCHAR1Store Return with Inbound and Outbound Delivery
EXT_RFX_NUMBERME_PUR_EXT_DOC_IDCHAR35Document Number of External Document
EXT_RFX_ITEMME_PUR_EXT_DOC_ITEM_IDCHAR10Item Number of External Document
EXT_RFX_SYSTEMLOGSYSTEMCHAR10
*
Logical SystemALPHA
SRM_CONTRACT_IDSRM_CONTRACT_IDCHAR10Central ContractALPHA
SRM_CONTRACT_ITMSRM_CONTRACT_ITEMNUMC10Central Contract Item Number
BLK_REASON_IDBLK_REASON_IDCHAR4Blocking Reason - ID
BLK_REASON_TXTBLK_REASON_TXTCHAR40Blocking Reason - Text
ITCONSME_IR_CO_ORDERCHAR1Real-Time Consumption Posting of Subcontracting Components
FIXMGME_FIXMGCHAR1Delivery Date and Quantity Fixed
WABWEWABWECHAR1Indicator for GI-based goods receipt
.INCLUDEJ_1BMM_TC_DETMM 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_STCHAR1Tax Subject to Substituição Tributária
FISCAL_INCENTIVE_IDJ_1BFISCAL_INCENTIVE_IDCHAR4
*
Incentive ID
.APPEND/BEV1/NE_EKPODATA_AEmpties Managment: EKPODATA Enhancement
/BEV1/NEGEN_ITEM/BEV1/NEGEN_ITEM_FLAGCHAR1Indicator: Item Is Generated
/BEV1/NEDEPFREE/BEV1/NEDEPFREECHAR1Indicator: Dependent Items Are Free of Charge
/BEV1/NESTRUCCAT/BEV1/NESTRUC_CATCHAR1Structure Category for Material Relationship
.APPEND/ISDFPS/EKPOAppend to EKPO for DFPS
ADVCODE/ISDFPS/ADVCODECHAR2
*
Advice Code
.APPENDEHP4_EKPODATA_BUDGET_PDBudget Period
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
.APPENDFMFG_EKPODATAAdd on for Public Sector
EXCPEEXCPENUMC2Acceptance Period
.APPENDIUID_EKPODATAIUID Append
IUID_RELEVANTIUID_RELEVANTCHAR1IUID-Relevant
.APPENDJ_1IR_EKPO_APPENDAddition of Fields to EKPODAT -Retail Localization for India
.INCLUDEJ_1IR_MRPIND_STAdditional Filed for Retail Localization for India
MRPINDJ_1IRMRPINDCHAR1Max. Retail Price Relevant
.APPENDOILEKPODATAOil APPEND
.INCLUDEOIC_PIPEOrigin, Destination, Trip and ex Batch No for Pipeline
OIPIPEVALOID_PIPEVCHAR1Validation indicator for pipeline fields (X=ON, blank=OFF)
OIC_LIFNRLIFNRCHAR10LFA1Account Number of Vendor or CreditorALPHA
.INCLUDEOIC_DEST_ORIGDestination/Origin: City,County,Region,Country + Tax
OIC_DCITYCOIC_DCITYCCHAR4T005GDestination city code
OIC_DCOUNCOIC_DCOUNCCHAR3T005EDestination county code
OIC_DREGIOOIC_DREGIOCHAR3T005SDestination region
OIC_DLAND1OIC_DLAND1CHAR3T005Destination country
OIC_OCITYCOIC_OCITYCCHAR4T005GOrigin city code
OIC_OCOUNCOIC_OCOUNCCHAR3T005EOrigin county code
OIC_OREGIOOIC_OREGIOCHAR3T005SOrigin region
OIC_OLAND1OIC_OLAND1CHAR3T005Origin country
OIC_PORGINOIC_PORGINCHAR15Tax origin
OIC_PDESTNOIC_PDESTNCHAR15Tax destination
OIC_PTRIPOIC_PTRIPCHAR16Pipeline trip number (external)
OIC_PBATCHOIC_PBATCHCHAR16Pipeline operator´s external batch number
OIC_MOTOIC_MOTCHAR2TVTRIS-OIL MAP external details mode of transport
OIC_AORGINOIC_AORGINCHAR15Alternate origin
OIC_ADESTNOIC_ADESTNCHAR15Alternate destination
OIC_TRUCKNOIC_TRUCKNCHAR10Truck number
OIA_BASELOOIA_BASELOCHAR15Base location
OITAXFROMOIH_TAXFROCHAR2OIH4Excise duty tax key for 'from' location
OIHANTYPOIH_HANTYPCHAR2OIH5Excise Duty Handling Type
OIPRICIEOIH_PRICIECHAR1ED pricing: external (indicator)
OITAXTOOIH_TAXTOCHAR2OIH4Excise duty tax key for 'to' location
OITAXCONOIH_TAXCONCURR13(2)Excise duty tax from pricing conditions
OITAXGRPOIH_TAXGRPCHAR2OIH2Excise Duty Group
OIOILCONOIH_OILCONDEC5(2)Oil content in a material as a percentage
OIINEXOIH_INEXCHAR2OIH16Code for internal or external excise duty rate determination
.INCLUDEOIA_INCDATExchanges structure to be included in Core tables
OIEXGNUMOIA_EXGNUMCHAR10Exchange agreement numberALPHA
OIEXGTYPOIA_EXGTYPCHAR4TOIA2Exchange type
OIFEETOTOIA_FEETOTCURR13(2)Fee total
OIFEEDTOIA_FEEDTDATS8Fee pricing condition date
OINETCYCOIA_NETCYCCHAR1T008Netting cycle (FI blocking indicator)
OIFERPOIA_FERPCHAR1Fee repricing indicator
OIFEECHOIA_FEECHCHAR1Fee edit control
OIA_IPMVATOIA_IPMVATCHAR1VAT on internally-posted material
OIA_SPLTIVOIA_SPLTIVCHAR1Indicator for split invoice verification
OIVATHDMBTRCURR13(2)Amount in Local Currency
OIVATFWRBTRCURR13(2)Amount in document currency
OISBRELOIA_SBRELNUMC3Sub product/ base product relevence indicator
OIBASPRODOIA_SBMATCHAR18
*
Base product numberMATN1
.INCLUDEOIHBEFUTRACKING FIELDS FOR 2 STEP TRANSFERS
OITRKNROIH_TRKNRCHAR10Tracking numberALPHA
OITRKJROIH_TRKJRNUMC4Tracking number year
OIEXTNROIH_EXTNRCHAR18External tracking number
OIITMNROIH_ITMNRNUMC5Tracking number item line
OIFTINDOIH_FTINDCHAR1Final transfer indicator
OIPRIOPOIH_PRIOPCHAR1Price options for gain calculation
OITRINDOIH_TRINDCHAR1Transfer sign for plant-to-plant transfers
OIGHNDLOIH_GHNDLCHAR1Gain handling
OIUMBAROIH_UMBARCHAR10T149DValuation 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_EXExternal Bill of Lading and Misc. Deliv. No
OID_EXTBOLOID_EXTBOLCHAR16External bill of lading
OID_MISCDLOID_MISCDLCHAR16Miscellaneous delivery number
OIMATCYCOIA_MATCYCNUMC1
*
Invoicing cycle for purchase material costs
OIEDOKOIH_EDOKCHAR1Excise duty validation indicator
OIEDBALOIH_EDBALCHAR1Excise duty balancing is required (indicator)
OIEDBALMOIH_EDBALMCHAR1Excise duty balancing method indicator
.INCLUDEOIHLICLicense fields for transfers
OICERTF1OIH_CERTF1CHAR15Excise tax external license number
OIDATFM1OIH_DATFM1DATS8Excise Duty License Valid from Date
OIDATTO1OIH_DATTO1DATS8Valid to date for excise duty tax certificate
OIH_LICTPOIH_LICTPCHAR4OIH20License type
OIH_LICINOIH_LICINCHAR10OIHLExcise tax internal license numberALPHA
OIH_LCFOLOIH_LCFOLCHAR10OIHLFollow-on license for quantity licenseALPHA
OIH_FOLQTYOIH_FOLQTYQUAN13(3)Excise Tax Follow-On License Quantity
OIEDOK_GIOIH_EDOK_GICHAR1Excise Duty Validation Indicator for Material (STO)
OIEDBAL_GIOIH_EDBAL_GICHAR1Excise Duty Balancing is Required for Mat. (STO)
OIEDBALM_GIOIH_EDBALM_GICHAR1Excise 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_GILicense fields for transfers to material (STO)
OICERTF1_GIOIH_CERTF1_GICHAR15Excise Tax External License Number Used During GI (STO)
OIDATFM1_GIOIH_DATFM1_GIDATS8Excise Duty License Valid from Date for Mat. (STO)
OIDATTO1_GIOIH_DATTO1_GIDATS8Valid To Date for Excise Duty Tax Certificate for Mat. (STO)
OIH_LICTP_GIOIH_LICTP_GICHAR4OIH20License Type to Material (STO)
OIH_LICIN_GIOIH_LICIN_GICHAR10OIHLExcise Tax Internal License Number to Mat. (STO)ALPHA
OIH_LCFOL_GIOIH_LCFOL_GICHAR10OIHLFollow-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
ZPRUEBABOOLEANCHAR1Boolean Variable (X=True, -=False, Space=Unknown)
REFSITEWREFSITECHAR4Reference Site For Purchasing
.APPEND/SAPMP/APP_EKPOMP: Append Purchases Item for MILL Products
.INCLUDE/SAPMP/EKPOEnhancements for Mill Products
/SAPMP/GPOSE/SAPMP/GPOSENUMC5Global Item Number in Purchasing Document
.APPENDADEKPOStructure for Additional Fields in SPEC 2000 Items
ANGPNANGPNNUMC6
*
Quotation Item Number (SD)
ADMOIADMOICHAR4CSPCMOIModel ID code
ADPRIADPRICHAR3CSPCPRIOrder priority
LPRIOLPRIONUMC2TPRIODelivery Priority
ADACNADACNCHAR5Aircraft registration number
AFPNRPOSNR_VANUMC6
*
Sales Document Item
BSARKBSARLCHAR4
*
Vendor confirmation type
AUDATAUDATDATS8Document Date (Date Received/Sent)
ANGNRADSPC_ANGNRCHAR20Quotation number
PNSTATADSPC_PNSTATCHAR1Flag for the S1PNSTAT message
.APPENDDISUB_EKPO_DATADI A&D SUB Enhancement of EKPO
SERRUSERRUCHAR1Type of subcontracting
SERNPSERAILCHAR4
*
Serial Number Profile
DISUB_SOBKZDISUB_SOBKZ_LBCHAR1Special stock indicator Subcontracting
DISUB_PSPNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP
DISUB_KUNNRKUNNRCHAR10Customer NumberALPHA
DISUB_VBELNVBELNCHAR10
*
Sales and Distribution Document NumberALPHA
DISUB_POSNRPOSNRNUMC6
*
Item number of the SD document
DISUB_OWNEROWNER_DCHAR10
*
Owner of stockALPHA
.APPENDISAUTOLABIS AUTOMOTIVE Enhancements in EKPO
STPACSTPACCHAR1Activate Static Stopping of Releases
LGBZOUNLPTCHAR10
*
(Automotive) Unloading Point
LGBZO_BUNLPTCHAR10
*
(Automotive) Unloading Point
ADDRNUMAD_ADDRNUMCHAR10
*
Address numberALPHA
CONSNUMAD_CONSNUMNUMC3Sequence Number
BORGR_MISSBORGR_MISSCHAR1Indicator: Action at Registration
.APPENDWRF_PBAS_EKPO_ADDON_STYEKPO Enhancement Seasonal Procurement: Procurement
.INCLUDEWRF_PSCD_EKPO_ADDON_STYEnhancement of Purchasing Document Item
REF_ITEMWRF_PSCD_REF_ITEMNUMC5Reference Item for Remaining Qty Cancellation
.INCLUDEWRF_POHF_EKPO_ADDON_STYEKPO Enhancement: PO Handling
.INCLUDEWRF_POHF_SOURCE_KEY_STYSource System and Source Key of Record
SOURCE_IDWRF_POHF_SOURCE_IDCHAR3WRFT_POHF_SOURCEOrigin Profile
SOURCE_KEYWRF_POHF_SOURCE_KEYCHAR32Key in Source System
PUT_BACKWRF_POHF_PUT_BACK_POGCHAR1Indicator for Putting Back from Grouped PO Document
POL_IDWRF_POHF_POL_IDCHAR10Order List Item NumberALPHA
.INCLUDEWRF_CONSIGNMENTSeasonal Procurement: Include for Consignment Processing
CONS_ORDERWRF_CONS_ORDERCHAR1Purchase Order for Consignment



Key field
Non-key field

EKPO relationships with 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