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

180 columns | Print definition?ERP 6.0  | KSTAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items100KSTARnvarchar100
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact100KSTARnvarchar100
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items143KSTARnvarchar100
4/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs13KSTARnvarchar100
5/BIC/B0000222000PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections12KSTARnvarchar100
6/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta17KSTARnvarchar100
7AUASSettlement Document: Totals Segment8KSTARCost Elementnvarchar100
8AUATSettlement Document: Totals Segment Per Period9KSTARCost Elementnvarchar100
9AUAWSettlement Document: Accounts for WIP Settlement12KSTARCost Elementnvarchar100
10BSEGAccounting Document Segment322KSTARCost Elementnvarchar100
11CE1PR22Périm. résultat IDES42KSTARNature comptablenvarchar100
12CE2PR22Périm. résultat IDES32KSTARNature comptablenvarchar100
13CNV_20100_COESDuplicate COES keys (target values)12KSTARCost Elementnvarchar100
14CNV_20100_CSKABackup copy - CSKA4KSTARCost Elementnvarchar100
15CNV_20100_CSKBBackup copy - CSKB4KSTARCost Elementnvarchar100
16CNV_20100_CSKUBackup copy - Cost Element Texts5KSTARCost Elementnvarchar100
17FUDT_VDOCBSEGVerification Document Item with Additional Info311KSTARCost Elementnvarchar100
18FUDT_VDOCBSEGEVVerification Document Item in the Entry View311KSTARCost Elementnvarchar100
19FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)311KSTARCost Elementnvarchar100
20GLPOS_C_CTFI Document: Entry View149KSTARCost Elementnvarchar100
21GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items149KSTARCost Elementnvarchar100
22GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items149KSTARCost Elementnvarchar100
23GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items149KSTARCost Elementnvarchar100
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type151KSTARCost Elementnvarchar100
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type151KSTARCost Elementnvarchar100
26MLAUFHHistory table for summarized MLAUF data14KSTARCost Elementnvarchar100
27T5UEFFR_BUND_RECTemporary storage of Bundled records in Effort Certification5KSTARCost Elementnvarchar100
28TCKHACost Element/Origin Assignment with Additive Costs5KSTARCost Elementnvarchar100
29TKA3AAutomatic account assignment - default assignments3KSTARCost Elementnvarchar100
30TKA3CAutomatic Acct. Assignment: Specific Assignments3KSTARCost Elementnvarchar100
31TKA3PAutomatic Account Assignment: Specific Assignments3KSTARCost Elementnvarchar100
32TKKEPUnit Costing Price Elements5KSTARCost Elementnvarchar100
33VIYCCOST2DCApplication of Distribution / Denominator Method14KSTARCost Elementnvarchar100
34VIYCCOST2OBJDetermined Costs for Objects in CAM recovery10KSTARCost Elementnvarchar100
35VIYCCOST2POOLDetermined Costs for Lease in CAM Recovery12KSTARCost Elementnvarchar100
36VIYCMETERCOSTSMeter Based Costs8KSTARCost Elementnvarchar100
37VIYCSTLMTRCOSTSettled Meter Costs with lease8KSTARCost Elementnvarchar100
38ZABW01Allowed deviation for period2KSTARCost Elementnvarchar100
39ZCOST_ELEMENTSCost Elements2KSTARCost Elementnvarchar100
40ZKSTAFB01 Postings cost types3KSTARCost Elementnvarchar100
TOPAccounting Interface
41GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)417KSTARCost Elementnvarchar100
42GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)417KSTARCost Elementnvarchar100
TOPActual CostingMaterial Ledger
43MLAUFMaterial Ledger Item Table for Order History13KSTARCost Elementnvarchar100
44MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction16KSTARCost Elementnvarchar100
45MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction16KSTARCost Elementnvarchar100
TOPActual Revenues and Forecast
46TEBCOCO/SD Interface: Product Number Determination from CO4KSTARKey conversion CO/SD: upper limit of cost element intervalnvarchar100
TOPBudgeting
47FMCY_COPIFor CO plan data transfer5KSTARCost Elementnvarchar100
TOPBusiness Package for Manager Self-Service FI
48FCOM_KFPRICEKey Figure Prices4KSTARCost Elementnvarchar100
49FCOM_KSTARCost Elements for Users7KSTARCharacteristic Specifying Key Figurenvarchar340
TOPConstruction Progress Report
50/SAPPCE/TPNV01Constr.Progr. Report/Plan Data: Definition of Cost Elements4KSTARCost Elementnvarchar100
51/SAPPCE/TPNV01KConstruction Progress Report: Definition Offsetting Account4KSTAROffsetting Accountnvarchar100
52/SAPPCE/TPNV14Constr.Progress Report: Definition Consolidation Account3KSTARCost Elementnvarchar100
TOPControlling
53COPPP_ITMCO Postprocessing List - Items25KSTARCost Elementnvarchar100
54CRMCO_CONF_COSTSCRM/CO: Actual Costs for Confirmations9KSTARCost Elementnvarchar100
55CSKACost Elements (Data Dependent on Chart of Accounts)3KSTARCost Elementnvarchar100
56CSKBCost Elements (Data Dependent on Controlling Area)3KSTARCost Elementnvarchar100
57CSKUCost Element Texts4KSTARCost Elementnvarchar100
58TKA08Price variances4KSTARCost Elementnvarchar100
59TKA30Automatic account assignment4KSTARCost Elementnvarchar100
TOPCost Center Accounting
60COSPRCO Objekt: Enhancement to COSP for Dependency Planning7KSTARCost Elementnvarchar100
61TKZU9Credit objects for target/actual cost elements3KSTARCost Elementnvarchar100
62TKZX3Credit objects for overhead cost elements per BUKRS/GSBER8KSTARCost Elementnvarchar100
63TKZX9Credit objects for tgt=act. cost elements per BUKRS/GSBER5KSTARCost Elementnvarchar100
TOPCost Object
64COEPBCO Object: Line Items Variance/Period-Based Results Analysis20KSTARCost Elementnvarchar100
65COSBCO Object: Total Variances/Results Analyses8KSTARCost Elementnvarchar100
66FCO_DOC_POSFailure Cost Document Item14KSTARCost Elementnvarchar100
67TKKABPosting Rules for Results Analysis Data9KSTARCost Elementnvarchar100
TOPCosting
68COERSales Order Value Revenue6KSTARCost Elementnvarchar100
69COESCO Object: Sales Order Value Line Items11KSTARCost Elementnvarchar100
TOPCross-Application Components
70AAUUFKOrder master data44KSTARSettlement cost elementnvarchar100
71MPO_CCMON_RULESCost Center Monitor: Rule Definition for Exception Reporting19KSTARCost Elementnvarchar100
TOPData Collection
72CF003Projects36KSTARCost elementnvarchar80
73S092Resource Requirements: Material9KSTARCost Elementnvarchar100
74S092ES092 - Structural Information4KSTARCost Elementnvarchar100
TOPData Retention Tool
75TXW_S_COEPRetrieve COEP from archive11KSTARCost Elementnvarchar100
TOPExpense-Related Billing
76PRSD_DMRP_ACC_CHEngagement Mgmt: Accrual Characteristics for DMR Lines9KSTARCost Elementnvarchar100
TOPExternal Services
77ESLLLines of Service Package72KSTARCost Elementnvarchar100
78ESUHExt. Services Management: Unpl. Service Limits: Header Data33KSTARCost Elementnvarchar100
TOPFinancial Accounting
79/BGLOCS/FIFXACOOSettlement Cost Elements Types7KSTARSettlement cost element for receivernvarchar100
80FERC_C10Special cost elements4KSTARCost Elementnvarchar100
81FERC_C4Specific standard cost adjustment assignments5KSTARCost Elementnvarchar100
82FERC_C5Specific clearing cost object assignments6KSTARClearing cost elementnvarchar100
83FERC_F3Totals per source object, transaction type, and CO element5KSTARCost Elementnvarchar100
TOPFlexible Real Estate Management
84VIAKHOWPWEG-Verwaltung: Eigentümerabrechnung Wirtschaftsplan7KSTARKostenartnvarchar100
TOPFunds Management
85FMCOPICO-FM: Plan Data Transfer - Annual/Overall Values9KSTARCost Elementnvarchar100
86FMICOITFM/CO integration: Line item18KSTARCost Elementnvarchar100
87FMZUCHChange information on allocation of CO Object to FM Object3KSTARCost Elementnvarchar100
88FMZUGRAllocation of CO Group to FM Account Assignment3KSTARCost Elementnvarchar100
89FMZUKAAllocation of Cost Element to FM Account Assignment2KSTARCost Elementnvarchar100
90FMZUOBAllocation of CO Object to FM Account Assignment3KSTARCost Elementnvarchar100
91KBLPDocument Item: Manual Document Entry21KSTARCost Elementnvarchar100
92TBPFKAvailability Control: Cost Elements Exempted3KSTARCost Elementnvarchar100
TOPGeneral Ledger Accounting
93BSEG_ADDEntry View of Accounting Document for Additional Ledgers109KSTARCost Elementnvarchar100
TOPInformation System
94MCKALKVVersions: Cost Itemization7KSTARCost Elementnvarchar100
95MCKALKWVersions: Cost Itemization4KSTARCost Elementnvarchar100
96MCSFISR/2 SFIS Data: Old8KSTARCost Elementnvarchar100
TOPInventory Management
97MWZDM07M2ZDM07M2238KSTARAccount numbernvarchar160
TOPLocal Currency Changeover
98EWUCOKException table for TWAER conversion8KSTARCost Elementnvarchar100
TOPLocalization
99J_3RNDSINVTarget use of ingoing invoice positions for AuC20KSTARCost Elementnvarchar100
100J_3RTSESecondary index table for VAT22KSTARCost Elementnvarchar100
101VIXCFRBUDGETBudget Seasonality Data7KSTARCost Elementnvarchar100
TOPMaintenance Orders
102TPEXTProfile for external procurement3KSTARCost Elementnvarchar100
TOPMaterials Management
103J_1GVL_MLMaterial Ledger116KSTARCost Elementnvarchar100
104J_1GVL_WHB004Valid G/L Accounts6KSTARCost Elementnvarchar100
TOPOrders for Projects
105COSPPTransfer of the Order in the COSP Table to the Project8KSTARCost Elementnvarchar100
106COSSPTransfer of the Order COSS Table to the Project8KSTARCost Elementnvarchar100
TOPOverhead Cost Controlling
107COEJCO Object: Line Items (by Fiscal Year)171KSTARCost Elementnvarchar100
108COEPCO Object: Line Items (by Period)21KSTARCost Elementnvarchar100
109COINT_TKB6TPControlling Integration: Account Determination for Reposting6KSTARCost Elementnvarchar100
110COINT_TPOST_ITControlling Integration: Reposting: Line Items5KSTARCost Elementnvarchar100
111COKACO Object: Control Data for Cost Elements4KSTARCost Elementnvarchar100
112COKPCO Object: Control Data for Primary Planning7KSTARCost Elementnvarchar100
113COKSCO Object: Control Data for Secondary Planning7KSTARCost Elementnvarchar100
114COSPCO Object: Cost Totals for External Postings7KSTARCost Elementnvarchar100
115COSSCO Object: Cost Totals for Internal Postings7KSTARCost Elementnvarchar100
116COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis23KSTARCost Elementnvarchar100
117CSSKCost center /cost element6KSTARCost Elementnvarchar100
118T823PRevaluation percentages (plan)6KSTARCost Elementnvarchar100
119T823ZRevaluation percentages (plan)7KSTARCost Elementnvarchar100
TOPOverhead Cost Orders
120AUAKDocument Header for Settlement22KSTARSettlement cost element for receivernvarchar100
121AUFKOrder master data44KSTARSettlement cost elementnvarchar100
122COBRASettlement Rule for Order Settlement9KSTARSettlement cost element for receivernvarchar100
123COSBDCO Object: Total of variances/accruals, of which settled8KSTARCost Elementnvarchar100
124COSPDCO Object: Settled Primary Cost Totals7KSTARCost Elementnvarchar100
125COSSDCO Object: Settled Secondary Cost Totals7KSTARCost Elementnvarchar100
126TKB6Account Determination for Settlement6KSTARSettlement cost element for receivernvarchar100
127TKZU3Overhead Credit6KSTARCost Elementnvarchar100
TOPPatient Accounting
128NMCOIS-H MM: CO Transfer Information16KSTARCost Elementnvarchar100
TOPPegging, Grouping, and Distribution
129DIS_TOBJSDistribution: cost objects posted to per group7KSTARCost Elementnvarchar100
130DIS_TOBJS_COSPDistribution: Objects distributed to per Group WBS (Cost)8KSTARCost Elementnvarchar100
131DIS_TOBJS_COSSDistribution: Objects distributed to per Group WBS (Cost)7KSTARCost Elementnvarchar100
TOPPersonnel Administration
132PA0027HR Master Record: Infotype 0027 (Cost Distribution)24KSTARCosts to be distributednvarchar40
TOPProduct Cost Planning
133CKBSBase Planning Object - Unit Costing5KSTARCost Elementnvarchar100
134CKHSHeader: Unit Costing (Control + Totals)64KSTARCost Elementnvarchar100
135CKISItems Unit Costing/Itemization Product Costing14KSTARCost Elementnvarchar100
136CKPSUnit Costing Items10KSTARCost Elementnvarchar100
137CKTC_CBEWCosting Master Data - Attributes5KSTARCost Elementnvarchar100
138TJP_ECP_KPIECP: Pricing Key Definition4KSTARCost Elementnvarchar100
TOPProfitability Analysis
139CE1850042KSTARCost Elementnvarchar100
140CE1BGISErgebnisbereich für42KSTARKostenartnvarchar100
141CE1E_B1Model Bank42KSTARCost Elementnvarchar100
142CE1IDEAOp. Concern BR World42KSTARCost Elementnvarchar100
143CE1IDEBErgebnisbereich IDES42KSTARKostenartnvarchar100
144CE1IDESErgebnisbereich IDES42KSTARKostenartnvarchar100
145CE1INT1Ergebnisbereich IDES42KSTARKostenartnvarchar100
146CE1OC01Bike International42KSTARCost Elementnvarchar100
147CE1R300Operating Concern IDES42KSTARCost Elementnvarchar100
148CE1S001Sample operating concern69KSTARCost Elementnvarchar100
149CE1S300Operating Concern IDES42KSTARCost Elementnvarchar100
150CE1S_ALAirline Route Profit42KSTARCost Elementnvarchar100
151CE1S_CPTemplate for Consumer Goods Industry42KSTARCost Elementnvarchar100
152CE1S_GOQuickstart Template42KSTARCost Elementnvarchar100
153CE2850032KSTARCost Elementnvarchar100
154CE2BGISErgebnisbereich für32KSTARKostenartnvarchar100
155CE2E_B1Model Bank32KSTARCost Elementnvarchar100
156CE2IDEAOp. Concern BR World32KSTARCost Elementnvarchar100
157CE2IDEBErgebnisbereich IDES32KSTARKostenartnvarchar100
158CE2IDESErgebnisbereich IDES32KSTARKostenartnvarchar100
159CE2INT1Ergebnisbereich IDES32KSTARKostenartnvarchar100
160CE2OC01Bike International32KSTARCost Elementnvarchar100
161CE2R300Operating Concern IDES32KSTARCost Elementnvarchar100
162CE2S001Sample operating concern92KSTARCost Elementnvarchar100
163CE2S300Operating Concern IDES32KSTARCost Elementnvarchar100
164CE2S_ALAirline Route Profit32KSTARCost Elementnvarchar100
165CE2S_CPTemplate for Consumer Goods Industry32KSTARCost Elementnvarchar100
166CE2S_GOQuickstart Template32KSTARCost Elementnvarchar100
167CECOEJCO-PA Account Based Line Items173KSTARCost Elementnvarchar100
168CECOEPCO-PA Account Based Line Items23KSTARCost Elementnvarchar100
TOPProgress Analysis
169EVCEProgress: Cost Element Assignments3KSTARCost Elementnvarchar100
TOPReal Estate Management
170VIEA03Administration information: Objects of owner settlement4KSTARCost Elementnvarchar100
171VIEA06Management information: Owner for owner settlement4KSTARCost Elementnvarchar100
TOPRevenues and Earnings
172AD01DLIDynamic items (DI)8KSTARCost Elementnvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
173NLHCO_KOSTENARTNL-HCO: Kostenarten4KSTARGroepsnaamnvarchar150
174NLHCO_LEISTARTNL-HCO: Leistungsarten4KSTARKostensoortnvarchar100
TOPSimulation
175VSAUFK_CNVersion: Order master data45KSTARSettlement cost elementnvarchar100
TOPSingle Transaction Costing
176JBDFTPASSIGNMENTSAP Banking: Assignment of value fields to cost elements4KSTARCost Elementnvarchar100
TOPStatistical Key Figures
177ANLEAsset Origin by Line Item14KSTARCost Elementnvarchar100
178ANLKAsset Origin by Cost Element8KSTARCost Elementnvarchar100
TOPStructures
179PSSKF_DEFAU_TABDefault SKF for the the Project Parameters7KSTARCost Elementnvarchar100
TOPTransfer Prices and Decentralized Responsibility
180KFPPDocument Header: Transfer Prices for Tasks17KSTARCost Elementnvarchar100