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

46 columns | Print definition?ERP 6.0  | UTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RM_MVACPayroll Structure MVAC: Leave Handling (DK)7UTYPELeave type, duplicate of SUPTYPE DKnvarchar40
2YIT_R1ACCIDA: Reference Table ACC1UTYPEIDA type of usenvarchar10
3YIT_R1ASSIDA: Reference Table ASS1UTYPEIDA type of usenvarchar10
4YIT_R1BNKIDA: Reference Table BNK1UTYPEIDA type of usenvarchar10
5YIT_R1BOMIDA: Reference Table BOM1UTYPEIDA type of usenvarchar10
6YIT_R1CATIDA: Reference Table CAT1UTYPEIDA type of usenvarchar10
7YIT_R1COEIDA: Reference Table COE1UTYPEIDA type of usenvarchar10
8YIT_R1COSIDA: Reference Table COS1UTYPEIDA type of usenvarchar10
9YIT_R1CREIDA: Reference Table CRE1UTYPEIDA type of usenvarchar10
10YIT_R1DEBIDA: Reference Table DEB1UTYPEIDA type of usenvarchar10
11YIT_R1DOCIDA: Reference Table DOC1UTYPEIDA type of usenvarchar10
12YIT_R1EQUIDA: Reference Table EQU1UTYPEIDA type of usenvarchar10
13YIT_R1IPRIDA: Reference Table IPR1UTYPEIDA type of usenvarchar10
14YIT_R1MATIDA: Reference Table MAT1UTYPEIDA type of usenvarchar10
15YIT_R1MPLIDA: Reference table MPL1UTYPEIDA type of usenvarchar10
16YIT_R1NETIDA: Reference table NET1UTYPEIDA type of usenvarchar10
17YIT_R1OBJIDA: Reference table OBJ1UTYPEIDA type of usenvarchar10
18YIT_R1ORDIDA: Reference table ORD1UTYPEIDA type of usenvarchar10
19YIT_R1PERIDA: Reference table PER1UTYPEIDA type of usenvarchar10
20YIT_R1PRCIDA: Reference Table COS1UTYPEIDA type of usenvarchar10
21YIT_R1PROIDA: Reference table PRO1UTYPEIDA type of usenvarchar10
22YIT_R1ROUIDA: Reference table ROU1UTYPEIDA type of usenvarchar10
23YIT_R1STNIDA: Reference table STN1UTYPEIDA type of usenvarchar10
24YIT_R1STPIDA: Reference table STP1UTYPEIDA type of usenvarchar10
25YIT_R1TPLIDA: Reference Table TPL1UTYPEIDA type of usenvarchar10
26YIT_R1WORIDA: Reference Table WOR1UTYPEIDA type of usenvarchar10
27YIT_R1__1IDA: Reference Table __1 Org. Units1UTYPEIDA type of usenvarchar10
28YIT_R1__2IDA: Reference Table __2 Application Customizing1UTYPEIDA type of usenvarchar10
29YIT_RDOCUIDA: Reference Table Documents1UTYPEIDA type of usenvarchar10
30YIT_REFIDA: Assignment Table - General1UTYPEIDA type of usenvarchar10
31YIT_REFMATIDA: Assignment Table MAT1UTYPEIDA type of usenvarchar10
32YIT_ROLEAreas of responsibility1UTYPEUsage type IDES Infobasenvarchar20
33YIT_ROLETRoles2UTYPEUsage type IDES Infobasenvarchar20
34YIT_RTCODEIDA: Reference Table for Transaction Codes1UTYPEIDA type of usenvarchar10
35YIT_STATUIDA: Status2UTYPEIDA type of usenvarchar10
36YIT_USERDATAIDA: User Data3UTYPEIDA type of usenvarchar10
37YIT_USETYPEInfobase usage types1UTYPEUsage type IDES Infobasenvarchar20
38YIT_USETYPELInfobase usage types2UTYPEUsage type IDES Infobasenvarchar20
TOPContract Accounts Receivable and Payable
39DFKKCMUSERAdditional User for Collections Management3UTYPEUser Types for Collections Managementnvarchar10
TOPDefense Forces and Public Security
40PA0800Personal Master Record Infotype 080030UTYPEUsage Typenvarchar10
TOPDenmark
41PA0074HR Master Record: Infotype 0074 (Leave Processing - DK)63UTYPELeave type, duplicate of SUPTYPE DKnvarchar40
42T5M6PDefault Values for Leave Accumulation44UTYPELeave type, duplicate of SUPTYPE DKnvarchar40
43T5V3CTypes of Vacation Allowance Calculation Units (DK/N)3UTYPEType of Entitlement to Vacation Allowance (DK/N)nvarchar20
44T5V3DTexts for T5V3C (DK/N)3UTYPEType of Entitlement to Vacation Allowance (DK/N)nvarchar20
TOPLogbook
45DIACL_LETYP_TLog Entry Type table4UTYPELog Entry Usage Typenvarchar10
46DIACL_LOG_ENTRYLogbook: log entry20UTYPELog Entry Usage Typenvarchar10