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

32 columns | Print definition?ERP 6.0  | CCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_RET_BLKDPP EOP Table4CCODECompany Codenvarchar40
2T063CCall-Screen Control: Inventory Management1CCODECall screen control codenvarchar200
3T063OOK Codes in Inventory Management3CCODECall screen control codenvarchar200
4T7RUOKINOKIN5CCODEOKIN Codenvarchar40
5T7RUOKINDOCUOKIN: Educational document6CCODEOKIN Codenvarchar40
6T7RUOKINFACETOKIN: Facet4CCODEOKIN Facetnvarchar20
7T7RUOKINOKINOKIN: OKIN link5CCODEOKIN Codenvarchar40
8T7RUOKINOKSOOKIN: OKSO link6CCODEOKIN Codenvarchar40
9T7RUPA0022_AIT-0022 converting: Education <-> Education OKIN5CCODEOKIN Codenvarchar40
10T7RUSCHOOLOKINOKIN: Educational institution link6CCODEOKIN Codenvarchar40
11TCMAC05CDetermine Payment Card Authorization2CCODECompany Codenvarchar40
TOPBusiness Partners
12NCUSAddnl HC-Specific Customer Data for SAP BP3CCODECompany Codenvarchar40
TOPCollectionsDisbursements
13DIMAIOBPAR_REIO Partner: Company Code Data (Reinsurance Only)6CCODECompany Codenvarchar40
14VVSCPOSPayment Plan Item22CCODECompany Codenvarchar40
TOPContract Accounts Receivable and Payable
15DFKKCFCVSClarification Cases from Payment Transfer - Ext. Pymt Coll.6CCODEExternal Payment Collectornvarchar40
16DFKKCVSConvenience Stores: Data for Convenience Store Document5CCODEExternal Payment Collectornvarchar40
17TFKCVS_CODECode in Payment Lot for Payments from Ext. Payment Collector4CCODEExternal Payment Collectornvarchar40
18TFKCVS_ELOCExternal Payment Collector3CCODEExternal Payment Collectornvarchar40
19TFKCVS_ELOCTText for External Payment Collector4CCODEExternal Payment Collectornvarchar40
TOPIncentive and Commission Management ICM
20CACSCD_ACRCDAccount Assignments of Remun.Types for FS-CD Stt.System7CCODECompany Codenvarchar40
21CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items5CCODECompany Codenvarchar40
TOPIntegrated Product and Process Engineering
22PCOLMRColor Key Master Record2CCODEColor Supplement Keynvarchar100
23PCOLMRTText Table for Color Key Master Record3CCODEColor Supplement Keynvarchar100
24PVCOLPVS Variant (COL): Color Attributes6CCODEColor Supplement Keynvarchar100
TOPLocalization
25J_3RFTAX_CHAINTax chains2CCODETax chain codenvarchar80
26J_3RFTAX_CHAINDTax chain details2CCODETax chain codenvarchar80
27J_3RFTAX_CHAINTTax chain texts2CCODETax chain codenvarchar80
TOPMulti Currency Accounting
28GLE_MCA_TPCKDEFMCA Package Definition for parallel processing3CCODECompany Codenvarchar40
TOPNorway
29T5V4CAssignment of KID number to Payee Key2CCODECompany Codenvarchar40
TOPProduct Catalog
30WWMIProduct catalog21CCODECatalog codenvarchar40
TOPPublic Sector
31T5RPBS8EOBSOLETE (SG Public Sector Pensions Scheme Constants Tab)6CCODEPensions Scheme Constant Codenvarchar60
32T5RPBS8ETOBSOLETE (Text Table for Pensions Scheme Constants Table)3CCODEPensions Scheme Constant Codenvarchar60