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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
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

111 columns | Print definition?ERP 6.0  | REFRYEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents103REFRYEARFiscal Yearnvarchar40
2GLPCA_T_CTProfit Center Documents119REFRYEARFiscal Yearnvarchar40
3ZSAWAActual line item table37REFRYEARReference fiscal yearnvarchar40
4ZSAWPPlan line items table117REFRYEARReference fiscal yearnvarchar40
5ZSEMBPSAActual line item table33REFRYEARReference fiscal yearnvarchar40
6ZSEMBPSPPlan line items table113REFRYEARReference fiscal yearnvarchar40
7ZSPLITAIsteinzelposten-Tabelle37REFRYEARReferenz-Geschäftsjahrnvarchar40
8ZSPLITPPlaneinzelposten-Tabelle117REFRYEARReferenz-Geschäftsjahrnvarchar40
9ZZ001AActual Line Item Table44REFRYEARReference fiscal yearnvarchar40
10ZZ001PPlan Line Items Table124REFRYEARReference fiscal yearnvarchar40
11ZZLINEAActual line item table38REFRYEARReference fiscal yearnvarchar40
12ZZLINEPPlan line items table102REFRYEARReference fiscal yearnvarchar40
13ZZSL01AActual line item table46REFRYEARReference fiscal yearnvarchar40
14ZZSL01PPlan line items table126REFRYEARReference fiscal yearnvarchar40
15ZZSPECAActual line item table37REFRYEARFiscal Yearnvarchar40
16ZZSPECPPlan line item table101REFRYEARFiscal Yearnvarchar40
TOPAvailability Control
17FMAVCAActual line item table36REFRYEARReference fiscal yearnvarchar40
18FMAVCPPlan line items table84REFRYEARReference fiscal yearnvarchar40
TOPBasic Functions
19ARC_IDX_ITArchive index table for FI-SL line items10REFRYEARFiscal Yearnvarchar40
20FILCAFI-LC: Actual journal entry table with 2 object tables47REFRYEARReference fiscal yearnvarchar40
21FILCPFI-LC: Plan line items for object table125REFRYEARFiscal Yearnvarchar40
22GGREFAExample for Global FI-SL Line Items (Actual)39REFRYEARReference fiscal yearnvarchar40
23GGREFPExample for Global FI-SL Line Items (Plan)119REFRYEARReference fiscal yearnvarchar40
24GLFUNCAActual Line Items Table for Cost of Sales Accounting37REFRYEARReference fiscal yearnvarchar40
25GLFUNCPPlan Line Items Table for Cost of Sales Accounting101REFRYEARReference fiscal yearnvarchar40
26GLFUNCURollup line item tables with function area for IDES37REFRYEARReference fiscal yearnvarchar40
27GLFUNCVRollup plan line items table with function area for IDES101REFRYEARReference fiscal yearnvarchar40
28GLP0Local Logical General Ledger Plan Line Items75REFRYEARFiscal Yearnvarchar40
29GLPO1Plan Line Items for Object Table127REFRYEARFiscal Yearnvarchar40
30GLPO2Plan Line Items for Object Table Global135REFRYEARFiscal Yearnvarchar40
31GLPO3Plan Line Items for Object Table127REFRYEARFiscal Yearnvarchar40
32GLREFAExample for Local FI-SL Line Items (Actual)37REFRYEARReference fiscal yearnvarchar40
33GLREFPExample for Local FI-SL Line Items (Plan)117REFRYEARReference fiscal yearnvarchar40
34GLREFUExample for FI-SL Rollup Line Items (Actual)39REFRYEARReference fiscal yearnvarchar40
35GLREFVExample for Rollup FI-SL Line Items (Plan)119REFRYEARReference fiscal yearnvarchar40
36GLSO1FI-SL Line Item Table with Objects for GLTO148REFRYEARFiscal Yearnvarchar40
37GLSO2FI-SL Table with Objects, Structure corresponds to GLS256REFRYEARFiscal Yearnvarchar40
38GLSO3FI-SL LI Table with Objects for GLTO348REFRYEARFiscal Yearnvarchar40
TOPBudgeting
39FMBDAActual line item table37REFRYEARReference fiscal yearnvarchar40
40FMBDPFM Budget change line items table85REFRYEARReference fiscal yearnvarchar40
41FMRBAActual line item table35REFRYEARReference fiscal yearnvarchar40
42FMRBPPlan line items table83REFRYEARReference fiscal yearnvarchar40
TOPCollectionsDisbursements
43GLISDEAActual Line Item Tables for Insurance (DE)49REFRYEARFiscal Yearnvarchar40
44GLISDEPPlan Line Item Table for Insurance (DE)113REFRYEARFiscal Yearnvarchar40
45GRISDEAActual Line Item Table for Insurance (DE) - Rollup49REFRYEARFiscal Yearnvarchar40
46GRISDEPPlan Line Item Table for Insurance (DE) - Rollup113REFRYEARFiscal Yearnvarchar40
TOPConsolidation
47ECMCASAP Cons.: Journal Entry Table (Actual)46REFRYEARFiscal Yearnvarchar40
TOPCost Element Accounting
48COFIPSingle plan items for reconciliation ledger113REFRYEARFiscal Yearnvarchar40
49COFISActual line items for reconciliation ledger50REFRYEARFiscal Yearnvarchar40
TOPFinancial Accounting
50FBICRC001AICRC: Open Items GL Accounts: Documents27REFRYEARReference fiscal yearnvarchar40
51FBICRC001PNot in use42REFRYEARReference fiscal yearnvarchar40
52FBICRC002AICRC: GL Accounts: Documents27REFRYEARReference fiscal yearnvarchar40
53FBICRC002PNot in use42REFRYEARReference fiscal yearnvarchar40
54FBICRC003AICRC: Open Items Customers/Vendors: Documents28REFRYEARReference fiscal yearnvarchar40
55FBICRC003PNot in use43REFRYEARReference fiscal yearnvarchar40
TOPFinancial Services Localization
56/CEEIS/RUAActual line item table48REFRYEARReference fiscal yearnvarchar40
57/CEEIS/RUPPlan line items table128REFRYEARReference fiscal yearnvarchar40
TOPFlexible Real Estate Management
58VIPRLEDTAGRAIsteinzelposten-Tabelle27REFRYEARReferenz-Geschäftsjahrnvarchar40
59VIPRLEDTAGRPPlaneinzelposten-Tabelle91REFRYEARReferenz-Geschäftsjahrnvarchar40
TOPFund Accounting
60FMCCAVCAActual line item table33REFRYEARReference fiscal yearnvarchar40
61FMCCAVCPPlan line items table81REFRYEARReference fiscal yearnvarchar40
TOPFunds Management
62FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60039REFRYEARReference fiscal yearnvarchar40
63FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60043REFRYEARReference fiscal yearnvarchar40
64FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60039REFRYEARReference fiscal yearnvarchar40
65FMIAActual Line Item Table for Funds Management40REFRYEARFiscal Yearnvarchar40
66FMIPPlan Line Items Table for Funds Management72REFRYEARFiscal Yearnvarchar40
67FMSPLITAActual line item table41REFRYEARReference fiscal yearnvarchar40
68FMSPLITPPlan line items table73REFRYEARReference fiscal yearnvarchar40
69FMUSFGAActual line item table for US Federal Government.39REFRYEARReference fiscal yearnvarchar40
70FMUSFGFACTS1A4Actual line item table39REFRYEARReference fiscal yearnvarchar40
71FMUSFGFACTS1PPlan line items table70REFRYEARReference fiscal yearnvarchar40
72FMUSFGFACTS2AActual line item table43REFRYEARReference fiscal yearnvarchar40
73FMUSFGFACTS2PPlan line items table74REFRYEARReference fiscal yearnvarchar40
74FMUSFGPPlan line items table70REFRYEARReference fiscal yearnvarchar40
TOPGeneral Ledger Accounting
75GLFLEXAFlexible general ledger: Actual line items41REFRYEARReference fiscal yearnvarchar40
76GLFLEXPFlexible G/L: Plan line items119REFRYEARReference fiscal yearnvarchar40
TOPGrantee Management
77GMAVCAActual line item table36REFRYEARReference fiscal yearnvarchar40
78GMAVCPPlan line items table100REFRYEARReference fiscal yearnvarchar40
79GMIAActual Line Item Table34REFRYEARReference fiscal yearnvarchar40
80GMIPPlan line items table82REFRYEARReference fiscal yearnvarchar40
TOPJoint Venture und Production Sharing Accounting
81ARC_IDB_ITArchive-Indextable for JV_BILLING8REFRYEARFiscal Yearnvarchar40
82ARC_IDJ_ITArchive-Indextable for JV_OBJECT8REFRYEARFiscal Yearnvarchar40
83JVPO1JVA: Plan Line Items112REFRYEARFiscal Yearnvarchar40
84JVPSC01AActual line item table47REFRYEARFiscal Yearnvarchar40
85JVPSC01PPlan line item table111REFRYEARFiscal Yearnvarchar40
86JVSO1JV LI Table with Objects for JVTO148REFRYEARFiscal Yearnvarchar40
87JVSO2JV Billing FI-SL Line Item32REFRYEARFiscal Yearnvarchar40
88T8JVBADocuments included in Bank Account Switching12REFRYEARFiscal Yearnvarchar40
89T8J_JVECJVA equity change document relationship13REFRYEARFiscal Yearnvarchar40
TOPLocalization
90J_3RFTAXRATax Accounting: Actual line item table48REFRYEARFiscal Yearnvarchar40
91J_3RFTAXRPTax Accounting: Plan line item table96REFRYEARFiscal Yearnvarchar40
92J_3RFTAXRVATax Accounting: Actual line item table48REFRYEARFiscal Yearnvarchar40
93J_3RFTAXRVPTax Accounting: Plan line item table96REFRYEARFiscal Yearnvarchar40
TOPProfit Center Accounting
94ARC_IPC_ITArchive index table for FI-SL line items10REFRYEARFiscal Yearnvarchar40
95GLPCAEC-PCA: Actual Line Items44REFRYEARFiscal Yearnvarchar40
96GLPCPEC-PCA: Plan Line Items105REFRYEARFiscal Yearnvarchar40
TOPRegulatory reporting for insurance companies
97ISSRFLDEAActual line item table71REFRYEARReference fiscal yearnvarchar40
98ISSRFLDEPPlan line items table151REFRYEARReference fiscal yearnvarchar40
TOPRemaining Beverage - Obsolete Objects
99/BEV3/CHFIAActual line item table35REFRYEARFiscal Yearnvarchar40
100/BEV3/CHFIPPlan Line Items Table115REFRYEARFiscal Yearnvarchar40
101/BEV3/CHVGRAActual line item table37REFRYEARFiscal Yearnvarchar40
102/BEV3/CHVGRPPlan Line Items Table117REFRYEARFiscal Yearnvarchar40
TOPRetail Ledger
103PCRRETAILAActual line item table36REFRYEARReference fiscal yearnvarchar40
104PCRRETAILPPlan line items table116REFRYEARReference fiscal yearnvarchar40
TOPSpecial Purpose Ledger
105/CCIS/PBU18APBU18: Actual line item table50REFRYEARReference fiscal yearnvarchar40
106/CCIS/PBU18PPBU18: Plan line item table130REFRYEARReference fiscal yearnvarchar40
TOPTariffs, Duties and Permits
107OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger51REFRYEARReference fiscal yearnvarchar40
108OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger131REFRYEARReference fiscal yearnvarchar40
109OIHSLATDP (excise duty) special ledger actual line item table56REFRYEARFiscal Yearnvarchar40
TOPTransfer to Financial Accounting
110TRACTSLAActual Line Item Table29REFRYEARReference fiscal yearnvarchar40
111TRACTSLPPlan Line Items Table109REFRYEARReference fiscal yearnvarchar40