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

51 columns | Print definition?ERP 6.0  | VERNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_LDBDAdministration information for LDB11VERNRVersion numbernvarchar60
2P01BN_BWXXData Record: Contribution Statement7VERNRVersion Numbernvarchar20
3P2RD_VBLPayroll Result: Supplementary Pension Public Sector38VERNRSupp. Insurance Numbernvarchar120
4PDPBSZVADM_RSPI Confirmation: Administration Table14VERNRSupp. Insurance Numbernvarchar120
TOPConstruction Industry
5PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
6PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
7PDBKBEConstr. Ind. Social Fund Procedure: BEMEL (PerNo) Records13VERNRVersion of Data Medium Exchangenvarchar20
8PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)17VERNRVersion of Data Medium Exchangenvarchar20
9PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
10PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
11PDBKRAConstruction Industry Social Fund Proced: RAMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
12PDBKURConstruction Industry Social Fund Proced: URMEL Data Records13VERNRVersion of Data Medium Exchangenvarchar20
TOPGermany
13PD3DSMEHR-DDU: Data Record Notfication8VERNRVersion Numbernvarchar20
TOPInvestment Programs
14IMPRInvestment Program Positions11VERNRPerson responsiblenvarchar80
15IMTPInvestment programs4VERNRPerson responsiblenvarchar80
TOPLogical DB, Selection Screens, Selection Variants
16LDBDAdministration information for LDB7VERNRVersion numbernvarchar60
17VARIABAP/4: Variant storage (similar to INDX)8VERNRABAP: Program version numbernvarchar60
TOPOperative Structures
18PROJProject definition14VERNRNumber of the responsible person (project manager)nvarchar80
19PRPSWBS (Work Breakdown Structure) Element Master Data12VERNRNumber of the responsible person (project manager)nvarchar80
20TCJ04Person in Responsible for Project2VERNRNumber of the responsible person (project manager)nvarchar80
TOPPatient Accounting
21NCIRIS-H: Insurance Relationships of a Case20VERNRIS-H: Patient Health Insurance Numbernvarchar200
22NPIRIS-H: Insurance Relationship Proposal Pool19VERNRIS-H: Patient Health Insurance Numbernvarchar200
TOPPatient Management
23NVVFIS-H: Case-Related Insurance Relationships31VERNRIS-H: Patient Health Insurance Numbernvarchar200
24NVVPIS-H: Patient-related insurance relationship8VERNRIS-H: Patient Health Insurance Numbernvarchar200
TOPProduction Orders
25COMPHOCM: Comparison result (header entry)12VERNRInternal counternvarchar40
TOPProject Summarization
26PSERBInheritance data, Project System7VERNRNumber of the responsible person (project manager)nvarchar80
TOPProject System
27PSHLPDB_HIER_TMPTable to store temporary hierarchy data28VERNRNumber of the responsible person (project manager)nvarchar80
28PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy26VERNRNumber of the responsible person (project manager)nvarchar80
TOPPublic Sector
29PA0051HR Master Record Infotype 0051 (VBL/SPI Data)49VERNRSupp. Insurance Numbernvarchar120
30PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure15VERNRSupp. Insurance Numbernvarchar120
TOPSAP Ambulatory Care Management
31NREDOMAIS-H: Table Renewable Documents - Header Data38VERNRIS-H: Patient Health Insurance Numbernvarchar200
TOPSimulation
32VSPROJ_CNVersion: Project definition15VERNRNumber of the responsible person (project manager)nvarchar80
33VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data13VERNRNumber of the responsible person (project manager)nvarchar80
TOPSocial Insurance
34P01BD_DSBDBusiness Data Maintenance Data Record6VERNRVersion Number of Data Recordnvarchar20
35P01BM_DSMEData Records Notification of PPO DEUEV Notifications6VERNRVersion Numbernvarchar20
36P01D3_DSKKDEUEV Confirmation: Data Record HI Fund Notification6VERNRVersion Numbernvarchar20
37P01D3_DSMEDEUEV Confirmation: Notification Data Record6VERNRVersion Numbernvarchar20
38P01DS_DSMEDEUEV Immediate Notification: Data Record Notification6VERNRVersion Numbernvarchar20
39P01EE_DSLWData Record Benefits of Compensation Benefits Notification6VERNRVersion Numbernvarchar20
40P01EL_DSVVData Record Assignment of Insurance No./Process No. ELENA6VERNRVersion Number of Data Recordnvarchar20
41P01EL_MVDSData Record Multifunctional Remun. Rec. (MVDS) ELENA6VERNRVersion Number of Data Recordnvarchar20
TOPStatements
42P01W_DSLWData Module: General Information10VERNRVersion Number of Data Recordnvarchar20
TOPStructures
43PSHLP_PROJWL_DBProject Definition ACL Worklist6VERNRNumber of the responsible person (project manager)nvarchar80
44PSHLP_WBSWL_DBWBS Elements ACL Worklist6VERNRNumber of the responsible person (project manager)nvarchar80
TOPTemplates
45PROJSStandard project definition14VERNRNumber of the responsible person (project manager)nvarchar80
46PRPSSStandard WBS Element (WBS element) - Master Data12VERNRNumber of the responsible person (project manager)nvarchar80
TOPTranslation Tools
47LXE_CSN_HDNotes14VERNRNumeric Character Field, Length 10nvarchar100
48LXE_CSN_TXLNotes10VERNRNumeric Character Field, Length 10nvarchar100
49LXE_CSN_TXSNotes9VERNRNumeric Character Field, Length 10nvarchar100
TOPWork Clearance Management
50WCAKWCM: Verification List (Header Data)3VERNRVerification Listnvarchar20
51WCAQWCM: Verification List (Items)3VERNRVerification Listnvarchar20