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

86 columns | Print definition?ERP 6.0  | SBUKRS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents114SBUKRSSender company codenvarchar40
2GLPCA_T_CTProfit Center Documents130SBUKRSSender company codenvarchar40
3T243ASet TR-CM Subsystems and Company Codes3SBUKRSSending company codenvarchar40
4ZSAWAActual line item table20SBUKRSCompany code of partnernvarchar40
5ZSAWPPlan line items table20SBUKRSCompany code of partnernvarchar40
6ZSAWTSummary table19SBUKRSCompany code of partnernvarchar40
7ZSPLITAIsteinzelposten-Tabelle20SBUKRSBuchungskreis des Partnersnvarchar40
8ZSPLITPPlaneinzelposten-Tabelle20SBUKRSBuchungskreis des Partnersnvarchar40
9ZSPLITTSummentabelle19SBUKRSBuchungskreis des Partnersnvarchar40
10ZZ001AActual Line Item Table27SBUKRSCompany code of partnernvarchar40
11ZZ001PPlan Line Items Table27SBUKRSCompany code of partnernvarchar40
12ZZ001TSummary Table26SBUKRSCompany code of partnernvarchar40
13ZZLINEAActual line item table22SBUKRSCompany code of partnernvarchar40
14ZZLINEPPlan line items table22SBUKRSCompany code of partnernvarchar40
15ZZLINETSummary table21SBUKRSCompany code of partnernvarchar40
16ZZSL01AActual line item table25SBUKRSCompany code of partnernvarchar40
17ZZSL01PPlan line items table25SBUKRSCompany code of partnernvarchar40
18ZZSL01TSummary table24SBUKRSCompany code of partnernvarchar40
19ZZSPECAActual line item table20SBUKRSCompany code of partnernvarchar40
20ZZSPECPPlan line item table20SBUKRSCompany code of partnernvarchar40
21ZZSPECTSummary table18SBUKRSCompany code of partnernvarchar40
TOPBasic Functions
22GLFUNCAActual Line Items Table for Cost of Sales Accounting22SBUKRSCompany code of partnernvarchar40
23GLFUNCPPlan Line Items Table for Cost of Sales Accounting22SBUKRSCompany code of partnernvarchar40
24GLFUNCTTotals Table for Cost of Sales Accounting21SBUKRSCompany code of partnernvarchar40
25GLFUNCURollup line item tables with function area for IDES22SBUKRSCompany code of partnernvarchar40
26GLFUNCVRollup plan line items table with function area for IDES22SBUKRSCompany code of partnernvarchar40
27GLPO1Plan Line Items for Object Table25SBUKRSCompany Codenvarchar40
28GLPO3Plan Line Items for Object Table25SBUKRSCompany Codenvarchar40
29GLREFAExample for Local FI-SL Line Items (Actual)20SBUKRSCompany code of partnernvarchar40
30GLREFPExample for Local FI-SL Line Items (Plan)20SBUKRSCompany code of partnernvarchar40
31GLREFTExample for Local FI-SL Summary Table19SBUKRSCompany code of partnernvarchar40
32GLREFUExample for FI-SL Rollup Line Items (Actual)21SBUKRSCompany code of partnernvarchar40
33GLREFVExample for Rollup FI-SL Line Items (Plan)21SBUKRSCompany code of partnernvarchar40
34GLSO1FI-SL Line Item Table with Objects for GLTO125SBUKRSCompany Codenvarchar40
35GLSO3FI-SL LI Table with Objects for GLTO325SBUKRSCompany Codenvarchar40
36GLTO1FI-SL Table with Objects, Structure Corresponds to GLT122SBUKRSCompany Codenvarchar40
37GLTO3FISL Table with Objects, Amounts and Quantities in Format P922SBUKRSCompany Codenvarchar40
TOPCost Element Accounting
38COFIPSingle plan items for reconciliation ledger24SBUKRSCompany code of partnernvarchar40
39COFISActual line items for reconciliation ledger24SBUKRSCompany code of partnernvarchar40
40COFITTotals Records for Reconciliation Ledger23SBUKRSCompany code of partnernvarchar40
TOPData Retention Tool
41TXW_S_COFIRetrieve COFIS from archive14SBUKRSCompany code of partnernvarchar40
TOPFinancial Services Localization
42/CEEIS/RUAActual line item table28SBUKRSCompany code of partnernvarchar40
43/CEEIS/RUPPlan line items table28SBUKRSCompany code of partnernvarchar40
44/CEEIS/RUTTotals Table27SBUKRSCompany code of partnernvarchar40
TOPFund Accounting
45FMCCAVCAActual line item table23SBUKRSCompany code of partnernvarchar40
46FMCCAVCPPlan line items table23SBUKRSCompany code of partnernvarchar40
47FMCCAVCTTotals Table22SBUKRSCompany code of partnernvarchar40
TOPFunds Management
48FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60029SBUKRSCompany code of partnernvarchar40
49FMSPLITAActual line item table25SBUKRSCompany code of partnernvarchar40
50FMSPLITPPlan line items table25SBUKRSCompany code of partnernvarchar40
51FMSPLITTSummary table26SBUKRSCompany code of partnernvarchar40
52FMUSFGFACTS1A4Actual line item table29SBUKRSCompany code of partnernvarchar40
53FMUSFGFACTS1PPlan line items table29SBUKRSCompany code of partnernvarchar40
54FMUSFGFACTS1TSummary table28SBUKRSCompany code of partnernvarchar40
TOPGrantee Management
55GMAVCAActual line item table25SBUKRSCompany code of partnernvarchar40
56GMAVCPPlan line items table25SBUKRSCompany code of partnernvarchar40
57GMAVCTSummary table24SBUKRSCompany code of partnernvarchar40
TOPLocalization
58J_3RFTAXRATax Accounting: Actual line item table29SBUKRSCompany code of partnernvarchar40
59J_3RFTAXRPTax Accounting: Plan line item table29SBUKRSCompany code of partnernvarchar40
60J_3RFTAXRTTax Accounting: Summary table27SBUKRSCompany code of partnernvarchar40
61J_3RFTAXRVATax Accounting: Actual line item table29SBUKRSCompany code of partnernvarchar40
62J_3RFTAXRVPTax Accounting: Plan line item table29SBUKRSCompany code of partnernvarchar40
63J_3RFTAXRVTTax Accounting: Summary table27SBUKRSCompany code of partnernvarchar40
TOPProfit Center Accounting
64GLPCAEC-PCA: Actual Line Items26SBUKRSSender company codenvarchar40
65GLPCPEC-PCA: Plan Line Items26SBUKRSSender company codenvarchar40
66GLPCTEC-PCA: Totals Table26SBUKRSSender company codenvarchar40
67T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material28SBUKRSSender company codenvarchar40
TOPRegulatory reporting for insurance companies
68ISSRFLDEAActual line item table44SBUKRSCompany code of partnernvarchar40
69ISSRFLDEPPlan line items table44SBUKRSCompany code of partnernvarchar40
70ISSRFLDETSummary table43SBUKRSCompany code of partnernvarchar40
TOPRemaining Beverage - Obsolete Objects
71/BEV3/CHFIAActual line item table21SBUKRSCompany code of partnernvarchar40
72/BEV3/CHFIPPlan Line Items Table21SBUKRSCompany code of partnernvarchar40
73/BEV3/CHFITTotals table20SBUKRSCompany code of partnernvarchar40
74/BEV3/CHVGRAActual line item table23SBUKRSCompany code of partnernvarchar40
75/BEV3/CHVGRPPlan Line Items Table23SBUKRSCompany code of partnernvarchar40
76/BEV3/CHVGRTTotals table22SBUKRSCompany code of partnernvarchar40
TOPSpecial Purpose Ledger
77/CCIS/PBU18APBU18: Actual line item table27SBUKRSCompany code of partnernvarchar40
78/CCIS/PBU18PPBU18: Plan line item table27SBUKRSCompany code of partnernvarchar40
79/CCIS/PBU18TPBU18: Summary table x26SBUKRSCompany code of partnernvarchar40
80/CCIS/PROFTAX06Object Table Number:062SBUKRSCompany code of partnernvarchar40
81/CCIS/PROFTAXAActual Line Items Table for General Ledger30SBUKRSCompany code of partnernvarchar40
82/CCIS/PROFTAXPPlan Line Items Table for General Ledger32SBUKRSCompany code of partnernvarchar40
83/CCIS/PROFTAXTTotals Table for General Ledger39SBUKRSCompany code of partnernvarchar40
TOPTariffs, Duties and Permits
84OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger27SBUKRSCompany code of partnernvarchar40
85OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger27SBUKRSCompany code of partnernvarchar40
86OIHEDTSummary table, IS-OIL Excise Duty Special Ledger26SBUKRSCompany code of partnernvarchar40