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

59 columns | Print definition?ERP 6.0  | FLG_NOUSE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_SUS_STG_FAXStaging address table16FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
2BBP_SUS_STG_MAILstaging mail table13FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
3BBP_SUS_STG_TELStaging table for telephone15FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
4NWS_EXT_ADFA2Transfer structure for fax numbers (central address admin.)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
5NWS_EXT_ADFAXTransfer structure for fax numbers (central address admin.)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
6NWS_EXT_ADPA2Transfer Structure for Page Numbers (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
7NWS_EXT_ADPAGTransfer Structure for Page Numbers (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
8NWS_EXT_ADPR2Transfer Structure for PRT Addresses (Centr. Address Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
9NWS_EXT_ADPRTTransfer Structure for PRT Addresses (Centr. Address Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
10NWS_EXT_ADRF2Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
11NWS_EXT_ADRFCTransfer Structure for RFC Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
12NWS_EXT_ADRM2Transfer Structure for RML Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
13NWS_EXT_ADRMLTransfer Structure for RML Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
14NWS_EXT_ADSM2Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
15NWS_EXT_ADSMTTransfer Structure for SMTP Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
16NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
17NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
18NWS_EXT_ADTL2Transfer Structure for Telex Nos (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
19NWS_EXT_ADTLXTransfer Structure for Telex Nos (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
20NWS_EXT_ADTT2Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
21NWS_EXT_ADTTXTransfer Structure for Teletex Numbers (Centr. Addr. Mgmnt)5FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
22NWS_EXT_ADX40Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
23NWS_EXT_ADX42Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt)4FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
TOPAddress ManagementBusiness Address
24ADR10Printer (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
25ADR10SShadow Table: Printer (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
26ADR10S2Shadow Table 2: Printer (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
27ADR11SSF (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
28ADR11SShadow Table: SSF (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
29ADR11S2Shadow Table 2: SSF (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
30ADR12FTP and URL (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
31ADR12SShadow Table: FTP and URL (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
32ADR12S2Shadow Table 2: FTP and URL (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
33ADR13Pager (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
34ADR13SShadow Table: Pager (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
35ADR13S2Shadow Table 2: Pager (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
36ADR2Telephone Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
37ADR2SShadow Table: Telephone Numbers (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
38ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
39ADR3Fax Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
40ADR3SShadow table: Fax numbers (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
41ADR3S2Shadow Table 2: Fax Numbers (Business Address Services)9FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
42ADR4Teletex Numbers (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
43ADR4SShadow Table: Teletex Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
44ADR4S2Shadow Table 2: Teletex Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
45ADR5Telex Numbers (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
46ADR5SShadow Table: Fax Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
47ADR5S2Shadow Table 2: Telex Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
48ADR6E-Mail Addresses (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
49ADR6SShadow Table: SMTP Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
50ADR6S2Shadow Table 2: SMTP Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
51ADR7Remote Mail Addresses (SAP - SAP - Communication; BAS)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
52ADR7SShadow Table: RML Addresses (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
53ADR7S2Shadow Table 2: RML Addresses (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
54ADR8X.400 Numbers (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
55ADR8SShadow Table: X.400 Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
56ADR8S2Shadow Table 2: X.400 Numbers (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
57ADR9RFC Destinations (Business Address Services)7FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
58ADR9SShadow Table: RFC Destinations (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10
59ADR9S2Shadow Table 2: RFC Destination (Business Address Services)8FLG_NOUSEFlag: This Communication Number is Not Usednvarchar10