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

64 columns | Print definition?ERP 6.0  | DOCNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BKK_SEPA_LIM_EVEvent Table for Mandate Limits5DOCNOItem number in current accountsnvarchar120
2BKK_SEPA_LIM_HISHistory Table for Mandate Limits6DOCNOItem number in current accountsnvarchar120
3J_1I_EXIMACCLOGEXIM: Account Posting Log4DOCNODocument Numbernvarchar100
4J_1I_PMLICUTILEXIM : License Utilization6DOCNODocument Numbernvarchar100
5PA3317HR Master Record: Infotype 331733DOCNONumber of Receiptnvarchar260
TOPAccount Management
6BKKITNTCNotice: Payment Item with Notice Lock Period > 05DOCNOItem number in current accountsnvarchar120
7BKKPAYMNOTEBCA: Payment Notes2DOCNOBCA: Document Number of Payment Notesnvarchar180
8BKK_FA_USEDUtilization of Allowance5DOCNOItem number in current accountsnvarchar120
TOPApplication System
9/SAPTRX/ASITEMIDItem Identifier Refernce Table3DOCNODocument Numbernvarchar200
TOPASAP Tools and Contents
10SMAPDOCNOSolution Map: Doc. ID number status2DOCNOnvarchar100
TOPBank Customer Accounts
11BCA_US_MEM_ITEMSMemo item table10DOCNOItem number in current accountsnvarchar120
12BKKCORRITEMAuxiliary Table: Payment Items for Adjustments3DOCNOItem number in current accountsnvarchar120
13BKK_PRENOTEPrenotes35DOCNOItem number in current accountsnvarchar120
14RTP_US_HISTRetirement plan history and audit table13DOCNOItem number in current accountsnvarchar120
TOPClaims Management
15ICLDOCDocument to be Sent in Claim5DOCNONumber of Document in Claimnvarchar30
16ICLDOCALAttachments to Outbound Documents5DOCNONumber of Document in Claimnvarchar30
17ICSDOCDocument in Claim5DOCNONumber of Document in Claimnvarchar30
18ICSDOCALAttachments to Outbound Correspondence5DOCNONumber of Document in Claimnvarchar30
TOPEnvironment, Health and Safety
19/TDAG/CPT_TASKDCP: Dokumente zu Aufgabenpositionen4DOCNOInternal Document Numbernvarchar100
20/TDAG/CPT_TASKDACP: Dokumente zu Aufgabenpositionen / Archiv4DOCNOInternal Document Numbernvarchar100
TOPFSCM In-House Cash
21IHC_DB_DSP_TRAPOTable Structure for displaying the Posted Item Detail2DOCNOInput Field for Search Criterion for Selecting Open Itemsnvarchar300
TOPGL transfer
22BKKC02General Ledger: Posting Totals for FI5DOCNOItem number in current accountsnvarchar120
23BKKC12_ITEMGL: New Balances for Balance Sheet Preparation (Items)3DOCNOItem number in current accountsnvarchar120
24BKKITGLGen. Ledger: Payment Item Data3DOCNOItem number in current accountsnvarchar120
TOPIndustry Solution Catch Weight Management
25CON_FIN_WQ_HDRHeader Table for Transactions in Work Queue12DOCNODocument Number of Transaction in Work Queuenvarchar120
TOPInterface to Terminal Automation System
26OIK01IS-OIL/TAS: LID Document Data3DOCNOSAP Document Number (TAS)nvarchar100
27OIK01DIS-OIL/TAS: deactivated LID Document Data3DOCNOSAP Document Number (TAS)nvarchar100
28OIK02AIS-OIL/TAS: Status of processed functions12DOCNOSAP Document Number (TAS)nvarchar100
29OIKLIDRTD - TAS Reference Table7DOCNOSAP Document Number (TAS)nvarchar100
TOPLease Accounting
30FIOTPOHOne-Time Postings: Header7DOCNODocument Numbernvarchar40
31FIOTPOIOne-Time Postings: Items7DOCNODocument Numbernvarchar40
TOPLocalization
32J_1IEXCDEPExcise information of vendor at detail level for depot4DOCNOInternal Excise Document Numbernvarchar100
33J_1IEXCDTLExcise invoice line item details4DOCNOInternal Excise Document Numbernvarchar100
34J_1IEXCHDRExcise invoice header detail4DOCNOInternal Excise Document Numbernvarchar100
35J_1IPART1Excise part I detials13DOCNOInternal Excise Document Numbernvarchar100
36J_1IPART2Excise Part II details7DOCNOInternal Excise Document Numbernvarchar100
37J_1IQRDEPQuarterly Returns Depot structure1DOCNOInternal Excise Document Numbernvarchar100
38J_1IRG23DRG23D register for the depot4DOCNOInternal number - GR for delivery at depotnvarchar100
39J_1ISUBBYPSubcontracting Scrap/ Byproduct3DOCNOInternal Excise Document Numbernvarchar100
TOPMaster Data
40BCA_US_HLD2RELHold Records which have not been released - Dual Control21DOCNOItem number in current accountsnvarchar120
41BCA_US_HOLDHold Amounts Which Affect Available Balance20DOCNOItem number in current accountsnvarchar120
TOPPayment Item
42BKKI3Turnover Items Not Posted for Last Bank Statement3DOCNOItem number in current accountsnvarchar120
43BKKITPayment Item3DOCNOItem number in current accountsnvarchar120
44BKKITADRPayment Item: Address of Transferring Party3DOCNOItem number in current accountsnvarchar120
45BKKITENQBlocked Payment Items3DOCNOItem number in current accountsnvarchar120
46BKKITPREParked Payment Items5DOCNOItem number in current accountsnvarchar120
47BKKITRELPayment Item3DOCNOItem number in current accountsnvarchar120
48BKKITRETRELPayment Item Return to be released3DOCNOItem number in current accountsnvarchar120
49BKKITTMPPlanned Payment Items5DOCNOItem number in current accountsnvarchar120
50BKKITTMP_DELPlanned Payment Items - Completed5DOCNOItem number in current accountsnvarchar120
51BKKNTPurpose3DOCNOItem number in current accountsnvarchar120
TOPReporting
52P05T_WCR_ER_INFOWCR Info on Employer Level13DOCNOInvoice Numbernvarchar100
TOPReturnable Packaging Logistics
53RLACPOITAccount Posting Record23DOCNOReference document for RP account postingnvarchar350
54RLACSTITTransactions in Returnable Packaging Account Statement8DOCNODocument Number for Transactionnvarchar350
TOPSelf-Billing Proced.
55TRNSMData Transfer16DOCNOIDoc numbernvarchar160
TOPService Station Retailing
56OIRA_PRNDOC_HEADPrint document header data2DOCNOCollective print document numbernvarchar100
57OIRA_PRNDOC_ITEMPrint document item data2DOCNOCollective print document numbernvarchar100
TOPTraders and Schedulers Workbench
58OIJPEGTSW: Pegging of scheduled movements3DOCNODocument key (generic)nvarchar200
59OIJ_EL_DFLOW_SUBTSW - Document flow for sub items2DOCNOTSW - Reference Document Number for Sub-Item Document Flownvarchar100
60OIJ_EL_ELOG_SUBTSW: Error log for ticketing process at sub item2DOCNOTSW - Reference Document Number for Sub-Item Document Flownvarchar100
TOPUSA
61PA0566HR Master Record: Infotype 056624DOCNOQDRO Docket Numbernvarchar350
TOPUse Subcomponents
62SOFMSAPoffice: Folder contents7DOCNOObject: Number from IDnvarchar120
63SOMGTable for persistence of objects MESSAGE/RECIPIENT15DOCNOObject: Number from IDnvarchar120
TOPWaste Management
64EHSWAT_ENTAMDisposal Processing (Quantity Entry/Planning)44DOCNOExternal Documentnvarchar160