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

46 columns | Print definition?ERP 6.0  | FISCPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SFISCPERMaster Data IDs: InfoObject Fiscal year/period2FISCPERFiscal year / periodnvarchar70
2/BIC/B0000020000Error Stack DTP_2A5Z40NS1YWKXF2SVP67BN60Z 000148FISCPERnvarchar70
3/BIC/B0000021000Error Stack DTP_6IRBVE9XUG23ADD5OVSAZGAPV 000148FISCPERnvarchar70
4/BIC/B0000022000Error Stack DTP_6Q0G7XQAXLGVPAQWU3CGHWF2B 000148FISCPERnvarchar70
5/BIC/B0000164000PSA for 0FI_AP_20 T90CLNT090 Vendor Balances11FISCPERnvarchar70
6/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta6FISCPERnvarchar70
7/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta6FISCPERnvarchar70
8/BIC/B0000167000PSA for 0FI_AR_20 T90CLNT090 Customer Balances8FISCPERnvarchar70
9/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta6FISCPERnvarchar70
10/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances29FISCPERnvarchar70
11/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items172FISCPERnvarchar70
12/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.31FISCPERnvarchar70
13/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs33FISCPERnvarchar70
14/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)33FISCPERnvarchar70
15/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data8FISCPERnvarchar70
16/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups8FISCPERnvarchar70
17/BIC/B0000192000PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level9FISCPERnvarchar70
18/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs6FISCPERnvarchar70
19/BIC/B0000220000PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs6FISCPERnvarchar70
20/BIC/B0000222000PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections6FISCPERnvarchar70
21/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta9FISCPERnvarchar70
22/BIC/B0000276000Transfer Structure Application /CPD/8PFP_C0129FISCPERFiscal year / periodnvarchar70
23GLPCA_CTProfit Center Documents71FISCPERFiscal year / periodnvarchar70
24GLPCA_T_CTProfit Center Documents87FISCPERFiscal year / periodnvarchar70
25GLPOS_C_CTFI Document: Entry View115FISCPERFiscal year / periodnvarchar70
26GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items115FISCPERFiscal year / periodnvarchar70
27GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items115FISCPERFiscal year / periodnvarchar70
28GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items115FISCPERFiscal year / periodnvarchar70
29GLPOS_N_CTNew General Ledger: Line Item with Currency Type117FISCPERFiscal year / periodnvarchar70
30GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type117FISCPERFiscal year / periodnvarchar70
31RSR_TIME_REL_FISTime Relations for Planning4FISCPERnvarchar70
TOPBalanced Scorecard
32UMB_SC151Scorecard: Objective Score, A&C, DBS, Doc Id4FISCPERPeriodnvarchar70
33UMB_SC161Scorecard: Measure Score, A&C, DBS, Doc Id4FISCPERPeriodnvarchar70
34UMB_SC184Scorecard: Status of a General Initiative4FISCPERPeriodnvarchar70
35UMB_SC185Scorecard: Initiative Score, A&C, DBS, Doc Id4FISCPERPeriodnvarchar70
36UMB_SC201Scorecard: Perspective Score & A&C BDS Doc ID4FISCPERPeriodnvarchar70
37UMB_SC211Scorecard: Strategy Score & A&C BDS Doc ID4FISCPERPeriodnvarchar70
38UMB_SC221Scorecard: Score & A&C BDS Doc ID3FISCPERPeriodnvarchar70
TOPCorporate Performance Monitor
39UMC_PC100Closing of Periods5FISCPERPeriodnvarchar70
40UMR_RI160OBSOLETE RMS: Risk Score5FISCPERPeriodnvarchar70
41UMV_TR231Value Driver Tree: Status, Assessments and Comments5FISCPERPeriodnvarchar70
TOPData Basis
42RSR_REL_TIME_FISTime Relations for Planning3FISCPERnvarchar70
TOPGeneral Ledger Accounting
43FAGL_BW_LOG_ITEMFI-GL: Log for BW Extraction: Line Items15FISCPERFiscal year / periodnvarchar70
44FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records34FISCPERFiscal year / periodnvarchar70
45FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis33FISCPERFiscal year / periodnvarchar70
TOPPosition Budgeting and Control
46HRFPM_BPREP_DATAPreprocesses Data for BPREP Data Extraction8FISCPERPosting periodnvarchar30