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

173 columns | Print definition?ERP 6.0  | ERKRS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000481TKEB5ERKRSnvarchar40
2/1CADMC/00000484TKEBT6ERKRSnvarchar40
3/1CADMC/00000486TKEFE4ERKRSnvarchar40
4/BIC/B0000157000PSA for 0CO_AREA_ATTR T90CLNT090 CO Area10ERKRSnvarchar40
5CNV_20000_ERKRSOperating concerns involved in fiscal year conversion3ERKRSOperating concernnvarchar40
6CNV_20100_TKA01Backup copy - controlling areas13ERKRSOperating concernnvarchar40
7CNV_20305_TKA01backup table of TKA01 (certain fields only)10ERKRSOperating concernnvarchar40
8CNV_20551_RKEOBJNumbers for reference objects (CO-PA)3ERKRSOperating concernnvarchar40
9GLPCA_CTProfit Center Documents70ERKRSOperating concernnvarchar40
10GLPCA_T_CTProfit Center Documents86ERKRSOperating concernnvarchar40
11K9001Derivation table for derivation rule A012ERKRSOperating concernnvarchar40
12T237Name of report structure2ERKRSOperating concernnvarchar40
13T258ADetermining the costing sheet for condition access2ERKRSOperating concernnvarchar40
14T258FCO-PA access control for Product Costing2ERKRSOperating concernnvarchar40
15T258IAssignment: Condition types -> CO-PA value fields2ERKRSOperating concernnvarchar40
16T258KAssignment of Cost Components to CO-PA Value Fields2ERKRSOperating concernnvarchar40
17TBVZCO-PA report library (no longer used)2ERKRSOperating concernnvarchar40
18TBVZTCO-PA Report library3ERKRSOperating concernnvarchar40
19TKEBBManagement for Operating Concerns (Cross-Client)1ERKRSOperating concernnvarchar40
20TKEIGCO-PA characteristics table2ERKRSOperating concernnvarchar40
21TKEOEControl for Profitability Segment Structure2ERKRSOperating concernnvarchar40
22TKEPDCO-PA: Screen Catalog - Planning2ERKRSOperating concernnvarchar40
23TKETD_SETT_PERSCOPA TD KE28L: Personal Settings2ERKRSOperating concernnvarchar40
24TKEVSCO-PA version attributes3ERKRSOperating concernnvarchar40
25TKEWPCO-PA value fields2ERKRSOperating concernnvarchar40
26TKE_TIMERCO-PA Runtime Measurements3ERKRSOperating concernnvarchar40
27TVGAINumber range table for number range object COPA_IST2ERKRSOperating concernnvarchar40
28TVGAPNumber range table for number range object COPA_PLAN2ERKRSOperating concernnvarchar40
29TVGARCO-PA record types (not currently in use)1ERKRSOperating concernnvarchar40
TOPAccounting Interface
30TKESUCO-PA: Control Table for Summarization2ERKRSOperating concernnvarchar40
TOPAdvertising Management
31TJHTKEVA10Control Transfer from IS-M/AM to CO-PA (TKEVA10)2ERKRSOperating concernnvarchar40
TOPBank Components
32JBTBEWWERTAssignment of Flow Type to Value Fields2ERKRSOperating concernnvarchar40
TOPCollectionsDisbursements
33VVKKFOPSingle Doc in Posting Data Interface51ERKRSOperating concernnvarchar40
TOPContract Accounts Receivable and Payable
34DFKKCOPALog Table for COPA Transfer3ERKRSOperating concernnvarchar40
35FKK_EBS_TOI_COPACO-PA Characteristic Derivation from IDOC Data2ERKRSOperating concernnvarchar40
36TE760CO-PA Characteristic Derivation from IS-U Objects2ERKRSOperating concernnvarchar40
37TE761Control CO-PA Posting by Consumption Months2ERKRSOperating concernnvarchar40
38TE762Unbilled Revenue Reporting: CO-PA Characteristic Derivation3ERKRSOperating concernnvarchar40
TOPContract Billing
39TE540CUpdate Quantities to CO-PA3ERKRSOperating concernnvarchar40
40TE541CUpdate Amounts to CO-PA3ERKRSOperating concernnvarchar40
TOPControlling
41TKA01Controlling Areas15ERKRSOperating concernnvarchar40
TOPIndustry Solution - Telecommunications
42IST_EBS_TOI_COPACO-PA Characteristic Derivation from IDOC Data2ERKRSOperating concernnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
43TFK2610CO-PA Characteristic Derivation3ERKRSOperating concernnvarchar40
TOPOverhead Cost Controlling
44PFFLDPeriod-End Partner: Organizational Log Information11ERKRSOperating concernnvarchar40
TOPPeriodical Sales and Distribution
45TJFTKEVA10Controls for Transfer from IS-M/SD to CO-PA (TKEVA10)2ERKRSOperating concernnvarchar40
TOPProfit Center Accounting
46GLPCAEC-PCA: Actual Line Items68ERKRSOperating concernnvarchar40
47GLPCPEC-PCA: Plan Line Items126ERKRSOperating concernnvarchar40
TOPProfitability Analysis
48CEALE01CO-PA Distribution: Line Item Reference for Distribution5ERKRSOperating concernnvarchar40
49CECOEJCO-PA Account Based Line Items6ERKRSOperating concernnvarchar40
50CECOEPCO-PA Account Based Line Items5ERKRSOperating concernnvarchar40
51COPA_CRM_GUIDMAPMapping Table CRM GUIDS - CO-PA Document Numbers7ERKRSnvarchar40
52COPA_GUID_MAPMapping Table between CRM GUIDS and CO-PA Database Structure5ERKRSnvarchar40
53K9066Ableitungstabelle für Ableitungsregel M102ERKRSOperating concernnvarchar40
54K9067Ableitungstabelle für Ableitungsregel M102ERKRSOperating concernnvarchar40
55K9068Ableitungstabelle für Ableitungsregel M202ERKRSOperating concernnvarchar40
56K9070Ableitungstabelle für Ableitungsregel C102ERKRSOperating concernnvarchar40
57K9071Ableitungstabelle für Ableitungsregel O102ERKRSOperating concernnvarchar40
58RKE_POST_LOGLog: Post Directly to CO-PA2ERKRSOperating concernnvarchar40
59SMCOPASpecial CO-PA Data in Monitor5ERKRSOperating concernnvarchar40
60T237ADisplay control for T2372ERKRSOperating concernnvarchar40
61T237TText table for T2373ERKRSOperating concernnvarchar40
62T239Report version table2ERKRSOperating concernnvarchar40
63T239TText table for T2393ERKRSOperating concernnvarchar40
64T258MAssignment: SD qty. fields -> CO-PA qty. fields3ERKRSOperating concernnvarchar40
65TERKRCO-PA structure2ERKRSOperating concernnvarchar40
66TERKTTexts for operating concern structures3ERKRSOperating concernnvarchar40
67TJBFEField Catalog IS-B-PA, Operating Concern Assignment1ERKRSOperating concernnvarchar40
68TJBP_DIST_DERIAdditions to Derivations in Distribution2ERKRSOperating concernnvarchar40
69TKB9FAssignment of cost element grps to CO-PA value fields4ERKRSOperating concernnvarchar40
70TKEABCCO-ABC -> CO-PA: Posting characteristics2ERKRSOperating concernnvarchar40
71TKEABCVGACO-PA/CO-ABC:_Selection-Relevant Record Types2ERKRSOperating concernnvarchar40
72TKEADPC00Assignment accounts -> value fields for profit center profit2ERKRSOperating concernnvarchar40
73TKEANCO-PA: Control Table for PA Derivation of Characteristics2ERKRSOperating concernnvarchar40
74TKEASCO-PA derivation rules: Control table2ERKRSOperating concernnvarchar40
75TKEATText table for TKEAS3ERKRSOperating concernnvarchar40
76TKEBManagement for Operating Concerns (Client-Specific)2ERKRSOperating concernnvarchar40
77TKEBAStatus of Operating Concern (Client-Specific)2ERKRSOperating concernnvarchar40
78TKEBCTranslation Status of Operating Concern1ERKRSOperating concernnvarchar40
79TKEBLAssignment: Ledger -> operating concern2ERKRSOperating concernnvarchar40
80TKEBO_MODELPCM Model3ERKRSOperating concernnvarchar40
81TKEBTDescription of operating concern3ERKRSOperating concernnvarchar40
82TKEBWKYFAssignment of Key Figure Scheme Rows to Fields in CEBWKYF2ERKRSOperating concernnvarchar40
83TKEBWLCO-PA Connection to SAP BW: InfoSources2ERKRSOperating concernnvarchar40
84TKECACOERKRSOperating Concern Conversion in Sender Table: KOKRS - ERKRS3ERKRSOperating concernnvarchar40
85TKECCUCO-PA: Conditional Usage of Segment-Level Characteristics2ERKRSOperating concernnvarchar40
86TKECRMCCRM: Transfer of CRM Cost Element Group2ERKRSOperating concernnvarchar40
87TKEDRUPGRADECharacteristic Derivation: CO-PA Conversions from 3.0/3.12ERKRSOperating concernnvarchar40
88TKEEXCOND02CO-PA: Assignment of CRM Conditions to Value Fields2ERKRSOperating concernnvarchar40
89TKEFACO-PA Archiving Management: Field Assignment1ERKRSOperating concernnvarchar40
90TKEFEField catalog, assignment to operating concern1ERKRSOperating concernnvarchar40
91TKEHACCCO-PA Accelerator: Customizing2ERKRSOperating concernnvarchar40
92TKEHA_MODELHANA Information Models3ERKRSOperating concernnvarchar40
93TKEHDBLCRIntegration of HANA and CO-PA2ERKRSOperating concernnvarchar40
94TKEHDB_CE1_ERRHANA CO-PA Integration: CE1 Error with HANA Replication2ERKRSOperating concernnvarchar40
95TKEHDB_CE2_ERRHANA CO-PA Integration: CE2 Error with HANA Replication2ERKRSOperating concernnvarchar40
96TKEHDB_CE4_ERRHANA CO-PA Integration: CE4 Error with HANA Replication2ERKRSOperating concernnvarchar40
97TKEHDB_RANGESCOPA HANA: Use of Read Access2ERKRSOperating concernnvarchar40
98TKEHISTUpgrade History2ERKRSOperating concernnvarchar40
99TKEICOCMPCO Interface:Assignment of Cost Components to CO-PA Val.Flds2ERKRSOperating concernnvarchar40
100TKEIDARKControl of Background Functions: CO-PA Actual Data2ERKRSOperating concernnvarchar40
101TKEIPV00CO-PA: Entry Aids (User-Independent)2ERKRSOperating concernnvarchar40
102TKEIPV00TCO-PA: Entry Aids (User-Independent) - Texts2ERKRSOperating concernnvarchar40
103TKEIPV01CO-PA: Entry Aids (User-Independent) - Characteristics2ERKRSOperating concernnvarchar40
104TKEIPV10CO-PA: Entry Aids (User-Dependent)3ERKRSOperating concernnvarchar40
105TKEIPV10TCO-PA: Entry Aids (User-Dependent) - Texts3ERKRSOperating concernnvarchar40
106TKEIPV11CO-PA: Entry Aids (User-Dependent) - Characteristics3ERKRSOperating concernnvarchar40
107TKEI_COCMPActive Indicator for the Cost Component Split Transfer2ERKRSOperating concernnvarchar40
108TKENC1CO-PA Realignments: Realignment Runs2ERKRSOperating concernnvarchar40
109TKENC5CO-PA Realignments: Execution Logs2ERKRSOperating concernnvarchar40
110TKENC6CO-PA Realign.: Lock only for excl. executable realign.runs2ERKRSOperating concernnvarchar40
111TKENCDCO-PA Net Change: Definitions2ERKRSOperating concernnvarchar40
112TKENCDTCO-PA Net Change: Definitions3ERKRSOperating concernnvarchar40
113TKENCFCO-PA: Characteristics of Realignments2ERKRSOperating concernnvarchar40
114TKENCGCO-PA Net Change: Groups2ERKRSOperating concernnvarchar40
115TKENCGTCO-PA Net Change Groups: Texts3ERKRSOperating concernnvarchar40
116TKEPACKPacked Storage for Segment Level: Control Table1ERKRSOperating concernnvarchar40
117TKEPDARKControl for Hidden Functions2ERKRSOperating concernnvarchar40
118TKEPEAdmin.table for transferring plan data from CO-PA to SOP2ERKRSOperating concernnvarchar40
119TKEPPIIntegrated Planning in FI/CO: +/- Sign Logic2ERKRSOperating concernnvarchar40
120TKEPROTCharacteristic Values in CO-PA Key Tables2ERKRSOperating concernnvarchar40
121TKETD_RUNCO-PA Top-Down: Top-Down Distribution Runs2ERKRSOperating concernnvarchar40
122TKETD_RUN_DOCNRCO-PA Top-Down: Top-Down Distribution Runs: Document Numbers2ERKRSOperating concernnvarchar40
123TKETD_SETTINGSCO-PA Top-Down: Technical Settings2ERKRSOperating concernnvarchar40
124TKETE01Operating Concern Templates: Sub-Tree Structure1ERKRSOperating concernnvarchar40
125TKETE02Templates: Control Table for Characteristic Maintenance1ERKRSOperating concernnvarchar40
126TKETE03Operating Concern Templates:Reference Values in Example Data1ERKRSOperating concernnvarchar40
127TKEVA01Valuation - Control2ERKRSOperating concernnvarchar40
128TKEVA01NValuation - Control2ERKRSOperating concernnvarchar40
129TKEVA02Valuation Strategies (CO-PA)2ERKRSOperating concernnvarchar40
130TKEVA03ACosting Key for Product2ERKRSOperating concernnvarchar40
131TKEVA03MCosting Key for Material Type2ERKRSOperating concernnvarchar40
132TKEVA04Assign Costing Elements to CO-PA Value Fields2ERKRSOperating concernnvarchar40
133TKEVA04_ACTValue Field Assignment: Actual Costs from Material Ledger3ERKRSOperating concernnvarchar40
134TKEVA05CO-PA Quantity Field --> Quantity Field with Standard Unit2ERKRSOperating concernnvarchar40
135TKEVA10Control for Transfer from SD to CO-PA2ERKRSOperating concernnvarchar40
136TKEVAACO-PA: Administration Table for Periodic Revaluation2ERKRSOperating concernnvarchar40
137TKEVGControl of Profitability Analysis by business function2ERKRSOperating concernnvarchar40
138TKEVSGJFiscal-Year Dependent Version Parameters2ERKRSOperating concernnvarchar40
139TKEXYWFValue Field Name <-> Value Field Key1ERKRSOperating concernnvarchar40
140TKEZUCO-PA: Assignments to CO-PA Characteristics2ERKRSOperating concernnvarchar40
141TKEZVCO-PA:Assignment SD characteristics to CO-PA characteristics2ERKRSOperating concernnvarchar40
142TKE_ALE_SCENARIORKE_ALE Scenario2ERKRSOperating concernnvarchar40
143TKE_ALE_SCEN_HISRKE_ALE History2ERKRSOperating concernnvarchar40
144TKE_ALE_SCEN_OBJRKE_ALE Sender Objects2ERKRSOperating concernnvarchar40
145TKE_ALE_SCEN_SYSRKE_ALE Target Systems2ERKRSOperating concernnvarchar40
146TKE_ALE_SCEN_TXTRKE_ALE Scenario Text2ERKRSOperating concernnvarchar40
147TKE_CO_ERSCHPA Transfer Structure for Overhead Cost Allocation2ERKRSOperating concernnvarchar40
148TKE_DISTCO-PA Distribution2ERKRSOperating concernnvarchar40
149TKE_DIST_BASE_CCOPA Distribution: Basic Target Credit Characteristics2ERKRSOperating concernnvarchar40
150TKE_DIST_BASE_VFCOPA Distribution: Base Value Fields / Portions2ERKRSOperating concernnvarchar40
151TKE_DIST_EXECDocument Numbers in CO-PA Distribution2ERKRSOperating concernnvarchar40
152TKE_DIST_SRC_CCOPA Distribution: Source Characteristics2ERKRSOperating concernnvarchar40
153TKE_DIST_SRC_VFCOPA Distribution: Value Field Assignment2ERKRSOperating concernnvarchar40
154TKE_DIST_TIdentifier for CO-PA Distribution3ERKRSOperating concernnvarchar40
155TKE_HACCCO-PA Accelerator: Customizing2ERKRSOperating concernnvarchar40
156TKE_HDBC_CUSTCO-PA Accelerator: Customizing HDBC2ERKRSOperating concernnvarchar40
157TKE_HDB_REPLCO-PA Accelerator: Replication-Runs2ERKRSOperating concernnvarchar40
TOPRemaining Beverage - Obsolete Objects
158/BEV1/RBDNUMScreen for Value Field of CO-PA Individual Record Postings2ERKRSOperating concernnvarchar40
159/BEV1/RBPAIntermediate Table (Material-Specific Contrib. Margin Acc.)26ERKRSOperating concernnvarchar40
TOPRisk Analysis
160JBRDERICharacteristic Derivation Settings for Analysis Structure5ERKRSRM/Analysis: Operating concern for Characteristic Derivationnvarchar40
TOPSales Plan
161LISCOPAKKey Figures Allocation Flexible Planning - CO-PA5ERKRSOperating concernnvarchar40
162LISCOPAMCharacteristics Allocation: Flexible Planning - CO-PA4ERKRSOperating concernnvarchar40
163LISCOPAZAssignment of info structure to operating concern4ERKRSOperating concernnvarchar40
TOPSingle Transaction Costing
164TJBABCCO-ABC->CO-PA: Update Characteristics for Summariz.2ERKRSOperating concernnvarchar40
TOPTools
165TKEBWLREQuery Data Transfer: Administration3ERKRSOperating concernnvarchar40
166TKEBWLRTTransfer: BW-Query-CO-PA3ERKRSOperating concernnvarchar40
167TKEBWLRTR2Transfer: BW-Query-CO-PA4ERKRSOperating concernnvarchar40
168TKEBWLRTR3Transfer: BW-Query-CO-PA3ERKRSOperating concernnvarchar40
169TKEBWLRTREBW-CO-PA Transfer: Assignment On BW System OpConc. Level2ERKRSOperating concernnvarchar40
170TKEBWLRTRTTransfer: BW-Query-CO-PA Text3ERKRSOperating concernnvarchar40
171TKEBWLTNTransfer: BW-Query-CO-PA2ERKRSOperating concernnvarchar40
172TKEBWLTNTTransfer: BW-Query-CO-PA Text2ERKRSOperating concernnvarchar40
TOPWaste Management
173EWA_CCOC_COPAFLDMap Confirmation Fields to CO-PA Characteristic9ERKRSOperating concernnvarchar40