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

61 columns | Print definition?ERP 6.0  | TIMEFROM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/SQLTIMSTSQL Monitor History: Timestamps - Mapping to time frame3TIMEFROMStart time of data collectionnvarchar60
2DBERCHECondition Data6TIMEFROMStart Timenvarchar60
3ECONDIIS-U: Conditions6TIMEFROMStart Timenvarchar60
4ETOUEXCEPTIONTOU Exception4TIMEFROMTOU Exception From-Timenvarchar60
TOPClaims Management
5ICLPROCUREClaim Item Groupings16TIMEFROMStart Time of Claim Item Groupnvarchar60
6ICSPROCUREClaim Item Groupings16TIMEFROMStart Time of Claim Item Groupnvarchar60
TOPCommodity Pricing Engine
7CPEC_PERIODDETCPE Term - Period Determination Rule15TIMEFROMCPE Term - Start Time for Fixed Periodnvarchar60
8CPED_PERIODDTINCPE Term - Changed Input Data for Period Determination13TIMEFROMCPE Term - Start Time for Fixed Periodnvarchar60
TOPContract Billing
9DBERCHZ4Individual line items (rarely used fields)40TIMEFROMStart Timenvarchar60
10DBERCHZ8Document line items (rarely used fields, unimportant)40TIMEFROMStart Timenvarchar60
11EMDUSDRQEXCLException Days for Subrequest6TIMEFROMStart Timenvarchar60
12EMDUSDRQITEMSubrequest for Request7TIMEFROMStart Timenvarchar60
TOPEnergy Data Management
13EEDMIMPORTLOG_DBEDM Import Log: Database Table6TIMEFROMFrom-Time for Profile Valuesnvarchar60
14EEDMPROSENDRecording of Sent Profiles4TIMEFROMFrom-timenvarchar60
15EEDMSETTLDOCSettlement Document (Header)4TIMEFROMFrom-timenvarchar60
16EEDMSETTLDOCSNDPSettlement Document (Sent Profiles)9TIMEFROMFrom-timenvarchar60
17EEDMSETTLDOCUPDPSettlement Document (Updated Profiles)11TIMEFROMFrom-timenvarchar60
18EEDMSETTLINLoad Shapes Per Settlement Run10TIMEFROMFrom-timenvarchar60
19EEDMSETTLPARAMPSettlement Paramter: Definition of Reference Profiles6TIMEFROMFrom-timenvarchar60
20EEDMSETTLUFUsage Factors per Settlement Run10TIMEFROMFrom-timenvarchar60
21EEDMSETTLUNITSettlement Unit (Header Data)4TIMEFROMFrom-timenvarchar60
22EEDMSETTLUNITGENSettlement Unit: Generated Form4TIMEFROMFrom-timenvarchar60
23EEDMSETTLUNITHSettlement Unit (Historical Data)4TIMEFROMFrom-timenvarchar60
24EEDMSYNPROFALLOCSynthetic Profile: Allocation of Profiles7TIMEFROMFrom-timenvarchar60
25EFORMULAHIERIS-U EDM Hierarchy Levels of Formula Instance (DB Table)8TIMEFROMFrom-timenvarchar60
26EFORMULAINSTPMIISU EDM Input Parameters for Formula Instance (DB Table)8TIMEFROMFrom-timenvarchar60
27EFORMULATRIGKMPISU EDM Compressed Trigger File for Formula Inst. (DB Table)4TIMEFROMFrom-timenvarchar60
28EFORMULATRIGTMPISU EDM Temporary Trigger File for Formula Inst. (DB Table)5TIMEFROMFrom-timenvarchar60
29EPROFASSAllocation of Profiles8TIMEFROMFrom-timenvarchar60
30EPROFHEADProfile Header Data17TIMEFROMFrom-timenvarchar60
31EPROFHEAD_TMPHeader Data of Temporary Profile17TIMEFROMFrom-timenvarchar60
32EPROFVALSTATProfile Value Status7TIMEFROMFrom-timenvarchar60
33EPROFVALSTATHISTHistory of Profile Value Status8TIMEFROMFrom-timenvarchar60
34EPROFVALSTAT_TMPStatus of Temporary Profile Values7TIMEFROMFrom-timenvarchar60
35EPROFVERSHEADHeader Data for Profile Version5TIMEFROMFrom-timenvarchar60
36EPROFVERSSTATStatus of Profile Version of Version7TIMEFROMFrom-timenvarchar60
37ERTPIFACECOMPHISComponents for RTP Interface (Historical Part)5TIMEFROMFrom-timenvarchar60
38ERTPIFACEINPAllocation of Input Parameters for RTP Interface7TIMEFROMFrom-timenvarchar60
39ERTPIFACEINSTActivation of RTP Components for Individual Installations8TIMEFROMFrom-timenvarchar60
40ERTPIFACEINSTPARAllocation of Parameters to RTP Interface for Indiv. Insts10TIMEFROMFrom-timenvarchar60
41ESERVPROVHISTService Provider (Historical Data)4TIMEFROMFrom-timenvarchar60
42ESERVPROVSERVICENon-Billable Services (Service Types) for Service Provider7TIMEFROMFrom-timenvarchar60
43ESOURCEHSource of Object (Historical Data)6TIMEFROMFrom-timenvarchar60
TOPFlexible Real Estate Management
44TIVCARECURRecurrence Rule7TIMEFROMStart of Appointment (Time)nvarchar60
45VICARECURDeadline Regulation7TIMEFROMStart of Appointment (Time)nvarchar60
TOPIntercompany Data Exchange
46EDEREGSPAGREEService Provider Agreements4TIMEFROMFrom-timenvarchar60
47TINV_INV_LOGHDLog Table - HEAD - for Bill Receipt Processing6TIMEFROMTimenvarchar60
TOPOLAP Technology
48RSDDSTATEXTRACTExtractor BW statistics: Time of last delta load3TIMEFROMUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPPlanning
49RN1SCHED_APPOINTIS-H*MED Appointment Table5TIMEFROMTime for VB Controlnvarchar60
50RN1SCHED_AVAILABIS-H*MED Planning Authority Table3TIMEFROMTime for VB Controlnvarchar60
51RN1SCHED_FOCAREAIS-H*MED: Time Areas for Planning Grid (Do not Use!!!)2TIMEFROMTime for VB Controlnvarchar60
52RN1SCHED_PATT_ASIS-H*MED: Resource-Planning Grid Pattern Assignment (No Use)3TIMEFROMTime for VB Controlnvarchar60
53RN1SCHED_SPECTIMIS-H*MED Special Time Table4TIMEFROMTime for VB Controlnvarchar60
TOPPoint of delivery
54EUIGRIDAllocation of PoD to Grid6TIMEFROMFrom-timenvarchar60
55EUIINSTLNAllocation of Installation to PoD7TIMEFROMFrom-timenvarchar60
56EUILNRAllocation of Logical Device to PoD7TIMEFROMFrom-timenvarchar60
57EUILZWAllocation of Logical Register to PoD7TIMEFROMFrom-timenvarchar60
58EUITRANSTransformation of Internal/External Point of Delivery No.6TIMEFROMFrom-timenvarchar60
TOPTime Zones
59TTZDFSummer time rules (fixed annual dates)5TIMEFROMStart of Daylight Saving Time (Time)nvarchar60
60TTZDVSummer time rules (variable dates)7TIMEFROMStart of Daylight Saving Time (Time)nvarchar60
TOPWithout Description
61RSTCMASTERLOADMaster data: Time of Last Load4TIMEFROMUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150