SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

98 columns | Print definition?ERP 6.0  | GL_SIRID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZSAWAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
2ZSAWPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
3ZSEMBPSAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
4ZSEMBPSPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
5ZSPLITAIsteinzelposten-Tabelle2GL_SIRIDSatznummer des Einzelpostensatzesnvarchar180
6ZSPLITPPlaneinzelposten-Tabelle2GL_SIRIDSatznummer des Einzelpostensatzesnvarchar180
7ZZ001AActual Line Item Table2GL_SIRIDRecord number of the line item recordnvarchar180
8ZZ001PPlan Line Items Table2GL_SIRIDRecord number of the line item recordnvarchar180
9ZZLINEAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
10ZZLINEPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
11ZZSL01AActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
12ZZSL01PPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
13ZZSPECAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
14ZZSPECPPlan line item table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPAvailability Control
15FMAVCAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
16FMAVCPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPBasic Functions
17FILCAFI-LC: Actual journal entry table with 2 object tables2GL_SIRIDRecord number of the line item recordnvarchar180
18FILCPFI-LC: Plan line items for object table2GL_SIRIDRecord number of the line item recordnvarchar180
19GGREFAExample for Global FI-SL Line Items (Actual)2GL_SIRIDRecord number of the line item recordnvarchar180
20GGREFPExample for Global FI-SL Line Items (Plan)2GL_SIRIDRecord number of the line item recordnvarchar180
21GLFUNCAActual Line Items Table for Cost of Sales Accounting2GL_SIRIDRecord number of the line item recordnvarchar180
22GLFUNCPPlan Line Items Table for Cost of Sales Accounting2GL_SIRIDRecord number of the line item recordnvarchar180
23GLFUNCURollup line item tables with function area for IDES2GL_SIRIDRecord number of the line item recordnvarchar180
24GLFUNCVRollup plan line items table with function area for IDES2GL_SIRIDRecord number of the line item recordnvarchar180
25GLREFAExample for Local FI-SL Line Items (Actual)2GL_SIRIDRecord number of the line item recordnvarchar180
26GLREFPExample for Local FI-SL Line Items (Plan)2GL_SIRIDRecord number of the line item recordnvarchar180
27GLREFUExample for FI-SL Rollup Line Items (Actual)2GL_SIRIDRecord number of the line item recordnvarchar180
28GLREFVExample for Rollup FI-SL Line Items (Plan)2GL_SIRIDRecord number of the line item recordnvarchar180
TOPBudgeting
29FMBDAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
30FMBDPFM Budget change line items table2GL_SIRIDRecord number of the line item recordnvarchar180
31FMRBAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
32FMRBPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPCollectionsDisbursements
33GLISDEAActual Line Item Tables for Insurance (DE)2GL_SIRIDRecord number of the line item recordnvarchar180
34GLISDEPPlan Line Item Table for Insurance (DE)2GL_SIRIDRecord number of the line item recordnvarchar180
35GRISDEAActual Line Item Table for Insurance (DE) - Rollup2GL_SIRIDRecord number of the line item recordnvarchar180
36GRISDEPPlan Line Item Table for Insurance (DE) - Rollup2GL_SIRIDRecord number of the line item recordnvarchar180
TOPConsolidation
37ECMCASAP Cons.: Journal Entry Table (Actual)2GL_SIRIDRecord number of the line item recordnvarchar180
TOPCost Element Accounting
38COFIPSingle plan items for reconciliation ledger2GL_SIRIDRecord number of the line item recordnvarchar180
39COFISActual line items for reconciliation ledger2GL_SIRIDRecord number of the line item recordnvarchar180
TOPFinancial Accounting
40FBICRC001AICRC: Open Items GL Accounts: Documents2GL_SIRIDRecord number of the line item recordnvarchar180
41FBICRC001PNot in use2GL_SIRIDRecord number of the line item recordnvarchar180
42FBICRC002AICRC: GL Accounts: Documents2GL_SIRIDRecord number of the line item recordnvarchar180
43FBICRC002PNot in use2GL_SIRIDRecord number of the line item recordnvarchar180
44FBICRC003AICRC: Open Items Customers/Vendors: Documents2GL_SIRIDRecord number of the line item recordnvarchar180
45FBICRC003PNot in use2GL_SIRIDRecord number of the line item recordnvarchar180
TOPFinancial Services Localization
46/CEEIS/RUAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
47/CEEIS/RUPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPFlexible Real Estate Management
48VIPRLEDTAGRAIsteinzelposten-Tabelle2GL_SIRIDSatznummer des Einzelpostensatzesnvarchar180
49VIPRLEDTAGRPPlaneinzelposten-Tabelle2GL_SIRIDSatznummer des Einzelpostensatzesnvarchar180
TOPFund Accounting
50FMCCAVCAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
51FMCCAVCPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPFunds Management
52FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6002GL_SIRIDRecord number of the line item recordnvarchar180
53FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6002GL_SIRIDRecord number of the line item recordnvarchar180
54FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6002GL_SIRIDRecord number of the line item recordnvarchar180
55FMIAActual Line Item Table for Funds Management2GL_SIRIDRecord number of the line item recordnvarchar180
56FMIPPlan Line Items Table for Funds Management2GL_SIRIDRecord number of the line item recordnvarchar180
57FMSPLITAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
58FMSPLITPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
59FMUSFGAActual line item table for US Federal Government.2GL_SIRIDRecord number of the line item recordnvarchar180
60FMUSFGFACTS1A4Actual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
61FMUSFGFACTS1PPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
62FMUSFGFACTS2AActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
63FMUSFGFACTS2PPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
64FMUSFGPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPGrantee Management
65GMAVCAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
66GMAVCPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
67GMIAActual Line Item Table2GL_SIRIDRecord number of the line item recordnvarchar180
68GMIPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPJoint Venture und Production Sharing Accounting
69JVPO1JVA: Plan Line Items2GL_SIRIDRecord number of the line item recordnvarchar180
70JVPSC01AActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
71JVPSC01PPlan line item table2GL_SIRIDRecord number of the line item recordnvarchar180
72JVSO1JV LI Table with Objects for JVTO12GL_SIRIDRecord number of the line item recordnvarchar180
73JVSO2JV Billing FI-SL Line Item2GL_SIRIDRecord number of the line item recordnvarchar180
TOPLocalization
74J_3RFTAXRATax Accounting: Actual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
75J_3RFTAXRPTax Accounting: Plan line item table2GL_SIRIDRecord number of the line item recordnvarchar180
76J_3RFTAXRVATax Accounting: Actual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
77J_3RFTAXRVPTax Accounting: Plan line item table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPPersonnel Management
78/BKC/S21_A_PCBIClone and Test-AC- conversion table for PC document numbers3GL_SIRIDRecord number of the line item recordnvarchar180
79/BKC/S21_A_PCBPClone and Test-AC- conversion table for PC document numbers3GL_SIRIDRecord number of the line item recordnvarchar180
TOPProfit Center Accounting
80GLPCAEC-PCA: Actual Line Items2GL_SIRIDRecord number of the line item recordnvarchar180
81GLPCPEC-PCA: Plan Line Items2GL_SIRIDRecord number of the line item recordnvarchar180
TOPRegulatory reporting for insurance companies
82ISSRFLDEAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
83ISSRFLDEPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPRemaining Beverage - Obsolete Objects
84/BEV3/CHABELFLUSContract Statement Document Flow21GL_SIRIDRecord number of the line item recordnvarchar180
85/BEV3/CHFIAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
86/BEV3/CHFIPPlan Line Items Table2GL_SIRIDRecord number of the line item recordnvarchar180
87/BEV3/CHVGRAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
88/BEV3/CHVGRPPlan Line Items Table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPRetail Ledger
89PCRRETAILAActual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
90PCRRETAILPPlan line items table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPRevenues and Earnings
91AD01DLIDynamic items (DI)56GL_SIRIDRecord number of the line item recordnvarchar180
TOPSpecial Purpose Ledger
92/CCIS/PBU18APBU18: Actual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
93/CCIS/PBU18PPBU18: Plan line item table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPTariffs, Duties and Permits
94OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger2GL_SIRIDRecord number of the line item recordnvarchar180
95OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger2GL_SIRIDRecord number of the line item recordnvarchar180
96OIHSLATDP (excise duty) special ledger actual line item table2GL_SIRIDRecord number of the line item recordnvarchar180
TOPTransfer to Financial Accounting
97TRACTSLAActual Line Item Table2GL_SIRIDRecord number of the line item recordnvarchar180
98TRACTSLPPlan Line Items Table2GL_SIRIDRecord number of the line item recordnvarchar180