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

143 columns | Print definition?ERP 6.0  | PASUBNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals65PASUBNRProfitability segment changes (CO-PA)nvarchar40
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals66PASUBNRProfitability segment changes (CO-PA)nvarchar40
3/OPT/VIM_1ITEM_SDocument Item63PASUBNRProfitability segment changes (CO-PA)nvarchar40
4/OPT/VIM_TITEMDocument Item63PASUBNRProfitability segment changes (CO-PA)nvarchar40
5/ORS/PS_ITEMProfitability Segment Fields and Values11PASUBNRProfitability segment changes (CO-PA)nvarchar40
6BSEGAccounting Document Segment228PASUBNRProfitability segment changes (CO-PA)nvarchar40
7BSSEGAccounting Document Segment217PASUBNRProfitability segment changes (CO-PA)nvarchar40
8CE1PR22Périm. résultat IDES7PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
9CE2PR22Périm. résultat IDES6PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
10CE3PR22Périm. résultat IDES8PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
11CE4PR22Périm. résultat IDES4PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
12CE4PR22_ACCTPérim. résultat IDES4PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
13CE4PR22_FLAGPérim. résultat IDES4PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
14CE4PR22_KENCPérim. résultat IDES5PASUBNRHistorique des modif. pour objets de résultat (CO-PA)nvarchar40
15CNVTDMS_05_CE1Collected Header Object Numbers for TDMS_Time-CE Tables8PASUBNRPASUBNRnvarchar40
16CNVTDMS_05_CE3XCollected Header Object Numbers for TDMS_Time-CE Tables9PASUBNRPASUBNRnvarchar40
17CNVTDMS_05_CE4Collected Header Object Numbers for TDMS_Time-CE Tables5PASUBNRPASUBNRnvarchar40
18CNVTDMS_05_CE4XCollected Header Object Numbers for TDMS_Time-CE Tables5PASUBNRPASUBNRnvarchar40
19FUDT_VDOCBSEGVerification Document Item with Additional Info217PASUBNRProfitability segment changes (CO-PA)nvarchar40
20FUDT_VDOCBSEGEVVerification Document Item in the Entry View217PASUBNRProfitability segment changes (CO-PA)nvarchar40
21FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)217PASUBNRProfitability segment changes (CO-PA)nvarchar40
22GLPCA_CTProfit Center Documents91PASUBNRProfitability segment changes (CO-PA)nvarchar40
23GLPCA_T_CTProfit Center Documents107PASUBNRProfitability segment changes (CO-PA)nvarchar40
24YVIM_1ITEMDocument Item63PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPContract Accounts Receivable and Payable
25DFKKMOPKItems in contract account document16PASUBNRProfitability segment changes (CO-PA)nvarchar40
26DFKKOPKItems in contract account document16PASUBNRProfitability segment changes (CO-PA)nvarchar40
27DFKKORDERPOSRequests: Items53PASUBNRProfitability segment changes (CO-PA)nvarchar40
28DFKKORDERPOS_SRequest Templates: Items47PASUBNRProfitability segment changes (CO-PA)nvarchar40
29DFKKSUMPosting totals from FI-CA25PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPFinancial Accounting
30/OPT/VIM_1ITEMDocument Item63PASUBNRProfitability segment changes (CO-PA)nvarchar40
31EBSEGDoc.Segment of Fin.Accntng External Documents72PASUBNRProfitability segment changes (CO-PA)nvarchar40
32KMZEIFI: Account Assignment Model Item Information50PASUBNRProfitability segment changes (CO-PA)nvarchar40
33KOMUAccount Assignment Templates for G/L Account Items50PASUBNRProfitability segment changes (CO-PA)nvarchar40
34VBSEGSDocument Segment for Document Parking - G/L Account Database80PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPFunds Management-Specific Postings
35FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years79PASUBNRProfitability segment changes (CO-PA)nvarchar40
36PSOSEGSRecurring Request Document Segment, G/L Accounts78PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPGeneral Ledger Accounting
37BSEG_ADDEntry View of Accounting Document for Additional Ledgers50PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPOverhead Cost Orders
38COBRBDistribution Rules Settlement Rule Order Settlement45PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPProfit Center Accounting
39GLPCAEC-PCA: Actual Line Items70PASUBNRProfitability segment changes (CO-PA)nvarchar40
40GLPCPEC-PCA: Plan Line Items128PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPProfitability Analysis
41CE185007PASUBNRProfitability segment changes (CO-PA)nvarchar40
42CE1BGISErgebnisbereich für7PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
43CE1E_B1Model Bank7PASUBNRProfitability segment changes (CO-PA)nvarchar40
44CE1IDEAOp. Concern BR World7PASUBNRProfitability segment changes (CO-PA)nvarchar40
45CE1IDEBErgebnisbereich IDES7PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
46CE1IDESErgebnisbereich IDES7PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
47CE1INT1Ergebnisbereich IDES7PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
48CE1OC01Bike International7PASUBNRProfitability segment changes (CO-PA)nvarchar40
49CE1R300Operating Concern IDES7PASUBNRProfitability segment changes (CO-PA)nvarchar40
50CE1S001Sample operating concern7PASUBNRProfitability segment changes (CO-PA)nvarchar40
51CE1S300Operating Concern IDES7PASUBNRProfitability segment changes (CO-PA)nvarchar40
52CE1S_ALAirline Route Profit7PASUBNRProfitability segment changes (CO-PA)nvarchar40
53CE1S_CPTemplate for Consumer Goods Industry7PASUBNRProfitability segment changes (CO-PA)nvarchar40
54CE1S_GOQuickstart Template7PASUBNRProfitability segment changes (CO-PA)nvarchar40
55CE285006PASUBNRProfitability segment changes (CO-PA)nvarchar40
56CE2BGISErgebnisbereich für6PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
57CE2E_B1Model Bank6PASUBNRProfitability segment changes (CO-PA)nvarchar40
58CE2IDEAOp. Concern BR World6PASUBNRProfitability segment changes (CO-PA)nvarchar40
59CE2IDEBErgebnisbereich IDES6PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
60CE2IDESErgebnisbereich IDES6PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
61CE2INT1Ergebnisbereich IDES6PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
62CE2OC01Bike International6PASUBNRProfitability segment changes (CO-PA)nvarchar40
63CE2R300Operating Concern IDES6PASUBNRProfitability segment changes (CO-PA)nvarchar40
64CE2S001Sample operating concern6PASUBNRProfitability segment changes (CO-PA)nvarchar40
65CE2S300Operating Concern IDES6PASUBNRProfitability segment changes (CO-PA)nvarchar40
66CE2S_ALAirline Route Profit6PASUBNRProfitability segment changes (CO-PA)nvarchar40
67CE2S_CPTemplate for Consumer Goods Industry6PASUBNRProfitability segment changes (CO-PA)nvarchar40
68CE2S_GOQuickstart Template6PASUBNRProfitability segment changes (CO-PA)nvarchar40
69CE385008PASUBNRProfitability segment changes (CO-PA)nvarchar40
70CE3BGISErgebnisbereich für8PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
71CE3E_B1Model Bank8PASUBNRProfitability segment changes (CO-PA)nvarchar40
72CE3IDEAOp. Concern BR World8PASUBNRProfitability segment changes (CO-PA)nvarchar40
73CE3IDEBErgebnisbereich IDES8PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
74CE3IDESErgebnisbereich IDES8PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
75CE3INT1Ergebnisbereich IDES8PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
76CE3OC01Bike International8PASUBNRProfitability segment changes (CO-PA)nvarchar40
77CE3R300Operating Concern IDES8PASUBNRProfitability segment changes (CO-PA)nvarchar40
78CE3S001Segment level (CO-PA)8PASUBNRProfitability segment changes (CO-PA)nvarchar40
79CE3S300Operating Concern IDES8PASUBNRProfitability segment changes (CO-PA)nvarchar40
80CE3S_ALAirline Route Profit8PASUBNRProfitability segment changes (CO-PA)nvarchar40
81CE3S_CPTemplate for Consumer Goods Industry8PASUBNRProfitability segment changes (CO-PA)nvarchar40
82CE3S_GOQuickstart Template8PASUBNRProfitability segment changes (CO-PA)nvarchar40
83CE485004PASUBNRProfitability segment changes (CO-PA)nvarchar40
84CE48500_ACCT4PASUBNRProfitability segment changes (CO-PA)nvarchar40
85CE48500_FLAG4PASUBNRProfitability segment changes (CO-PA)nvarchar40
86CE48500_KENC5PASUBNRProfitability segment changes (CO-PA)nvarchar40
87CE4BGISErgebnisbereich für4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
88CE4BGIS_ACCTErgebnisbereich für4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
89CE4BGIS_FLAGErgebnisbereich für4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
90CE4BGIS_KENCErgebnisbereich für5PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
91CE4E_B1Model Bank4PASUBNRProfitability segment changes (CO-PA)nvarchar40
92CE4E_B1_ACCTModel Bank4PASUBNRProfitability segment changes (CO-PA)nvarchar40
93CE4E_B1_FLAGModel Bank4PASUBNRProfitability segment changes (CO-PA)nvarchar40
94CE4E_B1_KENCModel Bank5PASUBNRProfitability segment changes (CO-PA)nvarchar40
95CE4IDEAOp. Concern BR World4PASUBNRProfitability segment changes (CO-PA)nvarchar40
96CE4IDEA_ACCTOp. Concern BR World4PASUBNRProfitability segment changes (CO-PA)nvarchar40
97CE4IDEA_FLAGOp. Concern BR World4PASUBNRProfitability segment changes (CO-PA)nvarchar40
98CE4IDEA_KENCOp. Concern BR World5PASUBNRProfitability segment changes (CO-PA)nvarchar40
99CE4IDEBErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
100CE4IDEB_ACCTErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
101CE4IDEB_FLAGErgebnisbereich IDES Banking4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
102CE4IDEB_KENCErgebnisbereich IDES5PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
103CE4IDESErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
104CE4IDES_ACCTErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
105CE4IDES_FLAGErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
106CE4IDES_KENCErgebnisbereich IDES5PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
107CE4INT1Ergebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
108CE4INT1_ACCTErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
109CE4INT1_FLAGErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
110CE4INT1_KENCErgebnisbereich IDES5PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
111CE4OC01Bike International4PASUBNRProfitability segment changes (CO-PA)nvarchar40
112CE4OC01_ACCTBike International4PASUBNRProfitability segment changes (CO-PA)nvarchar40
113CE4OC01_KENCBike International5PASUBNRProfitability segment changes (CO-PA)nvarchar40
114CE4R300Operating Concern IDES4PASUBNRProfitability segment changes (CO-PA)nvarchar40
115CE4R300_ACCTErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
116CE4R300_FLAGErgebnisbereich IDES4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
117CE4R300_KENCOperating Concern IDES5PASUBNRProfitability segment changes (CO-PA)nvarchar40
118CE4S001Sample operating concern4PASUBNRProfitability segment changes (CO-PA)nvarchar40
119CE4S001_ACCTSample operating con4PASUBNRProfitability segment changes (CO-PA)nvarchar40
120CE4S001_FLAGSample Operating Concern 14PASUBNRProfitability segment changes (CO-PA)nvarchar40
121CE4S001_KENCSample operating con5PASUBNRProfitability segment changes (CO-PA)nvarchar40
122CE4S300Operating Concern IDES4PASUBNRProfitability segment changes (CO-PA)nvarchar40
123CE4S300_ACCTOperating Concern IDES4PASUBNRProfitability segment changes (CO-PA)nvarchar40
124CE4S300_FLAGErgebnisbereich IDES Serv.Prov4PASUBNRÄnderungshistorie für Ergebnisobjekte (CO-PA)nvarchar40
125CE4S300_KENCOperating Concern IDES5PASUBNRProfitability segment changes (CO-PA)nvarchar40
126CE4S_ALAirline Route Profit4PASUBNRProfitability segment changes (CO-PA)nvarchar40
127CE4S_AL_ACCTAirline Route Profit4PASUBNRProfitability segment changes (CO-PA)nvarchar40
128CE4S_AL_FLAGAirline Route Profit4PASUBNRProfitability segment changes (CO-PA)nvarchar40
129CE4S_AL_KENCAirline Route Profit5PASUBNRProfitability segment changes (CO-PA)nvarchar40
130CE4S_CPTemplate for Consumer Goods Industry4PASUBNRProfitability segment changes (CO-PA)nvarchar40
131CE4S_CP_ACCTTemplate for Consumer Goods Industry4PASUBNRProfitability segment changes (CO-PA)nvarchar40
132CE4S_CP_FLAGTemplate for Consumer Goods Industry4PASUBNRProfitability segment changes (CO-PA)nvarchar40
133CE4S_CP_KENCTemplate for Consumer Goods Industry5PASUBNRProfitability segment changes (CO-PA)nvarchar40
134CE4S_GOQuickstart Template4PASUBNRProfitability segment changes (CO-PA)nvarchar40
135CE4S_GO_ACCTQuickstart Template4PASUBNRProfitability segment changes (CO-PA)nvarchar40
136CE4S_GO_FLAGQuickstart Template4PASUBNRProfitability segment changes (CO-PA)nvarchar40
137CE4S_GO_KENCQuickstart Template5PASUBNRProfitability segment changes (CO-PA)nvarchar40
138CEALE01CO-PA Distribution: Line Item Reference for Distribution12PASUBNRProfitability segment changes (CO-PA)nvarchar40
139CEST4Segment table (CO-PA)4PASUBNRProfitability segment changes (CO-PA)nvarchar40
140TKEHDB_CE1_ERRHANA CO-PA Integration: CE1 Error with HANA Replication8PASUBNRProfitability segment changes (CO-PA)nvarchar40
141TKEHDB_CE2_ERRHANA CO-PA Integration: CE2 Error with HANA Replication7PASUBNRProfitability segment changes (CO-PA)nvarchar40
142TKEHDB_CE4_ERRHANA CO-PA Integration: CE4 Error with HANA Replication5PASUBNRProfitability segment changes (CO-PA)nvarchar40
TOPRemaining Beverage - Obsolete Objects
143/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1219PASUBNRProfitability segment changes (CO-PA)nvarchar40