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  | VORNA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/OCR_TSTGStaging table for HDCC download data6VORNAFirst Namenvarchar400
2P2RB_NAMEPayroll Results: Name of Employee6VORNAFirst Namenvarchar400
3P2RD_NAMEPayroll Results: Name of Employee6VORNAFirst Namenvarchar400
4P2RK_NAMEName of Employee5VORNAFirst Namenvarchar400
5P2RN_NNAMPersonal Data7VORNAFirst Namenvarchar400
6P2RU_NAMEName of Employee6VORNAFirst Namenvarchar400
7PAPBSGB_SWF_STAFSWF: Staff Details12VORNAFirst Namenvarchar400
8PB0290HR Master Record: Infotype 0290 - Identity card CIS58VORNAFirst Namenvarchar400
9PDPBSZVNAM_RSPI Confirmation: Name (Record Type 80)7VORNAFirst Namenvarchar300
10HRP1702DB Table for Infotype 170219VORNAFirst Namenvarchar400
TOPAustria
11T5A9ACreated Statement of Employment (A)11VORNAFirst Namenvarchar400
12T5AB1Sick Leave Certificate: ELDA Record KB6VORNAFirst Namenvarchar400
TOPBelgium
13T5BS3Employee information except reductions ( level 3 )17VORNAFirst Namenvarchar400
TOPBenefit Integration
14T7USBENH1For saving records of issued HIPAA certificates8VORNAFirst Namenvarchar400
15T7USBENH2For savings records of on-demand printing of HIPAA certs.8VORNAFirst Namenvarchar400
TOPCapacity and Resource Planning
16/MRSS/SADRPXIS-Zusatzstruktur zu den SADR*-Strukturen6VORNAFirst Namenvarchar250
TOPCompany Pension Scheme Germany
17P01CVHActuarial CPS Header Records14VORNAFirst Namenvarchar400
18PA0746HR Master Record for Infotype 074630VORNAFirst Name of Investornvarchar350
TOPConstruction Industry
19PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records22VORNAFirst Namenvarchar300
20PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records29VORNAFirst Namenvarchar300
21PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records29VORNAFirst Namenvarchar300
22PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records30VORNAFirst Namenvarchar300
23PDBKRAConstruction Industry Social Fund Proced: RAMEL Data Records23VORNAFirst Namenvarchar300
24PDBKURConstruction Industry Social Fund Proced: URMEL Data Records37VORNAFirst Namenvarchar300
TOPCross-Application Objects in HR
25HRP5582DB Table for Infotype 558221VORNAFirst Namenvarchar400
TOPPayroll
26T5TA1External transfers8VORNAFirst Namenvarchar250
27T5TA2Medium for health insurance10VORNAFirst Namenvarchar250
28T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP18VORNAFirst Namenvarchar400
29T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP21VORNAFirst Namenvarchar400
30T7ROG1EE register - ER history19VORNAFirst Namenvarchar400
31T7ROG2EE register - EE history11VORNAFirst Namenvarchar400
32T7ROG5EE register - ER history23VORNAFirst Namenvarchar250
33T7ROG6EE register - EE history13VORNAFirst Namenvarchar400
34T7SIA8Data for VIRVDC8VORNAFirst Namenvarchar400
35T7SKA1External transfers8VORNAFirst Namenvarchar250
TOPPersonnel Administration
36PA0002HR Master Record: Infotype 0002 (Personal Data)28VORNAFirst Namenvarchar400
37T7GR4APDIKA - A.P.D.17VORNAFirst Namenvarchar400
TOPPersonnel Management
38/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON2VORNAVornamenvarchar250
TOPPublic Sector
39P01ZFA_NN_DATAZfA: Notifications Not Assigned18VORNAFirst Name of Investornvarchar400
40PDPBSZVNAMName (Record Type 80), ZVE-PBS15VORNAFirst Namenvarchar300
TOPPublic sector Sweden
41T5SA0_CEAlecta14VORNAFirst Namenvarchar400
42T5SK0_CEKPA events10VORNAFirst Namenvarchar400
43T5SS3_CEPA03 pernr5VORNAFirst Namenvarchar400
TOPRecruitment
44PB0002HR Master Record: Infotype 0002 (Personal Data)28VORNAFirst Namenvarchar400
TOPRussia
45PA0290HR Master Record: Infotype 0290 - Identity card CIS58VORNAFirst Namenvarchar400
TOPSweden
46T5SPPHR-SE: Information needed to be reported to Alecta12VORNAFirst Namenvarchar400
TOPTaiwan
47T7TW2IReported data of Tax withdrawal report19VORNAFirst Namenvarchar400
TOPTax
48P01T_LSTETStmt: General Employment Tax Data17VORNAETStmt: First Namenvarchar300
TOPVenezuela
49T7VE02Additional Data on Company (Time-dependent)9VORNASurname of Legal Person of the Companynvarchar400