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

68 columns | Print definition?ERP 6.0  | RECNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CF002Human Resources13RECNRCO-BPC record numbernvarchar80
2CF004Stock Prices9RECNRCO-BPC record numbernvarchar80
3TRK10Table for reorg structure11RECNRNumber of the record in the archive hierarchynvarchar40
TOPBenefits
4PA0172HR Master Record: Infotype 0172 (FSA Claims)31RECNRBenefit receipt numbernvarchar200
TOPBudgeting
5FMRBBRECSMaster Data For RIB: Budget Receivers per RIB Object8RECNRSequential Number of a Receiver in the RIB Processnvarchar30
TOPBudgeting and Availability Control
6GMRBBRECSGM Master Data For RIB: Budget Receivers per RIB Object4RECNRSequential Number of a Receiver in the RIB Processnvarchar30
TOPBusiness Consolidation
7UCM1001Explicit Values: Values3RECNRRecord Numbernvarchar30
TOPCapacity and Resource Planning
8/MRSS/CF999Broadcast Targets7RECNRCO-BPC record numbernvarchar80
TOPData Collection
9CF001Profitability Analysis16RECNRCO-BPC record numbernvarchar80
10CF003Projects16RECNRCO-BPC record numbernvarchar80
11CF005Personnel Information14RECNRCO-BPC record numbernvarchar80
12CF006Balance Sheet11RECNRCO-BPC record numbernvarchar80
13CF050Balance sheet/P&L (FI/FILC)16RECNRCO-BPC record numbernvarchar80
14CF500IDES Investment16RECNRCO-BPC record numbernvarchar80
15CF501Test HGK9RECNRSatznummer im RK-Cnvarchar80
16CF600HR Aspect9RECNRCO-BPC record numbernvarchar80
17CF650Profitability 112RECNRCO-BPC record numbernvarchar80
18CF665Attributes7RECNRCO-BPC record numbernvarchar80
19CF701IDES Marketing14RECNRCO-BPC record numbernvarchar80
20CF703IDES Profitability16RECNRCO-BPC record numbernvarchar80
21CF704IDES Sales Info Sys.13RECNRCO-BPC record numbernvarchar80
22CF705IDES Personnel Info15RECNRCO-BPC record numbernvarchar80
23CF706IDES Legal Cons.16RECNRCO-BPC record numbernvarchar80
24CF707IDES Insight12RECNRCO-BPC record numbernvarchar80
25CF708IDES: Setup Example11RECNRCO-BPC record numbernvarchar80
26CF709Consolidation Basic16RECNRCO-BPC record numbernvarchar80
27CF710IDES FPI14RECNRCO-BPC record numbernvarchar80
28CF711KPI9RECNRCO-BPC record numbernvarchar80
29CF712EC Integration: EVA12RECNRCO-BPC record numbernvarchar80
30CF714Strategic Planning13RECNRCO-BPC record numbernvarchar80
31CF715IDES:PCA-Integration14RECNRCO-BPC record numbernvarchar80
32CF720Top EIS Aspect16RECNRCO-BPC record numbernvarchar80
33CF750MCRED10RECNRCO-BPC record numbernvarchar80
34CF751MCBLUE10RECNRCO-BPC record numbernvarchar80
35CF752MCBlack11RECNRCO-BPC record numbernvarchar80
36CF760MC Black SAP Belgium10RECNRCO-BPC record numbernvarchar80
37CF7709RECNRCO-BPC record numbernvarchar80
38CF800Aspekt Übung8RECNRSatznummer im RK-Cnvarchar80
39CF880EC-BP10RECNRCO-BPC record numbernvarchar80
40CF899aspect 8997RECNRCO-BPC record numbernvarchar80
41CF9908RECNRCO-BPC record numbernvarchar80
42CF994archive example14RECNRCO-BPC record numbernvarchar80
43CF995profitab: customers16RECNRCO-BPC record numbernvarchar80
44CF996profitability (rep.)14RECNRCO-BPC record numbernvarchar80
45CF998example aspect 9987RECNRCO-BPC record numbernvarchar80
46CF999example aspect 99910RECNRCO-BPC record numbernvarchar80
47CFNNNReference structure for aspect tables SAP-EIS15RECNRCO-BPC record numbernvarchar80
48KCK710Comments for FPI2RECNRCO-BPC record numbernvarchar80
49KCK770Kommentar 7702RECNRSatznummer im RK-Cnvarchar80
50KCK880EC-BP2RECNRSatznummer im RK-Cnvarchar80
51KCK899comments for 8992RECNRCO-BPC record numbernvarchar80
52KCK996comments for 9962RECNRCO-BPC record numbernvarchar80
53KCK999comment table 9992RECNRCO-BPC record numbernvarchar80
TOPFrance
54T5F6GBatch header recording7RECNRRecord. No. of the filenvarchar50
TOPGeneral Ledger Accounting
55FAGL_BW_LOG_HEADFI-GL: Log for BW Extraction: Control Data5RECNRRecord number of the line item recordnvarchar180
56FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items5RECNRRecord number of the line item recordnvarchar180
57FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records5RECNRRecord number of the line item recordnvarchar180
58FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis3RECNRRecord number of the line item recordnvarchar180
TOPOverhead Cost Controlling
59COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis3RECNRRecord number of the line item recordnvarchar180
TOPProfitability Analysis
60TKETRPROTAccess Log for Summarization Levels3RECNRRecord Number for Access Log for Summarization Levelnvarchar60
TOPRemote Logistics Management
61OIO_MX_MTSTA_HIRLM tracking extract object status - high5RECNRRecord number for tracking extractnvarchar60
62OIO_MX_MTSTA_LORLM tracking extract object status - low5RECNRRecord number for tracking extractnvarchar60
TOPTransaction Manager
63TZKN6Allocation of charact. group to acct.ass.ref. via invoice no4RECNRLogical record number in tablenvarchar40
64TZKN7Acct assignment reference via the invoice no.4RECNRLogical record number in tablenvarchar40
65TZSZ6Alloc. of characteris.groups to clerk via invoice no.3RECNRLogical record number in tablenvarchar40
66TZSZ7Clerk allocation via the invoice no.3RECNRLogical record number in tablenvarchar40
TOPTreasury and Risk Management
67VVWKN6Alloc. of charac.group to second.term via the invoice no.3RECNRLogical record number in tablenvarchar40
68VVWKN7Charact.group - Secondary values alloc. (via the inv.no.)3RECNRLogical record number in tablenvarchar40