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

34 columns | Print definition?ERP 6.0  | COMPL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table384COMPLThis field is no longer usednvarchar20
2ZEIMMARAUSING FOR STORING EIM MARA DATAS120COMPLMaterial completion levelnvarchar20
TOPBusiness Planning and Simulation
3UPS_REALIGNLogging of Hierarchy Conversions as of 3.54COMPLBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPContract Accounts Receivable and Payable
4DFKKOPUSTAXOUT00Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
5DFKKOPUSTAXOUT01Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
6DFKKOPUSTAXOUT02Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
7DFKKOPUSTAXOUT03Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
8DFKKOPUSTAXOUT04Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
9DFKKOPUSTAXOUT05Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
10DFKKOPUSTAXOUT06Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
11DFKKOPUSTAXOUT07Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
12DFKKOPUSTAXOUT08Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
13DFKKOPUSTAXOUT09Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
14DFKKOPUSTAXOUT10Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
15DFKKOPUSTAXOUT11Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
16DFKKOPUSTAXOUT12Tax Details - Telecommunications Tax (U.S.A.)15COMPLCompliance Indicatornvarchar10
TOPCross-Application Components
17MMARAGeneral material data120COMPLMaterial completion levelnvarchar20
18MMARCPlant Data for Material188COMPLThis field is no longer usednvarchar20
TOPData Collection
19CF751MCBLUE50COMPLComplaintsdecimal153
TOPExpenditure Certification
20FMEUFEXPCertified Expenditure Documents26COMPLDocument Line Item Completely Certifiednvarchar10
21FMEUFFNSFinancing Source28COMPLCompletion Indicatornvarchar10
TOPGlobal Trade Services
22/SAPSLL/CUPEDSupplementary Customs Declaration Header19COMPLIndicates a Completed Supplementary Customs Declarationnvarchar10
TOPLine Maintenance
23/ISDFPS/CLMSTADCustomizing Table: Maintenance Status "Signed"6COMPLSignednvarchar10
TOPMaterial Master
24MARAGeneral Material Data120COMPLMaterial completion levelnvarchar20
25MARA_TMPFile for Incorrect Data in Direct Input127COMPLMaterial completion levelnvarchar20
26MARCPlant Data for Material188COMPLThis field is no longer usednvarchar20
27MARC_TMPFile for Incorrect Data in Direct Input191COMPLThis field is no longer usednvarchar20
28MVRACross-version fields for MARA120COMPLMaterial completion levelnvarchar20
29MVRCCross-version fields for MARC188COMPLThis field is no longer usednvarchar20
TOPPatient Accounting
30NFALACPIS-H: Case Accrual per Day24COMPLIS-H: Case is Closed for Daily Revenue Accrualnvarchar10
TOPPlanning
31T8PL01FI-Planning: Summary Table Dimensions to be Planned14COMPLCO planning processor: dimension complement permittednvarchar10
TOPSAP Retail Store
32TREC_FORC_COMPLTemporary data for the receiving forecast5COMPLProcessing status of output as traffic lightnvarchar400
TOPSouth Africa
33T5W9SStatus/Level of a Labour Relation intervention process5COMPLLR Process : completion stepnvarchar10
TOPWarranty Claim Processing
34CWTY004Status for Parts that Have to Be Returned6COMPLParts to Be Returned, Delivered Completelynvarchar10