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

63 columns | Print definition?ERP 6.0  | POST_CODE1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values13POST_CODE1City postal codenvarchar100
2/FLDQ/AD_ERRQTRTable to store address errors generated during RSADRQU211POST_CODE1City postal codenvarchar100
3/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI34POST_CODE1City postal codenvarchar100
4/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh34POST_CODE1City postal codenvarchar100
5/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table34POST_CODE1City postal codenvarchar100
6/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program35POST_CODE1City postal codenvarchar100
7/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE34POST_CODE1City postal codenvarchar100
8/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE34POST_CODE1City postal codenvarchar100
9/FLDQ/AD_PUPDATEMatchcode Records pending to be updated34POST_CODE1City postal codenvarchar100
10/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting27POST_CODE1City postal codenvarchar100
11/FLDQ/AD_QU_INDXQU2 Index Table23POST_CODE1City postal codenvarchar100
12/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK14POST_CODE1City postal codenvarchar100
13/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK14POST_CODE1City postal codenvarchar100
14/FLDQ/HNA_BM_INHANA task Batch Match Input Records27POST_CODE1City postal codenvarchar100
15/FLDQ/HNA_PREQU2staging table for RSADRQU2 report23POST_CODE1big field for output from GAC to stop truncationnvarchar1000
16/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report23POST_CODE1big field for output from GAC to stop truncationnvarchar1000
17/SAPSRM/SH_PLANTTable for ERP Search Help Plants7POST_CODE1City postal codenvarchar100
18CNVTDMS_11_SCADRScrambling Addresses11POST_CODE1City postal codenvarchar100
19J_1UF_TP_MAINMain Information of Notification12POST_CODE1City postal codenvarchar100
TOPAddress ManagementBusiness Address
20ADRCAddresses (Business Address Services)21POST_CODE1City postal codenvarchar100
21ADRCSShadow Table: Addresses (Business Address Services)22POST_CODE1City postal codenvarchar100
22ADRCS2Shadow Table 2: Addresses (Business Address Services)23POST_CODE1City postal codenvarchar100
TOPBank Customer Accounts
23BCA_US_BC_ADDRAddresses Associated with Bank Cheques35POST_CODE1City postal codenvarchar100
TOPBasic Functions
24FSLSAForeign Trade: Legal Control-Sanctioned Party List-Address11POST_CODE1City postal codenvarchar100
TOPBasis Components
25/XFT/INV_Q_6PO details (header) for an invoice receipt process34POST_CODE1City postal codenvarchar100
26/XFT/INV_Q_6_SPO details (header) for an invoice receipt process34POST_CODE1City postal codenvarchar100
TOPClaims Management
27ICLX_PARTICIPANTError Table for Participants with XI Input20POST_CODE1Participant: Participant Postal Codenvarchar100
TOPCollectionsDisbursements
28VVSCPOSESRPayment Plan Item: ISR Attachment11POST_CODE1City postal codenvarchar100
TOPContract Accounts Receivable and Payable
29DFKKCIBWFICA: Extraction of Cleared Items25POST_CODE1City postal codenvarchar100
30DFKKESRPOR Payment Supplement9POST_CODE1City postal codenvarchar100
31DFKKGP_SHORTData Extract: BP Data10POST_CODE1City postal codenvarchar100
32DFKKOPBWOI Extraction23POST_CODE1City postal codenvarchar100
33DFKKZAXRepayment Request (Address Data for Check)7POST_CODE1City postal codenvarchar100
34FKK_GPSHADData Extract: Business Partner Data (Faster Access)18POST_CODE1City postal codenvarchar100
TOPCountry-Specific Objects
35COMC_TAXJUR_CITYTax Jurisdiction codes by City4POST_CODE1City postal codenvarchar100
TOPFinancial Accounting
36AC400ADRCP01 Adressen für Programm AC400DEBITOR21POST_CODE1Postleitzahl des Ortsnvarchar100
TOPGlobal Trade Services
37/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit28POST_CODE1City postal codenvarchar100
38/SAPSLL/SPLAUDLegal Control - SPL - Audit61POST_CODE1City postal codenvarchar100
TOPLocalization
39J_1BNFCPDNota Fiscal one-time accounts41POST_CODE1City postal codenvarchar100
TOPLocations Location Structure
40EHFNDD_LOC_REVLocation - Revisions27POST_CODE1City Postal Codenvarchar100
TOPMaster Data
41EFISELField Selection Control for Address Data14POST_CODE1City postal codenvarchar10
42TECHSTRChanges to Street Names3POST_CODE1City postal codenvarchar100
TOPMove-InOut
43ECAMIOPRADDRIS-U: Parked Document: Addresses (Business Partner)12POST_CODE1City postal codenvarchar100
TOPOffer and Rental Request
44VIOROOOffered Object63POST_CODE1City postal codenvarchar100
45VIORRRRental Request75POST_CODE1City postal codenvarchar100
TOPPatient Accounting
46NEHC_PATIS-H: Health Insurance Card (Patient Data)17POST_CODE1City postal codenvarchar100
TOPPayroll
47T5HPBS06Technikai azonosító (1) - Közigazgatási szerv7POST_CODE1Helység irányítószámanvarchar100
48T5HPBS07Szervezeti egységek címe5POST_CODE1Helység irányítószámanvarchar100
TOPPortfolio
49VDBILL_RES_HEADBill Results Header33POST_CODE1City postal codenvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
50DFMCA_BRF540BRF: Create Address for Business Partner13POST_CODE1BRF: Expressionnvarchar200
51DFMCA_BRF650BRF: Business Partner Reading28POST_CODE1BRF: Expressionnvarchar200
52DFMCA_BRF750BRF: Address Check10POST_CODE1BRF: Expressionnvarchar200
53DFMCA_BRF760BRF: Read Location9POST_CODE1BRF: Expressionnvarchar200
54DFMCA_BRF770BRF: Create Location14POST_CODE1BRF: Expressionnvarchar200
55DFMCA_BRF820BRF: Address Autocorrection12POST_CODE1Field Namenvarchar300
56DFMCA_BRF890BRF: Business Partner Determination from Form29POST_CODE1BRF: Expressionnvarchar200
TOPSales Promotions
57SADLSTRECBDynamic Part of Address List (Record Body)32POST_CODE1City postal codenvarchar100
TOPUse AP-MD-BP Components
58BUTADRSEARCHMass Search Help: Business Partner14POST_CODE1City postal codenvarchar100
TOPWaste Management
59EEWA_CIC_FILTABIS-U CIC for Waste: Store Filter Data5POST_CODE1City postal codenvarchar100
60EHSWAT_APPBPMD: Waste Permit Partner34POST_CODE1City postal codenvarchar100
61EHSWAT_MNBPWaste Manifest/Delivery Note: Partners31POST_CODE1City postal codenvarchar100
62EPROP_ADRFLD_SELField Selection Control for Address Screen of Property14POST_CODE1City postal codenvarchar10
63EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object14POST_CODE1City postal codenvarchar10