SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

175 columns | Print definition?ERP 6.0  | EKGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)11EKGRPnvarchar30
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)14EKGRPnvarchar30
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line11EKGRPnvarchar30
4/SAPSRM/SH_PGRPTable for ERP Search Help Purchasing Groups3EKGRPPurchasing Groupnvarchar30
5/SMD/MD_____00EPSID-Tabelle fuer Purchasing Group3EKGRPPurchasing Groupnvarchar30
6/SMD/MD_____00OGSID-Tabelle fuer Purchasing Group3EKGRPPurchasing Groupnvarchar30
7/SMD/MD_____00U7SID-Tabelle fuer Purchasing Group3EKGRPPurchasing Groupnvarchar30
8/SMD/MD_____01AHSID-Tabelle fuer Purchasing Group3EKGRPPurchasing Groupnvarchar30
9/SMERP/STG_MM001Data staging - Material master plant view complex table208EKGRPPurchasing Groupnvarchar30
10/XFT/QMPPAPT001QM Sampling Header Table15EKGRPPurchasing Groupnvarchar30
11B061Purchasing Group4EKGRPPurchasing Groupnvarchar30
12CMM_D_IDXCommodity Management: Index Table11EKGRPPurchasing Groupnvarchar30
13FSH_MM_PERIODSPeriod Table for Season in MM & PP8EKGRPPurchasing Groupnvarchar30
14FSH_OS_MMTable for MM Season customizing4EKGRPPurchasing Groupnvarchar30
15HRT5500Table Section Infotype 55007EKGRPPurchasing Groupnvarchar30
16MEV_D_AD_ITEM_MMPeriod-End Valuation: Accruals Document Item MM4EKGRPPurchasing Groupnvarchar30
17MEV_D_WL_ITEMPeriod-end valuation: Worklist item34EKGRPPurchasing Groupnvarchar30
18S520ES520 - Strukturinformationen4EKGRPEinkäufergruppenvarchar30
19S806ES806 - Structural information5EKGRPPurchasing Groupnvarchar30
20S807ES807 - Structural information4EKGRPPurchasing Groupnvarchar30
21S808ES808 - Structural information4EKGRPPurchasing Groupnvarchar30
22TCO41CIM order: Default values for generating operations14EKGRPPurchasing group for external processingnvarchar30
23TMS_C_PAGExt. TMS: Settings for Int. of MM Scheduling Agreements4EKGRPPurchasing Groupnvarchar30
24ZDG60Table ZDG60 for Data Gen. in RT Area (Monthly via ZARTJ)10EKGRPPurchasing Groupnvarchar30
TOPAccount Determination
25TVKOOrganizational Unit: Sales Organizations15EKGRPPurchasing Groupnvarchar30
TOPAgency Business Global Trade
26WBRKAgency business: Header65EKGRPPurchasing Groupnvarchar30
TOPAllocation
27AUBSIWorklist for PO (Follow-on Document Generation)4EKGRPPurchasing Groupnvarchar30
28AUFIAllocation Table, Document Sub-item, Stores9EKGRPPurchasing Groupnvarchar30
29AUKOAllocation Table Document Header6EKGRPPurchasing Groupnvarchar30
30AUUMIWorklist for Stock Transport Orders (Follow-on Doc. Gen.)4EKGRPPurchasing Groupnvarchar30
31AUVZDistribution Center18EKGRPPurchasing Groupnvarchar30
32SVKOAllocation Rule / IS-R Allocation8EKGRPPurchasing Groupnvarchar30
TOPAssortment
33WRF_APC_PAPURPlanned Article Purchasing Data and Prices8EKGRPPurchasing Groupnvarchar30
34WRF_APC_PLHPurchasing List Header Data11EKGRPPurchasing Groupnvarchar30
TOPBasic Functions
35TMW01Pur. Group/Mat. Group: Objects for Web Scenario (Purchasing)2EKGRPPurchasing Groupnvarchar30
TOPBills of Material
36STPOBOM item45EKGRPPurchasing Groupnvarchar30
TOPChargeback
37WCOCOHCondition Contract: Header13EKGRPPurchasing Groupnvarchar30
TOPConditions
38KONAAgreements39EKGRPPurchasing Groupnvarchar30
TOPConsumption-Based Planning See Also PP-MRP
39EDMMSAssignment of EDI partner to purchasing org. and plant6EKGRPPurchasing Groupnvarchar30
40WBO3Log file for investment buy16EKGRPPurchasing Groupnvarchar30
TOPCross-Application Components
41FRE_OP_HEADER_INF&R CON R/3 - Order Proposal Inbound Header Buffer10EKGRPPurchasing Groupnvarchar30
42FRE_OP_ITEM_INF&R CON R/3 - Order Proposal Inbound Item Buffer20EKGRPPurchasing Groupnvarchar30
43MMARCPlant Data for Material12EKGRPPurchasing Groupnvarchar30
44PLLPOTask list - operation/activity109EKGRPPurchasing group for external processingnvarchar30
TOPCustomer Bill of Services
45TBOSGRPService Line: Subcontractor Group3EKGRPPurchasing Groupnvarchar30
TOPData Collection
46S011PURCHIS: Purchasing Group Statistics9EKGRPPurchasing Groupnvarchar30
47S011BIW1S011BIW1 * PURCHIS: Purchasing Group Statistics9EKGRPPurchasing Groupnvarchar30
48S011BIW2S011BIW2 * PURCHIS: Purchasing Group Statistics9EKGRPPurchasing Groupnvarchar30
49S011ES011 - Structural Information4EKGRPPurchasing Groupnvarchar30
50S015Subsequent Settlement: Evaluation14EKGRPPurchasing Groupnvarchar30
51S015ES015 - Structural Information9EKGRPPurchasing Groupnvarchar30
52S080Purchasing: Movements10EKGRPPurchasing Groupnvarchar30
53S080ES080 - Structural Information5EKGRPPurchasing Groupnvarchar30
54S081Purchasing: Stock4EKGRPPurchasing Groupnvarchar30
55S081ES081 - Structural Information5EKGRPPurchasing Groupnvarchar30
56S082Purchasing: Movements + Stock10EKGRPPurchasing Groupnvarchar30
57S082ES082 - Structural Information5EKGRPPurchasing Groupnvarchar30
58S105Season: Movements8EKGRPPurchasing Groupnvarchar30
59S105ES105 - Structural Information3EKGRPPurchasing Groupnvarchar30
60S106Season: Stock2EKGRPPurchasing Groupnvarchar30
61S106ES106 - Structural Information3EKGRPPurchasing Groupnvarchar30
62S107Season: Movements + Stock8EKGRPPurchasing Groupnvarchar30
63S107ES107 - Structural Information3EKGRPPurchasing Groupnvarchar30
64S160Perishables8EKGRPPurchasing Groupnvarchar30
65S160ES160 - Structural Information3EKGRPPurchasing Groupnvarchar30
66S170Payment document data9EKGRPPurchasing Groupnvarchar30
67S170ES170 - Structural Information4EKGRPPurchasing Groupnvarchar30
68S172Vendor billing document data9EKGRPPurchasing Groupnvarchar30
69S172ES172 - Structural Information4EKGRPPurchasing Groupnvarchar30
70S173Vendor billing document item9EKGRPPurchasing Groupnvarchar30
71S173ES173 - Structural Information4EKGRPPurchasing Groupnvarchar30
72S270Do not use!46EKGRPPurchasing Groupnvarchar30
73S270BIW1Do not use!46EKGRPPurchasing Groupnvarchar30
74S270BIW2Do not use!46EKGRPPurchasing Groupnvarchar30
75S275Transfer BW: Einkaufsdaten39EKGRPInkoopgroepnvarchar30
76S275BIW1S275BIW1 * Transfer to BW: Purchasing Data39EKGRPPurchasing Groupnvarchar30
77S275BIW2S275BIW2 * Transfer to BW: Purchasing Data39EKGRPPurchasing Groupnvarchar30
78S520Test9EKGRPPurchasing Groupnvarchar30
79S806LO555 Charac. as Key Figure10EKGRPPurchasing Groupnvarchar30
80S807LO555 Solution One9EKGRPPurchasing Groupnvarchar30
81S808LO555 Solution Two9EKGRPPurchasing Groupnvarchar30
TOPData Retention Tool
82TXW_S_EKKORetrieve EKKO from archive7EKGRPPurchasing Groupnvarchar30
TOPDefense Forces and Public Security
83/ISDFPS/ZEBANCopy of EBAN13EKGRPPurchasing Groupnvarchar30
TOPDistribution Requirements Planning
84MDRP_POCOEvent Table: Deployment Run15EKGRPPurchasing Groupnvarchar30
TOPElectronic Data Interchange
85PRICAT_001PRICAT inbound: Assignment of ILN - Vendor - Purch. group4EKGRPPurchasing Groupnvarchar30
86PRICAT_003PRICAT inbound: Assignment of SAP mat. group - purch. group3EKGRPPurchasing Groupnvarchar30
87PRICAT_K001PRICAT: Catalog header32EKGRPPurchasing Groupnvarchar30
88WRF_INBOUND_001Vendor Catalog Group Maintenance5EKGRPPurchasing Groupnvarchar30
89WRF_INBOUND_003Maintenance: Vendor Catalog Group Subrange Material Group6EKGRPPurchasing Groupnvarchar30
90WRF_PRICAT_001Assign Purch. Grp, Default Purch Org. and History f. Vendor3EKGRPPurchasing Groupnvarchar30
TOPExternal Services
91TMP_SPECModel Service Specifications7EKGRPPurchasing Groupnvarchar30
TOPForce Element
92/ISDFPS/FORCEForce Element (Database)16EKGRPPurchasing Groupnvarchar30
TOPFreight Processing
93TVFPAssignment of Purchasing Data for Shipment Costs5EKGRPPurchasing Groupnvarchar30
94VFKPShipment Costs: Item Data20EKGRPPurchasing Groupnvarchar30
TOPInventory Management
95MWXVM07MFields: Update Control of Module Pool SAPMM07M44EKGRPPurchasing Groupnvarchar30
96MWZVM07MFields: Update Control of Module Pool SAPMM07M44EKGRPPurchasing Groupnvarchar30
97RESBReservation/dependent requirements107EKGRPPurchasing Groupnvarchar30
98WRMA_MANDTSingle Client Settings for RMA6EKGRPPurchasing groupnvarchar30
99WRMA_PROFILERMA Profile6EKGRPPurchasing Groupnvarchar30
TOPInvoice Forecasting
100IFW_WORKLISTInvoice forecasting worklist6EKGRPPurchasing Groupnvarchar30
TOPInvoice Verification
101RBKP_BLOCKEDLogistics Invoice Verification: Blocked Invoices9EKGRPPurchasing Groupnvarchar30
TOPLogistics - General
102WBHDTrading Contract: Commercial Data7EKGRPPurchasing Groupnvarchar30
TOPMaintenance History
103HIMAPM order history - materials18EKGRPPurchasing Groupnvarchar30
104HIVGPM order history - operations45EKGRPPurchasing group for external processingnvarchar30
TOPMaintenance Orders
105TPEXTProfile for external procurement5EKGRPPurchasing Groupnvarchar30
TOPMaster Data
106MDKPHeader Data for MRP Document31EKGRPPurchasing Groupnvarchar30
107MDKPDBHeader Data for MRP Document32EKGRPPurchasing Groupnvarchar30
108T024DMRP controllers6EKGRPPurchasing Groupnvarchar30
TOPMaster Data Distribution
109/ISDFPS/TL1Task List - Operation/Activity109EKGRPPurchasing group for external processingnvarchar30
TOPMaterial Master
110MARCPlant Data for Material12EKGRPPurchasing Groupnvarchar30
111MARC_TMPFile for Incorrect Data in Direct Input15EKGRPPurchasing Groupnvarchar30
112MDIPMaterial: MRP Profiles (Field Contents)29EKGRPPurchasing Groupnvarchar30
113MVRCCross-version fields for MARC12EKGRPPurchasing Groupnvarchar30
114WSTN_AL_LINKRelation between alloc table created and generic article9EKGRPPurchasing Groupnvarchar30
TOPMaterials Management
115/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions18EKGRPPurchasing Groupnvarchar30
116T160EXCriteria Table für External BAnfen3EKGRPPurchasing Groupnvarchar30
TOPMedia Product Sales and Distribution
117JKSDORDERBOOKIS-M: Planned Purchase Quantities33EKGRPPurchasing Groupnvarchar30
118JKSDORDERBOOKPLGoods Movements for Return to Publisher13EKGRPPurchasing Groupnvarchar30
119JKSDORDERBOOKRETIS-M: Planned Quantities for Return to Publisher21EKGRPPurchasing Groupnvarchar30
TOPMerchandise and Assortment Planning
120TWISPC_INT_ALLOCInterface Parameters for "Allocation Table" Interface Cat.7EKGRPPurchasing Groupnvarchar30
121TWISPS_NOALLOC1Parameters for Allocation Tables Generated in MAP6EKGRPPurchasing Groupnvarchar30
122TWISPS_NOLISTG1Parameters for Allocation Tables Generated in MAP6EKGRPPurchasing Groupnvarchar30
TOPNetwork and Activity
123TCN41Network Defaults56EKGRPPurchasing Groupnvarchar30
TOPPatient Accounting
124TNM02IS-H MM: Material Requisition Parameters14EKGRPPurchasing Groupnvarchar30
TOPPerishables Procurement
125FIP_D_CONTRContract Data7EKGRPPurchasing Groupnvarchar30
126FIP_D_ORDER_LINEOrder lines for FIP9EKGRPPurchasing Groupnvarchar30
127FIP_D_SP_PURFIP -- Area of Responsibility -- Purchasing table5EKGRPPurchasing Groupnvarchar30
TOPPersonnel Administration
128PA0901HR Master Record: Infotype 0901 (Purchasing Data)25EKGRPPurchasing Groupnvarchar30
TOPPOS Interface
129WVFBDRS Interface, Intermediate Buffer, Order Item FM12EKGRPPurchasing Groupnvarchar30
TOPProcessing
130EWATSUBCNTCNFConfiguration Subcontractor Processing (General)7EKGRPPurchasing Groupnvarchar30
131EWATSUBCNTCNFWDIConfiguration Subcontractor Handling Waste Disp. Order Item7EKGRPPurchasing Groupnvarchar30
132EWATSUBCNTCNFWDOConfiguration Subcontract. Handling for Waste Disposal Order7EKGRPPurchasing Groupnvarchar30
133EWATSUBCNTCNFWDWConfiguration Subcontractor Processing for Weigh Bills7EKGRPPurchasing Groupnvarchar30
TOPProduct Cost Planning
134KALMCosting Run: Costing Objects41EKGRPPurchasing Groupnvarchar30
135KALOCosting Run: Costing Objects (KVMK)37EKGRPPurchasing Groupnvarchar30
TOPProduction Orders
136AFVCOperation within an order62EKGRPPurchasing group for external processingnvarchar30
TOPPromotion
137WAALMaterial-to-vendor assignment in price maintenance (promo.)13EKGRPPurchasing Groupnvarchar30
138WAKHPromotion Header Data, IS-R42EKGRPPurchasing Group - Promotion Headernvarchar30
139WAKPPromotion Item Data17EKGRPPurchasing Groupnvarchar30
140WALEMaterial to store assignment to promotion15EKGRPPurchasing Groupnvarchar30
TOPPurchasing
141EBANPurchase Requisition13EKGRPPurchasing Groupnvarchar30
142EINEPurchasing Info Record: Purchasing Organization Data9EKGRPPurchasing Groupnvarchar30
143EKKOPurchasing Document Header22EKGRPPurchasing Groupnvarchar30
144MEREQXPurchase Requisition Change Parameter13EKGRPUpdated information in related user data fieldnvarchar10
145T024Purchasing Groups2EKGRPPurchasing Groupnvarchar30
146T026ZAssignement of purchasing group to purchasing area3EKGRPPurchasing Groupnvarchar30
147WDFR1Requirements Planning for Perishables20EKGRPPurchasing Groupnvarchar30
148WDFR_DISPPerishables Planning Header90EKGRPPurchasing Groupnvarchar30
149WRF_POHF_POLOrder list6EKGRPPurchasing Groupnvarchar30
150WRF_POTB_DB1Worklist OTB Procurement9EKGRPPurchasing Groupnvarchar30
151WRF_PRCT_WL_ITEMOriginal Table for Worklist Items9EKGRPPurchasing Groupnvarchar30
152WRF_PRCT_WL_SHDWShadow Table for Worklist Items12EKGRPPurchasing Groupnvarchar30
TOPPurchasing Information System
153MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)9EKGRPPurchasing Groupnvarchar30
TOPRemote Logistics Management
154OIO_MX_OBJECTRLM tracking extract object data41EKGRPPurchasing Groupnvarchar30
TOPRetail Demand Management
155RDMT_EX_MDTYPEDefault Values Allocation Table for External Markdown Type5EKGRPPurchasing Groupnvarchar30
TOPRouting
156PLPOTask list - operation/activity109EKGRPPurchasing group for external processingnvarchar30
TOPSAP Retail Store
157WOSASAP Retail Store, Store Orders: Entities Table6EKGRPPurchasing Groupnvarchar30
TOPSelf-Service Procurement
158/SRMERP/D_SC_ITMShopping Cart Item15EKGRPPurchasing Groupnvarchar30
TOPShipping
159DVM01R/2-R/3 Link: R/3 Input Data for Material Master83EKGRPPurchasing Groupnvarchar30
160LIPSPOLIPS Reference Data Purchase Order7EKGRPPurchasing Groupnvarchar30
TOPSimulation
161VSAFVC_CNVersion: Operation in order63EKGRPPurchasing group for external processingnvarchar30
162VSEBAN_CNVersion: Purchase requisition14EKGRPPurchasing Groupnvarchar30
163VSRESB_CNVersion: Reservation/Dependent requirements108EKGRPPurchasing Groupnvarchar30
TOPStandard Network
164TCA41Default values for standard networks and profiles58EKGRPPurchasing group for external processingnvarchar30
TOPSubsequent Settlement
165S015BIW1S015BIW1 * Supplementary settlement - Evaluation14EKGRPPurchasing Groupnvarchar30
166S015BIW2S015BIW2 * Supplementary settlement - Evaluation14EKGRPPurchasing Groupnvarchar30
TOPTraders and Schedulers Workbench
167TOI0_REL_MMRelevance customizing for MM Documents9EKGRPPurchasing Groupnvarchar30
168TOI0_REL_TCTSW relevance table for trading contract13EKGRPPurchasing Groupnvarchar30
TOPTrading Contract
169TB2BWEBPROFILETrading Contract Web Profile Table9EKGRPPurchasing Groupnvarchar30
TOPTransportation Management Integration
170TMS_C_PURExt. Transport Manag.: Determination of Transfer Relev. PUR3EKGRPPurchasing Groupnvarchar30
TOPVehicle Management System
171CVLC23VELO : Assign Organization Data to VMS Roles12EKGRPPurchasing Groupnvarchar30
172VLCBATCHACTVELO : Variant for Action Execution in Batch9EKGRPPurchasing Groupnvarchar30
TOPVendor Master
173LFM1Vendor master record purchasing organization data23EKGRPPurchasing Groupnvarchar30
174LFM2Vendor Master Record: Purchasing Data25EKGRPPurchasing Groupnvarchar30
175WYT5Changes to Vendor Master Record10EKGRPPurchasing Groupnvarchar30