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

113 columns | Print definition?ERP 6.0  | WSDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GLPCA_CTProfit Center Documents133WSDATValue Date for Currency Translationnvarchar80
2GLPCA_T_CTProfit Center Documents149WSDATValue Date for Currency Translationnvarchar80
3ZSAWAActual line item table35WSDATValue Date for Currency Translationnvarchar80
4ZSAWPPlan line items table115WSDATValue Date for Currency Translationnvarchar80
5ZSEMBPSAActual line item table31WSDATValue Date for Currency Translationnvarchar80
6ZSEMBPSPPlan line items table111WSDATValue Date for Currency Translationnvarchar80
7ZSPLITAIsteinzelposten-Tabelle35WSDATWertstellungsdatum für Währungsumrechnungnvarchar80
8ZSPLITPPlaneinzelposten-Tabelle115WSDATWertstellungsdatum für Währungsumrechnungnvarchar80
9ZZ001AActual Line Item Table42WSDATValue Date for Currency Translationnvarchar80
10ZZ001PPlan Line Items Table122WSDATValue Date for Currency Translationnvarchar80
11ZZLINEAActual line item table36WSDATValue Date for Currency Translationnvarchar80
12ZZLINEPPlan line items table100WSDATValue Date for Currency Translationnvarchar80
13ZZSL01AActual line item table44WSDATValue Date for Currency Translationnvarchar80
14ZZSL01PPlan line items table124WSDATValue Date for Currency Translationnvarchar80
15ZZSPECAActual line item table35WSDATValue Date for Currency Translationnvarchar80
16ZZSPECPPlan line item table99WSDATValue Date for Currency Translationnvarchar80
TOPAvailability Control
17FMAVCAActual line item table34WSDATValue Date for Currency Translationnvarchar80
18FMAVCPPlan line items table82WSDATValue Date for Currency Translationnvarchar80
TOPBasic Functions
19FILCAFI-LC: Actual journal entry table with 2 object tables45WSDATValue Date for Currency Translationnvarchar80
20FILCPFI-LC: Plan line items for object table123WSDATValue Date for Currency Translationnvarchar80
21GGREFAExample for Global FI-SL Line Items (Actual)37WSDATValue Date for Currency Translationnvarchar80
22GGREFPExample for Global FI-SL Line Items (Plan)117WSDATValue Date for Currency Translationnvarchar80
23GLFUNCAActual Line Items Table for Cost of Sales Accounting35WSDATValue Date for Currency Translationnvarchar80
24GLFUNCPPlan Line Items Table for Cost of Sales Accounting99WSDATValue Date for Currency Translationnvarchar80
25GLFUNCURollup line item tables with function area for IDES35WSDATValue Date for Currency Translationnvarchar80
26GLFUNCVRollup plan line items table with function area for IDES99WSDATValue Date for Currency Translationnvarchar80
27GLPO1Plan Line Items for Object Table125WSDATValue Date for Currency Translationnvarchar80
28GLPO2Plan Line Items for Object Table Global133WSDATValue Date for Currency Translationnvarchar80
29GLPO3Plan Line Items for Object Table125WSDATValue Date for Currency Translationnvarchar80
30GLREFAExample for Local FI-SL Line Items (Actual)35WSDATValue Date for Currency Translationnvarchar80
31GLREFPExample for Local FI-SL Line Items (Plan)115WSDATValue Date for Currency Translationnvarchar80
32GLREFUExample for FI-SL Rollup Line Items (Actual)37WSDATValue Date for Currency Translationnvarchar80
33GLREFVExample for Rollup FI-SL Line Items (Plan)117WSDATValue Date for Currency Translationnvarchar80
34GLSO1FI-SL Line Item Table with Objects for GLTO146WSDATValue Date for Currency Translationnvarchar80
35GLSO2FI-SL Table with Objects, Structure corresponds to GLS254WSDATValue Date for Currency Translationnvarchar80
36GLSO3FI-SL LI Table with Objects for GLTO346WSDATValue Date for Currency Translationnvarchar80
TOPBudgeting
37FMBDAActual line item table35WSDATValue Date for Currency Translationnvarchar80
38FMBDPFM Budget change line items table83WSDATValue Date for Currency Translationnvarchar80
39FMRBAActual line item table33WSDATValue Date for Currency Translationnvarchar80
40FMRBPPlan line items table81WSDATValue Date for Currency Translationnvarchar80
TOPCollectionsDisbursements
41GLISDEAActual Line Item Tables for Insurance (DE)47WSDATValue Date for Currency Translationnvarchar80
42GLISDEPPlan Line Item Table for Insurance (DE)111WSDATValue Date for Currency Translationnvarchar80
43GRISDEAActual Line Item Table for Insurance (DE) - Rollup47WSDATValue Date for Currency Translationnvarchar80
44GRISDEPPlan Line Item Table for Insurance (DE) - Rollup111WSDATValue Date for Currency Translationnvarchar80
TOPConsolidation
45ECMCASAP Cons.: Journal Entry Table (Actual)44WSDATValue Date for Currency Translationnvarchar80
TOPControlling
46COPPP_HDRCO Postprocessing List - Headers26WSDATValue Date for Currency Translationnvarchar80
TOPCost Element Accounting
47COFIPSingle plan items for reconciliation ledger111WSDATValue Date for Currency Translationnvarchar80
48COFISActual line items for reconciliation ledger48WSDATValue Date for Currency Translationnvarchar80
TOPFinancial Accounting
49FBICRC001AICRC: Open Items GL Accounts: Documents25WSDATValue Date for Currency Translationnvarchar80
50FBICRC001PNot in use40WSDATValue Date for Currency Translationnvarchar80
51FBICRC002AICRC: GL Accounts: Documents25WSDATValue Date for Currency Translationnvarchar80
52FBICRC002PNot in use40WSDATValue Date for Currency Translationnvarchar80
53FBICRC003AICRC: Open Items Customers/Vendors: Documents26WSDATValue Date for Currency Translationnvarchar80
54FBICRC003PNot in use41WSDATValue Date for Currency Translationnvarchar80
TOPFinancial Services Localization
55/CEEIS/RUAActual line item table46WSDATValue Date for Currency Translationnvarchar80
56/CEEIS/RUPPlan line items table126WSDATValue Date for Currency Translationnvarchar80
TOPFlexible Real Estate Management
57VIPRLEDTAGRAIsteinzelposten-Tabelle25WSDATWertstellungsdatum für Währungsumrechnungnvarchar80
58VIPRLEDTAGRPPlaneinzelposten-Tabelle89WSDATWertstellungsdatum für Währungsumrechnungnvarchar80
TOPFund Accounting
59FMCCAVCAActual line item table31WSDATValue Date for Currency Translationnvarchar80
60FMCCAVCPPlan line items table79WSDATValue Date for Currency Translationnvarchar80
61FMGLFLEXPGeneral Ledger: Plan Line Items117WSDATValue Date for Currency Translationnvarchar80
62PSGLFLEXPGeneral Ledger: Plan Line Items121WSDATValue Date for Currency Translationnvarchar80
TOPFunds Management
63FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60036WSDATValue Date for Currency Translationnvarchar80
64FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60040WSDATValue Date for Currency Translationnvarchar80
65FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60036WSDATValue Date for Currency Translationnvarchar80
66FMIAActual Line Item Table for Funds Management38WSDATValue Date for Currency Translationnvarchar80
67FMIPPlan Line Items Table for Funds Management70WSDATValue Date for Currency Translationnvarchar80
68FMSPLITAActual line item table39WSDATValue Date for Currency Translationnvarchar80
69FMSPLITPPlan line items table71WSDATValue Date for Currency Translationnvarchar80
70FMUSFGAActual line item table for US Federal Government.36WSDATValue Date for Currency Translationnvarchar80
71FMUSFGFACTS1A4Actual line item table36WSDATValue Date for Currency Translationnvarchar80
72FMUSFGFACTS1PPlan line items table68WSDATValue Date for Currency Translationnvarchar80
73FMUSFGFACTS2AActual line item table40WSDATValue Date for Currency Translationnvarchar80
74FMUSFGFACTS2PPlan line items table72WSDATValue Date for Currency Translationnvarchar80
75FMUSFGPPlan line items table68WSDATValue Date for Currency Translationnvarchar80
TOPGeneral Ledger Accounting
76FAGLFLEXPGeneral Ledger: Plan Line Items119WSDATValue Date for Currency Translationnvarchar80
77GLFLEXAFlexible general ledger: Actual line items37WSDATValue Date for Currency Translationnvarchar80
78GLFLEXPFlexible G/L: Plan line items117WSDATValue Date for Currency Translationnvarchar80
TOPGrantee Management
79GMAVCAActual line item table34WSDATValue Date for Currency Translationnvarchar80
80GMAVCPPlan line items table98WSDATValue Date for Currency Translationnvarchar80
81GMIAActual Line Item Table32WSDATValue Date for Currency Translationnvarchar80
82GMIPPlan line items table80WSDATValue Date for Currency Translationnvarchar80
TOPJoint Venture und Production Sharing Accounting
83JVGLFLEXPGeneral Ledger: Plan Line Items121WSDATValue Date for Currency Translationnvarchar80
84JVPO1JVA: Plan Line Items109WSDATValue Date for Currency Translationnvarchar80
85JVPSC01AActual line item table45WSDATValue Date for Currency Translationnvarchar80
86JVPSC01PPlan line item table109WSDATValue Date for Currency Translationnvarchar80
87JVSO1JV LI Table with Objects for JVTO145WSDATValue Date for Currency Translationnvarchar80
88JVSO2JV Billing FI-SL Line Item30WSDATValue Date for Currency Translationnvarchar80
TOPLocalization
89J_3RFTAXRATax Accounting: Actual line item table46WSDATValue Date for Currency Translationnvarchar80
90J_3RFTAXRPTax Accounting: Plan line item table94WSDATValue Date for Currency Translationnvarchar80
91J_3RFTAXRVATax Accounting: Actual line item table46WSDATValue Date for Currency Translationnvarchar80
92J_3RFTAXRVPTax Accounting: Plan line item table94WSDATValue Date for Currency Translationnvarchar80
TOPOverhead Cost Controlling
93COBKCO Object: Document Header25WSDATValue Date for Currency Translationnvarchar80
TOPOverhead Cost Orders
94AUAKDocument Header for Settlement7WSDATValue Date for Currency Translationnvarchar80
TOPProfit Center Accounting
95GLPCAEC-PCA: Actual Line Items42WSDATValue Date for Currency Translationnvarchar80
96GLPCPEC-PCA: Plan Line Items103WSDATValue Date for Currency Translationnvarchar80
TOPReal Estate Management
97IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)22WSDATValue Date for Currency Translationnvarchar80
TOPRegulatory reporting for insurance companies
98ISSRFLDEAActual line item table69WSDATValue Date for Currency Translationnvarchar80
99ISSRFLDEPPlan line items table149WSDATValue Date for Currency Translationnvarchar80
TOPRemaining Beverage - Obsolete Objects
100/BEV3/CHFIAActual line item table33WSDATValue Date for Currency Translationnvarchar80
101/BEV3/CHFIPPlan Line Items Table113WSDATValue Date for Currency Translationnvarchar80
102/BEV3/CHVGRAActual line item table35WSDATValue Date for Currency Translationnvarchar80
103/BEV3/CHVGRPPlan Line Items Table115WSDATValue Date for Currency Translationnvarchar80
TOPRetail Ledger
104PCRRETAILAActual line item table34WSDATValue Date for Currency Translationnvarchar80
105PCRRETAILPPlan line items table114WSDATValue Date for Currency Translationnvarchar80
TOPSpecial Purpose Ledger
106/CCIS/PBU18APBU18: Actual line item table48WSDATValue Date for Currency Translationnvarchar80
107/CCIS/PBU18PPBU18: Plan line item table128WSDATValue Date for Currency Translationnvarchar80
108/CCIS/PROFTAXPPlan Line Items Table for General Ledger129WSDATValue Date for Currency Translationnvarchar80
TOPTariffs, Duties and Permits
109OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger49WSDATValue Date for Currency Translationnvarchar80
110OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger129WSDATValue Date for Currency Translationnvarchar80
111OIHSLATDP (excise duty) special ledger actual line item table54WSDATValue Date for Currency Translationnvarchar80
TOPTransfer to Financial Accounting
112TRACTSLAActual Line Item Table27WSDATValue Date for Currency Translationnvarchar80
113TRACTSLPPlan Line Items Table107WSDATValue Date for Currency Translationnvarchar80