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

66 columns | Print definition?ERP 6.0  | GDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRPC_UPG_HRP1000Upgrade Back Up Data19GDATEDelimitation datenvarchar80
2P01E2_MELD_STELStAM: Status of Notifications for the Administrator6GDATEELStAM: Date of Creation/Changenvarchar80
3P01RBM_TRINZfA: Manage PI Receipt of Notification8GDATEPension Receipt Notification: Date of Status Changenvarchar80
4P01ZFA_TRINZfA: Manage PI Receipt of Notification8GDATEZfA: Creation/Change Datenvarchar80
5P05TPRNL_PR_OUTPension Return: PR - Output Data12GDATECreation/Change Datenvarchar80
6P05T_WCR_SIMUWCR Simulation40GDATECreation/Change Datenvarchar80
7P2B2_QTACCHCM Declustering B2 - Generating Absence Quotas7GDATEDate Generatednvarchar80
8P2B2_QTTRANSHCM Declustering B2 - Transfer Pool for Quota Deduction7GDATEDate Generatednvarchar80
9P2RX_VERSCPayroll Status Information9GDATERetro.acct.for gross part as ofnvarchar80
10T021DLine Layout Fast Entry: Administration6GDATEFast Entry: Date of Savingnvarchar80
11TBVZCO-PA report library (no longer used)7GDATEDate creatednvarchar80
12TGTBControl table for table converter12GDATEDatenvarchar80
13ZRP1000Infotype 1000 DB Table19GDATEDelimitation datenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
14DDPARTDD: Partitioned form of TBATG9GDATEDatenvarchar80
15TBATGControl table for batch table conversion8GDATEDatenvarchar80
TOPB2A Business to Administration
16PB2ASTATHR-B2A: Status Management7GDATECreation/Change Date of Data Recordnvarchar80
17PC01B2A_SVEMSTATSI-Specific Storage E-Mails for Procedure for Returning Data7GDATEDatenvarchar80
TOPCompany Pension Scheme Germany
18P01RBM_HISTNotification Status: Pension Receipt Notifications5GDATEPension Receipt Notification: Date of Status Changenvarchar80
19P01RBM_STATNotification Status: Pension Receipt Notifications11GDATEPension Receipt Notification: Date of Status Changenvarchar80
20P01RBM_STAT_RStatus of Confirmations (Pension Receipt Notifications)11GDATEPension Receipt Notification: Date of Status Changenvarchar80
21P01RBM_TRANSRBM: Status Table for Transfer6GDATEPension Receipt Notification: Date of Status Changenvarchar80
22P01VA_STATPEP: Status of Pension Equalization Payment6GDATEPEP: Date of Status Changenvarchar80
TOPConstruction Industry
23PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)40GDATELocal Datenvarchar80
TOPContract Accounts Receivable and Payable
24TFK021DScreen variants: Administration6GDATEScreen variants: Date savednvarchar80
25TFK021KSubscreen Management (SAP)9GDATEFast Entry: Date of Savingnvarchar80
26TFK021KCDetail Screen Structure for Document Display (Customer)8GDATEFast Entry: Date of Savingnvarchar80
TOPGermany
27T5D4THIF Receiving Office for the E-Mail Procedure6GDATECompany Number Valid Untilnvarchar80
28T5D4UFile Numbers for E-Mail Procedure with Health Ins. Funds8GDATEDatenvarchar80
TOPLocalization
29J_3RSEXTRACTDExctract details (obsolete)18GDATECargo customs declaration datenvarchar80
TOPOrganizational Management
30HRP1000Infotype 1000 DB Table19GDATEDelimitation datenvarchar80
TOPProfile Maintenance
31TPFHSPrototype: Profile header, administration data for profiles10GDATEData part last profile generationnvarchar80
32TPFHTProfile header, administration data for profiles in DB10GDATEData part last profile generationnvarchar80
TOPProfitability Analysis
33T239Report version table4GDATEDate creatednvarchar80
34TKEB1Report Management11GDATECreated Onnvarchar80
35TKES1Row/column structures11GDATEDate creatednvarchar80
TOPPublic Sector
36P01ZFA_NN_STATUSZfA: Status Management for ZKNN Notifications6GDATEZfA: Creation/Change Datenvarchar80
37P01ZFA_STATUSZfA: Status Management for Notifications7GDATEZfA: Creation/Change Datenvarchar80
38P01ZFA_TRANSZfA: Status Table for Transfer6GDATEZfA: Creation/Change Datenvarchar80
TOPReporting
39P05TPRNL_EE_ADMSPension Return: Admin of Status Income Relationship - Pers L15GDATECreation/Change Datenvarchar80
40P05TPRNL_LP_ADMSPension Return: Administration of Status - Legal Pers Level13GDATECreation/Change Datenvarchar80
41P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table11GDATECreation/Change Datenvarchar80
42P05T_A_EXTWage Return: Collective Employer Data - Wage Return10GDATECreation/Change Datenvarchar80
43P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand8GDATECreation/Change Datenvarchar80
44P05T_IV_ADM_STATWage Return: Income Relationship - Status Table13GDATECreation/Change Datenvarchar80
45P05T_JLO_STATAnnual Wage Return status7GDATECreation/Change Datenvarchar80
46P05T_RESPONSEWage Return: Table for Response Messages8GDATECreation/Change Datenvarchar80
47P05T_WCR_ER_INFOWCR Info on Employer Level18GDATECreation/Change Datenvarchar80
48P05T_WCR_STATWCR Status Table11GDATECreation/Change Datenvarchar80
TOPSales and Distribution
49J_1USEXTRACTDEXTRACTD18GDATEnvarchar80
TOPSets
50T800SFI-SL Set Table (before Release 4.0)24GDATEDate on which object was last changednvarchar80
TOPSocial Insurance
51P01SV_B2ATRNSStatus Table Transfer to Social Insurance Agency15GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
TOPStatements
52P01W_ADMIN_01HR: Data Module: Administration for Health Insurance Funds9GDATECreation/Change Date of Data Recordnvarchar80
TOPTax
53P01E2_HISTELStAM Procedure: Table for Status History6GDATEELStAM: Date of Creation/Changenvarchar80
54P01E2_LISTMTL_STELStAM: Status Table for Monthly Change Lists13GDATEELStAM: Date of Creation/Changenvarchar80
55P01E2_LIST_STStatus Table for ELStAM Procedure Change Lists7GDATEELStAM: Date of Creation/Changenvarchar80
56P01E2_STATUSELStAM Procedure: Status Table8GDATEELStAM: Date of Creation/Changenvarchar80
57P01E2_TRANS_STStatus Table Transfer for ELStAM Procedure9GDATEELStAM: Date of Creation/Changenvarchar80
58P01T_ADMIN_STATETStmt: Status Management Employment Tax Statements10GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
59P01T_ADMSTETStmt: Status Management - Employment Tax Statements (Old)10GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
60P01T_A_ADSETNotif.: Status Administration/Employment Tax Notification11GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
61P01T_A_EXTETNotif.: External Data10GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
62P01T_TRANSETStmt: Administration/Processing Data Tickets6GDATEEmployment Tax Statement: Created/Changed Onnvarchar80
TOPUpgrade - General
63TBATG_SAVSteuertabelle für Tabellenumsetzung in Batch8GDATEDatumnvarchar80
64TBATG_SHDSteuertabelle für Tabellenumsetzung in Batch8GDATEDatumnvarchar80
65TBATG_STDSteuertabelle für Tabellenumsetzung in Batch8GDATEDatumnvarchar80
66UPGTBATGControl Table for Creating Indexes in Advance8GDATEDatenvarchar80