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

52 columns | Print definition?ERP 6.0  | CITY2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values6CITY2Districtnvarchar400
2/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI23CITY2Districtnvarchar400
3/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh23CITY2Districtnvarchar400
4/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table23CITY2Districtnvarchar400
5/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program24CITY2Districtnvarchar400
6/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE23CITY2Districtnvarchar400
7/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE23CITY2Districtnvarchar400
8/FLDQ/AD_PUPDATEMatchcode Records pending to be updated23CITY2Districtnvarchar400
9/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting20CITY2Districtnvarchar400
10/FLDQ/AD_QU_INDXQU2 Index Table16CITY2Districtnvarchar400
11/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK7CITY2Districtnvarchar400
12/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK7CITY2Districtnvarchar400
13/FLDQ/HNA_BM_INHANA task Batch Match Input Records16CITY2Districtnvarchar400
14/FLDQ/HNA_PREQU2staging table for RSADRQU2 report16CITY2locality with increased size to stop truncationnvarchar2000
15/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report16CITY2locality with increased size to stop truncationnvarchar2000
16CNVTDMS_11_SCADRScrambling Addresses9CITY2Districtnvarchar400
17T7PIQ_NL_INSTITInstitutes and Education Details22CITY2Citynvarchar400
TOPAddress ManagementBusiness Address
18ADRCAddresses (Business Address Services)14CITY2Districtnvarchar400
19ADRCSShadow Table: Addresses (Business Address Services)15CITY2Districtnvarchar400
20ADRCS2Shadow Table 2: Addresses (Business Address Services)16CITY2Districtnvarchar400
TOPBank Customer Accounts
21BCA_US_BC_ADDRAddresses Associated with Bank Cheques33CITY2Districtnvarchar400
TOPBasic Functions
22FSLSAForeign Trade: Legal Control-Sanctioned Party List-Address10CITY2Districtnvarchar400
TOPBasis Components
23/XFT/INV_Q_6PO details (header) for an invoice receipt process33CITY2Districtnvarchar400
24/XFT/INV_Q_6_SPO details (header) for an invoice receipt process33CITY2Districtnvarchar400
TOPContract Accounts Receivable and Payable
25DFKKGP_SHORTData Extract: BP Data8CITY2Districtnvarchar400
26DFKKZAXRepayment Request (Address Data for Check)6CITY2Districtnvarchar400
27FKK_GPSHADData Extract: Business Partner Data (Faster Access)16CITY2Districtnvarchar400
TOPFinancial Accounting
28AC400ADRCP01 Adressen für Programm AC400DEBITOR14CITY2Ortsteilnvarchar400
TOPGlobal Trade Services
29/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit21CITY2Districtnvarchar400
30/SAPSLL/SPLAUDLegal Control - SPL - Audit54CITY2Districtnvarchar400
TOPLocalization
31J_1BNFCPDNota Fiscal one-time accounts34CITY2Districtnvarchar400
TOPMaster Data
32EFISELField Selection Control for Address Data15CITY2City districtnvarchar10
33TECHSTRChanges to Street Names5CITY2City districtnvarchar400
TOPMove-InOut
34ECAMIOPRADDRIS-U: Parked Document: Addresses (Business Partner)17CITY2Districtnvarchar400
TOPOffer and Rental Request
35VIOROOOffered Object65CITY2Districtnvarchar400
36VIORRRRental Request77CITY2Districtnvarchar400
TOPPatient Accounting
37NEHC_PATIS-H: Health Insurance Card (Patient Data)54CITY2Districtnvarchar400
TOPPersonnel Administration
38T7PLD1Payee data19CITY2Districtnvarchar400
TOPPublic Sector Contract Accounts Receivable and Payable
39DFMCA_BRF540BRF: Create Address for Business Partner11CITY2BRF: Expressionnvarchar200
40DFMCA_BRF750BRF: Address Check8CITY2BRF: Expressionnvarchar200
41DFMCA_BRF760BRF: Read Location8CITY2BRF: Expressionnvarchar200
42DFMCA_BRF770BRF: Create Location12CITY2BRF: Expressionnvarchar200
43DFMCA_BRF820BRF: Address Autocorrection10CITY2Field Namenvarchar300
TOPSales Promotions
44SADLSTRECBDynamic Part of Address List (Record Body)30CITY2Districtnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
45TN50ADefault Values for ASL and ISTAT Code5CITY2Districtnvarchar400
TOPSAP NetWeaver Mobile - Use subcomponents
46MEREP_ADDRESSAddress (Sample Application)5CITY2City2 (Sample Application)nvarchar400
TOPStakeholder Relationship Management
47USC_CONT_ADDSRM Contact: Event Info13CITY2Districtnvarchar400
TOPUse AP-MD-BP Components
48BUTADRSEARCHMass Search Help: Business Partner21CITY2Districtnvarchar400
TOPWaste Management
49EHSWAT_APPBPMD: Waste Permit Partner33CITY2Districtnvarchar400
50EHSWAT_MNBPWaste Manifest/Delivery Note: Partners30CITY2Districtnvarchar400
51EPROP_ADRFLD_SELField Selection Control for Address Screen of Property15CITY2City districtnvarchar10
52EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object15CITY2City districtnvarchar10