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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

25 columns | Print definition?ERP 6.0  | LINE_NUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIN/KBNXLOGXML Application Log4LINE_NUMBERNumeric Character Field, Length 10nvarchar100
2/AIN/KBNXLOGDXML Application Log4LINE_NUMBERNumeric Character Field, Length 10nvarchar100
3/XFT/SRMCYCLE51Cycle: Node4LINE_NUMBERNumberint100
4CNV_10993_RESULTCoding Scan 10993 Search Run Result Table6LINE_NUMBERLine numbernvarchar50
5DOCM_STG_ARCHIVEDBOSC-CM: Staging Archive2LINE_NUMBERnvarchar100
6DOCR_LONG_VALUEDBOSC-CR: Long value in pieces of 255 chars3LINE_NUMBERnvarchar100
7FMADB_TC_WEIGHTSFMADB: Trace - Saved Weights (Last Run)4LINE_NUMBERLine Numbernvarchar100
8LTR_G_RTN_LRoutine Lines5LINE_NUMBERLine Numbernvarchar50
9PIQDB_GB_SEQ_EXUCAS: Student extract information from sequence files6LINE_NUMBERUCAS: Line number in sequence filenvarchar50
TOPBank Customer Accounts
10NIHC_DB_PO_RINFReference/Note to Payee Information3LINE_NUMBERnvarchar60
TOPCheck Input
11OIUCI_DETAILIncoming Check's Detail Line information5LINE_NUMBERCheck Detail line/group numbernvarchar50
12OIUCI_MESGContains warning, error message pertaining to a Line item(s)5LINE_NUMBERCheck Detail line/group numbernvarchar50
13OIUCI_NOTESNotes for Suspended Line item of Incoming Check5LINE_NUMBERCheck Detail line/group numbernvarchar50
14OIUCI_PDXLOCKIncoming Check Usage of Property/DOI xref master data11LINE_NUMBERCheck Detail line/group numbernvarchar50
15OIUCI_PTLOCKIncoming Check Usage of Property/Product translation data8LINE_NUMBERCheck Detail line/group numbernvarchar50
TOPElectronic Data Interchange
16PRICAT_K009PRICAT: Catalog Item Scales for Condition8LINE_NUMBERCurrent number of the line scalenvarchar40
17PRICAT_K009CPRICAT: Catalog Item Scales for Condition for Customer9LINE_NUMBERCurrent number of the line scalenvarchar40
TOPEnd User Technology
18RSZELTTXT_MULTIMultiline Texts from Reporting Components and Elements4LINE_NUMBERLine Number of Text for Multiline Textsnvarchar40
TOPFSCM In-House Cash
19IHC_DB_PN_RINFOReference/Note to Payee Information5LINE_NUMBERLine Number for Reference Infonvarchar60
TOPJoint Venture und Production Sharing Accounting
20T8J4HNon-Op saved bills - Detail Info (for holding bills)6LINE_NUMBERLine number in the Non-Operated Billing Formnvarchar40
TOPLocalization
21EPIC_ITM_REMEPIC: Comments/Remarks for Payment Items3LINE_NUMBERNatural Numberint100
TOPNetWeaver Enterprise Search
22ESH_GEN_SWC_DATAObsolete4LINE_NUMBERNatural Numberint100
TOPProcess Orchestration for Built-In Processes
23POC_C_SIMPOC: Simulation Data3LINE_NUMBERLine Number for Process Simulationnvarchar40
TOPShift Planning for Public Sector
24HRSP_ABS_INF_LINInfo Rows for Absence Planner: Public Sector Germany3LINE_NUMBERNo. of Columns for Customizing ALV Outputnvarchar20
TOPUpstream Graphics
25OIUGT_LOG_DETAILUpstream Graphics Graphics Log Details3LINE_NUMBERGraphical Tool Graphics Error Log Line Numbernvarchar50