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

49 columns | Print definition?ERP 6.0  | GESCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000285000PSA for 0PERSON_ATTR T90CLNT090 Person8GESCHnvarchar10
2P2RB_PERMPersonal Features4GESCHGender Keynvarchar10
3P2RD_PERMPayroll Results: Personal Features4GESCHGender Keynvarchar10
4P2RK_PERMPersonal Characteristics4GESCHGender Keynvarchar10
5P2RN_NNAMPersonal Data15GESCHGender Keynvarchar10
6P2RU_PERMPersonal Characteristics5GESCHGender Keynvarchar10
7PAPBSGB_SWF_STAFSWF: Staff Details15GESCHGender Keynvarchar10
8PB0290HR Master Record: Infotype 0290 - Identity card CIS60GESCHGender Keynvarchar10
9T7AEPBS66Absence Type Limit Condition13GESCHGender Keynvarchar10
10T7HK11General information of the IR56 forms11GESCHSingle-Character Indicatornvarchar10
11T7KW08Absence Type Limit Condition7GESCHGender Keynvarchar10
12T7OM33Absence Type Limit Condition7GESCHGendernvarchar10
13T7QAPBS25Absence Type Limit Condition7GESCHGender Keynvarchar10
14T7RUMATSTOKIN: Marital Status Designators5GESCHGender Keynvarchar10
15T7RU_MILAGELAge Limit for Military Administration (RU)5GESCHGender Keynvarchar10
16T7SAPBS30Absence Quota Generation Refinement8GESCHGender Keynvarchar10
17T7SAPBS66Absence Type Limit Condition7GESCHGender Keynvarchar10
18T7TRK06Retirement account table2GESCHGender Keynvarchar10
19HRP1702DB Table for Infotype 170237GESCHGender Keynvarchar10
TOPAustria
20T5A1WSI Age Levels2GESCHGender Keynvarchar10
21T5A71L16 Consolidation File41GESCHGender Keynvarchar10
22T5A74E18 Consolidation File41GESCHGender Keynvarchar10
23T5A9ACreated Statement of Employment (A)21GESCHGender Keynvarchar10
TOPBelgium
24T5BS3Employee information except reductions ( level 3 )18GESCHGender Keynvarchar10
TOPBrazil
25T7BRDEDependents eligibility for income tax2GESCHGender Keynvarchar10
TOPCompany Pension Scheme Germany
26P01CVHActuarial CPS Header Records28GESCHGender Keynvarchar10
27PA0746HR Master Record for Infotype 074651GESCHGender of Applicantnvarchar10
TOPConstruction Industry
28PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records29GESCHGender Keynvarchar10
TOPCross-Application Objects in HR
29HRP5582DB Table for Infotype 558235GESCHGender Keynvarchar10
TOPMaster Data
30JGTGPNRIS-M: Central Business Partner Table24GESCHIS-M: Gender Keynvarchar10
31TJG43IS-M: Form-of-Address Key3GESCHGender Keynvarchar10
TOPPayroll
32T5H4OReported "closed incapacities to work"11GESCHGender Keynvarchar10
TOPPersonnel Administration
33PA0002HR Master Record: Infotype 0002 (Personal Data)39GESCHGender Keynvarchar10
34T522Title Keys4GESCHGender Keynvarchar10
35T522GTitle Keys3GESCHGender Keynvarchar10
36T528BPositions14GESCHGender Keynvarchar10
TOPPersonnel Time Management
37T554MAbsences for Maternity Protection: Rule Table19GESCHGender Keynvarchar10
TOPPublic Sector
38P01ZFA_NN_DATAZfA: Notifications Not Assigned33GESCHGender Keynvarchar10
39PA0619HR-AU-PS : Equity and Diversity24GESCHGender for Equity and Diversitynvarchar10
40PAPBSMXSARCSAR current result27GESCHGender keynvarchar10
41PAPBSMXSARPSAR previous result27GESCHGender keynvarchar10
TOPRecruitment
42PB0002HR Master Record: Infotype 0002 (Personal Data)39GESCHGender Keynvarchar10
TOPReporting
43P05TPRNL_EE_PDPension Return: Personal Data - Pers Level18GESCHGender Keynvarchar10
TOPRussia
44PA0290HR Master Record: Infotype 0290 - Identity card CIS60GESCHGender Keynvarchar10
45T7RUP2Grouping of Employees for Pension Insurance/Accumula3GESCHGender Keynvarchar10
TOPSwitzerland
46T5C65Derivation of Relationship Between Child and Bonus Recipient4GESCHGender Keynvarchar10
47T5CR0HR-CH: Rules for Determining the Pension Start4GESCHGender Keynvarchar10
TOPTax
48P01T_LSTETStmt: General Employment Tax Data15GESCHETStmt: Gendernvarchar10
TOPUnited Kingdom
49PAGB_ASHEASHE Return Data12GESCHGender Keynvarchar10