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

24 columns | Print definition?ERP 6.0  | UPDATEFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)17UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
2NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)17UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
3NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)16UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
4NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)16UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
5NWS_EXT_ADPR2Transfer Structure for PRT Addresses (Centr. Address Mgmnt)11UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
6NWS_EXT_ADPRTTransfer Structure for PRT Addresses (Centr. Address Mgmnt)11UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
7NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)12UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
8NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)12UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
9NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)15UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
10NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)15UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
11NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)15UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
12NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)15UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
13NWS_EXT_ADSS2Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt)12UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
14NWS_EXT_ADSSFTransfer Structure for SSF Addresses (Centr. Addr. Mgmnt)12UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
15NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)16UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
16NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)16UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
17NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)13UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
18NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)13UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
19NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)13UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
20NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)13UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
21NWS_EXT_ADUR2URI address transfer structure (central address management)9UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
22NWS_EXT_ADURIURI address transfer structure (central address management)9UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
23NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)37UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10
24NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)37UPDATEFLAGChange operation code ('I'nsert, 'U'pdate, 'D'elete)nvarchar10