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

43 columns | Print definition?ERP 6.0  | TEL_NUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
2/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
3/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
4/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program51TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
5/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
6/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
7/FLDQ/AD_PUPDATEMatchcode Records pending to be updated50TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
8/FLDQ/HNA_BM_INHANA task Batch Match Input Records43TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
9BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address64TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
10CNVTDMS_11_SCADRScrambling Addresses26TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
11NWS_EXT_ADTE2Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt)7TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
12NWS_EXT_ADTELTransfer Structure for Telephone Nos (Centr. Addr. Mgmnt)7TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
TOPAddress ManagementBusiness Address
13ADCPPerson/Address Assignment (Business Address Services)21TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
14ADCPSShadow Table: Assignment Person/Addr. (Bus. Addr. Services)22TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
15ADR2Telephone Numbers (Business Address Services)10TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
16ADR2SShadow Table: Telephone Numbers (Business Address Services)11TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
17ADR2S2Shadow Table 2: Telephone Nos (Business Address Services)11TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
18ADRCAddresses (Business Address Services)60TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
19ADRCSShadow Table: Addresses (Business Address Services)61TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
20ADRCS2Shadow Table 2: Addresses (Business Address Services)62TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
TOPALE Integration Technology
21EDIPHONETelephony Data for Partner Profiles10TEL_NUMBERTelephone numbernvarchar300
TOPBank Customer Accounts
22BCA_US_BC_ADDRAddresses Associated with Bank Cheques51TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
TOPBasis Components
23/XFT/INV_Q_6PO details (header) for an invoice receipt process52TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
24/XFT/INV_Q_6_SPO details (header) for an invoice receipt process52TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
TOPClaims Management
25ICLX_PARTICIPANTError Table for Participants with XI Input24TEL_NUMBERParticipant: Participant Phone Numbernvarchar300
TOPContract Accounts Receivable and Payable
26FKK_GPSHADData Extract: Business Partner Data (Faster Access)25TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
TOPDSD Connector
27/DSD/ME_CONTACTDSD Connector: Contact Person23TEL_NUMBERDSD Connector: Tel numbernvarchar300
TOPFinancial Accounting
28AC400ADRCP01 Adressen für Programm AC400DEBITOR60TEL_NUMBERErste Telefon-Nr.: Vorwahl + Anschlußnvarchar300
TOPGlobal Trade Services
29/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit79TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
TOPLoans Management
30VDCBR_RES_DATATable of Data Reported to Credit Bureau (Per Loan)43TEL_NUMBERTelephone Number (Metro2 Format)nvarchar100
31VDCBR_RES_PARTPartner Data Reported to Credit Bureau (Pro Loan)17TEL_NUMBERTelephone Number (Metro2 Format)nvarchar100
TOPLocalization
32J_1BNFCPDNota Fiscal one-time accounts91TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
TOPMaster Data
33EFISELField Selection Control for Address Data20TEL_NUMBERFirst Telephone No.: Area Code + Numbernvarchar10
TOPMove-InOut
34ECAMIOPRTELIS-U: Pre-entry Document: Telephone Numbers6TEL_NUMBERTelephone No.: Dialling Code + Numbernvarchar300
TOPPatient Accounting
35NEHC_PATIS-H: Health Insurance Card (Patient Data)55TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
36DFMCA_BRF540BRF: Create Address for Business Partner27TEL_NUMBERBRF: Expressionnvarchar200
TOPPurchasing
37T024Purchasing Groups7TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
TOPUse AP-MD-BP Components
38BUT051BP Relationship: Contact Person Relationship15TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
39BUT051SShadow Table BP Relationship: Contact Person Relationship16TEL_NUMBERTelephone no.: dialling code+numbernvarchar300
TOPWaste Management
40EHSWAT_APPBPMD: Waste Permit Partner48TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
41EHSWAT_MNBPWaste Manifest/Delivery Note: Partners45TEL_NUMBERFirst telephone no.: dialling code+numbernvarchar300
42EPROP_ADRFLD_SELField Selection Control for Address Screen of Property20TEL_NUMBERFirst Telephone No.: Area Code + Numbernvarchar10
43EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object20TEL_NUMBERFirst Telephone No.: Area Code + Numbernvarchar10