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

24 columns | Print definition?ERP 6.0  | TIME_UNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes22TIME_UNITnvarchar30
2/IAM/D_NF_ROOT/IAM/NOTIFIER Root15TIME_UNITTime Unitnvarchar10
3/MRSS/C_CAR_UNITDay Unit Conversion table3TIME_UNITMapped SAP Standard Time Unitnvarchar30
4T5UPBSPOOL_TRANSSick Leave Donation - transaction history record10TIME_UNITTime/Measurement Unitnvarchar30
5T7SAPBS77Required Working Durations for Specific Actions7TIME_UNITTime Unitnvarchar10
TOPBasic Market Data
6/BA1/TF4_MATSTRPProperties of Maturity Structure6TIME_UNITTime Unitnvarchar10
7/BA1/TF4_REFRATEReference Interest Rates: Attributes7TIME_UNITTime Unitnvarchar10
TOPClinical System
8N1CYSRVTPLCORD: Cyclical Service Template18TIME_UNITCORD: Cyclical Service Template Unit Cycle Durationnvarchar30
TOPControlling
9DPR_RATES_CALCCustomizing: Mapping of Cost/Revenue Rates for Roles12TIME_UNITActivity Unitnvarchar30
TOPcProjects Accounting Integration
10DPR_RATES_MAPCustomizing: Validity/Details of Cost/Revenue Rates12TIME_UNITActivity Unit for Costs/Revenuesnvarchar30
TOPGeneral
11PA3893Time Account Status27TIME_UNITTime/Measurement Unitnvarchar30
TOPMaintenance Orders
12/MRSS/C_PLB_UNITTime unit for planning board profile4TIME_UNITInternal Time Unitnvarchar30
TOPManagement of Global Employees
13PA0710HR Master Record: Infotype 071027TIME_UNITTime/Measurement Unitnvarchar30
14T76MGE_ASIAssignment Types5TIME_UNITTime/Measurement Unitnvarchar30
TOPMonitoring
15ALPFAUTOREPORTList of PerfDB Report to Be Executed Automatically4TIME_UNITSingle-Character Indicatornvarchar10
TOPPersonnel Time Management
16PTARQ_DEDUCTIONDeduction Data for Attendances and Absences8TIME_UNITTime/Measurement Unitnvarchar30
TOPReporting
17P05TPRNL_EE_IRIPension Return: Income Relationship Indicators14TIME_UNITTime/Measurement Unitnvarchar30
18P05TPRNL_EE_PRPIPension Return: Income Rel - Pens/Ins Rel Period Indic PL18TIME_UNITTime/Measurement Unitnvarchar30
19P05TPRNL_LP_COLLPension Return: Collective Return - Legal Pers Level14TIME_UNITTime/Measurement Unitnvarchar30
TOPResources
20DPR_PARTProject Participants23TIME_UNITActivity Unit for Deviating Costs and Revenuesnvarchar30
TOPSAP NetWeaver Mobile - Use subcomponents
21MEALERTS_CONFConfiguration for Alerts monitored by CCMS8TIME_UNITDate Unit for Alerts monitored by CCMSnvarchar10
TOPStructure
22DPR_TASKTasks34TIME_UNITActivity Unit for Deviating Costs and Revenuesnvarchar30
23DPR_TIME_UNITSMaintenance of Application Time Units2TIME_UNITTime Unit for Execution Durationnvarchar30
TOPWorkforce Management Core
24WFD_TSTRM_PROJFRWFD: Time Stream Projection Frame2TIME_UNITWFD: Time Unit (Day, Month, Year)nvarchar10