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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

40 columns | Print definition?ERP 6.0  | KUKLA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000487TKUKL5KUKLAnvarchar20
2/1CADMC/00000488TKUKT6KUKLAnvarchar20
3/1RA/0SD010MIItems for Class SD01 - Raw Data88KUKLACustomer classificationnvarchar20
4/SMD/MD_____00Q1SID-Tabelle fuer Customer classific.3KUKLACustomer classificationnvarchar20
5CE1PR22Périm. résultat IDES66KUKLAClassification clientnvarchar20
6CE2PR22Périm. résultat IDES50KUKLAClassification clientnvarchar20
7CE4PR22Périm. résultat IDES35KUKLAClassification clientnvarchar20
8CE4PR22_ACCTPérim. résultat IDES36KUKLAClassification clientnvarchar20
9CE4PR22_FLAGPérim. résultat IDES32KUKLAFlag : caract. imputée manuellement ou via TKEZUnvarchar10
10CE4PR22_KENCPérim. résultat IDES34KUKLAClassification clientnvarchar20
TOPCross-Application Components
11BC490KKNA1General data in customer master37KUKLACustomer classificationnvarchar20
12KKNA1General Data in Customer Master37KUKLACustomer classificationnvarchar20
13SKNA1Customer Master table for BC417 Course37KUKLACustomer classificationnvarchar20
TOPCustomer Master
14KNA1General Data in Customer Master37KUKLACustomer classificationnvarchar20
TOPData Collection
15S018SIS: Address list for sales promotion15KUKLACustomer classificationnvarchar20
16S018ES018 - Structural Information10KUKLACustomer classificationnvarchar20
TOPMarketing, Contract and Order Entry
17OID9IRemapping Default Item Categories6KUKLACustomer classificationnvarchar20
TOPMaterial Maintenance
18TKUKLCustomers: Customer Classifications2KUKLACustomer classificationnvarchar20
19TKUKTCustomers: Customer classification: Texts3KUKLACustomer classificationnvarchar20
TOPProfitability Analysis
20CE1IDEAOp. Concern BR World66KUKLACustomer classificationnvarchar20
21CE1IDESErgebnisbereich IDES66KUKLAKundenklassifizierungnvarchar20
22CE1INT1Ergebnisbereich IDES66KUKLAKundenklassifizierungnvarchar20
23CE2IDEAOp. Concern BR World50KUKLACustomer classificationnvarchar20
24CE2IDESErgebnisbereich IDES50KUKLAKundenklassifizierungnvarchar20
25CE2INT1Ergebnisbereich IDES50KUKLAKundenklassifizierungnvarchar20
26CE4IDEAOp. Concern BR World35KUKLACustomer classificationnvarchar20
27CE4IDEA_ACCTOp. Concern BR World36KUKLACustomer classificationnvarchar20
28CE4IDEA_FLAGOp. Concern BR World32KUKLAFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
29CE4IDEA_KENCOp. Concern BR World34KUKLACustomer classificationnvarchar20
30CE4IDESErgebnisbereich IDES35KUKLAKundenklassifizierungnvarchar20
31CE4IDES_ACCTErgebnisbereich IDES36KUKLAKundenklassifizierungnvarchar20
32CE4IDES_FLAGErgebnisbereich IDES32KUKLAFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
33CE4IDES_KENCErgebnisbereich IDES34KUKLAKundenklassifizierungnvarchar20
34CE4INT1Ergebnisbereich IDES35KUKLAKundenklassifizierungnvarchar20
35CE4INT1_ACCTErgebnisbereich IDES36KUKLAKundenklassifizierungnvarchar20
36CE4INT1_FLAGErgebnisbereich IDES32KUKLAFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
37CE4INT1_KENCErgebnisbereich IDES34KUKLAKundenklassifizierungnvarchar20
TOPRemaining Beverage - Obsolete Objects
38/BEV3/CHCDPALLOCCDP: R/3 Environment Data22KUKLACustomer classificationnvarchar20
39/BEV3/CHKAALLOCACustomer Evaluation Table: Contract Allocations31KUKLACustomer classificationnvarchar20
TOPSales Promotions
40SADLSTRECBDynamic Part of Address List (Record Body)65KUKLACustomer classificationnvarchar20