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

198 columns | Print definition?ERP 6.0  | AETIM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/DSCSAG/TFLDSMetadata object fields for passing to plm12AETIMLast changed atnvarchar40
2/DSCSAG/TOBJAdditional selection data for object fields7AETIMLast changed atnvarchar40
3/DSCSAG/TVERSCustomized versions for object metadata6AETIMTime last change was madenvarchar60
4/OPT/VIM_CFG_VERTable to store ICC Configuration data versions6AETIMTime of Entrynvarchar60
5/OPT/VIM_FB_OBJTable to store ICC feedback status5AETIMTime of Entrynvarchar60
6CNV_10020_ACTActions - Header data13AETIMTime of last changenvarchar60
7CNV_10020_CDOBJHCondition objects: Header data12AETIMTime of last changenvarchar60
8CNV_10020_CFOBJHConcatenated/fragmented objects: Header data13AETIMTime of last changenvarchar60
9CNV_10020_CONDConditions - Header data13AETIMTime of last changenvarchar60
10CNV_10020_DTFLDAssignment of determination to tables and fields26AETIMTime of last changenvarchar60
11CNV_10020_DTOBJHDetermination objects14AETIMTime of last changenvarchar60
12CNV_10020_FVOBJFixed value objects14AETIMTime of last changenvarchar60
13CNV_10020_ITRLGIInformation about last generation of itr includes6AETIMTime of last changenvarchar60
14CNV_10020_PATHDetermination paths: Header data29AETIMTime of last changenvarchar60
15CNV_10020_RCOMPAssignment of rules to non-transp. field components17AETIMTime of last changenvarchar60
16CNV_10020_RDTOBJAssignment of rules to determination object components17AETIMTime of last changenvarchar60
17CNV_10020_RULERules - Header data12AETIMTime of last changenvarchar60
18CNV_10020_VLISTValue lists - Header data13AETIMTime of last changenvarchar60
19DFKKPDCFI-CA: Postdated Checks12AETIMTime at Which the Object Was Last Changednvarchar60
20DFKKPDCSFI-CA: Status Changes for Postdated Checks7AETIMTime at Which the Object Was Last Changednvarchar60
21DFKKPRNDSEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items15AETIMTime at Which the Object Was Last Changednvarchar60
22DFKKPRNHSEPA: Direct Debit Pre-Notifications (FI-CA)26AETIMTime at Which the Object Was Last Changednvarchar60
23DFKK_MA_HHeader Data of Master Agreement9AETIMLast Changed Atnvarchar60
24DFKK_VT_DCT: Discounts on Provider Contract13AETIMLast Changed Atnvarchar60
25DFKK_VT_TRCT: IDs of Provider Contract (Technical Resources)14AETIMLast Changed Atnvarchar60
26FAGL_011PC_XBRLFin. Statement Version: Items in Financial Statement Version13AETIMLast changed atnvarchar40
27FAGL_GCDPC_VERGCD Revision: Element Relationships15AETIMLast changed atnvarchar40
28FAGL_GCDPC_XBRLGCD-Structure: Element Relationships13AETIMLast changed atnvarchar40
29FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header23AETIMTime at Which the Object Was Last Changednvarchar60
30FKKID_VAT_HDR_ACr.Mem.&Exp.Conf.: VAT Transfer Header13AETIMTime at Which the Object Was Last Changednvarchar60
31T7UNPF_FI_ADDETAdditional Details26AETIMTime of last changenvarchar60
32T7UNPF_FI_ADJUSAdjustments18AETIMTime of last changenvarchar60
33T7UNPF_FI_CONTRContributions14AETIMTime of last changenvarchar60
34T7UNPF_FI_MISCEFinancial Interface Misc. Transactions16AETIMTime of last changenvarchar60
35T7UNPF_FI_OPRHDOperation Header16AETIMTime of last changenvarchar60
36T7UNPF_FI_STFHDStaff Member Header Table14AETIMTime of last changenvarchar60
37T7UNPF_FI_TRANSAdditional Details39AETIMTime of last changenvarchar60
38T7UNPF_HR_ADDRAddress21AETIMTime of last changenvarchar60
39T7UNPF_HR_CHILDChild details22AETIMTime of last changenvarchar60
40T7UNPF_HR_CNTRCContract details21AETIMTime of last changenvarchar60
41T7UNPF_HR_DEPNDDependent details22AETIMTime of last changenvarchar60
42T7UNPF_HR_DSDuty Station details13AETIMTime of last changenvarchar60
43T7UNPF_HR_EMAILEmail Information15AETIMTime of last changenvarchar60
44T7UNPF_HR_LANGLanguage Allowance13AETIMTime of last changenvarchar60
45T7UNPF_HR_LWOPLeave Without Pay14AETIMTime of last changenvarchar60
46T7UNPF_HR_OPRHDOperation Header15AETIMTime of last changenvarchar60
47T7UNPF_HR_PARTParttime Details13AETIMTime of last changenvarchar60
48T7UNPF_HR_PHONEPhone Information15AETIMTime of last changenvarchar60
49T7UNPF_HR_SALSalary details15AETIMTime of last changenvarchar60
50T7UNPF_HR_SECONStaff Secondment details16AETIMTime of last changenvarchar60
51T7UNPF_HR_SEPStaff Member Separation details16AETIMTime of last changenvarchar60
52T7UNPF_HR_STAFFStaff Member Table24AETIMTime of last changenvarchar60
53T7UNPF_HR_STFHDStaff Member Header Table17AETIMTime of last changenvarchar60
TOPAdvertising Management
54JJTGENTRIS-M/AM: Generation Status9AETIMTime last change was madenvarchar60
TOPAsset Accounting
55BWFIAA_AEDAT_ABFIAA-BW: Modified Valuation Area Data for Delta Upload7AETIMTime of Entrynvarchar60
56BWFIAA_AEDAT_ASFIAA-BW: New and Modified Master Records for Delta Upload6AETIMTime of Entrynvarchar60
57BWFIAA_AEDAT_TRFIAA-BW: New and Modified Transactions for Delta Upload9AETIMTime of Entrynvarchar60
TOPBulk Distribution Requirements Planning
58OIIGMMSGMM: Meter/Storage object assignment8AETIMTime of day the record was changednvarchar60
TOPBusiness Accounting
59URBWLRealigner: DataSources5AETIMTimenvarchar60
60URBWLGRealigner: Status Information for DataSource9AETIMSystem Timenvarchar60
TOPBusiness Partner
61DFKKBPCLBusiness Partner Duplicates: Predecessor - Successor12AETIMTime at Which the Object Was Last Changednvarchar60
62DFKKBPCL_ACTBusiness Partner Duplicates: Status of Activities14AETIMTime at Which the Object Was Last Changednvarchar60
TOPCollectionsDisbursements
63VVKKREPCL_REPFS-CD: Money Laundering Law Reporting State24AETIMTime at Which the Object Was Last Changednvarchar60
TOPCompany Pension Scheme Germany
64P01CADAdministration Data for CPS Tables5AETIMTime of Last Changenvarchar60
TOPContract Accounts Receivable and Payable
65DFKKAVKPayment Advice: Header Data18AETIMTime at Which the Object Was Last Changednvarchar60
66DFKKAWM_CORRRequest for Corrections for Entries in DFKKAWM5AETIMTime at Which the Object Was Last Changednvarchar60
67DFKKBRPOPNOTBalance reporting: noticed contract account document items18AETIMTime at Which the Object Was Last Changednvarchar60
68DFKKCCTKCollections Management: Test Series - Header Data12AETIMTime at Which the Object Was Last Changednvarchar60
69DFKKCLMEMManagement Table for Buffered Open Item Processing8AETIMTime at Which the Object Was Last Changednvarchar60
70DFKKCMKManually Issued Checks Lot: Header Data26AETIMTime at Which the Object Was Last Changednvarchar60
71DFKKCMPManually Issued Checks Lot: Item Data39AETIMTime at Which the Object Was Last Changednvarchar60
72DFKKCRRepository For Checks35AETIMTime at Which the Object Was Last Changednvarchar60
73DFKKCRCLTable for Checks To Be Clarified23AETIMTime at Which the Object Was Last Changednvarchar60
74DFKKCRDELCR: Deleted Payment Medium / Basic Data38AETIMTime at Which the Object Was Last Changednvarchar60
75DFKKDDADebit Memo Notification20AETIMTime changednvarchar60
76DFKKEXCJCash Journal: Data Store for Inbound Services39AETIMTime at Which the Object Was Last Changednvarchar60
77DFKKIP_GRPPayment Specification: Header Data20AETIMTime of Entrynvarchar60
78DFKKIP_GRPHPayment Specification: Payment Data (History)22AETIMTime of Entrynvarchar60
79DFKKMDUGPMaster Data Lot: Items of the Groups of a Lot10AETIMTime at Which the Object Was Last Changednvarchar60
80DFKKMDUKMaster Data Lot: Header Data18AETIMTime at Which the Object Was Last Changednvarchar60
81DFKKNRKNOC Returns Lot: Header Data12AETIMTime at Which the Object Was Last Changednvarchar60
82DFKKNRPNOC Returns Lot: Item Data6AETIMTime at Which the Object Was Last Changednvarchar60
83DFKKNRPENOC Returns Lot: Error Messages for Items11AETIMTime at Which the Object Was Last Changednvarchar60
84DFKKOPVZAgreed Payment Amounts16AETIMLast changed atnvarchar40
85DFKKORDERRequests: Header Data26AETIMTime at Which the Object Was Last Changednvarchar60
86DFKKORDER_SRequest Templates: Header Data26AETIMTime at Which the Object Was Last Changednvarchar60
87DFKKPNBKAPrenotification data (latest)7AETIMTime changednvarchar60
88DFKKPNBKHPrenotification data (history)7AETIMTime changednvarchar60
89DFKKPOHPayment Order: Header Data27AETIMTime changednvarchar60
90DFKKPPD_PAY_HISPromise to Pay Debit Memo Amounts per Date5AETIMTime at Which the Object Was Last Changednvarchar60
91DFKKPP_HISPromise to Pay History of Manual Status Changes4AETIMTime at Which the Object Was Last Changednvarchar60
92DFKKPREPREVFlagged Reversals for Top-Up Documents of Prepaid Accounts9AETIMTime of Last Attempt to Executenvarchar60
93DFKKRKReturns lot: Header data31AETIMTime at Which the Object Was Last Changednvarchar60
94DFKKRPReturns lot: Data for payment38AETIMTime at Which the Object Was Last Changednvarchar60
95DFKKTHI_SUMAggregated Transfer Records for Invoicing20AETIMTime at Which the Object Was Last Changednvarchar60
96DFKKWLWorklist10AETIMTime at Which the Object Was Last Changednvarchar60
97DFKKWLAWorklist (Work Item Type)10AETIMTime at Which the Object Was Last Changednvarchar60
98DFKKWLIWork Items29AETIMTime at Which the Object Was Last Changednvarchar60
99DFKKWLIAWork Items (Work Item Type)29AETIMTime at Which the Object Was Last Changednvarchar60
100DFKKWLIAHWork Items (History, Work Item Type)5AETIMTime at Which the Object Was Last Changednvarchar60
101DFKKWLIA_ACActions of Work Item (Work Item Type)16AETIMTime at Which the Object Was Last Changednvarchar60
102DFKKWLIHWork Items (History)4AETIMTime at Which the Object Was Last Changednvarchar60
103DFKKWLI_ACActions of Work Item16AETIMTime at Which the Object Was Last Changednvarchar60
104DFKKWLI_ILItem List of Work Item14AETIMTime at Which the Object Was Last Changednvarchar60
105DFKKZARepayment Request37AETIMTime changednvarchar60
106DFKKZKPayment lot: Header data31AETIMTime at Which the Object Was Last Changednvarchar60
107DFKKZPPayment lot: Data for payment31AETIMTime at Which the Object Was Last Changednvarchar60
108DFKK_IPL_CTRLControl Entries for Installment Plan Key Date Recording10AETIMLast changed atnvarchar40
109DFKK_VT_HCT: Header Data of Provider Contract9AETIMLast Changed Atnvarchar60
110DFKK_VT_ICT: Items of Provider Contract8AETIMLast Changed Atnvarchar60
111FKKDIHDRFI-CA: Distrib. of intervals - header12AETIMTime of Changenvarchar60
TOPDenmark
112T5M7WFile Entries Assignment from T5M7V18AETIMTime of Last Changenvarchar60
TOPExchanges
113OIA01Exchange header (IS-Oil EXG standard/core object)19AETIMTime of day the record was changednvarchar60
114OIA02Exchange item data - sales side13AETIMTime of day the record was changednvarchar60
115OIA03Exchange item data - purchasing side14AETIMTime of day the record was changednvarchar60
116OIA05HQuantity schedule header table - sales side28AETIMTime of day the record was changednvarchar60
117OIA06HQuantity schedule header table - purchasing side29AETIMTime of day the record was changednvarchar60
118OIA08HLIA Document: Header Data11AETIMTime of day the record was changednvarchar60
119OIA10HExchange - Netting document header9AETIMTime of day the record was changednvarchar60
120OIAQAExchange Statement Print Requests39AETIMTime of day the record was changednvarchar60
TOPFinancial Accounting
121BWFI_AEDA2BW FI: Log Table for Changed Transaction Figures8AETIMTime of Entrynvarchar60
122BWFI_AEDA3BW FI: Log Table for Changed Credit Management Data7AETIMTime of Entrynvarchar60
123BWFI_AEDATBW FI: Log Table for Changed FI Documents6AETIMTime of Entrynvarchar60
124KMKPFFI: Account Assignment Model Header Information14AETIMTime of Entrynvarchar60
TOPFinancial Services
125BWFS_SETTINGSTime Stamp Delta Extraction5AETIMSystem Timenvarchar60
TOPInformation System
126BIW_PS_DELTAAdmin. Data for Delta Extraction of Master Data5AETIMSystem Timenvarchar60
127KAP8_TIMESTBW PS: Time Stamp Tables for Delta Extraction4AETIMSystem Timenvarchar60
TOPInformation System, iViews
128BWOM2_TIMESTBW CO-OM: Timestamp Table for Delta Extraction4AETIMSystem Timenvarchar60
TOPIntegration Customer Relationship Management
129ECRM_REPL_CDTable for Change Documents FG EREPL_ERRORHANDLING5AETIMField of type TIMSnvarchar60
TOPKnowledge Base
130ISLACTSDB: Solution Activity13AETIMTime of Changenvarchar60
131ISLATTSDB: Solution Attachment12AETIMTime of Changenvarchar60
132ISLATTXTSDB: Solution Attachment Text13AETIMTime of Changenvarchar60
133ISLTKSDB: Solution Task13AETIMTime of Changenvarchar60
134ISLVALCATSDB: Solution Validation Category12AETIMTime of Changenvarchar60
135ISMITSDB: Symptom Trigger10AETIMTime of Changenvarchar60
136ISMITCASDB: Symptom Trigger Cause16AETIMTime of Changenvarchar60
137ISMITOPSDB: Symptom Trigger Object Part14AETIMTime of Changenvarchar60
138ISMITPRSDB: Symptom Trigger Problem15AETIMTime of Changenvarchar60
139ISMITXTSDB: Symptom Trigger Short Text14AETIMTime of Changenvarchar60
140ISMOBSDB: Symptom Object table15AETIMTime of Changenvarchar60
141ISMPSDB: Symptom table25AETIMTime of Changenvarchar60
142ISMSLSDB: Symptom Solution Link table12AETIMTime of Changenvarchar60
143ISMTXTSDB: Symptom short text13AETIMTime of Changenvarchar60
144ISMVALCATSDB: Symptom Validation Category12AETIMTime of Changenvarchar60
145ISOLSDB: Solution table18AETIMTime of Changenvarchar60
146ISOTXTSDB: Solution Short Text Table13AETIMTime of Changenvarchar60
TOPLease Accounting
147/LSIERP/WLWorklist8AETIMTime at Which the Object Was Last Changednvarchar60
148/LSIERP/WLIWork Items13AETIMTime at Which the Object Was Last Changednvarchar60
149/LSIERP/WLIHDO NOT USE -> Can Be Deleted4AETIMTime at Which the Object Was Last Changednvarchar60
150/LSIERP/WLI_ILItem List of Work Item17AETIMTime at Which the Object Was Last Changednvarchar60
TOPLocalization
151J_1APACK1Printing Authorization Code for Vendors11AETIMTime of Entrynvarchar60
TOPMarketing, Accounting and Pricing
152OICDCDifferential Reference Code13AETIMTime of day the record was changednvarchar60
153OICDTDifferential Reference Code - Texts9AETIMTime of day the record was changednvarchar60
TOPMarketing, Contract and Order Entry
154OID9IRemapping Default Item Categories13AETIMTime of day the record was changednvarchar60
155OIDAPAutomatic Plant Determination23AETIMTime of day the record was changednvarchar60
TOPNon Profit Organizations
156T7UNPF_MI_ACTCOUNJSPF Monthly Interface Activity Control Table13AETIMTime of last changenvarchar60
157T7UNPF_MI_BISTAUNJSPF Monthly Interface Break in Service16AETIMTime of last changenvarchar60
158T7UNPF_MI_CHLDRUNJSPF Monthly Interface Children Table26AETIMTime of last changenvarchar60
159T7UNPF_MI_DEPNDUNJSPF Monthly Interface Export key27AETIMTime of last changenvarchar60
160T7UNPF_MI_PARTTUNJSPF Monthly Interface Part Time Table14AETIMTime of last changenvarchar60
161T7UNPF_MI_PRTCIUNJSPF Monthly Interface Participant Table28AETIMTime of last changenvarchar60
162T7UNPF_YI_SCHEUNJSPF Yearly Interface data table17AETIMTimenvarchar60
TOPPayments
163DFKKBOHBoleto: Header data30AETIMTime changednvarchar60
TOPPayroll
164T7ROA7Master data events for HR-RO reporting7AETIMTime of last changenvarchar60
165T7SIA7Master data events for HR-SI reporting7AETIMTime of last changenvarchar60
TOPPeriodical Sales and Distribution
166JDTGENTRIS-M/SD: Generation Trigger9AETIMTime last change was madenvarchar60
TOPPersonnel Administration
167PA0255HR master record Infotype 0082 (Additional absence data)35AETIMTime of illnessnvarchar60
TOPProfitability Analysis
168TKEBWLCO-PA Connection to SAP BW: InfoSources5AETIMTimenvarchar60
169TKEBWLGCO-PA Connectn to SAP BW: Status Information for InfoSource11AETIMSystem Timenvarchar60
170TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource10AETIMSystem Timenvarchar60
171TKETRLSummarization Levels: Catalog Entry, Header7AETIMLast changed atnvarchar40
172TKETRLGSummarization Levels: Catalog entry, header (generated obj.)7AETIMLast changed atnvarchar40
173TKETRLGXSummarization Levels: Catalog entry, header (generated obj.)4AETIMLast changed atnvarchar40
174TKETRLXSummarization levels: Catalog entry, index descriptions8AETIMLast changed atnvarchar40
TOPPublic Sector
175PAPBS00_PWEBFLOWBusiness Flow Exchanger14AETIMLast changed atnvarchar40
176T7PBSWB6ABusiness flow log11AETIMTime of last changenvarchar60
TOPPublic Sector Contract Accounts Receivable and Payable
177DFMCA_BRF_MSGTax Calculation and Validation: Error Messages14AETIMTime of status changenvarchar60
178DFMCA_CORELData Table for Relationship19AETIMTime at Which the Object Was Last Changednvarchar60
TOPService Station Retailing
179OIRAPROCSTATPC Process status (IS-OIL SSR)11AETIMTime when Record Was Changednvarchar60
180OIRBMATMETBusiness Location material/meter assignment (IS-Oil, SSR)21AETIMTime of day the record was changednvarchar60
181OIRBPBLSTATLocation Status definition (IS-Oil SSR)11AETIMTime when Record Was Changednvarchar60
182OIRCCOMPDSSR Pricing - Competitor price differences13AETIMTime of day the record was changednvarchar60
183OIRCCOMPDMSSR Pricing - Competitor price differences/Material14AETIMTime of day the record was changednvarchar60
184OIRCLPCDSSR Pricing - Location price cluster differences13AETIMTime of day the record was changednvarchar60
185OIRCLPCDMSSR Pricing - Location price cluster differences/Material14AETIMTime of day the record was changednvarchar60
186OIRCMDPGRSSR Pricing - Material differences rates13AETIMTime of day the record was changednvarchar60
187OIRCSDPGRSSR Pricing - Service type differences rates13AETIMTime of day the record was changednvarchar60
188OIRECH_APPLSSR PC: Clearing House application data (IS-Oil SSR)13AETIMTime when Record Was Changednvarchar60
189OIREPBLSSR PC: Types per business location20AETIMTime when Record Was Changednvarchar60
190OIRESETT_HEADPayment Cards: Settlement Run Log15AETIMTime of day the record was changednvarchar60
191OIRESETT_ITEMPayment Cards: Settlement Run Log11AETIMTime of day the record was changednvarchar60
192OIRESPCRSSR PC: Splitting criteria16AETIMTime of day the record was changednvarchar60
193OIREUPLKXXXXSSR PC: Template for generated DTF tables (header)66AETIMTime of day the record was changednvarchar60
194OIRE_RECON_RUNReconciliation run results16AETIMTime of day the record was changednvarchar60
TOPSyntax, Compiler, Runtime
195ABAPDOCU_BUFFBuffer table for formatted content of ABAP Documentation6AETIMTIME Data Element for SYSTnvarchar60
196ABAPHTMLSystem Table for Buffering COntents of ABAP Documentation6AETIMTIME Data Element for SYSTnvarchar60
TOPTariffs, Duties and Permits
197OIH14Tax rate revaluation - obsolete29AETIMTime of day the record was changednvarchar60
TOPTraders and Schedulers Workbench
198OIJ_PLAN_PRF3WP Planning Profile86AETIMTime of day the record was changednvarchar60