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

33 columns | Print definition?ERP 6.0  | LAST_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_CONTACMaster Project contact person10LAST_NAMENamenvarchar400
2/OPT/VT_USERUser Details5LAST_NAMELast namenvarchar400
3ACMTST_DB_EMPLACMTST: Employee (DB-Table)5LAST_NAMEnvarchar400
4DIAN_A_1001_08Cached Data of DIAN Format 1001 version 089LAST_NAMELast Namenvarchar400
5DIAN_A_1003_07Cached Data of DIAN Format 1003 version 079LAST_NAMELast Namenvarchar400
6DIAN_A_1005_07Cached Data of DIAN Format 1005 version 078LAST_NAMELast Namenvarchar400
7DIAN_A_1006_07Cached Data of DIAN Format 1006 version 078LAST_NAMELast Namenvarchar400
8DIAN_A_1007_08Cached Data of DIAN Format 1007 version 089LAST_NAMELast Namenvarchar400
9DIAN_A_1008_07Cached Data of DIAN Format 1003 version 078LAST_NAMELast Namenvarchar400
10DIAN_A_1009_07Cached Data of DIAN Format 1009 version 078LAST_NAMELast Namenvarchar400
11DIAN_A_TFORMATTesting table for Cached Data of DIAN Formats10LAST_NAMELast Namenvarchar400
12GRACUSERUser Table5LAST_NAMEUser namenvarchar500
13J_3RF_TP_MAINMain Information of Notification20LAST_NAMELast namenvarchar600
14T5FADRAddresses for legal reporting5LAST_NAMELast namenvarchar800
15T7UNPF_FI_STFHDStaff Member Header Table6LAST_NAMELast name. Left justified.nvarchar200
16T7UNPF_HR_CHILDChild details6LAST_NAMELast name. Left justified.nvarchar200
17T7UNPF_HR_DEPNDDependent details6LAST_NAMELast name. Left justified.nvarchar200
18T7UNPF_HR_REMSGResponse Message9LAST_NAMELast name. Left justified.nvarchar200
19T7UNPF_HR_STAFFStaff Member Table8LAST_NAMELast name. Left justified.nvarchar200
20T7UNPF_HR_STFHDStaff Member Header Table8LAST_NAMELast name. Left justified.nvarchar200
TOPCross-Application Components
21SEMPLOYESEmployee Table: Starting Version5LAST_NAMELast name of employeenvarchar200
22SEMPLOYES_APPEmployees: Enhancement by Append (4)5LAST_NAMELast name of employeenvarchar200
23SEMPLOYES_RBEmployees: Enhancement by No. of Agency (2)5LAST_NAMELast name of employeenvarchar200
24SEMPLOYES_TIEmployees: Enhancement by Time Field in Include (3)5LAST_NAMELast name of employeenvarchar200
25SEMPLOY_CSHEmployee table: Collective Search Help5LAST_NAMELast name of employeenvarchar200
26SEMPLOY_SEARCHEmployee Table: Search Help Attachment to Table5LAST_NAMELast name of employeenvarchar200
TOPIncident Recording
27EHHSSD_INC_PINITIncident - Person Initial Recording10LAST_NAMELast Name of Involved Personnvarchar400
TOPNetWeaver Demonstration
28SNWD_BPA_CONTACTEPM: Business Partner Contacts7LAST_NAMEEPM: Last Namenvarchar400
29SNWD_CONTACTObsolete - Do Not Use7LAST_NAMEEPM: Last Namenvarchar400
30SNWD_EMPLOYEEObsolete - Do Not Use7LAST_NAMEEPM: Last Namenvarchar400
31SNWD_EMPLOYEESEPM: Employee Data7LAST_NAMEEPM: Last Namenvarchar400
TOPSAP NetWeaver Mobile - Use subcomponents
32MEREP_PERSONPerson (Sample Application)4LAST_NAMELast Name (Sample Application)nvarchar400
TOPTransportation and Distribution
33OIGDTD Driver5LAST_NAMEDriver's last namenvarchar200