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

63 columns | Print definition?ERP 6.0  | TIMETO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/SQLTIMSTSQL Monitor History: Timestamps - Mapping to time frame5TIMETOStart time of data collectionnvarchar60
2DBERCHECondition Data8TIMETOEnd Timenvarchar60
3ECONDIIS-U: Conditions8TIMETOEnd Timenvarchar60
4ETOUEXCEPTIONTOU Exception6TIMETOTOU Exception To-Timenvarchar60
TOPClaims Management
5ICLPROCUREClaim Item Groupings18TIMETOEnd Time of Claim Item Groupnvarchar60
6ICSPROCUREClaim Item Groupings18TIMETOEnd Time of Claim Item Groupnvarchar60
TOPCommodity Pricing Engine
7CPEC_PERIODDETCPE Term - Period Determination Rule17TIMETOCPE Term - End Time for Fixed Periodnvarchar60
8CPED_PERIODDTINCPE Term - Changed Input Data for Period Determination15TIMETOCPE Term - End Time for Fixed Periodnvarchar60
TOPContract Billing
9DBERCHZ4Individual line items (rarely used fields)42TIMETOEnd Timenvarchar60
10DBERCHZ8Document line items (rarely used fields, unimportant)42TIMETOEnd Timenvarchar60
11EMDUSDRQEXCLException Days for Subrequest8TIMETOEnd Timenvarchar60
12EMDUSDRQITEMSubrequest for Request9TIMETOEnd Timenvarchar60
TOPEnergy Data Management
13EEDMIMPORTLOG_DBEDM Import Log: Database Table8TIMETOTo-time for Profile Valuesnvarchar60
14EEDMPROSENDRecording of Sent Profiles6TIMETOTo-Timenvarchar60
15EEDMSETTLDOCSettlement Document (Header)6TIMETOTo-Timenvarchar60
16EEDMSETTLDOCSNDPSettlement Document (Sent Profiles)11TIMETOTo-Timenvarchar60
17EEDMSETTLDOCUPDPSettlement Document (Updated Profiles)13TIMETOTo-Timenvarchar60
18EEDMSETTLINLoad Shapes Per Settlement Run7TIMETOTo-Timenvarchar60
19EEDMSETTLUFUsage Factors per Settlement Run7TIMETOTo-Timenvarchar60
20EEDMSETTLUNITSettlement Unit (Header Data)6TIMETOTo-Timenvarchar60
21EEDMSETTLUNITGENSettlement Unit: Generated Form6TIMETOTo-Timenvarchar60
22EEDMSETTLUNITHSettlement Unit (Historical Data)6TIMETOTo-Timenvarchar60
23EEDMSYNPROFALLOCSynthetic Profile: Allocation of Profiles5TIMETOTo-Timenvarchar60
24EFORMULAHIERIS-U EDM Hierarchy Levels of Formula Instance (DB Table)10TIMETOTo-Timenvarchar60
25EFORMULAINSTPMIISU EDM Input Parameters for Formula Instance (DB Table)6TIMETOTo-Timenvarchar60
26EFORMULATRIGKMPISU EDM Compressed Trigger File for Formula Inst. (DB Table)6TIMETOTo-Timenvarchar60
27EFORMULATRIGTMPISU EDM Temporary Trigger File for Formula Inst. (DB Table)7TIMETOTo-Timenvarchar60
28EPROFASSAllocation of Profiles5TIMETOTo-Timenvarchar60
29EPROFHEADProfile Header Data19TIMETOTo-Timenvarchar60
30EPROFHEAD_TMPHeader Data of Temporary Profile19TIMETOTo-Timenvarchar60
31EPROFVALSTATProfile Value Status4TIMETOTo-Timenvarchar60
32EPROFVALSTATHISTHistory of Profile Value Status4TIMETOTo-Timenvarchar60
33EPROFVALSTAT_TMPStatus of Temporary Profile Values4TIMETOTo-Timenvarchar60
34EPROFVERSHEADHeader Data for Profile Version7TIMETOTo-Timenvarchar60
35EPROFVERSSTATStatus of Profile Version of Version4TIMETOTo-Timenvarchar60
36ERTPIFACECOMPHISComponents for RTP Interface (Historical Part)7TIMETOTo-Timenvarchar60
37ERTPIFACEINPAllocation of Input Parameters for RTP Interface9TIMETOTo-Timenvarchar60
38ERTPIFACEINSTActivation of RTP Components for Individual Installations6TIMETOTo-Timenvarchar60
39ERTPIFACEINSTPARAllocation of Parameters to RTP Interface for Indiv. Insts8TIMETOTo-Timenvarchar60
40ESERVPROVHISTService Provider (Historical Data)6TIMETOTo-Timenvarchar60
41ESERVPROVSERVICENon-Billable Services (Service Types) for Service Provider5TIMETOTo-Timenvarchar60
42ESOURCEHSource of Object (Historical Data)4TIMETOTo-Timenvarchar60
TOPFlexible Real Estate Management
43TIVCARECURRecurrence Rule8TIMETOEnd of Appointment (Time)nvarchar60
44VICARECURDeadline Regulation8TIMETOEnd of Appointment (Time)nvarchar60
TOPIntercompany Data Exchange
45EDEREGSPAGREEService Provider Agreements6TIMETOTo-Timenvarchar60
46TINV_INV_LOGHDLog Table - HEAD - for Bill Receipt Processing8TIMETOTimenvarchar60
TOPOLAP Technology
47RSDDSTATEXTRACTExtractor BW statistics: Time of last delta load4TIMETOUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPPlanning
48RN1SCHED_APPOINTIS-H*MED Appointment Table6TIMETOTime for VB Controlnvarchar60
49RN1SCHED_AVAILABIS-H*MED Planning Authority Table4TIMETOTime for VB Controlnvarchar60
50RN1SCHED_SPECTIMIS-H*MED Special Time Table5TIMETOTime for VB Controlnvarchar60
TOPPoint of delivery
51EUIGRIDAllocation of PoD to Grid4TIMETOTo-Timenvarchar60
52EUIINSTLNAllocation of Installation to PoD5TIMETOTo-Timenvarchar60
53EUILNRAllocation of Logical Device to PoD5TIMETOTo-Timenvarchar60
54EUILZWAllocation of Logical Register to PoD5TIMETOTo-Timenvarchar60
55EUITRANSTransformation of Internal/External Point of Delivery No.4TIMETOTo-Timenvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
56/ISHFR/TNGAPPIS-H FR: Supplements (Item Data)16TIMETOnvarchar50
TOPTime Zones
57TTZDFSummer time rules (fixed annual dates)7TIMETOEnd of Daylight Saving Time (Time)nvarchar60
58TTZDVSummer time rules (variable dates)11TIMETOEnd of Daylight Saving Time (Time)nvarchar60
TOPWithout Description
59RSTCMASTERLOADMaster data: Time of Last Load5TIMETOUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPWork Clearance Management
60WCAAPWCM: Application20TIMETOValid-To Time for WCM Objectnvarchar60
61WCAHEWCM: Work Clearance Document (Header)21TIMETOValid-To Time for WCM Objectnvarchar60
62WCAJWCM: Lineup26TIMETOValid-To Time for WCM Objectnvarchar60
63WCAWWCM: Work Approval19TIMETOValid-To Time for WCM Objectnvarchar60