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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

39 columns | Print definition?ERP 6.0  | VGART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_RBKPDocument Header: Invoice Receipt11VGARTTransaction type in AG08 (internal document type)nvarchar20
2CNV_20000_IKPFBackup copy of IKPF (header for phys. inventory document)4VGARTTransaction/event typenvarchar20
3FIEUD_MMINV_HSAFT:MM: Header table for XML Purchase Invoice9VGARTTransaction/Event Typenvarchar20
4T003MTransaction/Event Types for SAPMM07M/SAPMM07I2VGARTTransaction/Event Typenvarchar20
5T063Screen Control: Inventory Management1VGARTTransaction/Event Typenvarchar20
6T158Transaction Control: Inventory Management6VGARTTransaction/Event Typenvarchar20
7T158ITransaction Control: Physical Inventory4VGARTTransaction/Event Typenvarchar20
8T158NNext Transaction Code in Inventory Management2VGARTTransaction/Event Typenvarchar20
9T158TInv. Management: Text Table for Trans./Event Types Allowed2VGARTTransaction/Event Typenvarchar20
10T158VInv. Mngmt - General: Transaction/Event Types Allowed1VGARTTransaction/Event Typenvarchar20
11T158WLong Text for Transaction/Event Type2VGARTTransaction/Event Typenvarchar20
12T159MInv. Managmt Print Function: Active Form Version, Labels3VGARTTransaction/Event Typenvarchar20
13T159NInvent. Mgmt Print Function: Active Form Versions4VGARTTransaction/Event Typenvarchar20
14T159RIM Document Reorganization - Life of Documents3VGARTTransaction/event type with masked entrynvarchar20
15T169SAP Transaction Control, Invoice Verification/Valuation3VGARTTransaction Type in AG08 (Internal Document Type)nvarchar20
16ZAC99000Senderstruktur AC990002VGARTnvarchar10
TOPActual CostingMaterial Ledger
17MLARC_IDXIndex for ML Document10VGARTMaterial ledger: transaction typenvarchar20
18MLHDMaterial Ledger Document: Header4VGARTMaterial ledger: transaction typenvarchar20
19T003LTransaction Type for Material Ledger2VGARTMaterial ledger: transaction typenvarchar20
TOPBalance Sheet Valuation Procedures
20MYSEG_EXTRACTDocument Segment: Material11VGARTTransaction/Event Typenvarchar20
TOPConditions
21B070Transaction/print vers./print ind./label type/label form4VGARTTransaction/Event Typenvarchar20
22B072Transaction/Printed Version/Print ID4VGARTTransaction/Event Typenvarchar20
23B073Transaction/Print Vers./Print Ind./SHKZG4VGARTTransaction/Event Typenvarchar20
TOPData Retention Tool
24TXW_S_MKPFRetrieve MKPF from archive11VGARTTransaction/Event Typenvarchar20
TOPGermany
25PA0123Infotype 0123 (Default Disrup. Ev.-SI Income Thresh.Deficit24VGARTStandard Type of Disruptive Event SI in Infotype 0123nvarchar10
TOPHydrocarbon Product Management
26OIB09Log for missing MSEGO1 and MSEGO2 documents13VGARTTransaction/Event Typenvarchar20
TOPInventory Management
27IKPFHeader: Physical Inventory Document4VGARTTransaction/Event Typenvarchar20
28MARIShort document: material movement11VGARTTransaction/Event Typenvarchar20
29MKPFHeader: Material Document4VGARTTransaction/Event Typenvarchar20
30MWMKPFHeader Table for the Interface6VGARTTransaction/Event Typenvarchar20
31MWXVM07MFields: Update Control of Module Pool SAPMM07M76VGARTTransaction/Event Typenvarchar20
32MWZVM07MFields: Update Control of Module Pool SAPMM07M76VGARTTransaction/Event Typenvarchar20
33T159LDefault values for inventory management and physical invent.12VGARTTransaction/Event Typenvarchar20
TOPInvoice Verification
34RBKPDocument Header: Invoice Receipt11VGARTTransaction Type in AG08 (Internal Document Type)nvarchar20
35T003RNumber Ranges RE_BELEG (Logistics Invoice Verification)2VGARTTransaction Type in AG08 (Internal Document Type)nvarchar20
TOPMaterials Management
36/SAPNEA/ROWAChargeable component consumptions38VGARTTransaction/Event Typenvarchar20
37ROWAIndex table : Chargeable component consumptions38VGARTTransaction/Event Typenvarchar20
TOPRecycling Administration Core Functions
38J_7LC13REA Data Filters: Transaction Types3VGARTTransaction/Event Typenvarchar20
TOPTariffs, Duties and Permits
39OIH03Excise duty posting control6VGARTTransaction/Event Typenvarchar20