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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

89 columns | Print definition?ERP 6.0  | TITEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RB_NAMEPayroll Results: Name of Employee5TITELTitlenvarchar150
2P2RD_NAMEPayroll Results: Name of Employee5TITELTitlenvarchar150
3P2RN_NNAMPersonal Data8TITELTitlenvarchar150
4PDPBSZVNAM_RSPI Confirmation: Name (Record Type 80)8TITELTitle, ZVE-PBSnvarchar200
5T066Screen Selection, Invoice Verification10TITELTitle for CUA interfacenvarchar30
6T158ITransaction Control: Physical Inventory7TITELTitle for CUA interfacenvarchar30
7TDA10Alloc. of trans.codes to ok-codes and screen overview6TITEL3-Byte fieldnvarchar30
8TDOCUControl Table for the Document Manager5TITELDocument title is stored in documentation tablesnvarchar10
9TRSLTIndexing Results Display2TITELModule Titlenvarchar600
10TSHCLList of Shell Classes5TITELTitle in dialog boxnvarchar500
11YIT_EXAMIDA: Examples5TITELInfobase: Titlenvarchar800
12YIT_INFOBASE_LIDES Infobase language-dependent data4TITELInfobase: Titlenvarchar800
13YIT_PROCIDA: Processes in IDES9TITELInfobase: Titlenvarchar800
14YIT_TRAIIDA: Training Courses5TITELInfobase: Titlenvarchar800
15YIT_TREE_PROCESSIDES Infobase: IDES Process Hierarchy8TITELInfobase: Titlenvarchar800
16HRP1702DB Table for Infotype 170223TITELTitlenvarchar150
17T7PIQ_GB_TITLEUCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre5TITELName affixnvarchar150
TOPAdvertising Management
18JJTAMIS-M/AM: Media Contact Person18TITELIS-M: Titlenvarchar150
19TJJAMTLIS-M/AM: Official Title2TITELIS-M: Official titlenvarchar20
20TJJAMTLTIS-M/AM: Official Title of Contact Person, Texts3TITELIS-M: Official titlenvarchar20
TOPALE Integration Technology
21EDIPOITable for describing Internet ports7TITELTitle of Document in Business Workplacenvarchar500
TOPBasic Data
22NGPAIS-H: Business Partners13TITELIS-H: Titlenvarchar150
TOPCapacity Leveling
23TCY50TChart sequence: Title5TITELChart headingnvarchar700
TOPClinical System
24N1DOKEMPFIS-H*MED: Recipient of the Documents13TITELIS-H: Titlenvarchar150
25N1LSTEAMIS-H*MED: Tasks/Employees for a Service21TITELIS-H: Titlenvarchar150
26N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle10TITELIS-H: Basliknvarchar150
27N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle11TITELIS-H: Basliknvarchar150
28N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal11TITELIS-H: Basliknvarchar150
29N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient11TITELIS-H: Titlenvarchar150
30N2MV_DISREQDispatch Request Data Table15TITELDispatch Control: Titlenvarchar600
31N2MV_VSDATRecipient Data Table14TITELDispatch Control: Titlenvarchar600
TOPCompany Pension Scheme Germany
32P01RBM_IM01Notification Data IM01 Pension Receipt Notif. Answer Tax ID10TITELTitlenvarchar200
33P01RBM_MI01Notification Data MI01 Pension Receipt Notif. Query Tax ID22TITELTitlenvarchar200
34P01RBM_MI01RConfirmation MI01 Pension Receipt Notification Query Tax ID22TITELTitlenvarchar200
35P01RBM_MZ01Reporting Data MZ01 Pension Receipt Notification27TITELTitlenvarchar200
36P01RBM_MZ01RConfirmation MZ01 Pension Receipt Notification27TITELTitlenvarchar200
37PA0746HR Master Record for Infotype 074653TITELTitlenvarchar150
TOPConstruction Equipment Management
38/SAPCEM/PT06TDefinition of Charts - Texts4TITELChart headingnvarchar700
TOPCross-Application Objects in HR
39HRP5582DB Table for Infotype 558226TITELTitlenvarchar150
TOPGermany
40PD3DBNAHR-DDU: Name Data Module9TITELTitlenvarchar200
41T5D4ODEUEV Permissible Name Extensions2TITELDEUEV Name Affixnvarchar150
TOPManagement of Internal Controls
42FOPCTASKTMIC Task - Text Table5TITELTitel/Short Namenvarchar420
TOPMaster Data
43EFISELField Selection Control for Address Data2TITELForm of address textnvarchar10
44JGTSADRIS-M: Extended Address Management19TITELIS-M: Titlenvarchar150
TOPOrganizational Management
45T77S4Menu: Dynamic Menu Texts3TITELText IDnvarchar40
TOPPatient Management
46NPAPIS-H: Provisional Patient Master Data11TITELIS-H: Titlenvarchar150
47NPATIS-H: Patient Master Data (General)9TITELIS-H: Titlenvarchar150
48NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)19TITELIS-H: Titlenvarchar150
TOPPayroll
49T5HB3EMMA Titulus kódok2TITELNévkiegészítésnvarchar150
50T5TELDP2004TRANSRecords ELDP for transfer from external system to SAP19TITELTitlenvarchar150
51T5TREGTRANSHRCZ - table for transfer items of Insured Register to SAP22TITELTitlenvarchar150
TOPPeriodical Sales and Distribution
52JKTWBZINIS-M/SD: Clipboard for WBZ Records for Processing54TITELIS-M/SD: WBZ, Titlenvarchar150
53JKTWBZOUTIS-M/SD: Clipboard for Processed WBZ Records42TITELIS-M/SD: WBZ, Titlenvarchar150
54JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet9TITELIS-M: Titlenvarchar150
55JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data27TITELIS-M: Titlenvarchar150
56JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data27TITELIS-M: Titlenvarchar150
57JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet8TITELIS-M: Titlenvarchar150
58TJ535NUName Affixes3TITELName affixnvarchar150
TOPPersonnel Administration
59PA0002HR Master Record: Infotype 0002 (Personal Data)30TITELTitlenvarchar150
60PA0021HR Master Record: Infotype 0021 (Family)61TITELTitlenvarchar150
TOPPersonnel Management
61PA0563HR Master Record: Infotype 056363TITELTitlenvarchar150
TOPProcess Controls
62GRPCTASKTObsolete: PC Task - Text Table5TITELTitel/Short Namenvarchar420
TOPProcess Management
63TCB_PIE1PI Assistant: Assigning Screen ID to Calling Function Module7TITELInternal ABAP/4 text numbernvarchar80
TOPProduction Orders
64COCF_CU_SR_REPTText Table for COCF_CU_SR_REP5TITELText Fieldnvarchar500
65TCO05CUA status depending on panel, trans. type, funct. type etc.10TITELKey for CUA screen titlesnvarchar200
TOPPublic Sector
66P01ZFA_NN_DATAZfA: Notifications Not Assigned37TITELTitlenvarchar150
67PDPBSZVNAMName (Record Type 80), ZVE-PBS16TITELTitle, ZVE-PBSnvarchar200
TOPRecruitment
68PB0002HR Master Record: Infotype 0002 (Personal Data)30TITELTitlenvarchar150
TOPReuse Services for Country Development
69T535NName affixes3TITELName affixnvarchar150
TOPRouting
70TC01CUA status table10TITELGUI title numbernvarchar200
TOPSAP Business Partner
71TBZ9DBDT Differentiation Type Elements: Texts3TITELDescriptionnvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
72NPSPATIS-H: Pseudonymized Patient Master Data (General)9TITELPseudonymized Titlenvarchar150
73NVVNIS-H: Guarantors12TITELIS-H: Titlenvarchar150
TOPSAP Media
74J_1SFSPEDIS-M/SD CH/V: Addresses, Orders for Third-Party Shipping11TITELIS-M: Titlenvarchar150
TOPScreen Sequence Control
75T185TScreen Sequence Control: Dialogs: Texts4TITELTitle of POPUP's for the POPUP_TO_CONFIRM function modulenvarchar350
TOPSocial Insurance
76P01BM_DBNAData Modules Name of PPO DEUEV Notifications7TITELTitlenvarchar200
77P01D3_DBNADEUV Confirmation: Data Module - Name7TITELTitlenvarchar200
78P01DS_DBNAData Module Name of DEUEV Immediate Notifications7TITELTitlenvarchar200
79P01EE_DBNAData Module DBNA Name7TITELTitlenvarchar200
80P01EL_DBNAData Module Name of ELENA Notifications7TITELTitlenvarchar200
TOPStatements
81P01W_DBNAData Module: Name11TITELTitlenvarchar200
TOPTax
82P01T_LSTETStmt: General Employment Tax Data20TITELETStmt: Titlenvarchar200
TOPTraining and Event Management
83HRP1034Infotype 1034 DB table19TITELTitlenvarchar150
TOPTraining Management
84LSO_COL_PROF_TXTProfiles / Titles4TITELProfile Titlenvarchar400
85LSO_COL_TMPL_TXTTemplates / Titles4TITELCollaboration Room Template Titlenvarchar400
TOPWarehouse Management
86T342TAssignment of Title Bar to PF Status8TITELWindow Title Numbernvarchar200
TOPWaste Management
87EPROP_ADRFLD_SELField Selection Control for Address Screen of Property2TITELForm of address textnvarchar10
88EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object2TITELForm of address textnvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
89EUINFOLIRepository Infosystem: Save background lists8TITELSpool Descriptionnvarchar680