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

102 columns | Print definition?ERP 6.0  | VERSI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CE1PR22Périm. résultat IDES4VERSIVersion de pré-budget (CO-PA)nvarchar30
2CE2PR22Périm. résultat IDES4VERSIVersion de pré-budget (CO-PA)nvarchar30
3CE3PR22Périm. résultat IDES6VERSIVersion de pré-budget (CO-PA)nvarchar30
4CNVTDMS_05_CE1Collected Header Object Numbers for TDMS_Time-CE Tables5VERSIVERSInvarchar30
5CNVTDMS_05_CE3Collected Header Object Numbers for TDMS_Time-CE Tables7VERSIVERSInvarchar30
6CNVTDMS_05_CE3XCollected Header Object Numbers for TDMS_Time-CE Tables6VERSIVERSInvarchar30
7T138AFields for Mass Change: Material Master Records1VERSIVersion numbernvarchar20
8T138CIndividual Transaction Code for Mass Change3VERSIVersion numbernvarchar20
9T138VVersions for Mass Change: Material Master Records1VERSIVersion numbernvarchar20
10T258ADetermining the costing sheet for condition access5VERSIPlan version (CO-PA)nvarchar30
11T258FCO-PA access control for Product Costing4VERSIPlan version (CO-PA)nvarchar30
12T5C1SWithholding Tax Rates (CH)3VERSITax Table Versionnvarchar10
13T77PADKZLNGVERLanguage to version connection3VERSIVersion ID for International Addressesnvarchar10
14TKEVSCO-PA version attributes2VERSIPlan version (CO-PA)nvarchar30
15TKKAS_CONVCopy of TKKAS18VERSIPlan Version for Simulationnvarchar30
TOPAppropriation Requests
16IMAVZAssignment of approp. request variants to plan versions4VERSIVersionnvarchar30
TOPClasses
17KLAHClass Header Data31VERSIVersion Numbernvarchar20
TOPContract Billing
18TE537Mass simulation periods9VERSIPlan version (CO-PA)nvarchar30
TOPCost Object
19TKKASControl Table for Results Analysis18VERSIPlan Version for Simulationnvarchar30
20TKKAUResults Analysis Methods - Default Values in TKKAS14VERSIPlan Version for Simulationnvarchar30
TOPEnvironment
21LKLAHClass Header (Special Objects)31VERSIVersion Numbernvarchar20
TOPFree goods
22FGDC_COND_PFree Goods Procedures4VERSIVersion Number of Free Goods Procedurenvarchar60
TOPGlobal Trade Services
23/SAPSLL/LEGMESSLL: Customs Document: Messages for Each Activity30VERSIVersion Number of Messagesmallint50
TOPInvestment Programs
24TAIF2Plan versions per approval year and program type4VERSIVersionnvarchar30
TOPLocalization
25J_1BECD_HISTORYElectronic-Accounting-File History15VERSILayout Version Codenvarchar30
TOPMaterial
26TPGPRFProfile for static pegging and data distribution16VERSIVersionnvarchar30
TOPNetherlands
27PA0060HR Master Record: Infotype 0060 (Fiscal Data - NL)55VERSIVersion Number for Conversion of IT0060nvarchar10
TOPOverhead Cost Controlling
28TKA07Fiscal-Year Dependent Version Parameters22VERSIReceiver Plan Version (CO-PA)nvarchar30
29TKVSCO Versions2VERSIVersionnvarchar30
TOPPayroll
30T7ROG8EE register - Bonus History9VERSInvarchar80
TOPPegging, Grouping, and Distribution
31DIS_ADMINDistribution - Administration Table19VERSIVersionnvarchar30
32DIS_PGPRFDistribution: Assignemnt Distribution Profile - Group WBSEl.17VERSIVersionnvarchar30
33PEG_DIS_ADMINPegging and Distribution - administration table37VERSIVersionnvarchar30
TOPPricing
34PRCC_COND_PPPricing Procedure Data (T683S)4VERSIVersion Number of Pricing Procedurenvarchar60
35PRCC_COND_PPTTexts for Line in Pricing Procedure (T683T)5VERSIVersion Number of Pricing Procedurenvarchar60
TOPProduct Safety
36TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions35VERSIVersion Numbernvarchar20
TOPProfitability Analysis
37CE185004VERSIPlan version (CO-PA)nvarchar30
38CE1BGISErgebnisbereich für4VERSIPlanversion (CO-PA)nvarchar30
39CE1E_B1Model Bank4VERSIPlan version (CO-PA)nvarchar30
40CE1IDEAOp. Concern BR World4VERSIPlan version (CO-PA)nvarchar30
41CE1IDEBErgebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
42CE1IDESErgebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
43CE1INT1Ergebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
44CE1OC01Bike International4VERSIPlan version (CO-PA)nvarchar30
45CE1R300Operating Concern IDES4VERSIPlan version (CO-PA)nvarchar30
46CE1S001Sample operating concern4VERSIPlan version (CO-PA)nvarchar30
47CE1S300Operating Concern IDES4VERSIPlan version (CO-PA)nvarchar30
48CE1S_ALAirline Route Profit4VERSIPlan version (CO-PA)nvarchar30
49CE1S_CPTemplate for Consumer Goods Industry4VERSIPlan version (CO-PA)nvarchar30
50CE1S_GOQuickstart Template4VERSIPlan version (CO-PA)nvarchar30
51CE285004VERSIPlan version (CO-PA)nvarchar30
52CE2BGISErgebnisbereich für4VERSIPlanversion (CO-PA)nvarchar30
53CE2E_B1Model Bank4VERSIPlan version (CO-PA)nvarchar30
54CE2IDEAOp. Concern BR World4VERSIPlan version (CO-PA)nvarchar30
55CE2IDEBErgebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
56CE2IDESErgebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
57CE2INT1Ergebnisbereich IDES4VERSIPlanversion (CO-PA)nvarchar30
58CE2OC01Bike International4VERSIPlan version (CO-PA)nvarchar30
59CE2R300Operating Concern IDES4VERSIPlan version (CO-PA)nvarchar30
60CE2S001Sample operating concern4VERSIPlan version (CO-PA)nvarchar30
61CE2S300Operating Concern IDES4VERSIPlan version (CO-PA)nvarchar30
62CE2S_ALAirline Route Profit4VERSIPlan version (CO-PA)nvarchar30
63CE2S_CPTemplate for Consumer Goods Industry4VERSIPlan version (CO-PA)nvarchar30
64CE2S_GOQuickstart Template4VERSIPlan version (CO-PA)nvarchar30
65CE385006VERSIPlan version (CO-PA)nvarchar30
66CE3BGISErgebnisbereich für6VERSIPlanversion (CO-PA)nvarchar30
67CE3E_B1Model Bank6VERSIPlan version (CO-PA)nvarchar30
68CE3IDEAOp. Concern BR World6VERSIPlan version (CO-PA)nvarchar30
69CE3IDEBErgebnisbereich IDES6VERSIPlanversion (CO-PA)nvarchar30
70CE3IDESErgebnisbereich IDES6VERSIPlanversion (CO-PA)nvarchar30
71CE3INT1Ergebnisbereich IDES6VERSIPlanversion (CO-PA)nvarchar30
72CE3OC01Bike International6VERSIPlan version (CO-PA)nvarchar30
73CE3R300Operating Concern IDES6VERSIPlan version (CO-PA)nvarchar30
74CE3S001Segment level (CO-PA)6VERSIPlan version (CO-PA)nvarchar30
75CE3S300Operating Concern IDES6VERSIPlan version (CO-PA)nvarchar30
76CE3S_ALAirline Route Profit6VERSIPlan version (CO-PA)nvarchar30
77CE3S_CPTemplate for Consumer Goods Industry6VERSIPlan version (CO-PA)nvarchar30
78CE3S_GOQuickstart Template6VERSIPlan version (CO-PA)nvarchar30
79CEALE01CO-PA Distribution: Line Item Reference for Distribution9VERSIPlan version (CO-PA)nvarchar30
80TKEHDB_CE1_ERRHANA CO-PA Integration: CE1 Error with HANA Replication5VERSIPlan version (CO-PA)nvarchar30
81TKEHDB_CE2_ERRHANA CO-PA Integration: CE2 Error with HANA Replication5VERSIPlan version (CO-PA)nvarchar30
82TKEPSVCO-PA: Plan Structure Status Management5VERSIPlan version (CO-PA)nvarchar30
83TKEVA01Valuation - Control5VERSIPlan version (CO-PA)nvarchar30
84TKEVA01NValuation - Control4VERSIPlan version (CO-PA)nvarchar30
85TKEVA03ACosting Key for Product5VERSIPlan version (CO-PA)nvarchar30
86TKEVA03MCosting Key for Material Type5VERSIPlan version (CO-PA)nvarchar30
87TKVSTCO Version Texts3VERSIVersionnvarchar30
TOPProfitability Analysis Basic Functions
88K810001Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003105VERSIPlanversion (CO-PA)nvarchar30
89K810003Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003119VERSIPlanversion (CO-PA)nvarchar30
90K810005Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003137VERSIPlanversion (CO-PA)nvarchar30
91K810007Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003145VERSIPlanversion (CO-PA)nvarchar30
TOPSwitzerland
92T5C2OConversion of Residence Status for Vaud2VERSIVersion Number of Notification Formatnvarchar40
93T5C2O_CHILDEMP-ACI: No. of Children2VERSIVersion Number of Notification Formatnvarchar40
94T5C2O_FAMSTEMP-ACI: Assignment of Marital Status to Event2VERSIVersion Number of Notification Formatnvarchar40
95T5C2O_SCALEEMP-ACI: Conversion of Scale Names for File2VERSIVersion Number of Notification Formatnvarchar40
96T5C2PWHT Geneva: Conversion of Pay Scale Indicator2VERSIGeTIS and ISEL Versionnvarchar40
97T5C2P_FAMSTWHT Geneva: Conversion of Marital Status from Infotype 00022VERSIGeTIS and ISEL Versionnvarchar40
98T5C2P_KONFEWHT GE: Assignment of Religion Key for File2VERSIGeTIS and ISEL Versionnvarchar40
99T5C2P_STREETWithholding Tax for Geneva: Street Name Conversion2VERSIGeTIS and ISEL Versionnvarchar40
TOPTransaction Data Pool
100JBDVTLD_POSVariable Transaction: Ledger Item11VERSIPlan version (CO-PA)nvarchar30
TOPTransaction Tax Engine
101TTE2C_TAX_MAPMapping between Tax Type and Procedure4VERSIVersion Number of Pricing Procedurenvarchar60
TOPUnited Kingdom
102T5G35FP35: XML tag structure1VERSIPayroll Yearnvarchar40