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

29 columns | Print definition?ERP 6.0  | CANCELLED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/CT_IDH_LOGInbound Document Handler: Document Log13CANCELLEDOption Execute Cancellednvarchar10
2/SAPQUERY/T200Single Flight Booking20CANCELLEDCancelation flagnvarchar10
3/SAPQUERY/T211Single Container Flight Booking20CANCELLEDCancelation flagnvarchar10
4DAAG_SBOOKSingle Flight Booking20CANCELLEDCancelation flagnvarchar10
TOPABAP Workbench, Java IDE and Infrastructure
5SBOOKSingle Flight Booking20CANCELLEDCancelation flagnvarchar10
TOPArchiving Engine
6TARCHBOOKArchiving Example: Flight Bookings20CANCELLEDCancelation flagnvarchar10
TOPClaims Management
7ICLLITHEADERLitigation24CANCELLEDStatus "Cancelled"nvarchar10
8ICLLITITEMLitigation Level25CANCELLEDStatus "Cancelled"nvarchar10
9ICL_NEGNegotiation22CANCELLEDStatus "Cancelled"nvarchar10
10ICL_NEGITOffer / Demand17CANCELLEDStatus "Cancelled"nvarchar10
11ICL_NEGITSOffer / Demand (Shadow Table)17CANCELLEDStatus "Cancelled"nvarchar10
12ICL_NEGSNegotiation (Shadow Table)22CANCELLEDStatus "Cancelled"nvarchar10
13ICSLITHEADERLitigation24CANCELLEDStatus "Cancelled"nvarchar10
14ICSLITITEMLitigation Levels25CANCELLEDStatus "Cancelled"nvarchar10
TOPClinical System
15N2VDNOTEIS-H*MED PD: Progress Entry10CANCELLEDIS-H: Cancellation Indicatornvarchar10
TOPContract Accounts Receivable and Payable
16TRM001IAccount Balance: List Types for Bills7CANCELLEDIndicator: Read reversed bills?nvarchar10
TOPCross-Application Components
17BC402_SBOOKIndividual Flight Booking20CANCELLEDCancelation flagnvarchar10
TOPCustomer Service
18EINIDATCRInit. Data Cr. Doc.: Premise - Header Data3CANCELLEDIndicator: initial data creation document was cancelednvarchar10
TOPExcise Duty
19/BEV2/CS_MSEGARCEMCS Process: ARC in Material Document Items7CANCELLEDEMCS Process Cancellednvarchar10
20/BEV2/CS_MSEGA_HEMCS Process: ARC in Material Document Items - History8CANCELLEDEMCS Process Cancellednvarchar10
TOPFinancial Accounting
21/OPT/VIM_1LOGDocument Log16CANCELLEDOption Execute Cancellednvarchar10
22/OPT/VIM_8LOGOpenText VIM Document Log10CANCELLEDOption Execute Cancellednvarchar10
TOPInvoice Forecasting
23IFW_HEADERInvoice forecasting header13CANCELLEDBilling document is cancellednvarchar10
TOPLocalization
24ISJPINVSUMHDInvoice Summary Header24CANCELLEDCancellednvarchar10
TOPSAP Business Workflow
25SWPNODEWFM: Node Properties and Node Hierarchy at Runtime12CANCELLEDWFM: Indicator that component was cancelednvarchar10
26SWP_JOINWorkflow instances: Join node of a workflow execution13CANCELLEDInternal Data Elementnvarchar10
TOPSAP Utilities
27EIUBILLDOCS_PRProfile used for the ISUBILLAG role3CANCELLEDCancellednvarchar10
28EIUPRINTDOCS_PRProfile for Billing & Consumption4CANCELLEDCancellednvarchar10
TOPWorkforce Management Core
29WFDSD_DEMANDWork Force Deployment Demand10CANCELLEDService Order Item is cancellednvarchar20