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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
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
2OCRD332Business Partner
3OINV386A/R Invoice
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OSRN20Serial Numbers Master Data
8OOCR9Loading Factors
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

121 columns | Print definition?ERP 6.0  | REFDOCNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents102REFDOCNRReference Document Number (External Document Number)nvarchar100
2GLPCA_T_CTProfit Center Documents118REFDOCNRReference Document Number (External Document Number)nvarchar100
3ZSAWAActual line item table36REFDOCNRReference document number of an accounting documentnvarchar100
4ZSAWPPlan line items table116REFDOCNRReference document number of an accounting documentnvarchar100
5ZSEMBPSAActual line item table32REFDOCNRReference document number of an accounting documentnvarchar100
6ZSEMBPSPPlan line items table112REFDOCNRReference document number of an accounting documentnvarchar100
7ZSPLITAIsteinzelposten-Tabelle36REFDOCNRReferenz-Belegnummer eines Buchhaltungsbelegesnvarchar100
8ZSPLITPPlaneinzelposten-Tabelle116REFDOCNRReferenz-Belegnummer eines Buchhaltungsbelegesnvarchar100
9ZZ001AActual Line Item Table43REFDOCNRReference document number of an accounting documentnvarchar100
10ZZ001PPlan Line Items Table123REFDOCNRReference document number of an accounting documentnvarchar100
11ZZLINEAActual line item table37REFDOCNRReference document number of an accounting documentnvarchar100
12ZZLINEPPlan line items table101REFDOCNRReference document number of an accounting documentnvarchar100
13ZZSL01AActual line item table45REFDOCNRReference document number of an accounting documentnvarchar100
14ZZSL01PPlan line items table125REFDOCNRReference document number of an accounting documentnvarchar100
15ZZSPECAActual line item table36REFDOCNRAccounting Document Numbernvarchar100
16ZZSPECPPlan line item table100REFDOCNRAccounting Document Numbernvarchar100
TOPAvailability Control
17FMAVCAActual line item table35REFDOCNRReference document number of an accounting documentnvarchar100
18FMAVCPPlan line items table83REFDOCNRReference document number of an accounting documentnvarchar100
TOPBasic Functions
19ARC_IDX_ITArchive index table for FI-SL line items9REFDOCNRAccounting Document Numbernvarchar100
20FILCAFI-LC: Actual journal entry table with 2 object tables46REFDOCNRAccounting Document Numbernvarchar100
21FILCPFI-LC: Plan line items for object table124REFDOCNRAccounting Document Numbernvarchar100
22GGREFAExample for Global FI-SL Line Items (Actual)38REFDOCNRReference document number of an accounting documentnvarchar100
23GGREFPExample for Global FI-SL Line Items (Plan)118REFDOCNRReference document number of an accounting documentnvarchar100
24GLFUNCAActual Line Items Table for Cost of Sales Accounting36REFDOCNRReference document number of an accounting documentnvarchar100
25GLFUNCPPlan Line Items Table for Cost of Sales Accounting100REFDOCNRReference document number of an accounting documentnvarchar100
26GLFUNCURollup line item tables with function area for IDES36REFDOCNRReference document number of an accounting documentnvarchar100
27GLFUNCVRollup plan line items table with function area for IDES100REFDOCNRReference document number of an accounting documentnvarchar100
28GLP0Local Logical General Ledger Plan Line Items74REFDOCNRAccounting Document Numbernvarchar100
29GLPO1Plan Line Items for Object Table126REFDOCNRAccounting Document Numbernvarchar100
30GLPO2Plan Line Items for Object Table Global134REFDOCNRAccounting Document Numbernvarchar100
31GLPO3Plan Line Items for Object Table126REFDOCNRAccounting Document Numbernvarchar100
32GLREFAExample for Local FI-SL Line Items (Actual)36REFDOCNRReference document number of an accounting documentnvarchar100
33GLREFPExample for Local FI-SL Line Items (Plan)116REFDOCNRReference document number of an accounting documentnvarchar100
34GLREFUExample for FI-SL Rollup Line Items (Actual)38REFDOCNRReference document number of an accounting documentnvarchar100
35GLREFVExample for Rollup FI-SL Line Items (Plan)118REFDOCNRReference document number of an accounting documentnvarchar100
36GLSO1FI-SL Line Item Table with Objects for GLTO147REFDOCNRAccounting Document Numbernvarchar100
37GLSO2FI-SL Table with Objects, Structure corresponds to GLS255REFDOCNRAccounting Document Numbernvarchar100
38GLSO3FI-SL LI Table with Objects for GLTO347REFDOCNRAccounting Document Numbernvarchar100
TOPBudgeting
39FMBDAActual line item table36REFDOCNRReference document number of an accounting documentnvarchar100
40FMBDPFM Budget change line items table84REFDOCNRReference document number of an accounting documentnvarchar100
41FMRBAActual line item table34REFDOCNRReference document number of an accounting documentnvarchar100
42FMRBPPlan line items table82REFDOCNRReference document number of an accounting documentnvarchar100
TOPCollectionsDisbursements
43GLISDEAActual Line Item Tables for Insurance (DE)48REFDOCNRAccounting Document Numbernvarchar100
44GLISDEPPlan Line Item Table for Insurance (DE)112REFDOCNRAccounting Document Numbernvarchar100
45GRISDEAActual Line Item Table for Insurance (DE) - Rollup48REFDOCNRAccounting Document Numbernvarchar100
46GRISDEPPlan Line Item Table for Insurance (DE) - Rollup112REFDOCNRAccounting Document Numbernvarchar100
TOPConsolidation
47ECMCASAP Cons.: Journal Entry Table (Actual)45REFDOCNRAccounting Document Numbernvarchar100
TOPContract Accounts Receivable and Payable
48DFKKORDERRequests: Header Data20REFDOCNRReference document numbernvarchar160
49DFKKORDER_SRequest Templates: Header Data20REFDOCNRReference document numbernvarchar160
TOPCost Element Accounting
50COFIPSingle plan items for reconciliation ledger112REFDOCNRAccounting Document Numbernvarchar100
51COFISActual line items for reconciliation ledger49REFDOCNRAccounting Document Numbernvarchar100
TOPFinancial Accounting
52FBICRC001AICRC: Open Items GL Accounts: Documents26REFDOCNRReference document number of an accounting documentnvarchar100
53FBICRC001PNot in use41REFDOCNRReference document number of an accounting documentnvarchar100
54FBICRC002AICRC: GL Accounts: Documents26REFDOCNRReference document number of an accounting documentnvarchar100
55FBICRC002PNot in use41REFDOCNRReference document number of an accounting documentnvarchar100
56FBICRC003AICRC: Open Items Customers/Vendors: Documents27REFDOCNRReference document number of an accounting documentnvarchar100
57FBICRC003PNot in use42REFDOCNRReference document number of an accounting documentnvarchar100
TOPFinancial Services Localization
58/CEEIS/RUAActual line item table47REFDOCNRReference document number of an accounting documentnvarchar100
59/CEEIS/RUPPlan line items table127REFDOCNRReference document number of an accounting documentnvarchar100
TOPFlexible Real Estate Management
60VIPRLEDTAGRAIsteinzelposten-Tabelle26REFDOCNRReferenz-Belegnummer eines Buchhaltungsbelegesnvarchar100
61VIPRLEDTAGRPPlaneinzelposten-Tabelle90REFDOCNRReferenz-Belegnummer eines Buchhaltungsbelegesnvarchar100
TOPFund Accounting
62FMCCAVCAActual line item table32REFDOCNRReference document number of an accounting documentnvarchar100
63FMCCAVCPPlan line items table80REFDOCNRReference document number of an accounting documentnvarchar100
64FMGLFLEXPGeneral Ledger: Plan Line Items118REFDOCNRReference document number of an accounting documentnvarchar100
65PSGLFLEXPGeneral Ledger: Plan Line Items122REFDOCNRReference document number of an accounting documentnvarchar100
TOPFunds Management
66FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60038REFDOCNRReference document number of an accounting documentnvarchar100
67FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60042REFDOCNRReference document number of an accounting documentnvarchar100
68FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60038REFDOCNRReference document number of an accounting documentnvarchar100
69FMIAActual Line Item Table for Funds Management39REFDOCNRAccounting Document Numbernvarchar100
70FMIPPlan Line Items Table for Funds Management71REFDOCNRAccounting Document Numbernvarchar100
71FMSPLITAActual line item table40REFDOCNRReference document number of an accounting documentnvarchar100
72FMSPLITPPlan line items table72REFDOCNRReference document number of an accounting documentnvarchar100
73FMUSFGAActual line item table for US Federal Government.38REFDOCNRReference document number of an accounting documentnvarchar100
74FMUSFGFACTS1A4Actual line item table38REFDOCNRReference document number of an accounting documentnvarchar100
75FMUSFGFACTS1PPlan line items table69REFDOCNRReference document number of an accounting documentnvarchar100
76FMUSFGFACTS2AActual line item table42REFDOCNRReference document number of an accounting documentnvarchar100
77FMUSFGFACTS2PPlan line items table73REFDOCNRReference document number of an accounting documentnvarchar100
78FMUSFGPPlan line items table69REFDOCNRReference document number of an accounting documentnvarchar100
79PSBM_EVENTPS Budget Monitoring Events7REFDOCNRReference document number of an accounting documentnvarchar100
TOPGeneral Ledger Accounting
80FAGLFLEXPGeneral Ledger: Plan Line Items120REFDOCNRReference document number of an accounting documentnvarchar100
81FAGLSKF_PNGeneral Ledger; Statistical Key Figures (Source Document)21REFDOCNRReference document number of an accounting documentnvarchar100
82GLFLEXAFlexible general ledger: Actual line items40REFDOCNRReference document number of an accounting documentnvarchar100
83GLFLEXPFlexible G/L: Plan line items118REFDOCNRReference document number of an accounting documentnvarchar100
TOPGrantee Management
84GMAVCAActual line item table35REFDOCNRReference document number of an accounting documentnvarchar100
85GMAVCPPlan line items table99REFDOCNRReference document number of an accounting documentnvarchar100
86GMIAActual Line Item Table33REFDOCNRReference document number of an accounting documentnvarchar100
87GMIPPlan line items table81REFDOCNRReference document number of an accounting documentnvarchar100
TOPJoint Venture und Production Sharing Accounting
88ARC_IDB_ITArchive-Indextable for JV_BILLING7REFDOCNRAccounting Document Numbernvarchar100
89ARC_IDJ_ITArchive-Indextable for JV_OBJECT7REFDOCNRAccounting Document Numbernvarchar100
90JVGLFLEXPGeneral Ledger: Plan Line Items122REFDOCNRReference document number of an accounting documentnvarchar100
91JVPO1JVA: Plan Line Items111REFDOCNRDoc. Numbernvarchar100
92JVPSC01AActual line item table46REFDOCNRAccounting Document Numbernvarchar100
93JVPSC01PPlan line item table110REFDOCNRAccounting Document Numbernvarchar100
94JVSO1JV LI Table with Objects for JVTO147REFDOCNRAccounting Document Numbernvarchar100
95JVSO2JV Billing FI-SL Line Item31REFDOCNRAccounting Document Numbernvarchar100
96T8JVBADocuments included in Bank Account Switching11REFDOCNRAccounting Document Numbernvarchar100
97T8J_JVECJVA equity change document relationship12REFDOCNRAccounting Document Numbernvarchar100
TOPLocalization
98J_3RFTAXRATax Accounting: Actual line item table47REFDOCNRAccounting Document Numbernvarchar100
99J_3RFTAXRPTax Accounting: Plan line item table95REFDOCNRAccounting Document Numbernvarchar100
100J_3RFTAXRVATax Accounting: Actual line item table47REFDOCNRAccounting Document Numbernvarchar100
101J_3RFTAXRVPTax Accounting: Plan line item table95REFDOCNRAccounting Document Numbernvarchar100
TOPProfit Center Accounting
102ARC_IPC_ITArchive index table for FI-SL line items9REFDOCNRAccounting Document Numbernvarchar100
103GLPCAEC-PCA: Actual Line Items43REFDOCNRReference Document Number (External Document Number)nvarchar100
104GLPCPEC-PCA: Plan Line Items104REFDOCNRReference Document Number (External Document Number)nvarchar100
TOPRegulatory reporting for insurance companies
105ISSRFLDEAActual line item table70REFDOCNRReference document number of an accounting documentnvarchar100
106ISSRFLDEPPlan line items table150REFDOCNRReference document number of an accounting documentnvarchar100
TOPRemaining Beverage - Obsolete Objects
107/BEV3/CHFIAActual line item table34REFDOCNRAccounting Document Numbernvarchar100
108/BEV3/CHFIPPlan Line Items Table114REFDOCNRAccounting Document Numbernvarchar100
109/BEV3/CHVGRAActual line item table36REFDOCNRAccounting Document Numbernvarchar100
110/BEV3/CHVGRPPlan Line Items Table116REFDOCNRAccounting Document Numbernvarchar100
TOPRetail Ledger
111PCRRETAILAActual line item table35REFDOCNRReference document number of an accounting documentnvarchar100
112PCRRETAILPPlan line items table115REFDOCNRReference document number of an accounting documentnvarchar100
TOPRevenues and Earnings
113AD01DLIDynamic items (DI)57REFDOCNRReference document number of an accounting documentnvarchar100
TOPSpecial Purpose Ledger
114/CCIS/PBU18APBU18: Actual line item table49REFDOCNRReference document number of an accounting documentnvarchar100
115/CCIS/PBU18PPBU18: Plan line item table129REFDOCNRReference document number of an accounting documentnvarchar100
116/CCIS/PROFTAXPPlan Line Items Table for General Ledger130REFDOCNRReference document number of an accounting documentnvarchar100
TOPTariffs, Duties and Permits
117OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger50REFDOCNRReference document number of an accounting documentnvarchar100
118OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger130REFDOCNRReference document number of an accounting documentnvarchar100
119OIHSLATDP (excise duty) special ledger actual line item table55REFDOCNRAccounting Document Numbernvarchar100
TOPTransfer to Financial Accounting
120TRACTSLAActual Line Item Table28REFDOCNRReference document number of an accounting documentnvarchar100
121TRACTSLPPlan Line Items Table108REFDOCNRReference document number of an accounting documentnvarchar100