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

33 columns | Print definition?ERP 6.0  | ACCID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_DUMMYDummy Table for External Deductions20ACCIDBank details IDnvarchar40
2/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)9ACCIDBank details IDnvarchar40
3CNVTDMS_05_DIMACollected Header Document Numbers for TDMS_Time-VBUK3ACCIDACCID/MATID for DIMPnvarchar100
4FIBKRUD_ACCLISTList of generated banking accounts3ACCIDGenerated account number - internal valuenvarchar100
5FIBKRUD_ACCLISTTList of generated banking accounts. Texts3ACCIDGenerated account number - internal valuenvarchar100
6FIBKRUD_ACCOUNTSAccount profiles3ACCIDGenerated account number - internal valuenvarchar100
7FIBKRUD_BALANCEFI Banking Russia: Totals Records3ACCIDGenerated account number - internal valuenvarchar100
8FIBKRUD_T0Multi-digit account master record transaction figures4ACCIDGenerated account number - internal valuenvarchar100
9P2NZ_LVACCPayroll Result: Leave Accruals LVACC - NZ8ACCIDLeave Accrual Identifier - NZnvarchar20
10P2RQ_LSLPRPayroll Results: LSLPR Table12ACCIDLeave Accrual Identifier Australianvarchar20
11P2RQ_LVACCPayroll Results: Leave Accrual (Australia)6ACCIDLeave Accrual Identifier Australianvarchar20
12P2RQ_LVEPRPayroll Results: LVEPR Table12ACCIDLeave Accrual Identifier Australianvarchar20
13PA3529HR Master Record: Infotype 352934ACCIDDegree Certificate IDnvarchar200
14PB3529Applicant data infotype 3529 (model)34ACCIDDegree Certificate IDnvarchar200
TOPAustralia
15T5QLPLeave Provisions - Australia4ACCIDLeave Accrual Identifier Australianvarchar20
16T5QLRLeave Accrual Rules Australia4ACCIDLeave Accrual Identifier Australianvarchar20
17T5QLTLeave Accrual-Id description Australia5ACCIDLeave Accrual Identifier Australianvarchar20
TOPBusiness Consolidation
18UCF0021Method Steps: Selection Condition6ACCIDGUID to Identify Posting Rulenvarchar220
19UCFI200IPI Customizing: Inventory Items8ACCIDGUID to Identify Posting Rulenvarchar220
20UCMI200Selected Items: Cross-Functional8ACCIDGUID to Identify Posting Rulenvarchar220
21UCMI300Deferred Tax Items8ACCIDGUID to Identify Posting Rulenvarchar220
22UCT4000Target Account Assignment: Characteristics2ACCIDGUID to Identify Posting Rulenvarchar220
23UCT400CTarget Account Assignment: GUID4ACCIDGUID to Identify Posting Rulenvarchar220
24UCT400GTarget Account Assignment: GUID2ACCIDGUID to Identify Posting Rulenvarchar220
TOPIndonesia
25PA0319Indonesia Private Insurances25ACCIDInsurance Account Idnvarchar150
TOPInformation System
26UCRX010XBRL Mapping Table6ACCIDGUID to Identify Posting Rulenvarchar220
TOPNew Zealand
27PA0311Leave Adjustments - NZ25ACCIDLeave Accrual Identifier - NZnvarchar20
28T7NZLALeave Accrual Id Table - NZ5ACCIDLeave Accrual Identifier - NZnvarchar20
29T7NZLBLeave Accrual Id Description - NZ6ACCIDLeave Accrual Identifier - NZnvarchar20
30T7NZLRLeave Rule Table - NZ5ACCIDLeave Accrual Identifier - NZnvarchar20
TOPProduction Backflush
31PPC_CONF_MATActual Quantity of Backflushed Materials3ACCIDKey (Number Range) PPC_MAT_DET, References MATIDnvarchar100
32PPC_CONF_MAT_VARVariance with Target Quantity for Backflushed Materials3ACCIDKey (Number Range) PPC_MAT_DET, References MATIDnvarchar100
33PPC_MAT_DETSuper BOM: Special Account/Batch Information2ACCIDKey (Number Range) PPC_MAT_DET, References MATIDnvarchar100