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

82 columns | Print definition?ERP 6.0  | SACCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWAActual line item table21SACCTPartner account numbernvarchar100
2ZSAWPPlan line items table21SACCTPartner account numbernvarchar100
3ZSAWTSummary table20SACCTPartner account numbernvarchar100
4ZSPLITAIsteinzelposten-Tabelle21SACCTPartner-Kontonummernvarchar100
5ZSPLITPPlaneinzelposten-Tabelle21SACCTPartner-Kontonummernvarchar100
6ZSPLITTSummentabelle20SACCTPartner-Kontonummernvarchar100
7ZZ001AActual Line Item Table28SACCTPartner account numbernvarchar100
8ZZ001PPlan Line Items Table28SACCTPartner account numbernvarchar100
9ZZ001TSummary Table27SACCTPartner account numbernvarchar100
10ZZLINEAActual line item table23SACCTPartner account numbernvarchar100
11ZZLINEPPlan line items table23SACCTPartner account numbernvarchar100
12ZZLINETSummary table22SACCTPartner account numbernvarchar100
13ZZSL01AActual line item table26SACCTPartner account numbernvarchar100
14ZZSL01PPlan line items table26SACCTPartner account numbernvarchar100
15ZZSL01TSummary table25SACCTPartner account numbernvarchar100
16ZZSPECAActual line item table21SACCTPartner account numbernvarchar100
17ZZSPECPPlan line item table21SACCTPartner account numbernvarchar100
18ZZSPECTSummary table19SACCTPartner account numbernvarchar100
TOPBasic Functions
19FILCAFI-LC: Actual journal entry table with 2 object tables30SACCTConsolidation itemnvarchar100
20FILCPFI-LC: Plan line items for object table30SACCTConsolidation itemnvarchar100
21FILCTFI-LC: Global totals table with 2 object tables29SACCTConsolidation itemnvarchar100
22GGREFAExample for Global FI-SL Line Items (Actual)23SACCTPartner account numbernvarchar100
23GGREFPExample for Global FI-SL Line Items (Plan)23SACCTPartner account numbernvarchar100
24GGREFTExample for Global FI-SL Summary Table22SACCTPartner account numbernvarchar100
25GLFUNCAActual Line Items Table for Cost of Sales Accounting23SACCTPartner account numbernvarchar100
26GLFUNCPPlan Line Items Table for Cost of Sales Accounting23SACCTPartner account numbernvarchar100
27GLFUNCTTotals Table for Cost of Sales Accounting22SACCTPartner account numbernvarchar100
28GLFUNCURollup line item tables with function area for IDES23SACCTPartner account numbernvarchar100
29GLFUNCVRollup plan line items table with function area for IDES23SACCTPartner account numbernvarchar100
30GLPO1Plan Line Items for Object Table26SACCTAccount Numbernvarchar100
31GLPO2Plan Line Items for Object Table Global31SACCTAccount Numbernvarchar100
32GLPO3Plan Line Items for Object Table26SACCTAccount Numbernvarchar100
33GLREFAExample for Local FI-SL Line Items (Actual)21SACCTPartner account numbernvarchar100
34GLREFPExample for Local FI-SL Line Items (Plan)21SACCTPartner account numbernvarchar100
35GLREFTExample for Local FI-SL Summary Table20SACCTPartner account numbernvarchar100
36GLREFUExample for FI-SL Rollup Line Items (Actual)22SACCTPartner account numbernvarchar100
37GLREFVExample for Rollup FI-SL Line Items (Plan)22SACCTPartner account numbernvarchar100
38GLSO1FI-SL Line Item Table with Objects for GLTO126SACCTAccount Numbernvarchar100
39GLSO2FI-SL Table with Objects, Structure corresponds to GLS231SACCTAccount Numbernvarchar100
40GLSO3FI-SL LI Table with Objects for GLTO326SACCTAccount Numbernvarchar100
41GLTO1FI-SL Table with Objects, Structure Corresponds to GLT123SACCTAccount Numbernvarchar100
42GLTO2FI-SL Table with Objects, Structure Corresponds to GLT228SACCTAccount Numbernvarchar100
43GLTO3FISL Table with Objects, Amounts and Quantities in Format P923SACCTAccount Numbernvarchar100
TOPCost Element Accounting
44COFIPSingle plan items for reconciliation ledger25SACCTCost element of partnernvarchar100
45COFISActual line items for reconciliation ledger25SACCTCost element of partnernvarchar100
46COFITTotals Records for Reconciliation Ledger24SACCTCost element of partnernvarchar100
TOPData Retention Tool
47TXW_S_COFIRetrieve COFIS from archive15SACCTCost element of partnernvarchar100
TOPFinancial Services Localization
48/CEEIS/RUAActual line item table29SACCTPartner account numbernvarchar100
49/CEEIS/RUPPlan line items table29SACCTPartner account numbernvarchar100
50/CEEIS/RUTTotals Table28SACCTPartner account numbernvarchar100
TOPFunds Management
51FMSPLITAActual line item table26SACCTPartner account numbernvarchar100
52FMSPLITPPlan line items table26SACCTPartner account numbernvarchar100
53FMSPLITTSummary table27SACCTPartner account numbernvarchar100
TOPGeneral Ledger Accounting
54GLFLEX05General ledger: Sender main account assignment2SACCTPartner account numbernvarchar100
55GLFLEXAFlexible general ledger: Actual line items18SACCTPartner account numbernvarchar100
56GLFLEXPFlexible G/L: Plan line items18SACCTPartner account numbernvarchar100
57GLFLEXTFlexible G/L: Totals24SACCTPartner account numbernvarchar100
TOPLocalization
58J_3RFTAXRATax Accounting: Actual line item table33SACCTAccount numbernvarchar100
59J_3RFTAXRPTax Accounting: Plan line item table33SACCTAccount numbernvarchar100
60J_3RFTAXRTTax Accounting: Summary table31SACCTAccount numbernvarchar100
61J_3RFTAXRVATax Accounting: Actual line item table32SACCTAccount numbernvarchar100
62J_3RFTAXRVPTax Accounting: Plan line item table32SACCTAccount numbernvarchar100
63J_3RFTAXRVTTax Accounting: Summary table30SACCTAccount numbernvarchar100
TOPRegulatory reporting for insurance companies
64ISSRFLDEAActual line item table46SACCTPartner account numbernvarchar100
65ISSRFLDEPPlan line items table46SACCTPartner account numbernvarchar100
66ISSRFLDETSummary table45SACCTPartner account numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
67/BEV3/CHFIAActual line item table22SACCTPartner account numbernvarchar100
68/BEV3/CHFIPPlan Line Items Table22SACCTPartner account numbernvarchar100
69/BEV3/CHFITTotals table21SACCTPartner account numbernvarchar100
70/BEV3/CHVGRAActual line item table24SACCTPartner account numbernvarchar100
71/BEV3/CHVGRPPlan Line Items Table24SACCTPartner account numbernvarchar100
72/BEV3/CHVGRTTotals table23SACCTPartner account numbernvarchar100
TOPSpecial Purpose Ledger
73/CCIS/PBU18APBU18: Actual line item table28SACCTPartner account numbernvarchar100
74/CCIS/PBU18PPBU18: Plan line item table28SACCTPartner account numbernvarchar100
75/CCIS/PBU18TPBU18: Summary table x27SACCTPartner account numbernvarchar100
76/CCIS/PROFTAX06Object Table Number:066SACCTAccount numbernvarchar100
77/CCIS/PROFTAXAActual Line Items Table for General Ledger34SACCTAccount numbernvarchar100
78/CCIS/PROFTAXPPlan Line Items Table for General Ledger36SACCTAccount numbernvarchar100
79/CCIS/PROFTAXTTotals Table for General Ledger43SACCTAccount numbernvarchar100
TOPTariffs, Duties and Permits
80OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger35SACCTPartner account numbernvarchar100
81OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger35SACCTPartner account numbernvarchar100
82OIHEDTSummary table, IS-OIL Excise Duty Special Ledger34SACCTPartner account numbernvarchar100