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

53 columns | Print definition?ERP 6.0  | STAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TKAUMMilestones for CO Object Conversions6STANDVariable textnvarchar600
TOPAdvertising Management
2TJJV10IS-M: Components That Are Not To Be Read: Applications14STANDIS-M: Indicator for Excluding Componentsnvarchar10
3TJJV10CIS-M: Components That Are Not To Be Read14STANDIS-M: Indicator for Excluding Componentsnvarchar10
TOPAssortment Maintenance
4TWSZSubsequent processing for errors in material discontinuation4STANDStandard procedure for subsequent processing of errorsnvarchar10
TOPBank
5NBNKNumber range for banks3STANDCurrent number levelnvarchar100
TOPBasic Data
6NC00IS-HCM Dispatch Log File10STANDIS-HCM: Communications Standardnvarchar80
7NC01IS-HCM Dispatch Orders to HCM8STANDIS-HCM: Communications Standardnvarchar80
8NC02IS-HCM Messages Ready-to-Send9STANDIS-HCM: Communications Standardnvarchar80
9NC301IS-HCM: Order Table Data Transmission for EDI9STANDIS-HCM: Communications Standardnvarchar80
10NC301AIS-HCM: EDI - Obsolete! (Documentation Archive Transfers)16STANDIS-HCM: Communications Standardnvarchar80
11NC301BIS-H: EDI - Agreements with Data Collection Points15STANDIS-HCM: Communications Standardnvarchar80
12NC301DIS-HCM: EDI - Documentation Archive Transfers18STANDIS-HCM: Communications Standardnvarchar80
13NC301SIS-HCM: EDI Status Management9STANDIS-HCM: Communications Standardnvarchar80
14NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records9STANDIS-HCM: Communications Standardnvarchar80
15NCI0IS-HCM Receipt Log File6STANDIS-HCM: Communications Standardnvarchar80
16NCIFIS-HCM: Errored Inbound Messages in Original Format6STANDIS-HCM: Communications Standardnvarchar80
17TN02SIS-H: Systems and System Attributes6STANDIS-HCM: Communications Standardnvarchar80
18TNC301EEIS-H: EDI Error Messages (External)2STANDIS-HCM: Communications Standardnvarchar80
19TNC301EIIS-H: EDI Error Messages (Internal, Asgmt to Ext. Errors)1STANDIS-HCM: Communications Standardnvarchar80
20TNC301GSIS-H EDI: Assign Standards to Procedures2STANDIS-HCM: Communications Standardnvarchar80
21TNC301VERIS-H: EDI - Version Validity Period7STANDIS-HCM: Communications Standardnvarchar80
22TNCDF0IS-H: DRG Coding and Grouping System Master Data Table3STANDIS-HCM: Communications Standardnvarchar80
23TNCF0IS-HCM Message Fields1STANDIS-HCM: Communications Standardnvarchar80
24TNCF1IS-HCM Message Fields - Texts2STANDIS-HCM: Communications Standardnvarchar80
25TNCI0IS-HCM Receipt: Event - General Message Type - Assignment3STANDIS-HCM: Communications Standardnvarchar80
26TNCI1IS-HCM Receipt Parameters for Partner Systems5STANDIS-HCM: Communications Standardnvarchar80
27TNCMAPPIS-H Mapping Table, Assignment to External Codes2STANDIS-HCM: Communications Standardnvarchar80
28TNCO0IS-HCM Dispatch: Event - General Message Type - Assignment3STANDIS-HCM: Communications Standardnvarchar80
29TNCO1IS-HCM Dispatch Control Without Dependencies6STANDIS-HCM: Communications Standardnvarchar80
30TNCO2IS-HCM Dispatch Control with Org. Unit Dependency7STANDIS-HCM: Communications Standardnvarchar80
31TNCS0IS-HCM Message Segments1STANDIS-HCM: Communications Standardnvarchar80
32TNCS1IS-HCM Message Segments - Texts2STANDIS-HCM: Communications Standardnvarchar80
33TNCS2IS-HCM Message Segment - Field Assignment1STANDIS-HCM: Communications Standardnvarchar80
34TNCS3IS-HCM: Segment-to-Group Segment Assignment1STANDIS-HCM: Communications Standardnvarchar80
35TNCSTIS-HCM Communication Standards1STANDIS-HCM: Communications Standardnvarchar80
36TNCSUIS-HCM Communication Standards - Texts2STANDIS-HCM: Communications Standardnvarchar80
37TNCT0IS-HCM Message Types1STANDIS-HCM: Communications Standardnvarchar80
38TNCT1IS-HCM Message Types - Texts2STANDIS-HCM: Communications Standardnvarchar80
39TNCT2IS-HCM Message Type-Segment Assignment1STANDIS-HCM: Communications Standardnvarchar80
TOPBasic Functions
40NKAPNumber Range for Contact Partner2STANDStatus of number assignment for contact personnvarchar120
TOPBatches
41TBICUGBatch Information Cockpit User Groups3STANDStandard user group in Batch Information Cockpitnvarchar10
TOPClassification
42TCLAClass Types9STANDStandard Class Typenvarchar10
TOPClinical System
43NC321IS-H: Table for data exchange of §3219STANDIS-HCM: Communications Standardnvarchar80
TOPCross-Application Components
44CCRHDWork Center Header37STANDWork center locationnvarchar100
TOPDevice Management
45EANASIS-U Device Checker: Current Processing Status of Test7STANDElement Last Testednvarchar300
TOPFinancial Accounting
46NKUKNumber range for change documents5STANDLast Change Numberdecimal80
TOPGeneral status management
47TONRNumber status: general object number3STANDNumber status: general object numbernvarchar200
TOPPeriodical Sales and Distribution
48TJF31IS-M/SD: Collective Transfer Run to RF/FI15STANDIS-M: 6-digit sequence numbernvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
49NCSSNCommunication Table (Item) to SSN6STANDIS-HCM: Communications Standardnvarchar80
50TNWAT_EDI_CODESIS-H AT: EDIVKA EDI Verfahren Codelisten2STANDIS-HCM Kommunikationsstandardnvarchar80
TOPWarehouse Management
51NKLVNumber ranges in WM7STANDCurrent number level within number rangenvarchar100
TOPWork Center
52CRHDWork Center Header37STANDWork center locationnvarchar100
53T499SLocation3STANDLocationnvarchar100