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

123 columns | Print definition?ERP 6.0  | DOCCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EPIDXB7DOCCTnvarchar10
2EPIDXC7DOCCTnvarchar10
3GLIDXBLine-item index for FI-SL BUKRS7DOCCTDocument Typenvarchar10
4GLIDXCLine Item Index for FI-SL Global Company7DOCCTDocument Typenvarchar10
5GLPCA_CTProfit Center Documents62DOCCTDocument Typenvarchar10
6GLPCA_T_CTProfit Center Documents78DOCCTDocument Typenvarchar10
7GLS2CLUS2DOCCTnvarchar10
8GLS2IDXIndex table for FI-LC document cluster2DOCCTDocument Typenvarchar10
9ZSAWAActual line item table11DOCCTDocument Typenvarchar10
10ZSAWPPlan line items table11DOCCTDocument Typenvarchar10
11ZSEMBPSAActual line item table11DOCCTDocument Typenvarchar10
12ZSEMBPSPPlan line items table11DOCCTDocument Typenvarchar10
13ZSPLITAIsteinzelposten-Tabelle11DOCCTBelegtypnvarchar10
14ZSPLITPPlaneinzelposten-Tabelle11DOCCTBelegtypnvarchar10
15ZZ001AActual Line Item Table11DOCCTDocument Typenvarchar10
16ZZ001PPlan Line Items Table11DOCCTDocument Typenvarchar10
17ZZLINEAActual line item table11DOCCTDocument Typenvarchar10
18ZZLINEPPlan line items table11DOCCTDocument Typenvarchar10
19ZZSL01AActual line item table11DOCCTDocument Typenvarchar10
20ZZSL01PPlan line items table11DOCCTDocument Typenvarchar10
21ZZSPECAActual line item table11DOCCTDocument Typenvarchar10
22ZZSPECPPlan line item table11DOCCTDocument Typenvarchar10
TOPAvailability Control
23FMAVCAActual line item table10DOCCTDocument Typenvarchar10
24FMAVCPPlan line items table10DOCCTDocument Typenvarchar10
TOPBasic Functions
25ARC_IDX_ITArchive index table for FI-SL line items4DOCCTDocument Typenvarchar10
26FILCAFI-LC: Actual journal entry table with 2 object tables11DOCCTDocument Typenvarchar10
27FILCPFI-LC: Plan line items for object table11DOCCTDocument Typenvarchar10
28GGREFAExample for Global FI-SL Line Items (Actual)11DOCCTDocument Typenvarchar10
29GGREFPExample for Global FI-SL Line Items (Plan)11DOCCTDocument Typenvarchar10
30GLFUNCAActual Line Items Table for Cost of Sales Accounting11DOCCTDocument Typenvarchar10
31GLFUNCPPlan Line Items Table for Cost of Sales Accounting11DOCCTDocument Typenvarchar10
32GLFUNCURollup line item tables with function area for IDES11DOCCTDocument Typenvarchar10
33GLFUNCVRollup plan line items table with function area for IDES11DOCCTDocument Typenvarchar10
34GLIDXAIndex to Find FI-SL Documents Based on AWKEY6DOCCTDocument Typenvarchar10
35GLP0Local Logical General Ledger Plan Line Items12DOCCTDocument Typenvarchar10
36GLPO1Plan Line Items for Object Table13DOCCTDocument Typenvarchar10
37GLPO2Plan Line Items for Object Table Global13DOCCTDocument Typenvarchar10
38GLPO3Plan Line Items for Object Table13DOCCTDocument Typenvarchar10
39GLREFAExample for Local FI-SL Line Items (Actual)11DOCCTDocument Typenvarchar10
40GLREFPExample for Local FI-SL Line Items (Plan)11DOCCTDocument Typenvarchar10
41GLREFUExample for FI-SL Rollup Line Items (Actual)11DOCCTDocument Typenvarchar10
42GLREFVExample for Rollup FI-SL Line Items (Plan)11DOCCTDocument Typenvarchar10
43GLSO1FI-SL Line Item Table with Objects for GLTO113DOCCTDocument Typenvarchar10
44GLSO2FI-SL Table with Objects, Structure corresponds to GLS213DOCCTDocument Typenvarchar10
45GLSO3FI-SL LI Table with Objects for GLTO313DOCCTDocument Typenvarchar10
TOPBudgeting
46FMBDAActual line item table10DOCCTDocument Typenvarchar10
47FMBDPFM Budget change line items table10DOCCTDocument Typenvarchar10
48FMRBAActual line item table10DOCCTDocument Typenvarchar10
49FMRBPPlan line items table10DOCCTDocument Typenvarchar10
TOPCollectionsDisbursements
50GLISDEAActual Line Item Tables for Insurance (DE)11DOCCTDocument Typenvarchar10
51GLISDEPPlan Line Item Table for Insurance (DE)11DOCCTDocument Typenvarchar10
52GRISDEAActual Line Item Table for Insurance (DE) - Rollup11DOCCTDocument Typenvarchar10
53GRISDEPPlan Line Item Table for Insurance (DE) - Rollup11DOCCTDocument Typenvarchar10
TOPConsolidation
54ECMCASAP Cons.: Journal Entry Table (Actual)11DOCCTDocument Typenvarchar10
TOPCost Element Accounting
55COFIPSingle plan items for reconciliation ledger11DOCCTDocument Typenvarchar10
56COFISActual line items for reconciliation ledger11DOCCTDocument Typenvarchar10
TOPData Retention Tool
57TXW_S_COFIRetrieve COFIS from archive4DOCCTDocument Typenvarchar10
TOPFinancial Accounting
58FBICRC001AICRC: Open Items GL Accounts: Documents10DOCCTDocument Typenvarchar10
59FBICRC001PNot in use10DOCCTDocument Typenvarchar10
60FBICRC002AICRC: GL Accounts: Documents10DOCCTDocument Typenvarchar10
61FBICRC002PNot in use10DOCCTDocument Typenvarchar10
62FBICRC003AICRC: Open Items Customers/Vendors: Documents10DOCCTDocument Typenvarchar10
63FBICRC003PNot in use10DOCCTDocument Typenvarchar10
TOPFinancial Services Localization
64/CEEIS/RUAActual line item table11DOCCTDocument Typenvarchar10
65/CEEIS/RUPPlan line items table11DOCCTDocument Typenvarchar10
TOPFlexible Real Estate Management
66VIPRLEDTAGRAIsteinzelposten-Tabelle11DOCCTBelegtypnvarchar10
67VIPRLEDTAGRPPlaneinzelposten-Tabelle11DOCCTBelegtypnvarchar10
TOPFund Accounting
68FMCCAVCAActual line item table10DOCCTDocument Typenvarchar10
69FMCCAVCPPlan line items table10DOCCTDocument Typenvarchar10
70FMGLFLEXPGeneral Ledger: Plan Line Items7DOCCTDocument Typenvarchar10
71PSGLFLEXPGeneral Ledger: Plan Line Items7DOCCTDocument Typenvarchar10
TOPFunds Management
72FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60010DOCCTDocument Typenvarchar10
73FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60010DOCCTDocument Typenvarchar10
74FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60010DOCCTDocument Typenvarchar10
75FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 6006DOCCTDocument Typenvarchar10
76FMIAActual Line Item Table for Funds Management9DOCCTDocument Typenvarchar10
77FMIPPlan Line Items Table for Funds Management9DOCCTDocument Typenvarchar10
78FMSPLITAActual line item table10DOCCTDocument Typenvarchar10
79FMSPLITPPlan line items table10DOCCTDocument Typenvarchar10
80FMUSFGAActual line item table for US Federal Government.10DOCCTDocument Typenvarchar10
81FMUSFGFACTS1A4Actual line item table10DOCCTDocument Typenvarchar10
82FMUSFGFACTS1PPlan line items table10DOCCTDocument Typenvarchar10
83FMUSFGFACTS2AActual line item table10DOCCTDocument Typenvarchar10
84FMUSFGFACTS2PPlan line items table10DOCCTDocument Typenvarchar10
85FMUSFGPPlan line items table10DOCCTDocument Typenvarchar10
TOPGeneral Ledger Accounting
86FAGLFLEXPGeneral Ledger: Plan Line Items7DOCCTDocument Typenvarchar10
87GLFLEXAFlexible general ledger: Actual line items7DOCCTDocument Typenvarchar10
88GLFLEXPFlexible G/L: Plan line items7DOCCTDocument Typenvarchar10
TOPGrantee Management
89GMAVCAActual line item table11DOCCTDocument Typenvarchar10
90GMAVCPPlan line items table11DOCCTDocument Typenvarchar10
91GMIAActual Line Item Table10DOCCTDocument Typenvarchar10
92GMIPPlan line items table10DOCCTDocument Typenvarchar10
TOPJoint Venture und Production Sharing Accounting
93ARC_IDB_ITArchive-Indextable for JV_BILLING4DOCCTDocument Typenvarchar10
94ARC_IDJ_ITArchive-Indextable for JV_OBJECT4DOCCTDocument Typenvarchar10
95JVGLFLEXPGeneral Ledger: Plan Line Items7DOCCTDocument Typenvarchar10
96JVPO1JVA: Plan Line Items11DOCCTDocument Typenvarchar10
97JVPSC01AActual line item table11DOCCTDocument Typenvarchar10
98JVPSC01PPlan line item table11DOCCTDocument Typenvarchar10
99JVSO1JV LI Table with Objects for JVTO111DOCCTDocument Typenvarchar10
100JVSO2JV Billing FI-SL Line Item10DOCCTDocument Typenvarchar10
TOPLocalization
101J_3RFTAXRATax Accounting: Actual line item table11DOCCTDocument Typenvarchar10
102J_3RFTAXRPTax Accounting: Plan line item table11DOCCTDocument Typenvarchar10
103J_3RFTAXRVATax Accounting: Actual line item table11DOCCTDocument Typenvarchar10
104J_3RFTAXRVPTax Accounting: Plan line item table11DOCCTDocument Typenvarchar10
TOPProfit Center Accounting
105ARC_IPC_ITArchive index table for FI-SL line items4DOCCTDocument Typenvarchar10
106GLPCAEC-PCA: Actual Line Items11DOCCTDocument Typenvarchar10
107GLPCPEC-PCA: Plan Line Items11DOCCTDocument Typenvarchar10
TOPRegulatory reporting for insurance companies
108ISSRFLDEAActual line item table11DOCCTDocument Typenvarchar10
109ISSRFLDEPPlan line items table11DOCCTDocument Typenvarchar10
TOPRemaining Beverage - Obsolete Objects
110/BEV3/CHFIAActual line item table11DOCCTDocument Typenvarchar10
111/BEV3/CHFIPPlan Line Items Table11DOCCTDocument Typenvarchar10
112/BEV3/CHVGRAActual line item table11DOCCTDocument Typenvarchar10
113/BEV3/CHVGRPPlan Line Items Table11DOCCTDocument Typenvarchar10
TOPRetail Ledger
114PCRRETAILAActual line item table11DOCCTDocument Typenvarchar10
115PCRRETAILPPlan line items table11DOCCTDocument Typenvarchar10
TOPSpecial Purpose Ledger
116/CCIS/PBU18APBU18: Actual line item table11DOCCTDocument Typenvarchar10
117/CCIS/PBU18PPBU18: Plan line item table11DOCCTDocument Typenvarchar10
118/CCIS/PROFTAXPPlan Line Items Table for General Ledger7DOCCTDocument Typenvarchar10
TOPTariffs, Duties and Permits
119OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger11DOCCTDocument Typenvarchar10
120OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger11DOCCTDocument Typenvarchar10
121OIHSLATDP (excise duty) special ledger actual line item table11DOCCTDocument Typenvarchar10
TOPTransfer to Financial Accounting
122TRACTSLAActual Line Item Table11DOCCTDocument Typenvarchar10
123TRACTSLPPlan Line Items Table11DOCCTDocument Typenvarchar10