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

48 columns | Print definition?ERP 6.0  | GTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P01E2_MELD_STELStAM: Status of Notifications for the Administrator7GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
2P01RBM_TRINZfA: Manage PI Receipt of Notification9GTIMEPension Receipt Notification: Time of Status Changenvarchar60
3P01ZFA_TRINZfA: Manage PI Receipt of Notification9GTIMEZfA: Time at Which the Data Record Was Created or Changednvarchar60
4P05TPRNL_PR_OUTPension Return: PR - Output Data13GTIMECreation/Change Hournvarchar60
5P05T_WCR_SIMUWCR Simulation41GTIMECreation/Change Hournvarchar60
6TGTBControl table for table converter13GTIMETimenvarchar60
TOPABAP Authorization and Role Management
7HRP1250DB table for infotype 125018GTIMEGeneration Timenvarchar60
TOPB2A Business to Administration
8PB2ASTATHR-B2A: Status Management8GTIMECreation/Change Time of Data Recordnvarchar60
9PC01B2A_SVEMSTATSI-Specific Storage E-Mails for Procedure for Returning Data8GTIMETimenvarchar60
TOPCompany Pension Scheme Germany
10P01RBM_HISTNotification Status: Pension Receipt Notifications6GTIMEPension Receipt Notification: Time of Status Changenvarchar60
11P01RBM_STATNotification Status: Pension Receipt Notifications12GTIMEPension Receipt Notification: Time of Status Changenvarchar60
12P01RBM_STAT_RStatus of Confirmations (Pension Receipt Notifications)12GTIMEPension Receipt Notification: Time of Status Changenvarchar60
13P01RBM_TRANSRBM: Status Table for Transfer7GTIMEPension Receipt Notification: Time of Status Changenvarchar60
14P01VA_STATPEP: Status of Pension Equalization Payment7GTIMEPEP: Time of Status Changenvarchar60
TOPConstruction Industry
15PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)41GTIMELocal Timenvarchar60
TOPGermany
16T5D4UFile Numbers for E-Mail Procedure with Health Ins. Funds9GTIMETimenvarchar60
TOPOrganizational Management
17HRP1016Infotype 1016 DB Table18GTIMEGeneration Timenvarchar60
18HRP1220DB Table for Infotype 1220 Activity Profile18GTIMEGeneration Timenvarchar60
19HRP1221DB Table for Infotype 1221 Excluded Activities18GTIMEGeneration Timenvarchar60
20HRPADD3Additional Data PADD36GTIMEGeneration Timenvarchar60
TOPProfile Maintenance
21TPFHSPrototype: Profile header, administration data for profiles11GTIMETime part last profile generationnvarchar60
22TPFHTProfile header, administration data for profiles in DB11GTIMETime part last profile generationnvarchar60
TOPPublic Sector
23P01ZFA_NN_STATUSZfA: Status Management for ZKNN Notifications7GTIMEZfA: Time at Which the Data Record Was Created or Changednvarchar60
24P01ZFA_STATUSZfA: Status Management for Notifications8GTIMEZfA: Time at Which the Data Record Was Created or Changednvarchar60
25P01ZFA_TRANSZfA: Status Table for Transfer7GTIMEZfA: Time at Which the Data Record Was Created or Changednvarchar60
TOPReporting
26P05TPRNL_EE_ADMSPension Return: Admin of Status Income Relationship - Pers L16GTIMECreation/Change Hournvarchar60
27P05TPRNL_LP_ADMSPension Return: Administration of Status - Legal Pers Level14GTIMECreation/Change Hournvarchar60
28P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table12GTIMECreation/Change Hournvarchar60
29P05T_A_EXTWage Return: Collective Employer Data - Wage Return11GTIMECreation/Change Hournvarchar60
30P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand9GTIMECreation/Change Hournvarchar60
31P05T_IV_ADM_STATWage Return: Income Relationship - Status Table14GTIMECreation/Change Hournvarchar60
32P05T_JLO_STATAnnual Wage Return status8GTIMECreation/Change Hournvarchar60
33P05T_RESPONSEWage Return: Table for Response Messages9GTIMECreation/Change Hournvarchar60
34P05T_WCR_ER_INFOWCR Info on Employer Level19GTIMECreation/Change Hournvarchar60
35P05T_WCR_STATWCR Status Table12GTIMECreation/Change Hournvarchar60
TOPSets
36T800SFI-SL Set Table (before Release 4.0)25GTIMELast changed atnvarchar60
TOPSocial Insurance
37P01SV_B2ATRNSStatus Table Transfer to Social Insurance Agency16GTIMECreation/Change Time of Data Recordnvarchar60
TOPStatements
38P01W_ADMIN_01HR: Data Module: Administration for Health Insurance Funds10GTIMECreation/Change Time of Data Recordnvarchar60
TOPTax
39P01E2_HISTELStAM Procedure: Table for Status History7GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
40P01E2_LISTMTL_STELStAM: Status Table for Monthly Change Lists14GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
41P01E2_LIST_STStatus Table for ELStAM Procedure Change Lists8GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
42P01E2_STATUSELStAM Procedure: Status Table9GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
43P01E2_TRANS_STStatus Table Transfer for ELStAM Procedure10GTIMEELStAM: Time of Creation/Change of Data Recordnvarchar60
44P01T_ADMIN_STATETStmt: Status Management Employment Tax Statements11GTIMECreation/Change Time of Data Recordnvarchar60
45P01T_ADMSTETStmt: Status Management - Employment Tax Statements (Old)11GTIMECreation/Change Time of Data Recordnvarchar60
46P01T_A_ADSETNotif.: Status Administration/Employment Tax Notification12GTIMECreation/Change Time of Data Recordnvarchar60
47P01T_A_EXTETNotif.: External Data11GTIMECreation/Change Time of Data Recordnvarchar60
48P01T_TRANSETStmt: Administration/Processing Data Tickets7GTIMECreation/Change Time of Data Recordnvarchar60