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

40 columns | Print definition?ERP 6.0  | ORGEH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee14ORGEHnvarchar80
2/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee15ORGEHnvarchar80
3/OTEI/DU_WD_DCTPDocument types customzing table4ORGEHOrganizational Unitnvarchar80
4CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)17ORGEHOrganizational Unitnvarchar80
5CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)17ORGEHOrganizational Unitnvarchar80
6P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay27ORGEHOrganizational Unitnvarchar80
7P2RX_WPBPPayroll Results: Work Center/Basic Pay25ORGEHOrganizational Unitnvarchar80
8PA3343HR Master Record: Infotype 334325ORGEHOrganizational Unitnvarchar80
9T5BPBS27XOrganisational units and Employee's activity Code (NACE)3ORGEHOrganizational Unitnvarchar80
10T5REGEmployee Information Log for Destruction of Data19ORGEHOrganizational Unitnvarchar80
11T5RPDPersonnel Data Deletion Log29ORGEHOrganizational Unitnvarchar80
12T77WWW_TEAADAdministrative Data45ORGEHOrganizational Unitnvarchar80
13T77WWW_TEAAD_BUAdministrative Data - Back Up45ORGEHOrganizational Unitnvarchar80
14ZSY_CRM_ORGRegion and Pernr configuration for CRM Syclo User3ORGEHOrganizational Unitnvarchar80
TOPBasic Functions
15T011ECalendar of person responsible for unit3ORGEHOrganization objectnvarchar140
TOPCompensation Management
16PA0395HR Master Record: Infotype 0395 (External Org.Assignment)27ORGEHOrganizational Unit Externalnvarchar400
TOPCross-Application Objects in HR
17HRP5581DB Table for Infotype 558119ORGEHOrganizational Unitnvarchar80
TOPItaly
18PA3214HR Master Record: Infotype 3214270ORGEHOrganizational Unitnvarchar80
TOPJapan
19PA0853HR Master Record: Infotype 085331ORGEHOrganizational Unit Externalnvarchar400
TOPLogbook
20ADFSH_PRTHEADFlight Scheduling: PRT Master records2ORGEHOrganizational Unitnvarchar80
21ADFSH_PRTHEAD_TFlight Scheduling: PRT Description3ORGEHOrganizational Unitnvarchar80
TOPMaintenance Processing
22/MRSS/C_PREMKDummy table for creating Org. Assgnmnt Search Help (No Data)9ORGEHOrganizational Unitnvarchar80
TOPPayroll
23PA3261Commission contracts H26ORGEHOrganizational Unitnvarchar80
24PA3265HR master record, infotype 326530ORGEHOrganizational Unitnvarchar80
25T5HPBS07Szervezeti egységek címe2ORGEHSzervezeti egységnvarchar80
26T5HPBS78Konvertáló tábla szervezeti egység és részterület között3ORGEHSzervezeti egységnvarchar80
TOPPayroll General Parts
27HRPY_WPBPHR-PAY: Transparent Table WPBP23ORGEHOrganizational Unitnvarchar80
TOPPersonnel Administration
28PA0001HR Master Record: Infotype 0001 (Org. Assignment)35ORGEHOrganizational Unitnvarchar80
29PA0030HR Master Record: Infotype 0030 (Powers of Attorney)25ORGEHOrganizational Unitnvarchar80
30PB0395HR Master Record: Infotype 0395 (External Org.Assignment)27ORGEHOrganizational Unit Externalnvarchar400
31T527XOrganizational Units3ORGEHOrganizational Unitnvarchar80
32T528BPositions18ORGEHOrganizational Unitnvarchar80
TOPPublic Sector
33PA0509HR-AU-PS: Master Data (Higher Duty Allowance)141ORGEHOrganizational Unitnvarchar80
34T5D8KAssignment of Exception Indicator to Organizational Unit2ORGEHOrganizational Unitnvarchar80
TOPRecruitment
35PB0001HR Master Record: Infotype 0001 (Org. Assignment)35ORGEHOrganizational Unitnvarchar80
36T750XVacancy10ORGEHReserve field/unused field 8 characters in lengthnvarchar80
TOPSouth Africa
37T5W8PStrategic Skills Priorities3ORGEHOrganizational Unitnvarchar80
TOPTaiwan
38T7TW2IReported data of Tax withdrawal report34ORGEHOrganizational Unitnvarchar80
TOPUSA
39T5U26WC: Assignment of WC to Organizational Units2ORGEHOrganizational Unitnvarchar80
40T5U27EEO/AAP: Organizational Unit attributes2ORGEHOrganizational Unitnvarchar80