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

41 columns | Print definition?ERP 6.0  | ICTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2AR_ARCIMPTax results13ICTYPDocument typenvarchar20
2P2AR_ARDIMPTax deduction results13ICTYPDocument typenvarchar20
3P2AR_AROIMPOther employers5ICTYPDocument typenvarchar20
4P2BR_BRDEPDependents: master data13ICTYPType of identification (IC type)nvarchar20
5P2CO_COSSAPC2CO_SSA19ICTYPIdentification typenvarchar20
6P2RR_NRICPayroll Singapore: NRIC18ICTYPType of identification (IC type)nvarchar20
7PA3318HR Master Record: Infotype 331824ICTYPType of identification (IC type)nvarchar20
8T7AE06Dependant Document Types (UAE)2ICTYPType of identification (IC type)nvarchar20
9T7AE15Default in Country of Issue for Doc. Type It 01852ICTYPType of identification (IC type)nvarchar20
10T7AE25Unique Personal ID UAE2ICTYPType of identification (IC type)nvarchar20
11T7OMDTDependant Document Types for IT 0021(OM)2ICTYPType of identification (IC type)nvarchar20
12T7QA07Dependant Document Types (QA)2ICTYPType of identification (IC type)nvarchar20
13T7QA09Default in Country of Issue for Documents Infotype 0185 (QA)2ICTYPType of identification (IC type)nvarchar20
14T7QA64Request Type for the Application of Resident Permit3ICTYPType of identification (IC type)nvarchar20
15T7QA72Document Renewal Provision2ICTYPType of identification (IC type)nvarchar20
16T7QA72TDocument Renewal Provision Text3ICTYPType of identification (IC type)nvarchar20
17T7QA82Unique Personal ID QA2ICTYPType of identification (IC type)nvarchar20
18T7SA24Default in Country of Issue for Doc. Type It 01852ICTYPType of identification (IC type)nvarchar20
19T7SA39Unique Personal ID SA2ICTYPType of identification (IC type)nvarchar20
TOPArgentina
20PA0390Income Tax: Deductions31ICTYPDocument typenvarchar20
21PA0391Income Tax: Information on other employers24ICTYPDocument typenvarchar20
22PA0392Social Security: General data39ICTYPDocument typenvarchar20
23PA0394Family data: Additional information34ICTYPDocument typenvarchar20
24T7AR82Assignment of ANSeS document type2ICTYPType of identification (IC type)nvarchar20
TOPBrazil
25PA0397Infotype 0021 Family42ICTYPType of ID documentnvarchar20
TOPContract Accounts Receivable and Payable
26TFK050ICategories of Information to Collection Agency2ICTYPType of Information to Collection Agencynvarchar20
TOPNon Profit Organizations
27PA0964HR Master Record: Infotype 096424ICTYPType of Identification Numbernvarchar40
TOPPayroll
28PA0770Personnel master data: Info type 077024ICTYPType of identification (IC type)nvarchar20
29PB0770Personnel master data: Info type 077024ICTYPType of identification (IC type)nvarchar20
TOPPersonnel Administration
30PA0517HR Master Record: Infotype 051740ICTYPType of identification (IC type)nvarchar20
31PA0839HR master record for infotypes 083924ICTYPType of identification (IC type)nvarchar20
32PB0839Candidates data for infotype 0839 (sample)24ICTYPType of identification (IC type)nvarchar20
33T7CO85Identification type3ICTYPType of identification (IC type)nvarchar20
34T7COT2Payroll external results transfer: COSSA19ICTYPIdentification typenvarchar20
TOPPublic Sector
35PA0502Letter of appointment51ICTYPType of identification (IC type)nvarchar20
36PB0502Letter of appointment51ICTYPType of identification (IC type)nvarchar20
TOPSingapore
37PA0185HR Master Record: Infotype 0185 [Identification] (SG)24ICTYPType of identification (IC type)nvarchar20
38PB0185HR Master Record: Infotype 0185 (Personal ID)24ICTYPType of identification (IC type)nvarchar20
39T5R05Types of Identification3ICTYPType of identification (IC type)nvarchar20
40T5R05_ESSEXESS:Deactivation of subtypes for Personal IDs (IT0185)3ICTYPType of identification (IC type)nvarchar20
41T5R06Types of Identification - Texts4ICTYPType of identification (IC type)nvarchar20