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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

50 columns | Print definition?ERP 6.0  | NACHN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/OCR_TSTGStaging table for HDCC download data4NACHNLast Namenvarchar400
2P2RB_NAMEPayroll Results: Name of Employee4NACHNLast Namenvarchar400
3P2RD_NAMEPayroll Results: Name of Employee4NACHNLast Namenvarchar400
4P2RK_NAMEName of Employee4NACHNLast Namenvarchar400
5P2RN_NNAMPersonal Data4NACHNLast Namenvarchar400
6P2RU_NAMEName of Employee5NACHNLast Namenvarchar400
7PAPBSGB_SWF_STAFSWF: Staff Details11NACHNLast Namenvarchar400
8PB0290HR Master Record: Infotype 0290 - Identity card CIS57NACHNLast Namenvarchar400
9HRP1702DB Table for Infotype 170218NACHNLast Namenvarchar400
TOPAustria
10T5A9ACreated Statement of Employment (A)10NACHNLast Namenvarchar400
11T5AB1Sick Leave Certificate: ELDA Record KB5NACHNLast Namenvarchar400
TOPBelgium
12T5BS3Employee information except reductions ( level 3 )16NACHNLast Namenvarchar400
TOPBenefit Integration
13T7USBENH1For saving records of issued HIPAA certificates9NACHNLast Namenvarchar400
14T7USBENH2For savings records of on-demand printing of HIPAA certs.9NACHNLast Namenvarchar400
TOPCapacity and Resource Planning
15/MRSS/SADRPXIS-Zusatzstruktur zu den SADR*-Strukturen5NACHNLast namenvarchar300
TOPCompany Pension Scheme Germany
16P01CVHActuarial CPS Header Records13NACHNLast Namenvarchar400
17PA0746HR Master Record for Infotype 074629NACHNLast Name of Investornvarchar350
TOPConstruction Equipment Management
18J_3GBELKDocument File - Header Data45NACHNLast Namenvarchar250
19J_3GBELPDocument Data - Item Data47NACHNLast Namenvarchar250
TOPConstruction Industry
20PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records21NACHNLast Namenvarchar300
21PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records28NACHNLast Namenvarchar300
22PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records28NACHNLast Namenvarchar300
23PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records29NACHNLast Namenvarchar300
24PDBKRAConstruction Industry Social Fund Proced: RAMEL Data Records22NACHNLast Namenvarchar300
25PDBKURConstruction Industry Social Fund Proced: URMEL Data Records36NACHNLast Namenvarchar300
TOPCross-Application Objects in HR
26HRP5582DB Table for Infotype 558222NACHNLast Namenvarchar400
TOPPayroll
27T5TA1External transfers7NACHNLast Namenvarchar250
28T5TA2Medium for health insurance11NACHNLast Namenvarchar250
29T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP20NACHNLast Namenvarchar400
30T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP19NACHNLast Namenvarchar400
31T7ROG1EE register - ER history18NACHNLast Namenvarchar400
32T7ROG2EE register - EE history10NACHNLast Namenvarchar400
33T7ROG5EE register - ER history22NACHNLast Namenvarchar250
34T7ROG6EE register - EE history12NACHNLast Namenvarchar400
35T7SIA8Data for VIRVDC7NACHNLast Namenvarchar400
36T7SKA1External transfers7NACHNLast Namenvarchar250
TOPPersonnel Administration
37PA0002HR Master Record: Infotype 0002 (Personal Data)25NACHNLast Namenvarchar400
38T7GR4APDIKA - A.P.D.16NACHNLast Namenvarchar400
TOPPersonnel Management
39/BKC/S21_ANONSol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON3NACHNNachnamenvarchar250
TOPPublic Sector
40P01ZFA_NN_DATAZfA: Notifications Not Assigned17NACHNInvestor's Last Namenvarchar400
TOPPublic sector Sweden
41T5SA0_CEAlecta13NACHNLast Namenvarchar400
42T5SK0_CEKPA events9NACHNLast Namenvarchar400
43T5SS3_CEPA03 pernr6NACHNLast Namenvarchar400
TOPRecruitment
44PB0002HR Master Record: Infotype 0002 (Personal Data)25NACHNLast Namenvarchar400
TOPReporting
45P05TPRNL_EE_PDPension Return: Personal Data - Pers Level13NACHNLast Namenvarchar250
TOPRussia
46PA0290HR Master Record: Infotype 0290 - Identity card CIS57NACHNLast Namenvarchar400
TOPSweden
47T5SPPHR-SE: Information needed to be reported to Alecta11NACHNLast Namenvarchar400
TOPTaiwan
48T7TW2IReported data of Tax withdrawal report18NACHNLast Namenvarchar400
TOPTax
49P01T_LSTETStmt: General Employment Tax Data16NACHNETStmt: Last Namenvarchar300
TOPUnited Kingdom
50PAGB_ASHEASHE Return Data10NACHNLast Namenvarchar400