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

67 columns | Print definition?ERP 6.0  | FLGDEFAULT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
2NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
3NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
4NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
5NWS_EXT_ADPR2Transfer Structure for PRT Addresses (Centr. Address Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
6NWS_EXT_ADPRTTransfer Structure for PRT Addresses (Centr. Address Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
7NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
8NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
9NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
10NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
11NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
12NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
13NWS_EXT_ADSS2Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
14NWS_EXT_ADSSFTransfer Structure for SSF Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
15NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
16NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
17NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
18NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
19NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
20NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)4FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
21NWS_EXT_ADUR2URI address transfer structure (central address management)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
22NWS_EXT_ADURIURI address transfer structure (central address management)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
23NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
24NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)3FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
TOPAddress ManagementBusiness Address
25ADR10Printer (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
26ADR10SShadow Table: Printer (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
27ADR10S2Shadow Table 2: Printer (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
28ADR11SSF (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
29ADR11SShadow Table: SSF (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
30ADR11S2Shadow Table 2: SSF (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
31ADR12FTP and URL (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
32ADR12SShadow Table: FTP and URL (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
33ADR12S2Shadow Table 2: FTP and URL (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
34ADR13Pager (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
35ADR13SShadow Table: Pager (Business Address Services)8FLGDEFAULTFlag: this address is the default addressnvarchar10
36ADR13S2Shadow Table 2: Pager (Business Address Services)8FLGDEFAULTFlag: this address is the default addressnvarchar10
37ADR14Reserve Communication Method (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
38ADR15Reserve Communication Method (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
39ADR16Reserve Communication Method (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
40ADR2Telephone Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
41ADR2SShadow Table: Telephone Numbers (Business Address Services)8FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
42ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)8FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
43ADR3Fax Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
44ADR3SShadow table: Fax numbers (Business Address Services)8FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
45ADR3S2Shadow Table 2: Fax Numbers (Business Address Services)8FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
46ADR4Teletex Numbers (Business Address Services)6FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
47ADR4SShadow Table: Teletex Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
48ADR4S2Shadow Table 2: Teletex Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
49ADR5Telex Numbers (Business Address Services)6FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
50ADR5SShadow Table: Fax Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
51ADR5S2Shadow Table 2: Telex Numbers (Business Address Services)7FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
52ADR6E-Mail Addresses (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
53ADR6SShadow Table: SMTP Numbers (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
54ADR6S2Shadow Table 2: SMTP Numbers (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
55ADR7Remote Mail Addresses (SAP - SAP - Communication; BAS)6FLGDEFAULTFlag: this name is the default namenvarchar10
56ADR7SShadow Table: RML Addresses (Business Address Services)7FLGDEFAULTFlag: this name is the default namenvarchar10
57ADR7S2Shadow Table 2: RML Addresses (Business Address Services)7FLGDEFAULTFlag: this name is the default namenvarchar10
58ADR8X.400 Numbers (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
59ADR8SShadow Table: X.400 Numbers (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
60ADR8S2Shadow Table 2: X.400 Numbers (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
61ADR9RFC Destinations (Business Address Services)6FLGDEFAULTFlag: this address is the default addressnvarchar10
62ADR9SShadow Table: RFC Destinations (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
63ADR9S2Shadow Table 2: RFC Destination (Business Address Services)7FLGDEFAULTFlag: this address is the default addressnvarchar10
TOPMove-InOut
64ECAMIOPREMAILIS-U: Parked Document: E-Mail Addresses6FLGDEFAULTFlag: this address is the default addressnvarchar10
65ECAMIOPRTELIS-U: Pre-entry Document: Telephone Numbers8FLGDEFAULTStandard Sender Address in this Communication Typenvarchar10
TOPRecords and Case Management
66RMPS_AI_SCENScenario Definitions3FLGDEFAULTFlag: this name is the default namenvarchar10
TOPTransaction Variant and Table Control Settings
67SHDSTUSRAssignment User <--> Namespace Standard Variant4FLGDEFAULTFlag (X or Blank)nvarchar10