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

46 columns | Print definition?ERP 6.0  | R3_USER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)13R3_USERFlag: Connected to an SAP Systemnvarchar10
2NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)13R3_USERFlag: Connected to an SAP Systemnvarchar10
3NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)12R3_USEREncoded Reference to a Sequence Numbernvarchar10
4NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)12R3_USEREncoded Reference to a Sequence Numbernvarchar10
5NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)8R3_USERFlag: Connected to an SAP Systemnvarchar10
6NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)8R3_USERFlag: Connected to an SAP Systemnvarchar10
7NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)11R3_USERFlag: Connected to an SAP Systemnvarchar10
8NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)11R3_USERFlag: Connected to an SAP Systemnvarchar10
9NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
10NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
11NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)12R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10
12NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)12R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10
13NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
14NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
15NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
16NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)9R3_USERFlag: Connected to an SAP Systemnvarchar10
17NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)31R3_USERFlag: Connected to an SAP Systemnvarchar10
18NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)31R3_USERFlag: Connected to an SAP Systemnvarchar10
TOPAddress ManagementBusiness Address
19ADR13Pager (Business Address Services)15R3_USEREncoded Reference to a Sequence Numbernvarchar10
20ADR13SShadow Table: Pager (Business Address Services)16R3_USEREncoded Reference to a Sequence Numbernvarchar10
21ADR13S2Shadow Table 2: Pager (Business Address Services)16R3_USEREncoded Reference to a Sequence Numbernvarchar10
22ADR2Telephone Numbers (Business Address Services)15R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10
23ADR2SShadow Table: Telephone Numbers (Business Address Services)16R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10
24ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)16R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10
25ADR3Fax Numbers (Business Address Services)16R3_USERFlag: Connected to an SAP Systemnvarchar10
26ADR3SShadow table: Fax numbers (Business Address Services)17R3_USERFlag: Connected to an SAP Systemnvarchar10
27ADR3S2Shadow Table 2: Fax Numbers (Business Address Services)17R3_USERFlag: Connected to an SAP Systemnvarchar10
28ADR4Teletex Numbers (Business Address Services)11R3_USERFlag: Connected to an SAP Systemnvarchar10
29ADR4SShadow Table: Teletex Numbers (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
30ADR4S2Shadow Table 2: Teletex Numbers (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
31ADR5Telex Numbers (Business Address Services)11R3_USERFlag: Connected to an SAP Systemnvarchar10
32ADR5SShadow Table: Fax Numbers (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
33ADR5S2Shadow Table 2: Telex Numbers (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
34ADR6E-Mail Addresses (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
35ADR6SShadow Table: SMTP Numbers (Business Address Services)13R3_USERFlag: Connected to an SAP Systemnvarchar10
36ADR6S2Shadow Table 2: SMTP Numbers (Business Address Services)13R3_USERFlag: Connected to an SAP Systemnvarchar10
37ADR7Remote Mail Addresses (SAP - SAP - Communication; BAS)14R3_USERFlag: Connected to an SAP Systemnvarchar10
38ADR7SShadow Table: RML Addresses (Business Address Services)15R3_USERFlag: Connected to an SAP Systemnvarchar10
39ADR7S2Shadow Table 2: RML Addresses (Business Address Services)15R3_USERFlag: Connected to an SAP Systemnvarchar10
40ADR8X.400 Numbers (Business Address Services)10R3_USERFlag: Connected to an SAP Systemnvarchar10
41ADR8SShadow Table: X.400 Numbers (Business Address Services)11R3_USERFlag: Connected to an SAP Systemnvarchar10
42ADR8S2Shadow Table 2: X.400 Numbers (Business Address Services)11R3_USERFlag: Connected to an SAP Systemnvarchar10
43ADR9RFC Destinations (Business Address Services)11R3_USERFlag: Connected to an SAP Systemnvarchar10
44ADR9SShadow Table: RFC Destinations (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
45ADR9S2Shadow Table 2: RFC Destination (Business Address Services)12R3_USERFlag: Connected to an SAP Systemnvarchar10
TOPMove-InOut
46ECAMIOPRTELIS-U: Pre-entry Document: Telephone Numbers9R3_USERIndicator: Telephone is a Mobile Telephonenvarchar10