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

46 columns | Print definition?ERP 6.0  | DUEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_PSI_COMMCommunication Definition Settings21DUEDATEDue Datenvarchar80
2GRACREQRequest Header5DUEDATERequest Approval Due Datenvarchar80
3GRFNTSVYINSTSurvey Instance table6DUEDATEDue Date in Surveynvarchar80
4VIXCESCDLOGLog of Secure Deposit Files6DUEDATEDue datenvarchar80
TOPBalanced Scorecard
5UMB_SC197Scorecard: Initiative: Milestones6DUEDATEMilestone: Due Datenvarchar80
TOPBatch-Oriented Parallel Processing of Mass Data
6PPF_TST_APPLPARMApplication Parameters of PPF Test Application5DUEDATEDatenvarchar80
7PPF_TST_EMPLOYEEMaster Data for PPF Test Application8DUEDATEDatenvarchar80
TOPBusiness Package for Manager Self-Service FI
8FCOM_PL_ROOMSPlanning Rooms Back End Parameter8DUEDATEDue Datenvarchar80
TOPBusiness Planning and Simulation
9UPS_LINKSLinks to Org. Values6DUEDATEField of type DATSnvarchar80
TOPClaims Management
10ICLPAYClaim Payment17DUEDATEDue Date for Net Paymentnvarchar80
11ICLPOLPolicy Snapshot43DUEDATEDue Datenvarchar80
12ICLPROCUREClaim Item Groupings32DUEDATEDue Datenvarchar80
13ICL_BENSPLIT_ITMBenefit Split Item (One-Time)18DUEDATEDue Date for Net Paymentnvarchar80
14ICL_BENSPPER_ITMBenefit Split Item (Periodic)13DUEDATEDue Date for Net Paymentnvarchar80
15ICSPAYPayment17DUEDATEDue Date for Net Paymentnvarchar80
16ICSPOLPolicy Snapshot43DUEDATEDue Datenvarchar80
17ICSPROCUREClaim Item Groupings32DUEDATEDue Datenvarchar80
18ICS_BENSPLIT_ITMBenefit Split Item (Shadow Table)18DUEDATEDue Date for Net Paymentnvarchar80
19ICS_BENSPPER_ITMBenefit Split Item (Shadow Table)13DUEDATEDue Date for Net Paymentnvarchar80
TOPConfiguration management
20TCMFOLDERSTable for sending CM folders5DUEDATESystem Datenvarchar80
TOPContract Accounts Receivable and Payable
21DFKKORDERHISTRequests: Document History4DUEDATEDatenvarchar80
22DFKKORDOPHISTStanding Requests: Document History6DUEDATEDatenvarchar80
TOPCorporate Performance Monitor
23UMR_RI141RMS: Risk-Reducing Activities - Milestones7DUEDATEMilestone: Due Datenvarchar80
TOPEmployee Interaction Center
24THREIC_SLA_ALERTEIC Alerts4DUEDATEDue Datedecimal150
TOPEnvironment, Health and Safety
25/TDAG/CPT_TASKHHeader data for tasks19DUEDATEDue Datenvarchar80
26/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv19DUEDATEDue Datenvarchar80
27/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben7DUEDATEDue Datenvarchar80
28/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv7DUEDATEDue Datenvarchar80
29/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten16DUEDATEDue Datenvarchar80
30/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv16DUEDATEDue Datenvarchar80
31/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten7DUEDATEDue Datenvarchar80
32/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv7DUEDATEDue Datenvarchar80
TOPGRC Risk Management
33GRRMTSVYINSTSurvey Instance table8DUEDATEDue Date in Surveynvarchar80
TOPInvoicing
34DBEOSBIS-U On-Site Billing12DUEDATEDue date for net paymentnvarchar80
TOPLease Accounting
35TFILA_GF_007CValue IDs to Be Included in Payment Schedule5DUEDATEReference Date for Including Value ID in Payment Schedulenvarchar300
TOPLoans Management
36VDPOST_CONTROLData Selection for Debit Position8DUEDATEBill Creation Datenvarchar80
TOPLocalization
37TIVXCPTSTRATEStamp Tax Rate4DUEDATEDue Date of Stamp Tax Paymentnvarchar20
TOPManagement of Internal Controls
38FOPCRBFPLReporting Buffer: Cases - Remediation Plans15DUEDATEDue Date for Remediation Plannvarchar80
TOPPeriodical Sales and Distribution
39JKAPRENEWIS-M/SD: Index for Renewal of Subscriptions9DUEDATEIS-M/SD: Due Date for Next Paymentnvarchar80
TOPProcess Controls
40GRPCRBFPLReporting Buffer: Cases - Remediation Plans15DUEDATEDue Date for Remediation Plannvarchar80
TOPProduct Data Management
41CEPFOLDERSTable of CM folder for CEP scenario5DUEDATESystem Datenvarchar80
TOPReal Estate Contract
42VICDCONDCALCConditions - Calculation Factors and Condition Amounts19DUEDATEDue Datenvarchar80
TOPStakeholder Relationship Management
43USS_SHARE_TYPESEM-SRM: Table for Shares8DUEDATEDue Datenvarchar80
TOPTransaction Manager
44TCORT_CODFLDeal: Flows29DUEDATEDue datenvarchar80
45TCORT_CODUL2FLDeal: 2nd Underlying's Flows25DUEDATEDue datenvarchar80
46TCORT_CODULFLDeal: Underlying Flows24DUEDATEDue datenvarchar80