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

98 columns | Print definition?ERP 6.0  | BRSCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000458T0165BRSCHnvarchar40
2/1CADMC/00000459T016T6BRSCHnvarchar40
3/1RA/0SD010MIItems for Class SD01 - Raw Data57BRSCHIndustry keynvarchar40
4CE1PR22Périm. résultat IDES68BRSCHCode branchenvarchar40
5CE2PR22Périm. résultat IDES52BRSCHCode branchenvarchar40
6CE4PR22Périm. résultat IDES37BRSCHCode branchenvarchar40
7CE4PR22_ACCTPérim. résultat IDES38BRSCHCode branchenvarchar40
8CE4PR22_FLAGPérim. résultat IDES34BRSCHFlag : caract. imputée manuellement ou via TKEZUnvarchar10
9CE4PR22_KENCPérim. résultat IDES36BRSCHCode branchenvarchar40
10T016Industries2BRSCHIndustry keynvarchar40
11T016TIndustry Names3BRSCHIndustry keynvarchar40
12T7SA40Saudization Color ranges as per Line of Business5BRSCHIndustry keynvarchar40
13TJ016UIndustry Sectors2BRSCHIndustry keynvarchar40
14TZD0ADarwin: Customer default values per trans. type for KNA110BRSCHIndustry keynvarchar40
TOPBusiness Partner
15TIVBPVENDORGENVendor Preassignment (General Data)8BRSCHIndustry keynvarchar40
16TP17UBusiness Partner: Convert Industries2BRSCHIndustry keynvarchar40
TOPBusiness Partner Enhancements for Financial Services
17TP038M1Mapping Branchen SAP-GP --> TR GP / Debitor + Kreditor4BRSCH????nvarchar40
18TP038M2Mapping Branchen TR GP / Debitor / Kreditor --> SAP GP2BRSCH????nvarchar40
TOPCross-Application Components
19BC490KKNA1General data in customer master25BRSCHIndustry keynvarchar40
20KKNA1General Data in Customer Master25BRSCHIndustry keynvarchar40
21SKNA1Customer Master table for BC417 Course25BRSCHIndustry keynvarchar40
TOPCustomer Master
22KNA1General Data in Customer Master25BRSCHIndustry keynvarchar40
TOPData Collection
23CF703IDES Profitability13BRSCHIndustry keynvarchar40
24S018SIS: Address list for sales promotion13BRSCHIndustry keynvarchar40
25S018ES018 - Structural Information8BRSCHIndustry keynvarchar40
TOPFinancial Accounting
26LFA1Vendor Master (General Section)25BRSCHIndustry keynvarchar40
TOPFinancial Services Localization
27/GSINS/REU_BRSCHInsurance ETL Acc Group Customizing Table3BRSCHIndustry keynvarchar40
TOPInformation System
28DKKOSBalance Audit Trail34BRSCHIndustry keynvarchar40
29DKOKSOpen Item Account Balance Audit Trail Master Record37BRSCHIndustry keynvarchar40
TOPJoint Venture und Production Sharing Accounting
30T8PSA_BRSCHArms/Non-arms length2BRSCHIndustry keynvarchar40
TOPLocalization
31A343BR: Substituiçao Tributária from SD12BRSCHBranchenschlüsselnvarchar40
32LFB1_KRVendor Master Enhancement for Korea4BRSCHIndustry keynvarchar40
33T042E_KRKorea : BoE Due Date Determination by Industry3BRSCHIndustry keynvarchar40
TOPMaster Data
34JGTGPNRIS-M: Central Business Partner Table17BRSCHIndustry keynvarchar40
TOPProfitability Analysis
35CE1850057BRSCHIndustry keynvarchar40
36CE1BGISErgebnisbereich für57BRSCHBranchenschlüsselnvarchar40
37CE1IDEAOp. Concern BR World68BRSCHIndustry keynvarchar40
38CE1IDEBErgebnisbereich IDES58BRSCHBranchenschlüsselnvarchar40
39CE1IDESErgebnisbereich IDES68BRSCHBranchenschlüsselnvarchar40
40CE1INT1Ergebnisbereich IDES68BRSCHBranchenschlüsselnvarchar40
41CE1OC01Bike International58BRSCHIndustry keynvarchar40
42CE1S001Sample operating concern45BRSCHIndustry keynvarchar40
43CE1S300Operating Concern IDES57BRSCHIndustry keynvarchar40
44CE1S_GOQuickstart Template57BRSCHIndustry keynvarchar40
45CE2850041BRSCHIndustry keynvarchar40
46CE2BGISErgebnisbereich für41BRSCHBranchenschlüsselnvarchar40
47CE2IDEAOp. Concern BR World52BRSCHIndustry keynvarchar40
48CE2IDEBErgebnisbereich IDES42BRSCHBranchenschlüsselnvarchar40
49CE2IDESErgebnisbereich IDES52BRSCHBranchenschlüsselnvarchar40
50CE2INT1Ergebnisbereich IDES52BRSCHBranchenschlüsselnvarchar40
51CE2OC01Bike International42BRSCHIndustry keynvarchar40
52CE2S001Sample operating concern35BRSCHIndustry keynvarchar40
53CE2S300Operating Concern IDES41BRSCHIndustry keynvarchar40
54CE2S_GOQuickstart Template41BRSCHIndustry keynvarchar40
55CE4850026BRSCHIndustry keynvarchar40
56CE48500_ACCT27BRSCHIndustry keynvarchar40
57CE48500_FLAG23BRSCHFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
58CE48500_KENC25BRSCHIndustry keynvarchar40
59CE4BGISErgebnisbereich für26BRSCHBranchenschlüsselnvarchar40
60CE4BGIS_ACCTErgebnisbereich für27BRSCHBranchenschlüsselnvarchar40
61CE4BGIS_FLAGErgebnisbereich für23BRSCHFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
62CE4BGIS_KENCErgebnisbereich für25BRSCHBranchenschlüsselnvarchar40
63CE4IDEAOp. Concern BR World37BRSCHIndustry keynvarchar40
64CE4IDEA_ACCTOp. Concern BR World38BRSCHIndustry keynvarchar40
65CE4IDEA_FLAGOp. Concern BR World34BRSCHFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
66CE4IDEA_KENCOp. Concern BR World36BRSCHIndustry keynvarchar40
67CE4IDEBErgebnisbereich IDES27BRSCHBranchenschlüsselnvarchar40
68CE4IDEB_ACCTErgebnisbereich IDES28BRSCHBranchenschlüsselnvarchar40
69CE4IDEB_FLAGErgebnisbereich IDES Banking24BRSCHFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
70CE4IDEB_KENCErgebnisbereich IDES26BRSCHBranchenschlüsselnvarchar40
71CE4IDESErgebnisbereich IDES37BRSCHBranchenschlüsselnvarchar40
72CE4IDES_ACCTErgebnisbereich IDES38BRSCHBranchenschlüsselnvarchar40
73CE4IDES_FLAGErgebnisbereich IDES34BRSCHFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
74CE4IDES_KENCErgebnisbereich IDES36BRSCHBranchenschlüsselnvarchar40
75CE4INT1Ergebnisbereich IDES37BRSCHBranchenschlüsselnvarchar40
76CE4INT1_ACCTErgebnisbereich IDES38BRSCHBranchenschlüsselnvarchar40
77CE4INT1_FLAGErgebnisbereich IDES34BRSCHFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
78CE4INT1_KENCErgebnisbereich IDES36BRSCHBranchenschlüsselnvarchar40
79CE4OC01Bike International27BRSCHIndustry keynvarchar40
80CE4OC01_ACCTBike International28BRSCHIndustry keynvarchar40
81CE4OC01_KENCBike International26BRSCHIndustry keynvarchar40
82CE4S001Sample operating concern22BRSCHIndustry keynvarchar40
83CE4S001_ACCTSample operating con30BRSCHIndustry keynvarchar40
84CE4S001_FLAGSample Operating Concern 126BRSCHFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
85CE4S001_KENCSample operating con27BRSCHIndustry keynvarchar40
86CE4S300Operating Concern IDES26BRSCHIndustry keynvarchar40
87CE4S300_ACCTOperating Concern IDES27BRSCHIndustry keynvarchar40
88CE4S300_FLAGErgebnisbereich IDES Serv.Prov23BRSCHFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
89CE4S300_KENCOperating Concern IDES25BRSCHIndustry keynvarchar40
90CE4S_GOQuickstart Template26BRSCHIndustry keynvarchar40
91CE4S_GO_ACCTQuickstart Template27BRSCHIndustry keynvarchar40
92CE4S_GO_FLAGQuickstart Template23BRSCHFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
93CE4S_GO_KENCQuickstart Template25BRSCHIndustry keynvarchar40
TOPProfitability Analysis Basic Functions
94K810005Verdichtungsebene KT: 800 KE 01 CE1IDEA 0003133BRSCHBranchenschlüsselnvarchar40
TOPReal Estate Management
95VIMI04Old. replaced in 3.0 with VIMIMV19BRSCHIndustry keynvarchar40
TOPRecycling Administration Core Functions
96J_7LC32REA Data Filters: Customer Industry Key3BRSCHIndustry keynvarchar40
TOPSales Promotions
97SADLSTRECBDynamic Part of Address List (Record Body)58BRSCHIndustry keynvarchar40
TOPTreasury
98VZKNA1Collector for batch input KNA1 from RF-VV7BRSCHIndustry keynvarchar40