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

35 columns | Print definition?ERP 6.0  | TEL_EXTENS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
2/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
3/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
4/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program52TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
5/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
6/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
7/FLDQ/AD_PUPDATEMatchcode Records pending to be updated51TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
8/FLDQ/HNA_BM_INHANA task Batch Match Input Records44TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
9CNVTDMS_11_SCADRScrambling Addresses27TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
10NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)8TEL_EXTENSTelephone no.: Extensionnvarchar100
11NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)8TEL_EXTENSTelephone no.: Extensionnvarchar100
TOPAddress ManagementBusiness Address
12ADCPPerson/Address Assignment (Business Address Services)22TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
13ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)23TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
14ADR2Telephone Numbers (Business Address Services)11TEL_EXTENSTelephone no.: Extensionnvarchar100
15ADR2SShadow Table: Telephone Numbers (Business Address Services)12TEL_EXTENSTelephone no.: Extensionnvarchar100
16ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)12TEL_EXTENSTelephone no.: Extensionnvarchar100
17ADRCAddresses (Business Address Services)61TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
18ADRCSShadow Table: Addresses (Business Address Services)62TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
19ADRCS2Shadow Table 2: Addresses (Business Address Services)63TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
TOPBank Customer Accounts
20BCA_US_BC_ADDRAddresses Associated with Bank Cheques52TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
TOPBasis Components
21/XFT/INV_Q_6PO details (header) for an invoice receipt process53TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
22/XFT/INV_Q_6_SPO details (header) for an invoice receipt process53TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
TOPClaims Management
23ICLX_PARTICIPANTError Table for Participants with XI Input25TEL_EXTENSParticipant: Participant Phone Number Extensionnvarchar100
TOPContract Accounts Receivable and Payable
24FKK_GPSHADData Extract: Business Partner Data (Faster Access)26TEL_EXTENSTelephone no.: Extensionnvarchar100
TOPDSD Connector
25/DSD/ME_CONTACTDSD Connector: Contact Person24TEL_EXTENSDSD Connector: Extensionnvarchar100
TOPFinancial Accounting
26AC400ADRCP01 Adressen für Programm AC400DEBITOR61TEL_EXTENSErste Telefon-Nr.: Durchwahlnvarchar100
TOPGlobal Trade Services
27/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit80TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
TOPLocalization
28J_1BNFCPDNota Fiscal one-time accounts92TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
TOPMove-InOut
29ECAMIOPRTELIS-U: Pre-entry Document: Telephone Numbers7TEL_EXTENSTelephone no.: Extensionnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
30DFMCA_BRF540BRF: Create Address for Business Partner28TEL_EXTENSBRF: Expressionnvarchar200
TOPPurchasing
31T024Purchasing Groups8TEL_EXTENSTelephone no.: Extensionnvarchar100
TOPUse AP-MD-BP Components
32BUT051BP Relationship: Contact Person Relationship16TEL_EXTENSTelephone no.: Extensionnvarchar100
33BUT051SShadow Table BP Relationship: Contact Person Relationship17TEL_EXTENSTelephone no.: Extensionnvarchar100
TOPWaste Management
34EHSWAT_APPBPMD: Waste Permit Partner49TEL_EXTENSFirst Telephone No.: Extensionnvarchar100
35EHSWAT_MNBPWaste Manifest/Delivery Note: Partners46TEL_EXTENSFirst Telephone No.: Extensionnvarchar100