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

116 columns | Print definition?ERP 6.0  | REFDOCCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents100REFDOCCTDocument Typenvarchar10
2GLPCA_T_CTProfit Center Documents116REFDOCCTDocument Typenvarchar10
3ZSAWAActual line item table39REFDOCCTReference document categorynvarchar10
4ZSAWPPlan line items table119REFDOCCTReference document categorynvarchar10
5ZSEMBPSAActual line item table35REFDOCCTReference document categorynvarchar10
6ZSEMBPSPPlan line items table115REFDOCCTReference document categorynvarchar10
7ZSPLITAIsteinzelposten-Tabelle39REFDOCCTReferenz-Belegtypnvarchar10
8ZSPLITPPlaneinzelposten-Tabelle119REFDOCCTReferenz-Belegtypnvarchar10
9ZZ001AActual Line Item Table46REFDOCCTReference document categorynvarchar10
10ZZ001PPlan Line Items Table126REFDOCCTReference document categorynvarchar10
11ZZLINEAActual line item table40REFDOCCTReference document categorynvarchar10
12ZZLINEPPlan line items table104REFDOCCTReference document categorynvarchar10
13ZZSL01AActual line item table48REFDOCCTReference document categorynvarchar10
14ZZSL01PPlan line items table128REFDOCCTReference document categorynvarchar10
15ZZSPECAActual line item table39REFDOCCTDocument Typenvarchar10
16ZZSPECPPlan line item table103REFDOCCTDocument Typenvarchar10
TOPAvailability Control
17FMAVCAActual line item table38REFDOCCTReference document categorynvarchar10
18FMAVCPPlan line items table86REFDOCCTReference document categorynvarchar10
TOPBasic Functions
19ARC_IDX_ITArchive index table for FI-SL line items11REFDOCCTDocument Typenvarchar10
20FILCAFI-LC: Actual journal entry table with 2 object tables49REFDOCCTDocument Typenvarchar10
21FILCPFI-LC: Plan line items for object table127REFDOCCTDocument Typenvarchar10
22GGREFAExample for Global FI-SL Line Items (Actual)41REFDOCCTReference document categorynvarchar10
23GGREFPExample for Global FI-SL Line Items (Plan)121REFDOCCTReference document categorynvarchar10
24GLFUNCAActual Line Items Table for Cost of Sales Accounting39REFDOCCTReference document categorynvarchar10
25GLFUNCPPlan Line Items Table for Cost of Sales Accounting103REFDOCCTReference document categorynvarchar10
26GLFUNCURollup line item tables with function area for IDES39REFDOCCTReference document categorynvarchar10
27GLFUNCVRollup plan line items table with function area for IDES103REFDOCCTReference document categorynvarchar10
28GLP0Local Logical General Ledger Plan Line Items77REFDOCCTDocument Typenvarchar10
29GLPO1Plan Line Items for Object Table129REFDOCCTDocument Typenvarchar10
30GLPO2Plan Line Items for Object Table Global137REFDOCCTDocument Typenvarchar10
31GLPO3Plan Line Items for Object Table129REFDOCCTDocument Typenvarchar10
32GLREFAExample for Local FI-SL Line Items (Actual)39REFDOCCTReference document categorynvarchar10
33GLREFPExample for Local FI-SL Line Items (Plan)119REFDOCCTReference document categorynvarchar10
34GLREFUExample for FI-SL Rollup Line Items (Actual)41REFDOCCTReference document categorynvarchar10
35GLREFVExample for Rollup FI-SL Line Items (Plan)121REFDOCCTReference document categorynvarchar10
36GLSO1FI-SL Line Item Table with Objects for GLTO150REFDOCCTDocument Typenvarchar10
37GLSO2FI-SL Table with Objects, Structure corresponds to GLS258REFDOCCTDocument Typenvarchar10
38GLSO3FI-SL LI Table with Objects for GLTO350REFDOCCTDocument Typenvarchar10
TOPBudgeting
39FMBDAActual line item table39REFDOCCTReference document categorynvarchar10
40FMBDPFM Budget change line items table87REFDOCCTReference document categorynvarchar10
41FMRBAActual line item table37REFDOCCTReference document categorynvarchar10
42FMRBPPlan line items table85REFDOCCTReference document categorynvarchar10
TOPCollectionsDisbursements
43GLISDEAActual Line Item Tables for Insurance (DE)51REFDOCCTDocument Typenvarchar10
44GLISDEPPlan Line Item Table for Insurance (DE)115REFDOCCTDocument Typenvarchar10
45GRISDEAActual Line Item Table for Insurance (DE) - Rollup51REFDOCCTDocument Typenvarchar10
46GRISDEPPlan Line Item Table for Insurance (DE) - Rollup115REFDOCCTDocument Typenvarchar10
TOPConsolidation
47ECMCASAP Cons.: Journal Entry Table (Actual)48REFDOCCTDocument Typenvarchar10
TOPCost Element Accounting
48COFIPSingle plan items for reconciliation ledger115REFDOCCTDocument Typenvarchar10
49COFISActual line items for reconciliation ledger52REFDOCCTDocument Typenvarchar10
TOPFinancial Accounting
50FBICRC001AICRC: Open Items GL Accounts: Documents29REFDOCCTReference document categorynvarchar10
51FBICRC001PNot in use44REFDOCCTReference document categorynvarchar10
52FBICRC002AICRC: GL Accounts: Documents29REFDOCCTReference document categorynvarchar10
53FBICRC002PNot in use44REFDOCCTReference document categorynvarchar10
54FBICRC003AICRC: Open Items Customers/Vendors: Documents30REFDOCCTReference document categorynvarchar10
55FBICRC003PNot in use45REFDOCCTReference document categorynvarchar10
TOPFinancial Services Localization
56/CEEIS/RUAActual line item table50REFDOCCTReference document categorynvarchar10
57/CEEIS/RUPPlan line items table130REFDOCCTReference document categorynvarchar10
TOPFlexible Real Estate Management
58VIPRLEDTAGRAIsteinzelposten-Tabelle29REFDOCCTReferenz-Belegtypnvarchar10
59VIPRLEDTAGRPPlaneinzelposten-Tabelle93REFDOCCTReferenz-Belegtypnvarchar10
TOPFund Accounting
60FMCCAVCAActual line item table35REFDOCCTReference document categorynvarchar10
61FMCCAVCPPlan line items table83REFDOCCTReference document categorynvarchar10
62FMGLFLEXPGeneral Ledger: Plan Line Items120REFDOCCTReference document categorynvarchar10
63PSGLFLEXPGeneral Ledger: Plan Line Items124REFDOCCTReference document categorynvarchar10
TOPFunds Management
64FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60041REFDOCCTReference document categorynvarchar10
65FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60045REFDOCCTReference document categorynvarchar10
66FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60041REFDOCCTReference document categorynvarchar10
67FMIAActual Line Item Table for Funds Management42REFDOCCTDocument Typenvarchar10
68FMIPPlan Line Items Table for Funds Management74REFDOCCTDocument Typenvarchar10
69FMSPLITAActual line item table43REFDOCCTReference document categorynvarchar10
70FMSPLITPPlan line items table75REFDOCCTReference document categorynvarchar10
71FMUSFGAActual line item table for US Federal Government.41REFDOCCTReference document categorynvarchar10
72FMUSFGFACTS1A4Actual line item table41REFDOCCTReference document categorynvarchar10
73FMUSFGFACTS1PPlan line items table72REFDOCCTReference document categorynvarchar10
74FMUSFGFACTS2AActual line item table45REFDOCCTReference document categorynvarchar10
75FMUSFGFACTS2PPlan line items table76REFDOCCTReference document categorynvarchar10
76FMUSFGPPlan line items table72REFDOCCTReference document categorynvarchar10
TOPGeneral Ledger Accounting
77FAGLFLEXPGeneral Ledger: Plan Line Items122REFDOCCTReference document categorynvarchar10
78GLFLEXAFlexible general ledger: Actual line items43REFDOCCTReference document categorynvarchar10
79GLFLEXPFlexible G/L: Plan line items121REFDOCCTReference document categorynvarchar10
TOPGrantee Management
80GMAVCAActual line item table38REFDOCCTReference document categorynvarchar10
81GMAVCPPlan line items table102REFDOCCTReference document categorynvarchar10
82GMIAActual Line Item Table36REFDOCCTReference document categorynvarchar10
83GMIPPlan line items table84REFDOCCTReference document categorynvarchar10
TOPJoint Venture und Production Sharing Accounting
84ARC_IDB_ITArchive-Indextable for JV_BILLING9REFDOCCTDocument Typenvarchar10
85ARC_IDJ_ITArchive-Indextable for JV_OBJECT9REFDOCCTDocument Typenvarchar10
86JVGLFLEXPGeneral Ledger: Plan Line Items124REFDOCCTReference document categorynvarchar10
87JVPO1JVA: Plan Line Items114REFDOCCTDocument Typenvarchar10
88JVPSC01AActual line item table49REFDOCCTDocument Typenvarchar10
89JVPSC01PPlan line item table113REFDOCCTDocument Typenvarchar10
90JVSO1JV LI Table with Objects for JVTO150REFDOCCTDocument Typenvarchar10
91JVSO2JV Billing FI-SL Line Item34REFDOCCTDocument Typenvarchar10
92T8JVBADocuments included in Bank Account Switching13REFDOCCTDocument Typenvarchar10
93T8J_JVECJVA equity change document relationship15REFDOCCTDocument Typenvarchar10
TOPLocalization
94J_3RFTAXRATax Accounting: Actual line item table50REFDOCCTDocument Typenvarchar10
95J_3RFTAXRPTax Accounting: Plan line item table98REFDOCCTDocument Typenvarchar10
96J_3RFTAXRVATax Accounting: Actual line item table50REFDOCCTDocument Typenvarchar10
97J_3RFTAXRVPTax Accounting: Plan line item table98REFDOCCTDocument Typenvarchar10
TOPProfit Center Accounting
98ARC_IPC_ITArchive index table for FI-SL line items11REFDOCCTDocument Typenvarchar10
99GLPCAEC-PCA: Actual Line Items46REFDOCCTDocument Typenvarchar10
100GLPCPEC-PCA: Plan Line Items107REFDOCCTDocument Typenvarchar10
TOPRegulatory reporting for insurance companies
101ISSRFLDEAActual line item table73REFDOCCTReference document categorynvarchar10
102ISSRFLDEPPlan line items table153REFDOCCTReference document categorynvarchar10
TOPRemaining Beverage - Obsolete Objects
103/BEV3/CHFIAActual line item table37REFDOCCTDocument Typenvarchar10
104/BEV3/CHFIPPlan Line Items Table117REFDOCCTDocument Typenvarchar10
105/BEV3/CHVGRAActual line item table39REFDOCCTDocument Typenvarchar10
106/BEV3/CHVGRPPlan Line Items Table119REFDOCCTDocument Typenvarchar10
TOPRetail Ledger
107PCRRETAILAActual line item table38REFDOCCTReference document categorynvarchar10
108PCRRETAILPPlan line items table118REFDOCCTReference document categorynvarchar10
TOPSpecial Purpose Ledger
109/CCIS/PBU18APBU18: Actual line item table52REFDOCCTReference document categorynvarchar10
110/CCIS/PBU18PPBU18: Plan line item table132REFDOCCTReference document categorynvarchar10
111/CCIS/PROFTAXPPlan Line Items Table for General Ledger132REFDOCCTReference document categorynvarchar10
TOPTariffs, Duties and Permits
112OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger53REFDOCCTReference document categorynvarchar10
113OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger133REFDOCCTReference document categorynvarchar10
114OIHSLATDP (excise duty) special ledger actual line item table58REFDOCCTDocument Typenvarchar10
TOPTransfer to Financial Accounting
115TRACTSLAActual Line Item Table31REFDOCCTReference document categorynvarchar10
116TRACTSLPPlan Line Items Table111REFDOCCTReference document categorynvarchar10