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

196 columns | Print definition?ERP 6.0  | KSTRG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data87KSTRGCost Objectnvarchar120
2/OPT/VIM_1ITEM_SDocument Item28KSTRGCost Objectnvarchar120
3/OPT/VIM_TITEMDocument Item28KSTRGCost Objectnvarchar120
4AUAASettlement Document: Receiver Segment25KSTRGCost Objectnvarchar120
5BSEGAccounting Document Segment222KSTRGCost Objectnvarchar120
6BSSEGAccounting Document Segment211KSTRGCost Objectnvarchar120
7CE1PR22Périm. résultat IDES44KSTRGSupport de coûtsnvarchar120
8CE2PR22Périm. résultat IDES34KSTRGSupport de coûtsnvarchar120
9CE4PR22Périm. résultat IDES23KSTRGSupport de coûtsnvarchar120
10CE4PR22_ACCTPérim. résultat IDES21KSTRGSupport de coûtsnvarchar120
11CE4PR22_FLAGPérim. résultat IDES20KSTRGFlag : caract. imputée manuellement ou via TKEZUnvarchar10
12CE4PR22_KENCPérim. résultat IDES22KSTRGSupport de coûtsnvarchar120
13FIKZD_CONTR_MAPCSubsoil use contracts mapping13KSTRGCost Objectnvarchar120
14FIKZD_CONTR_MAPPSubsoil use contracts mapping18KSTRGCost Objectnvarchar120
15FUDT_VDOCBSEGVerification Document Item with Additional Info211KSTRGCost Objectnvarchar120
16FUDT_VDOCBSEGEVVerification Document Item in the Entry View211KSTRGCost Objectnvarchar120
17FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)211KSTRGCost Objectnvarchar120
18GLPCA_CTProfit Center Documents81KSTRGCost Objectnvarchar120
19GLPCA_T_CTProfit Center Documents97KSTRGCost Objectnvarchar120
20GLPOS_C_CTFI Document: Entry View150KSTRGCost Objectnvarchar120
21GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items150KSTRGCost Objectnvarchar120
22GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items150KSTRGCost Objectnvarchar120
23GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items150KSTRGCost Objectnvarchar120
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type152KSTRGCost Objectnvarchar120
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type152KSTRGCost Objectnvarchar120
26P2B2_C1HCM Declustering B2 - Cost Distribution Table C113KSTRGCost Objectnvarchar120
27P2B2_CWSTHCM Declustering B2 - PDC Time Tickets101KSTRGCost Objectnvarchar120
28P2B2_WSTHCM Declustering B2 - PDC Time Tickets101KSTRGCost Objectnvarchar120
29P2PL_RETROADJPayroll Result PL: Retro, originals and changes23KSTRGCost Objectnvarchar120
30P2PL_RETRODIFPayroll Result PL: Retro, originals and changes23KSTRGCost Objectnvarchar120
31P2PL_RETROMEMPayroll Result PL: Retro, originals and changes23KSTRGCost Objectnvarchar120
32P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)30KSTRGCost Objectnvarchar120
33P2RT_CZDAVP18_0314KSTRGCost Objectnvarchar120
34P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)30KSTRGCost Objectnvarchar120
35P2RX_C1Cost Distribution Table C111KSTRGCost Objectnvarchar120
36YVIM_1ITEMDocument Item28KSTRGCost Objectnvarchar120
TOPAccounting Interface
37GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)168KSTRGCost Objectnvarchar120
38GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)168KSTRGCost Objectnvarchar120
TOPActual CostingMaterial Ledger
39CKMLDUVCOUsage Differences for Each Account Assignment Object21KSTRGCost Objectnvarchar120
40FCML_PROCBusiness Processes24KSTRGCost Object (Process)nvarchar120
41MLCOMaterial valuation document account assignment information29KSTRGCost Objectnvarchar120
TOPAlternative Valuation Run
42CKMLAVRDOCITLines for Cumulation Posting Document46KSTRGCost Objectnvarchar120
TOPConfirmations
43AFRVConfirmation pool21KSTRGCost Objectnvarchar120
44AFRV_DELBackup Copy for Confirmation Pool21KSTRGCost Objectnvarchar120
TOPConstruction Industry
45T5DB4HR Construction Site File11KSTRGCost Objectnvarchar120
46T5DB8Construction Sector: Team Assignment to Work Site34KSTRGCost Objectnvarchar120
47T5DBVConstruction Pay: Cost Assignment: Hostels10KSTRGCost Objectnvarchar120
48T5DBXConstruction Pay: Incentive Wage Connection10KSTRGCost Objectnvarchar120
TOPCost Object
49CKPHTTexts for CKPH2KSTRGCost Objectnvarchar120
50COVABCO-PC Responsibility Area Characteristics7KSTRGCost Objectnvarchar120
TOPCross-Application Components
51ONRHPObject number index for process manufacturing hierarchy3KSTRGCost Objectnvarchar120
TOPData Retention Tool
52TXW_S_BSEGRetrieve BSEG from archive111KSTRGCost Objectnvarchar120
TOPData Transfer
53PPDITTransfer to Accounting: Lines in HR IDOCs19KSTRGCost Objectnvarchar120
54PPDSTTransfer to Accounting: Substituted Acc. Assig. Object8KSTRGCost Objectnvarchar120
55PPKIXTransfer FI/CO: Index of Account Assignment Combinations10KSTRGCost Objectnvarchar120
TOPDistribution of Usage Variances
56CKMLDUVACTCODistribution Acty Differences: Diff. Per Acct Assgnmt object20KSTRGProduct Cost Collector for Ordernvarchar120
57CKMLDUVNCOUsage Differences for Each Account Assignment Object21KSTRGCost Objectnvarchar120
TOPElectronic Bank Statement
58FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)27KSTRGCost Objectnvarchar120
59FEB_ACTAcct Assignment Templates27KSTRGCost Objectnvarchar120
TOPExternal Services
60ESKNAccount Assignment in Service Package24KSTRGCost Objectnvarchar120
TOPFinancial Accounting
61/OPT/VIM_1ITEMDocument Item28KSTRGCost Objectnvarchar120
62ACCTITCompressed Data from FI/CO Document62KSTRGCost Objectnvarchar120
63EBSEGDoc.Segment of Fin.Accntng External Documents68KSTRGCost Objectnvarchar120
64KMZEIFI: Account Assignment Model Item Information46KSTRGCost Objectnvarchar120
65KOMUAccount Assignment Templates for G/L Account Items46KSTRGCost Objectnvarchar120
66VBSEGADocument Segment for Document Parking - Asset Database54KSTRGCost Objectnvarchar120
67VBSEGSDocument Segment for Document Parking - G/L Account Database75KSTRGCost Objectnvarchar120
TOPFreight Processing
68VFKNAccount Determination in Shipment Costs Item22KSTRGCost Objectnvarchar120
TOPFunds Management-Specific Postings
69FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years74KSTRGCost Objectnvarchar120
70PSOSEGSRecurring Request Document Segment, G/L Accounts73KSTRGCost Objectnvarchar120
TOPGeneral Ledger Accounting
71BSEG_ADDEntry View of Accounting Document for Additional Ledgers44KSTRGCost Objectnvarchar120
72FAGL_SPLINFOSplittling Information of Open Items23KSTRGCost Objectnvarchar120
TOPGeneral Ledger Reorganization
73FAGL_R_SPLReorganization: Splitting Information of the Open Items29KSTRGCost Objectnvarchar120
TOPGL Account Posting
74TCJ_POSITIONSCash Journal Document Items34KSTRGCost Objectnvarchar120
TOPInventory Management
75MSEGDocument Segment: Material110KSTRGCost Objectnvarchar120
76MWXMSEGZMSEG: Interface for Posting of Value110KSTRGCost Objectnvarchar120
77MWZMSEGZMSEG:Interface for Posting of Value110KSTRGCost Objectnvarchar120
78RKPFDocument Header: Reservation27KSTRGCost Objectnvarchar120
TOPInvoice Verification
79RBCODocument Item, Incoming Invoice, Account Assignment21KSTRGCost Objectnvarchar120
TOPJapan
80T7JPSK_CONTTShukko Contract Template10KSTRGCost Objectnvarchar120
TOPLocalization
81J_1BNFLINNota Fiscal line items92KSTRGCost Objectsnvarchar120
TOPOverhead Cost Orders
82COBRBDistribution Rules Settlement Rule Order Settlement51KSTRGCost Objectnvarchar120
TOPPayroll
83T5TPSC1SPLITRozdelení nákladu21KSTRGNositel nákladunvarchar120
TOPPersonnel Time Events
84TPTCOR_KOSTLCost Assignment (Correction Scenario)4KSTRGCost Objectnvarchar120
TOPPersonnel Time Management
85ASSOBAssignment Objects9KSTRGCost Objectnvarchar120
86CC1ERPIncorrect Time Events from CC1, Postings103KSTRGCost Objectnvarchar120
87CC1TEVTemporary Buffer for Time Events from CC126KSTRGCost Objectnvarchar120
88COIFTInterface to Activity Allocation41KSTRGCost Objectnvarchar120
89PTEX2000Interface Table for Attendances/Absences Infotype(2001/2002)51KSTRGCost Objectnvarchar120
90PTEX2003GENInterface Table for IT 2003: General Information50KSTRGCost Objectnvarchar120
91PTEX2003SPECInterface Table for IT 2003: Interval Information26KSTRGCost Objectnvarchar120
92PTEX2010Interface Table for EE Remuneration Info. Infotype (2010)50KSTRGCost Objectnvarchar120
93TEVEN_MOREAdditional Data for Time Events102KSTRGCost Objectnvarchar120
TOPPlant Data Collection
94RUECKTemp. storage for subsystem confirmations16KSTRGCost Objectnvarchar120
TOPProduct Cost by Period
95CKPECO-PC Cost Object Hierarchy: Individual Objects2KSTRGCost Objectnvarchar120
96CKPHMaster Record: Cost Object ID Number2KSTRGCost Objectnvarchar120
TOPProfit Center Accounting
97GLPCAEC-PCA: Actual Line Items67KSTRGCost Objectnvarchar120
98GLPCPEC-PCA: Plan Line Items125KSTRGCost Objectnvarchar120
TOPProfitability Analysis
99CE1850044KSTRGCost Objectnvarchar120
100CE1BGISErgebnisbereich für44KSTRGKostenträgernvarchar120
101CE1E_B1Model Bank44KSTRGCost Objectnvarchar120
102CE1IDEAOp. Concern BR World44KSTRGCost Objectnvarchar120
103CE1IDEBErgebnisbereich IDES44KSTRGKostenträgernvarchar120
104CE1IDESErgebnisbereich IDES44KSTRGKostenträgernvarchar120
105CE1INT1Ergebnisbereich IDES44KSTRGKostenträgernvarchar120
106CE1OC01Bike International44KSTRGCost Objectnvarchar120
107CE1R300Operating Concern IDES44KSTRGCost Objectnvarchar120
108CE1S001Sample operating concern71KSTRGCost Objectnvarchar120
109CE1S300Operating Concern IDES44KSTRGCost Objectnvarchar120
110CE1S_ALAirline Route Profit44KSTRGCost Objectnvarchar120
111CE1S_CPTemplate for Consumer Goods Industry44KSTRGCost Objectnvarchar120
112CE1S_GOQuickstart Template44KSTRGCost Objectnvarchar120
113CE2850034KSTRGCost Objectnvarchar120
114CE2BGISErgebnisbereich für34KSTRGKostenträgernvarchar120
115CE2E_B1Model Bank34KSTRGCost Objectnvarchar120
116CE2IDEAOp. Concern BR World34KSTRGCost Objectnvarchar120
117CE2IDEBErgebnisbereich IDES34KSTRGKostenträgernvarchar120
118CE2IDESErgebnisbereich IDES34KSTRGKostenträgernvarchar120
119CE2INT1Ergebnisbereich IDES34KSTRGKostenträgernvarchar120
120CE2OC01Bike International34KSTRGCost Objectnvarchar120
121CE2R300Operating Concern IDES34KSTRGCost Objectnvarchar120
122CE2S001Sample operating concern94KSTRGCost Objectnvarchar120
123CE2S300Operating Concern IDES34KSTRGCost Objectnvarchar120
124CE2S_ALAirline Route Profit34KSTRGCost Objectnvarchar120
125CE2S_CPTemplate for Consumer Goods Industry34KSTRGCost Objectnvarchar120
126CE2S_GOQuickstart Template34KSTRGCost Objectnvarchar120
127CE4850023KSTRGCost Objectnvarchar120
128CE48500_ACCT21KSTRGCost Objectnvarchar120
129CE48500_FLAG20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
130CE48500_KENC22KSTRGCost Objectnvarchar120
131CE4BGISErgebnisbereich für23KSTRGKostenträgernvarchar120
132CE4BGIS_ACCTErgebnisbereich für21KSTRGKostenträgernvarchar120
133CE4BGIS_FLAGErgebnisbereich für20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
134CE4BGIS_KENCErgebnisbereich für22KSTRGKostenträgernvarchar120
135CE4E_B1Model Bank23KSTRGCost Objectnvarchar120
136CE4E_B1_ACCTModel Bank21KSTRGCost Objectnvarchar120
137CE4E_B1_FLAGModel Bank20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
138CE4E_B1_KENCModel Bank22KSTRGCost Objectnvarchar120
139CE4IDEAOp. Concern BR World23KSTRGCost Objectnvarchar120
140CE4IDEA_ACCTOp. Concern BR World21KSTRGCost Objectnvarchar120
141CE4IDEA_FLAGOp. Concern BR World20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
142CE4IDEA_KENCOp. Concern BR World22KSTRGCost Objectnvarchar120
143CE4IDEBErgebnisbereich IDES23KSTRGKostenträgernvarchar120
144CE4IDEB_ACCTErgebnisbereich IDES21KSTRGKostenträgernvarchar120
145CE4IDEB_FLAGErgebnisbereich IDES Banking20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
146CE4IDEB_KENCErgebnisbereich IDES22KSTRGKostenträgernvarchar120
147CE4IDESErgebnisbereich IDES23KSTRGKostenträgernvarchar120
148CE4IDES_ACCTErgebnisbereich IDES21KSTRGKostenträgernvarchar120
149CE4IDES_FLAGErgebnisbereich IDES20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
150CE4IDES_KENCErgebnisbereich IDES22KSTRGKostenträgernvarchar120
151CE4INT1Ergebnisbereich IDES23KSTRGKostenträgernvarchar120
152CE4INT1_ACCTErgebnisbereich IDES21KSTRGKostenträgernvarchar120
153CE4INT1_FLAGErgebnisbereich IDES20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
154CE4INT1_KENCErgebnisbereich IDES22KSTRGKostenträgernvarchar120
155CE4OC01Bike International23KSTRGCost Objectnvarchar120
156CE4OC01_ACCTBike International21KSTRGCost Objectnvarchar120
157CE4OC01_KENCBike International22KSTRGCost Objectnvarchar120
158CE4R300Operating Concern IDES23KSTRGCost Objectnvarchar120
159CE4R300_ACCTErgebnisbereich IDES21KSTRGKostenträgernvarchar120
160CE4R300_FLAGErgebnisbereich IDES20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
161CE4R300_KENCOperating Concern IDES22KSTRGCost Objectnvarchar120
162CE4S001Sample operating concern32KSTRGCost Objectnvarchar120
163CE4S001_ACCTSample operating con21KSTRGCost Objectnvarchar120
164CE4S001_FLAGSample Operating Concern 120KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
165CE4S001_KENCSample operating con21KSTRGCost Objectnvarchar120
166CE4S300Operating Concern IDES23KSTRGCost Objectnvarchar120
167CE4S300_ACCTOperating Concern IDES21KSTRGCost Objectnvarchar120
168CE4S300_FLAGErgebnisbereich IDES Serv.Prov20KSTRGFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
169CE4S300_KENCOperating Concern IDES22KSTRGCost Objectnvarchar120
170CE4S_ALAirline Route Profit23KSTRGCost Objectnvarchar120
171CE4S_AL_ACCTAirline Route Profit21KSTRGCost Objectnvarchar120
172CE4S_AL_FLAGAirline Route Profit20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
173CE4S_AL_KENCAirline Route Profit22KSTRGCost Objectnvarchar120
174CE4S_CPTemplate for Consumer Goods Industry23KSTRGCost Objectnvarchar120
175CE4S_CP_ACCTTemplate for Consumer Goods Industry21KSTRGCost Objectnvarchar120
176CE4S_CP_FLAGTemplate for Consumer Goods Industry20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
177CE4S_CP_KENCTemplate for Consumer Goods Industry22KSTRGCost Objectnvarchar120
178CE4S_GOQuickstart Template23KSTRGCost Objectnvarchar120
179CE4S_GO_ACCTQuickstart Template21KSTRGCost Objectnvarchar120
180CE4S_GO_FLAGQuickstart Template20KSTRGFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
181CE4S_GO_KENCQuickstart Template22KSTRGCost Objectnvarchar120
182CEST4Segment table (CO-PA)23KSTRGCost Objectnvarchar120
TOPPurchasing
183EBKNPurchase Requisition Account Assignment26KSTRGCost Objectnvarchar120
184EKKNAccount Assignment in Purchasing Document29KSTRGCost Objectnvarchar120
TOPQuality Inspection
185QALSInspection lot record194KSTRGCost Objectnvarchar120
TOPQuality Notifications
186TQ8COAssignment of reference orders to notification type15KSTRGCost Objectnvarchar120
TOPRemaining Beverage - Obsolete Objects
187/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1213KSTRGCost Objectnvarchar120
TOPRepetitive Manufacturing
188COMPMOVEGoods Movement of Components131KSTRGCost Objectnvarchar120
TOPSelf-Service Procurement
189/SRMERP/D_ACC_ITAccount assignment item23KSTRGCost Objectnvarchar120
TOPSimulation
190VSEBKN_CNVersion: Purchase requisition account assignment27KSTRGCost Objectnvarchar120
TOPSocial Insurance
191T5D3PHR Technical Assignments for Workers' Compensation Assoc.11KSTRGCost Objectnvarchar120
TOPTravel Expenses
192PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document18KSTRGCost Objectnvarchar120
TOPTravel Planning
193FTPT_REQ_ACCOUNTTravel Request Cost Assignment13KSTRGCost Objectnvarchar120
TOPWaste Management
194EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment22KSTRGCost Objectnvarchar120
195EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document19KSTRGCost Objectnvarchar120
196EHSWAT_MNACCAccount Assignments for Disposal Document18KSTRGCost Objectnvarchar120