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

79 columns | Print definition?ERP 6.0  | DISPO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00U3SID-Tabelle fuer MRP Controller4DISPOMRP Controller (Materials Planner)nvarchar30
2/SMERP/STG_MM001Data staging - Material master plant view complex table212DISPOMRP Controller (Materials Planner)nvarchar30
3B065MRP Controller5DISPOMRP Controller (Materials Planner)nvarchar30
4S025ES025 - Structural information4DISPOMRP controller for the ordernvarchar30
5SDM_AORSDM Area of Responsibility4DISPOMRP Controller (Materials Planner)nvarchar30
6T449USettings for Collective Display of MRP List4DISPOMRP Controller (Materials Planner)nvarchar30
7T496TPrint PP shop papers: Transaction control5DISPOPrint control: MRP groupnvarchar30
8ZARIXPP1PP_ORDER : Indextabelle zur Selektion von Datenobjekten10DISPODisponent für Auftragnvarchar30
TOPBasic Data
9TN40AIS-H: Text for Scheduling Type5DISPOIS-H: Scheduling Type for Visit Schedulingnvarchar80
10TN40BIS-H: Scheduling Types4DISPOIS-H: Scheduling Type for Visit Schedulingnvarchar80
TOPBills of Material
11T414Explosion Types2DISPOExplosion typenvarchar20
12T414TExplosion type description3DISPOExplosion typenvarchar20
TOPConditions
13B033MRP Controller6DISPOMRP Controller (Materials Planner)nvarchar30
TOPConfirmations
14AFFWGoods Movements with Errors from Confirmations50DISPOMRP Controller (Materials Planner)nvarchar30
TOPConsumption-Based Planning See Also PP-MRP
15DBPRONReproc. of Forecast Errors and Excpn Messages with MRP Area2DISPOMRP Controller (Materials Planner)nvarchar30
TOPCross-Application Components
16MMARCPlant Data for Material16DISPOMRP Controller (Materials Planner)nvarchar30
TOPData Collection
17S023SFIS: Totals Records for Material9DISPOMRP controller for the ordernvarchar30
18S023ES023 - Structure information4DISPOMRP controller for the ordernvarchar30
19S025SFIS: Run Schedule9DISPOMRP controller for the ordernvarchar30
20S028Reporting Point Statistics9DISPOMRP controller for the ordernvarchar30
21S028ES028 - Structural Information4DISPOMRP controller for the ordernvarchar30
22S032Statistics: Current Stock and Grouping Terms10DISPOMRP Controller (Materials Planner)nvarchar30
23S039Statistics: Inventory Controlling11DISPOMRP Controller (Materials Planner)nvarchar30
24S039ES039 - Structural Information6DISPOMRP Controller (Materials Planner)nvarchar30
25S094ES094 - Structural Information5DISPOMRP Controller (Materials Planner)nvarchar30
26S194MRP: Business Info Warehouse10DISPOMRP Controller (Materials Planner)nvarchar30
27S194BIW1S194BIW1 * MRP: Business Info Warehouse5DISPOMRP Controller (Materials Planner)nvarchar30
28S225Goods receipts: repetitive manufacturing9DISPOMRP controller for the ordernvarchar30
29S225ES225 - Structural Information4DISPOMRP controller for the ordernvarchar30
TOPDefense Forces and Public Security
30/ISDFPS/ZEBANCopy of EBAN54DISPOMRP Controller (Materials Planner)nvarchar30
TOPGlobal Trade Services
31/SAPSLL/BOMHDSLL: BOM - Header12DISPOLow-Level Codedecimal30
32/SAPSLL/BOMITSLL: BOM - Item8DISPOLow-Level Codedecimal30
33/SAPSLL/RXPMRe-Export: Log: Products9DISPOLow-Level Codedecimal30
34/SAPSLL/RXPMRARe-Export: Log: Assemblies in Bill of Product12DISPOLow-Level Codedecimal30
35/SAPSLL/RXPMRACRe-Export: Log: Components in Assembly9DISPOLow-Level Codedecimal30
TOPInformation System
36MCAFKOVVersions: Order Header Data - PP Orders14DISPOMRP controller for the ordernvarchar30
37MCSFISR/2 SFIS Data: Old22DISPOMRP controller for the ordernvarchar30
TOPInventory Controlling
38PRONPostprocessing of forecast errors and exception messages2DISPOMRP Controller (Materials Planner)nvarchar30
39S094Stock/Requirements Analysis10DISPOMRP Controller (Materials Planner)nvarchar30
TOPInventory Management
40MWXVM07MFields: Update Control of Module Pool SAPMM07M55DISPOMRP Controller (Materials Planner)nvarchar30
41MWZVM07MFields: Update Control of Module Pool SAPMM07M55DISPOMRP Controller (Materials Planner)nvarchar30
TOPMaster Data
42MDCOVTable with Range of Coverage Information7DISPOMRP Controller (Materials Planner)nvarchar30
43MDDMAPMapping Table for External User for MRP Evaluations5DISPOMRP Controller (Materials Planner)nvarchar30
44MDKPHeader Data for MRP Document29DISPOMRP Controller (Materials Planner)nvarchar30
45MDKPDBHeader Data for MRP Document30DISPOMRP Controller (Materials Planner)nvarchar30
46MDMAMRP Area for Material7DISPOMRP Controller (Materials Planner)nvarchar30
47MDMULTLEVDELAYMultilevel Delay Calculated via Order Report20DISPOMRP Controller (Materials Planner)nvarchar30
48PLAFPlanned Order17DISPOMRP Controller (Materials Planner)nvarchar30
49SAFKRun Schedule Master Data23DISPOMRP controller of the run schedule headernvarchar30
50T024DMRP controllers3DISPOMRP Controller (Materials Planner)nvarchar30
TOPMaterial Master
51MARCPlant Data for Material16DISPOMRP Controller (Materials Planner)nvarchar30
52MARC_TMPFile for Incorrect Data in Direct Input19DISPOMRP Controller (Materials Planner)nvarchar30
53MDIPMaterial: MRP Profiles (Field Contents)4DISPOMRP Controller (Materials Planner)nvarchar30
54MVRCCross-version fields for MARC16DISPOMRP Controller (Materials Planner)nvarchar30
TOPMaterial Requirements Planning
55CIFMDMAVRVersions of Table MDMA8DISPOMRP Controller (Materials Planner)nvarchar30
TOPMaterials Management
56/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions59DISPOMRP Controller (Materials Planner)nvarchar30
57/ISDFPS/ORG_UM_WCross-Plant Reorganizations15DISPOMRP Controller (Materials Planner)nvarchar30
TOPNetwork and Activity
58TCN41Network Defaults26DISPOMRP controller for the ordernvarchar30
59TCN61Parameter: Create network from sales order10DISPOMRP controller for the ordernvarchar30
TOPPatient Management
60NTPGPIS-H: Day program items (possible appointments)4DISPOIS-H: Scheduling Type for Visit Schedulingnvarchar80
61TN40CIS-H: Alternative Scheduling Types4DISPOIS-H: Scheduling Type for Visit Schedulingnvarchar80
TOPPOS Interface
62WVFBDRS Interface, Intermediate Buffer, Order Item FM13DISPOMRP Controller (Materials Planner)nvarchar30
TOPProduct Cost Planning
63KALMCosting Run: Costing Objects40DISPOMRP Controller (Materials Planner)nvarchar30
64KALOCosting Run: Costing Objects (KVMK)36DISPOMRP Controller (Materials Planner)nvarchar30
TOPProduction Orders
65AFKOOrder Header Data PP Orders44DISPOMRP controller for the ordernvarchar30
66COCF_CU_PRCHECKCustomizing Table for Problem Check by Production Supervisor5DISPOMRP controller for the ordernvarchar30
67COCF_CU_PRCHECKTTexts for Checking Production Supervisor Problems6DISPOMRP controller for the ordernvarchar30
68T496PPrint PP documents: Determination of output device5DISPOPrint control: MRP groupnvarchar30
TOPPurchasing
69EBANPurchase Requisition54DISPOMRP Controller (Materials Planner)nvarchar30
70MEREQXPurchase Requisition Change Parameter54DISPOUpdated information in related user data fieldnvarchar10
TOPSales Plan
71SAUFSOP Orders10DISPOMRP Controller (Materials Planner)nvarchar30
TOPSAP Retail Store
72WOSASAP Retail Store, Store Orders: Entities Table7DISPOMRP Controller (Materials Planner)nvarchar30
TOPSimulation
73VSAFKO_CNVersion: Order header data for PP orders45DISPOMRP controller for the ordernvarchar30
74VSEBAN_CNVersion: Purchase requisition55DISPOMRP Controller (Materials Planner)nvarchar30
75VSPLAF_CNVersion: Planned order18DISPOMRP controllernvarchar30
TOPTraining and Event Management
76HRP1023Infotype 1023 DB table20DISPOAmount availabledecimal52
77HRPAD22Additional data PAD224DISPOAmount availabledecimal52
TOPVendor Master
78LFM2Vendor Master Record: Purchasing Data33DISPOMRP Controller (Materials Planner)nvarchar30
79WYT5Changes to Vendor Master Record24DISPOMRP Controller (Materials Planner)nvarchar30